public int Add(PEIS.Model.OnCustReportManage model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OnCustReportManage(");
stringBuilder.Append("ID_ReportWay,ID_ReprotWay,ReportWay,Is_Informed,Informer,InformedDate,Is_InformReturned,Is_ReportReceipted,Is_SelfReceipted,ReportReceiptor,ReportReceiptedDate,ID_ReportOffer,ReportOffer,Is_ReportPrinted,ID_ReportPrinter,ReportPrinter,ReportPrintedDate,ID_ReportChecker,ReportChecker,ReportCheckDate,ReportPosition)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_ReportWay,@ID_ReprotWay,@ReportWay,@Is_Informed,@Informer,@InformedDate,@Is_InformReturned,@Is_ReportReceipted,@Is_SelfReceipted,@ReportReceiptor,@ReportReceiptedDate,@ID_ReportOffer,@ReportOffer,@Is_ReportPrinted,@ID_ReportPrinter,@ReportPrinter,@ReportPrintedDate,@ID_ReportChecker,@ReportChecker,@ReportCheckDate,@ReportPosition)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
new SqlParameter("@ID_ReprotWay", SqlDbType.Int, 4),
new SqlParameter("@ReportWay", SqlDbType.VarChar, 50),
new SqlParameter("@Is_Informed", SqlDbType.Bit, 1),
new SqlParameter("@Informer", SqlDbType.VarChar, 30),
new SqlParameter("@InformedDate", SqlDbType.DateTime),
new SqlParameter("@Is_InformReturned", SqlDbType.Bit, 1),
new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
new SqlParameter("@Is_SelfReceipted", SqlDbType.Bit, 1),
new SqlParameter("@ReportReceiptor", SqlDbType.VarChar, 30),
new SqlParameter("@ReportReceiptedDate", SqlDbType.DateTime),
new SqlParameter("@ID_ReportOffer", SqlDbType.Int, 4),
new SqlParameter("@ReportOffer", SqlDbType.VarChar, 30),
new SqlParameter("@Is_ReportPrinted", SqlDbType.Bit, 1),
new SqlParameter("@ID_ReportPrinter", SqlDbType.Int, 4),
new SqlParameter("@ReportPrinter", SqlDbType.VarChar, 30),
new SqlParameter("@ReportPrintedDate", SqlDbType.DateTime),
new SqlParameter("@ID_ReportChecker", SqlDbType.Int, 4),
new SqlParameter("@ReportChecker", SqlDbType.VarChar, 30),
new SqlParameter("@ReportCheckDate", SqlDbType.DateTime),
new SqlParameter("@ReportPosition", SqlDbType.VarChar, 30)
};
array[0].Value = model.ID_ReportWay;
array[1].Value = model.ID_ReprotWay;
array[2].Value = model.ReportWay;
array[3].Value = model.Is_Informed;
array[4].Value = model.Informer;
array[5].Value = model.InformedDate;
array[6].Value = model.Is_InformReturned;
array[7].Value = model.Is_ReportReceipted;
array[8].Value = model.Is_SelfReceipted;
array[9].Value = model.ReportReceiptor;
array[10].Value = model.ReportReceiptedDate;
array[11].Value = model.ID_ReportOffer;
array[12].Value = model.ReportOffer;
array[13].Value = model.Is_ReportPrinted;
array[14].Value = model.ID_ReportPrinter;
array[15].Value = model.ReportPrinter;
array[16].Value = model.ReportPrintedDate;
array[17].Value = model.ID_ReportChecker;
array[18].Value = model.ReportChecker;
array[19].Value = model.ReportCheckDate;
array[20].Value = model.ReportPosition;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public bool Update(PEIS.Model.OnCustReportManage model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnCustReportManage set ");
stringBuilder.Append("ID_ReportWay=@ID_ReportWay,");
stringBuilder.Append("ID_ReprotWay=@ID_ReprotWay,");
stringBuilder.Append("ReportWay=@ReportWay,");
stringBuilder.Append("Is_Informed=@Is_Informed,");
stringBuilder.Append("Informer=@Informer,");
stringBuilder.Append("InformedDate=@InformedDate,");
stringBuilder.Append("Is_InformReturned=@Is_InformReturned,");
stringBuilder.Append("Is_ReportReceipted=@Is_ReportReceipted,");
stringBuilder.Append("Is_SelfReceipted=@Is_SelfReceipted,");
stringBuilder.Append("ReportReceiptor=@ReportReceiptor,");
stringBuilder.Append("ReportReceiptedDate=@ReportReceiptedDate,");
stringBuilder.Append("ID_ReportOffer=@ID_ReportOffer,");
stringBuilder.Append("ReportOffer=@ReportOffer,");
stringBuilder.Append("Is_ReportPrinted=@Is_ReportPrinted,");
stringBuilder.Append("ID_ReportPrinter=@ID_ReportPrinter,");
stringBuilder.Append("ReportPrinter=@ReportPrinter,");
stringBuilder.Append("ReportPrintedDate=@ReportPrintedDate,");
stringBuilder.Append("ID_ReportChecker=@ID_ReportChecker,");
stringBuilder.Append("ReportChecker=@ReportChecker,");
stringBuilder.Append("ReportCheckDate=@ReportCheckDate,");
stringBuilder.Append("ReportPosition=@ReportPosition");
stringBuilder.Append(" where ID_ReportManage=@ID_ReportManage");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ReportWay", SqlDbType.Int, 4),
new SqlParameter("@ID_ReprotWay", SqlDbType.Int, 4),
new SqlParameter("@ReportWay", SqlDbType.VarChar, 50),
new SqlParameter("@Is_Informed", SqlDbType.Bit, 1),
new SqlParameter("@Informer", SqlDbType.VarChar, 30),
new SqlParameter("@InformedDate", SqlDbType.DateTime),
new SqlParameter("@Is_InformReturned", SqlDbType.Bit, 1),
new SqlParameter("@Is_ReportReceipted", SqlDbType.Bit, 1),
new SqlParameter("@Is_SelfReceipted", SqlDbType.Bit, 1),
new SqlParameter("@ReportReceiptor", SqlDbType.VarChar, 30),
new SqlParameter("@ReportReceiptedDate", SqlDbType.DateTime),
new SqlParameter("@ID_ReportOffer", SqlDbType.Int, 4),
new SqlParameter("@ReportOffer", SqlDbType.VarChar, 30),
new SqlParameter("@Is_ReportPrinted", SqlDbType.Bit, 1),
new SqlParameter("@ID_ReportPrinter", SqlDbType.Int, 4),
new SqlParameter("@ReportPrinter", SqlDbType.VarChar, 30),
new SqlParameter("@ReportPrintedDate", SqlDbType.DateTime),
new SqlParameter("@ID_ReportChecker", SqlDbType.Int, 4),
new SqlParameter("@ReportChecker", SqlDbType.VarChar, 30),
new SqlParameter("@ReportCheckDate", SqlDbType.DateTime),
new SqlParameter("@ReportPosition", SqlDbType.VarChar, 30),
new SqlParameter("@ID_ReportManage", SqlDbType.Int, 4)
};
array[0].Value = model.ID_ReportWay;
array[1].Value = model.ID_ReprotWay;
array[2].Value = model.ReportWay;
array[3].Value = model.Is_Informed;
array[4].Value = model.Informer;
array[5].Value = model.InformedDate;
array[6].Value = model.Is_InformReturned;
array[7].Value = model.Is_ReportReceipted;
array[8].Value = model.Is_SelfReceipted;
array[9].Value = model.ReportReceiptor;
array[10].Value = model.ReportReceiptedDate;
array[11].Value = model.ID_ReportOffer;
array[12].Value = model.ReportOffer;
array[13].Value = model.Is_ReportPrinted;
array[14].Value = model.ID_ReportPrinter;
array[15].Value = model.ReportPrinter;
array[16].Value = model.ReportPrintedDate;
array[17].Value = model.ID_ReportChecker;
array[18].Value = model.ReportChecker;
array[19].Value = model.ReportCheckDate;
array[20].Value = model.ReportPosition;
array[21].Value = model.ID_ReportManage;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public PEIS.Model.OnCustReportManage GetModel(int ID_ReportManage)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_ReportManage,ID_ReportWay,ID_ReprotWay,ReportWay,Is_Informed,Informer,InformedDate,Is_InformReturned,Is_ReportReceipted,Is_SelfReceipted,ReportReceiptor,ReportReceiptedDate,ID_ReportOffer,ReportOffer,Is_ReportPrinted,ID_ReportPrinter,ReportPrinter,ReportPrintedDate,ID_ReportChecker,ReportChecker,ReportCheckDate,ReportPosition from OnCustReportManage ");
stringBuilder.Append(" where ID_ReportManage=@ID_ReportManage");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ReportManage", SqlDbType.Int, 4)
};
array[0].Value = ID_ReportManage;
PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.OnCustReportManage result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_ReportManage"].ToString() != "")
{
onCustReportManage.ID_ReportManage = int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportManage"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString() != "")
{
onCustReportManage.ID_ReportWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportWay"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_ReprotWay"].ToString() != "")
{
onCustReportManage.ID_ReprotWay = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReprotWay"].ToString()));
}
onCustReportManage.ReportWay = dataSet.Tables[0].Rows[0]["ReportWay"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_Informed"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Informed"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Informed"].ToString().ToLower() == "true")
{
onCustReportManage.Is_Informed = new bool?(true);
}
else
{
onCustReportManage.Is_Informed = new bool?(false);
}
}
onCustReportManage.Informer = dataSet.Tables[0].Rows[0]["Informer"].ToString();
if (dataSet.Tables[0].Rows[0]["InformedDate"].ToString() != "")
{
onCustReportManage.InformedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["InformedDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_InformReturned"].ToString().ToLower() == "true")
{
onCustReportManage.Is_InformReturned = new bool?(true);
}
else
{
onCustReportManage.Is_InformReturned = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ReportReceipted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_ReportReceipted = new bool?(true);
}
else
{
onCustReportManage.Is_ReportReceipted = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_SelfReceipted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_SelfReceipted = new bool?(true);
}
else
{
onCustReportManage.Is_SelfReceipted = new bool?(false);
}
}
onCustReportManage.ReportReceiptor = dataSet.Tables[0].Rows[0]["ReportReceiptor"].ToString();
if (dataSet.Tables[0].Rows[0]["ReportReceiptedDate"].ToString() != "")
{
onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportReceiptedDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_ReportOffer"].ToString() != "")
{
onCustReportManage.ID_ReportOffer = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportOffer"].ToString()));
}
onCustReportManage.ReportOffer = dataSet.Tables[0].Rows[0]["ReportOffer"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_ReportPrinted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_ReportPrinted = new bool?(true);
}
else
{
onCustReportManage.Is_ReportPrinted = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_ReportPrinter"].ToString() != "")
{
onCustReportManage.ID_ReportPrinter = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportPrinter"].ToString()));
}
onCustReportManage.ReportPrinter = dataSet.Tables[0].Rows[0]["ReportPrinter"].ToString();
if (dataSet.Tables[0].Rows[0]["ReportPrintedDate"].ToString() != "")
{
onCustReportManage.ReportPrintedDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportPrintedDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_ReportChecker"].ToString() != "")
{
onCustReportManage.ID_ReportChecker = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ReportChecker"].ToString()));
}
onCustReportManage.ReportChecker = dataSet.Tables[0].Rows[0]["ReportChecker"].ToString();
if (dataSet.Tables[0].Rows[0]["ReportCheckDate"].ToString() != "")
{
onCustReportManage.ReportCheckDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["ReportCheckDate"].ToString()));
}
onCustReportManage.ReportPosition = dataSet.Tables[0].Rows[0]["ReportPosition"].ToString();
result = onCustReportManage;
}
else
{
result = null;
}
return(result);
}
public void UpdateCustomerReportReceiptFlag()
{
string text = base.GetString("AllData").TrimEnd(new char[]
{
'|'
});
string text2 = base.GetString("modelName").Trim().ToLower();
List <PEIS.Model.OnCustReportManage> list = new List <PEIS.Model.OnCustReportManage>();
string[] array = text.Split(new char[]
{
'|'
});
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine(string.Format("本次共计领取{0}个", array.Length));
if (array.Length > 0)
{
string[] array2 = array;
for (int i = 0; i < array2.Length; i++)
{
string text3 = array2[i];
string[] array3 = text3.Split(new char[]
{
'-'
});
if (array3.Length > 0)
{
PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
onCustReportManage.ID_Customer = array3[0];
onCustReportManage.Is_SelfReceipted = new bool?(array3[1] == "1");
onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Now);
onCustReportManage.ID_ReportOffer = new int?(int.Parse(this.ID_User));
onCustReportManage.Is_ReportReceipted = new bool?(true);
onCustReportManage.ReportOffer = this.UserName;
onCustReportManage.ReportReceiptor = array3[2];
onCustReportManage.ReportReceiptor = Secret.AES.EncryptPrefix(onCustReportManage.ReportReceiptor);
list.Add(onCustReportManage);
stringBuilder.AppendLine(string.Format("姓名[{0}],体检号[{1}],是否本人[{2}],领取人[{3}]", new object[]
{
array3[3],
onCustReportManage.ID_Customer,
onCustReportManage.Is_SelfReceipted,
array3[2]
}));
}
}
}
try
{
int num = CommonReport.Instance.UpdateCustomerReportReceiptFlag(list);
if (num > 0)
{
string msg = "{\"success\":\"1\",\"Message\":\"领取成功！\"}";
this.OutPutMessage(msg);
Log4J.Instance.Info(string.Concat(new string[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",报告领取成功 详细名单：",
stringBuilder.ToString()
}));
DateTime now = DateTime.Now;
foreach (PEIS.Model.OnCustReportManage current in list)
{
if (!string.IsNullOrEmpty(current.ID_Customer))
{
base.AddOrUpdateByBackLogType(long.Parse(current.ID_Customer.ToString()), EnumBusBackLogType.报告领取, true, null);
}
}
}
else
{
string msg = "{\"success\":\"0\",\"Message\":\"领取失败，请重试！\"}";
this.OutPutMessage(msg);
Log4J.Instance.Error(string.Concat(new string[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",报告领取失败,0行受影响 详细名单：",
stringBuilder.ToString()
}));
}
}
catch (Exception ex)
{
string msg = "{\"success\":\"0\",\"Message\":\"领取失败，请重试！\"}";
this.OutPutMessage(msg);
Log4J.Instance.Error(string.Concat(new string[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",报告领取失败，详细名单：",
stringBuilder.ToString(),
"错误原因为",
ex.Message
}));
}
}
public List <PEIS.Model.OnCustReportManage> DataTableToList(DataTable dt)
{
List <PEIS.Model.OnCustReportManage> list = new List <PEIS.Model.OnCustReportManage>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.OnCustReportManage onCustReportManage = new PEIS.Model.OnCustReportManage();
if (dt.Rows[i]["ID_ReportManage"].ToString() != "")
{
onCustReportManage.ID_ReportManage = int.Parse(dt.Rows[i]["ID_ReportManage"].ToString());
}
if (dt.Rows[i]["ID_ReportWay"].ToString() != "")
{
onCustReportManage.ID_ReportWay = new int?(int.Parse(dt.Rows[i]["ID_ReportWay"].ToString()));
}
if (dt.Rows[i]["ID_ReprotWay"].ToString() != "")
{
onCustReportManage.ID_ReprotWay = new int?(int.Parse(dt.Rows[i]["ID_ReprotWay"].ToString()));
}
onCustReportManage.ReportWay = dt.Rows[i]["ReportWay"].ToString();
if (dt.Rows[i]["Is_Informed"].ToString() != "")
{
if (dt.Rows[i]["Is_Informed"].ToString() == "1" || dt.Rows[i]["Is_Informed"].ToString().ToLower() == "true")
{
onCustReportManage.Is_Informed = new bool?(true);
}
else
{
onCustReportManage.Is_Informed = new bool?(false);
}
}
onCustReportManage.Informer = dt.Rows[i]["Informer"].ToString();
if (dt.Rows[i]["InformedDate"].ToString() != "")
{
onCustReportManage.InformedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["InformedDate"].ToString()));
}
if (dt.Rows[i]["Is_InformReturned"].ToString() != "")
{
if (dt.Rows[i]["Is_InformReturned"].ToString() == "1" || dt.Rows[i]["Is_InformReturned"].ToString().ToLower() == "true")
{
onCustReportManage.Is_InformReturned = new bool?(true);
}
else
{
onCustReportManage.Is_InformReturned = new bool?(false);
}
}
if (dt.Rows[i]["Is_ReportReceipted"].ToString() != "")
{
if (dt.Rows[i]["Is_ReportReceipted"].ToString() == "1" || dt.Rows[i]["Is_ReportReceipted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_ReportReceipted = new bool?(true);
}
else
{
onCustReportManage.Is_ReportReceipted = new bool?(false);
}
}
if (dt.Rows[i]["Is_SelfReceipted"].ToString() != "")
{
if (dt.Rows[i]["Is_SelfReceipted"].ToString() == "1" || dt.Rows[i]["Is_SelfReceipted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_SelfReceipted = new bool?(true);
}
else
{
onCustReportManage.Is_SelfReceipted = new bool?(false);
}
}
onCustReportManage.ReportReceiptor = dt.Rows[i]["ReportReceiptor"].ToString();
if (dt.Rows[i]["ReportReceiptedDate"].ToString() != "")
{
onCustReportManage.ReportReceiptedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportReceiptedDate"].ToString()));
}
if (dt.Rows[i]["ID_ReportOffer"].ToString() != "")
{
onCustReportManage.ID_ReportOffer = new int?(int.Parse(dt.Rows[i]["ID_ReportOffer"].ToString()));
}
onCustReportManage.ReportOffer = dt.Rows[i]["ReportOffer"].ToString();
if (dt.Rows[i]["Is_ReportPrinted"].ToString() != "")
{
if (dt.Rows[i]["Is_ReportPrinted"].ToString() == "1" || dt.Rows[i]["Is_ReportPrinted"].ToString().ToLower() == "true")
{
onCustReportManage.Is_ReportPrinted = new bool?(true);
}
else
{
onCustReportManage.Is_ReportPrinted = new bool?(false);
}
}
if (dt.Rows[i]["ID_ReportPrinter"].ToString() != "")
{
onCustReportManage.ID_ReportPrinter = new int?(int.Parse(dt.Rows[i]["ID_ReportPrinter"].ToString()));
}
onCustReportManage.ReportPrinter = dt.Rows[i]["ReportPrinter"].ToString();
if (dt.Rows[i]["ReportPrintedDate"].ToString() != "")
{
onCustReportManage.ReportPrintedDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportPrintedDate"].ToString()));
}
if (dt.Rows[i]["ID_ReportChecker"].ToString() != "")
{
onCustReportManage.ID_ReportChecker = new int?(int.Parse(dt.Rows[i]["ID_ReportChecker"].ToString()));
}
onCustReportManage.ReportChecker = dt.Rows[i]["ReportChecker"].ToString();
if (dt.Rows[i]["ReportCheckDate"].ToString() != "")
{
onCustReportManage.ReportCheckDate = new DateTime?(DateTime.Parse(dt.Rows[i]["ReportCheckDate"].ToString()));
}
onCustReportManage.ReportPosition = dt.Rows[i]["ReportPosition"].ToString();
list.Add(onCustReportManage);
}
}
return(list);
}
public bool Update(PEIS.Model.OnCustReportManage model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.OnCustReportManage model)
{
return(this.dal.Add(model));
}