public static string saveDrug(string jsonStr)
{
string key = "ccode";
string val = "无法读取属性";
int info = 0;
err = "";
DataTable dt = new DataTable();
//添加表字段
dt.Columns.Add("ccode");
dt.Columns.Add("cname");
dt.Columns.Add("spec");
dt.Columns.Add("dos");
dt.Columns.Add("dosu");
dt.Columns.Add("spell");
dt.Columns.Add("cap");
dt.Columns.Add("capu");
dt.Columns.Add("pishi");
dt.Columns.Add("portno");
dt.Columns.Add("idupdate");
string reqMsgSerial = "";//发送方报文流水号
List<string> msgs = PrintError.printErrMsg(info.ToString());
List<Dictionary<string, object>> rows = new List<Dictionary<string,object>>();
try
{
rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial);
for (int m = 0; m < rows.Count; m++)
{
dt.Rows.Add(new object[]
{ rows[m]["ccode"].ToString(),
rows[m]["cname"].ToString(),
rows[m]["spec"].ToString(),
rows[m]["dos"].ToString(),
rows[m]["dosu"].ToString(),
rows[m]["spell"].ToString(),
rows[m]["cap"].ToString(),
rows[m]["capu"].ToString(),
rows[m]["pishi"].ToString(),
rows[m]["portno"].ToString(),
rows[m]["idupdate"].ToString() });
}
DBHelp dbhelp = new DBHelp("sqlConnection");
//统计数据执行条数
int count = 0;
int countUpdate = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
StringBuilder sql = new StringBuilder();
switch (dt.Rows[i]["idupdate"].ToString().ToLower())
{
case "insert":
sql.Append("insert into [DDrug]([DrugCode],[DrugName],[Spec],[Dosage],[DosageUnit]");
sql.Append(",[SpellCode],[Capacity],[CapacityUnit],[PiShi],[PortNo],[flag]) values(");
sql.Append("'" + dt.Rows[i]["ccode"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["cname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["spec"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dos"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dosu"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["spell"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["cap"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["capu"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["pishi"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["portno"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
break;
case "update":
sql.Append("update [DDrug] set");
sql.Append(" [DrugName] = '" + dt.Rows[i]["cname"].ToString() + "'");
sql.Append(",[Spec] = '" + dt.Rows[i]["spec"].ToString() + "'");
sql.Append(",[Dosage] = '" + dt.Rows[i]["dos"].ToString() + "'");
sql.Append(",[DosageUnit] = '" + dt.Rows[i]["dosu"].ToString() + "'");
sql.Append(",[SpellCode] = '" + dt.Rows[i]["spell"].ToString() + "'");
sql.Append(",[Capacity] = '" + dt.Rows[i]["cap"].ToString() + "'");
sql.Append(",[CapacityUnit] = '" + dt.Rows[i]["capu"].ToString() + "'");
sql.Append(",[PiShi] = '" + dt.Rows[i]["pishi"].ToString() + "'");
sql.Append(",[PortNo] = '" + dt.Rows[i]["portno"].ToString() + "'");
sql.Append(",[flag] = 0");
sql.Append(" where [DDrug].[DrugCode] = '" + dt.Rows[i]["ccode"].ToString() + "'");
break;
case "delete":
sql.Append("delete from [DDrug]");
sql.Append(" where [DDrug].[DrugCode] = '" + dt.Rows[i]["ccode"].ToString() + "'");
break;
default:
info = 3;
throw new Exception(info.ToString());
}
int n = dbhelp.addAndUpdate(sql.ToString());
if (n == 0)
{
if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update")
{
sql.Append("insert into [DDrug]([DrugCode],[DrugName],[Spec],[Dosage],[DosageUnit]");
sql.Append(",[SpellCode],[Capacity],[CapacityUnit],[PiShi],[PortNo],[flag]) values(");
sql.Append("'" + dt.Rows[i]["ccode"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["cname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["spec"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dos"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dosu"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["spell"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["cap"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["capu"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["pishi"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["portno"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
n = dbhelp.addAndUpdate(sql.ToString());
}
else
{
CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower());
}
}
count += n;
}
if (count == dt.Rows.Count)
{
//标识同步数据完成
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete")
{
countUpdate += 1;
break;
}
string updateSql = "update [DDrug] set flag = 1 where [DDrug].[DrugCode] = '" + dt.Rows[j]["ccode"].ToString() + "'";
countUpdate += dbhelp.addAndUpdate(updateSql);
}
}
else
{
info = 7;
throw new Exception(info.ToString());
}
}
catch (Exception ex)
{
//确认错误类型
msgs = PrintError.printErrMsg(ex.Message);
writeContent.writeText(DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial);
}
string p;
if (0 != rows.Count)
{
if(rows[0].ContainsKey(key))
{
val = rows[0][key].ToString();
}
}
p = MakeHeaders.makePayLoad(key, val, msgs);
if (0 != info)
{
err = msgs[0];
}
string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p);
writeContent.writeOutLog("Drug_" + DateTime.Now.ToString("HHmmss"), "HISLog", result);
return result;
}
public static string saveQuantity(string jsonStr)
{
string key = "drugcode";
string val = "无法读取属性";
int info = 0;
err = "";
DataTable dt = new DataTable();
#region 添加表字段
dt.Columns.Add("drugcode");
dt.Columns.Add("quantity");
dt.Columns.Add("idupdate");
#endregion
string reqMsgSerial = "";//发送方报文流水号
List<string> msgs = PrintError.printErrMsg(info.ToString());
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
try
{
rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial);
//HIS所加字段判断同步的操作类型{insert|update|delete}
foreach (var row in rows)
{
//Dictionary<string, object> data = (Dictionary<string, object>)row;
dt.Rows.Add(new object[] { row["drugcode"].ToString(), row["quantity"].ToString(), row["idupdate"].ToString() });
}
DBHelp dbhelp = new DBHelp("sqlConnection");
//统计数据执行条数
int count = 0;
int countUpdate = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
StringBuilder sql = new StringBuilder();
switch (dt.Rows[i]["idupdate"].ToString().ToLower())
{
case "insert":
sql.Append("insert into [Quantity]([drugcode],[quantity],[flag]) values(");
sql.Append("'" + dt.Rows[i]["drugcode"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
break;
case "update":
sql.Append("update [Quantity] set");
sql.Append(" [Quantity].[quantity] = '" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",[Quantity].[flag] = 0");
sql.Append(" where [Quantity].[drugcode] = '" + dt.Rows[i]["drugcode"].ToString() + "'");
break;
case "delete":
sql.Append("delete from [Quantity]");
sql.Append(" where [Quantity].[drugcode] = '" + dt.Rows[i]["drugcode"].ToString() + "'");
break;
default:
info = 3;
throw new Exception(info.ToString());
}
int n = dbhelp.addAndUpdate(sql.ToString());
if (n == 0)
{
if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update")
{
sql.Append("insert into [Quantity]([drugcode],[quantity],[flag]) values(");
sql.Append("'" + dt.Rows[i]["drugcode"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
n = dbhelp.addAndUpdate(sql.ToString());
}
else
{
CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower());
}
}
count += n;
}
if (count == dt.Rows.Count)
{
//标识同步数据完成
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete")
{
countUpdate += 1;
break;
}
string updateSql = "update [Quantity] set flag = 1 where [Quantity].[drugcode] = '" + dt.Rows[j]["drugcode"].ToString() + "'";
countUpdate += dbhelp.addAndUpdate(updateSql);
}
}
else
{
info = 7;
throw new Exception(info.ToString());
}
}
catch (Exception ex)
{
msgs = PrintError.printErrMsg(ex.Message);
writeContent.writeText(DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial);
}
string p;
if (0 != rows.Count)
{
if (rows[0].ContainsKey(key))
{
val = rows[0][key].ToString();
}
}
p = MakeHeaders.makePayLoad(key, val, msgs);
if (0 != info)
{
err = msgs[0];
}
string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p);
writeContent.writeOutLog("Quantity_" + DateTime.Now.ToString("HHmmss"), "HISLog", result);
return result;
}
public static string savePrescription(string jsonStr)
{
string key = "ccode";
string val = "无法读取属性";
int info = 0;
err = "";
DataTable dt = new DataTable();
#region 添加字段名
dt.Columns.Add("act_order_no");
dt.Columns.Add("parent_no");
dt.Columns.Add("ward_code");
dt.Columns.Add("wardname");
dt.Columns.Add("bed_no");
dt.Columns.Add("hospital_no");
dt.Columns.Add("inpatient_no");
dt.Columns.Add("patientname");
dt.Columns.Add("sex");
dt.Columns.Add("age");
dt.Columns.Add("ageunit");
dt.Columns.Add("birthday");
dt.Columns.Add("avdp");
dt.Columns.Add("doctor");
dt.Columns.Add("doctor_name");
dt.Columns.Add("drawer");
dt.Columns.Add("drawername");
dt.Columns.Add("freq_code");
dt.Columns.Add("charge_code");
dt.Columns.Add("drugname");
dt.Columns.Add("specification");
dt.Columns.Add("dose");
dt.Columns.Add("dose_unit");
dt.Columns.Add("quantity");
dt.Columns.Add("pack_unit");
dt.Columns.Add("drug_company");
dt.Columns.Add("start_time");
dt.Columns.Add("end_time");
dt.Columns.Add("remark");
dt.Columns.Add("selfbuy");
dt.Columns.Add("tpn");
dt.Columns.Add("state");
dt.Columns.Add("idupdate");
dt.Columns.Add("reportdate");
dt.Columns.Add("last_perform_date_time");
#endregion
string reqMsgSerial = "";//发送方报文流水号
List<string> msgs = PrintError.printErrMsg(info.ToString());
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
try
{
rows = MakeJson.JsonToDataTable(jsonStr, out reqMsgSerial);
//HIS所加字段判断同步的操作类型{insert|update|delete}
foreach (var row in rows)
{
//Dictionary<string, object> data = (Dictionary<string, object>)row;
#region 获取传入数据
dt.Rows.Add(new object[] {
row["act_order_no"].ToString(),
row["parent_no"].ToString(),
row["ward_code"].ToString(),
row["wardname"].ToString(),
row["bed_no"].ToString(),
row["hospital_no"].ToString(),
row["inpatient_no"].ToString(),
row["patientname"].ToString(),
row["sex"].ToString(),
row["age"].ToString(),
row["ageunit"].ToString(),
row["birthday"].ToString(),
row["avdp"].ToString(),
row["doctor"].ToString(),
row["doctor_name"].ToString(),
"",//row["drawer"].ToString(),
"",//row["drawername"].ToString(),
row["freq_code"].ToString(),
row["charge_code"].ToString(),
row["drugname"].ToString(),
row["specification"].ToString(),
row["dose"].ToString(),
row["dose_unit"].ToString(),
row["qantity"].ToString(),
row["pack_unit"].ToString(),
row["drug_company"].ToString(),
row["start_time"].ToString(),
row["end_time"].ToString(),
row["remark"].ToString(),
row["selfbuy"].ToString(),
row["tpn"].ToString(),
row["state"].ToString(),
row["idupdate"].ToString(),
row["reportdate"].ToString()});
#endregion
}
DBHelp dbhelp = new DBHelp("sqlConnection");
//统计数据执行条数
int count = 0;
int countUpdate = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
StringBuilder sql = new StringBuilder();
switch (dt.Rows[i]["idupdate"].ToString().ToLower())
{
case "insert":
#region 插入SQL
sql.Append("insert into [RecipeSync]([RecipeID],[RecipeNo],[GroupNo],[WardCode],[WardName]");
sql.Append(",[BedNo],[HospitalNo],[PatientCode],[PatientName],[sex],[age],[ageunit]");
sql.Append(",[Birthday],[avdp],[DoctorCode],[DoctorName],[DrawerCode],[DrawerName]");
sql.Append(",[FreqCode],[ChargeCode],[DrugName],[specification],[dose],[dose_unit],[quantity]");
sql.Append(",[pack_unit],[DrugCompany],[InceptDT],[StartTime],[EndTime],[remark],[SelfBuy],[TPN],[state],[flag]) values(");
sql.Append("'" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["act_order_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["parent_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["ward_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["wardname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["bed_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["hospital_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["inpatient_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["patientname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["sex"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["age"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["ageunit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["birthday"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["avdp"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["doctor"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["doctor_name"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drawer"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drawername"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["freq_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["charge_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drugname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["specification"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dose"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dose_unit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["pack_unit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drug_company"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["reportdate"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["start_time"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["end_time"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["remark"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["selfbuy"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["tpn"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["state"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
sql.AppendLine("");
#endregion
break;
case "update":
#region 修改SQL
sql.Append("update [RecipeSync] set");
sql.Append(" [RecipeSync].[GroupNo]='" + dt.Rows[i]["parent_no"].ToString() + "'");
sql.Append(",[RecipeSync].[WardCode]='" + dt.Rows[i]["ward_code"].ToString() + "'");
sql.Append(",[RecipeSync].[WardName]='" + dt.Rows[i]["wardname"].ToString() + "'");
sql.Append(",[RecipeSync].[BedNo]='" + dt.Rows[i]["bed_no"].ToString() + "'");
sql.Append(",[RecipeSync].[HospitalNo]='" + dt.Rows[i]["hospital_no"].ToString() + "'");
sql.Append(",[RecipeSync].[PatientCode]='" + dt.Rows[i]["inpatient_no"].ToString() + "'");
sql.Append(",[RecipeSync].[PatientName]='" + dt.Rows[i]["patientname"].ToString() + "'");
sql.Append(",[RecipeSync].[sex]='" + dt.Rows[i]["sex"].ToString() + "'");
sql.Append(",[RecipeSync].[age]='" + dt.Rows[i]["age"].ToString() + "'");
sql.Append(",[RecipeSync].[ageunit]='" + dt.Rows[i]["ageunit"].ToString() + "'");
sql.Append(",[RecipeSync].[Birthday]='" + dt.Rows[i]["birthday"].ToString() + "'");
sql.Append(",[RecipeSync].[avdp]='" + dt.Rows[i]["avdp"].ToString() + "'");
sql.Append(",[RecipeSync].[DoctorCode]='" + dt.Rows[i]["doctor"].ToString() + "'");
sql.Append(",[RecipeSync].[DoctorName]='" + dt.Rows[i]["doctor_name"].ToString() + "'");
sql.Append(",[RecipeSync].[DrawerCode]='" + dt.Rows[i]["drawer"].ToString() + "'");
sql.Append(",[RecipeSync].[DrawerName]='" + dt.Rows[i]["drawername"].ToString() + "'");
sql.Append(",[RecipeSync].[FreqCode]='" + dt.Rows[i]["freq_code"].ToString() + "'");
sql.Append(",[RecipeSync].[ChargeCode]='" + dt.Rows[i]["charge_code"].ToString() + "'");
sql.Append(",[RecipeSync].[DrugName]='" + dt.Rows[i]["drugname"].ToString() + "'");
sql.Append(",[RecipeSync].[specification]='" + dt.Rows[i]["specification"].ToString() + "'");
sql.Append(",[RecipeSync].[dose]='" + dt.Rows[i]["dose"].ToString() + "'");
sql.Append(",[RecipeSync].[dose_unit]='" + dt.Rows[i]["dose_unit"].ToString() + "'");
sql.Append(",[RecipeSync].[quantity]='" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",[RecipeSync].[pack_unit]='" + dt.Rows[i]["pack_unit"].ToString() + "'");
sql.Append(",[RecipeSync].[DrugCompany]='" + dt.Rows[i]["drug_company"].ToString() + "'");
sql.Append(",[RecipeSync].[StartTime]='" + dt.Rows[i]["start_time"].ToString() + "'");
sql.Append(",[RecipeSync].[EndTime]='" + dt.Rows[i]["end_time"].ToString() + "'");
sql.Append(",[RecipeSync].[remark]='" + dt.Rows[i]["remark"].ToString() + "'");
sql.Append(",[RecipeSync].[SelfBuy]='" + dt.Rows[i]["selfbuy"].ToString() + "'");
sql.Append(",[RecipeSync].[TPN]='" + dt.Rows[i]["tpn"].ToString() + "'");
sql.Append(",[RecipeSync].[state]='" + dt.Rows[i]["state"].ToString() + "'");
sql.Append(",[RecipeSync].[flag] = 0");
sql.Append(" where [RecipeSync].[RecipeID] = '" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'");
#endregion
break;
case "delete":
sql.Append("delete from [RecipeSync]");
sql.Append(" where [RecipeSync].[RecipeID] = '" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'");
break;
default:
info = 3;
throw new Exception(info.ToString());
}
int n = dbhelp.addAndUpdate(sql.ToString());
if (n == 0)
{
if (dt.Rows[i]["idupdate"].ToString().ToLower() == "update")
{
#region 插入SQL
sql.Append("insert into [RecipeSync]([RecipeID],[RecipeNo],[GroupNo],[WardCode],[WardName]");
sql.Append(",[BedNo],[HospitalNo],[PatientCode],[PatientName],[sex],[age],[ageunit]");
sql.Append(",[Birthday],[avdp],[DoctorCode],[DoctorName],[DrawerCode],[DrawerName]");
sql.Append(",[FreqCode],[ChargeCode],[DrugName],[specification],[dose],[dose_unit],[quantity]");
sql.Append(",[pack_unit],[DrugCompany],[InceptDT],[StartTime],[EndTime],[remark],[SelfBuy],[TPN],[state],[flag]) values(");
sql.Append("'" + dt.Rows[i]["inpatient_no"].ToString() + "Y" + dt.Rows[i]["parent_no"].ToString() + "Z" + dt.Rows[i]["act_order_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["act_order_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["parent_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["ward_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["wardname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["bed_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["hospital_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["inpatient_no"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["patientname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["sex"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["age"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["ageunit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["birthday"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["avdp"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["doctor"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["doctor_name"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drawer"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drawername"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["freq_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["charge_code"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drugname"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["specification"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dose"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["dose_unit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["quantity"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["pack_unit"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["drug_company"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["reportdate"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["start_time"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["end_time"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["remark"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["selfbuy"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["tpn"].ToString() + "'");
sql.Append(",'" + dt.Rows[i]["state"].ToString() + "'");
sql.Append(",0");
sql.Append(")");
sql.AppendLine("");
#endregion
n = dbhelp.addAndUpdate(sql.ToString());
}
else
{
CommonUtil.isCount(dt.Rows[i]["idupdate"].ToString().ToLower());
}
}
count += n;
}
if (count == dt.Rows.Count)
{
//标识同步数据完成
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j]["idupdate"].ToString().ToLower() == "delete")
{
countUpdate += 1;
break;
}
string updateSql = "update [RecipeSync] set flag = 1 where [RecipeSync].[RecipeNo] = '" + dt.Rows[j]["act_order_no"].ToString() + "'";
countUpdate += dbhelp.addAndUpdate(updateSql);
}
}
else
{
info = 7;
throw new Exception(info.ToString());
}
}
catch (Exception ex)
{
msgs = PrintError.printErrMsg(ex.Message);
writeContent.writeText(key + DateTime.Now.ToString("HHmmss") + msgs[0], msgs[0] + "\r\n" + msgs[1] + "\r\n" + ex.ToString() + "\r\nUUID:" + reqMsgSerial);
}
string p;
if (0 != rows.Count)
{
if (rows[0].ContainsKey(key))
{
val = rows[0][key].ToString();
}
}
p = MakeHeaders.makePayLoad(key, val, msgs);
if (0 != info)
{
err = msgs[0];
}
string result = MakeHeaders.responseHeader(reqMsgSerial, responseMsgCode, err, p);
writeContent.writeOutLog("Recipe_" + DateTime.Now.ToString("HHmmss"), "HISLog", result);
return result;
}
