public int UpdateRegdate(tj_book_patient regdatejson)
{
int temp;
SqlParameter[] ps = new SqlParameter[]{
//实体类的字段和存储过程的参数对齐
new SqlParameter("@reg_date",regdatejson.reg_date),
new SqlParameter("@pat_code",regdatejson.pat_code),
new SqlParameter("@reg_time",regdatejson.reg_time),
new SqlParameter("@hsp_code",regdatejson.hsp_code),
//存储过程中的output参数
new SqlParameter("@reg_no",'' ''),
};
//执行存储过程
temp = SqlHelper.ExecuteNonQuery("pr_update_dlyyregdate", ps);
return temp;
}
//此处调用上面的方法
public int InsertRegister(string regdatejson) {
//反序列化json数组
JavaScriptSerializer js = new JavaScriptSerializer();
List<tj_book_patient> pt = js.Deserialize<List<tj_book_patient>>(regdatejson);
int result = 0;
foreach (tj_book_patient s in pt)
{
result = UpdateRegdate(s);
//存储过程返回的output参数来判断数据是否执行成功
switch (result)
{
case 0: message = "添加失败"; break;
case 1: message = "添加成功"; break;
}
}
return result;
}
|