public int AddCustomerArcInfo(PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("if not exists(select CultrulName from OnArcCust where IDCard=@IDCard AND CustomerName=@CustomerName)\r\n begin\r\n insert into OnArcCust(IDCard,CustomerName,ID_Gender,GenderName,BirthDay,NationID,NationName,Photo,FirstDatePE,LatestDatePE,FinishedNum,UnfinishedNum)\r\nvalues(@IDCard,@CustomerName,@ID_Gender,@GenderName,@BirthDay,@NationID,@NationName,@Photo,@FirstDatePE,@LatestDatePE,0,1);\r\nselect @@IDENTITY;\r\n end\r\n else \r\n begin\r\n update OnArcCust set CustomerName=@CustomerName,ID_Gender=@ID_Gender,GenderName=@GenderName,BirthDay=@BirthDay,NationID=@NationID,NationName=@NationName,Photo=@Photo\r\nwhere IDCard=@IDCard AND CustomerName=@CustomerName;\r\nselect 2;\r\n end;");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@IDCard", SqlDbType.VarChar),
new SqlParameter("@CustomerName", SqlDbType.VarChar),
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@GenderName", SqlDbType.VarChar),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@NationID", SqlDbType.Int, 4),
new SqlParameter("@NationName", SqlDbType.VarChar),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@FirstDatePE", SqlDbType.DateTime),
new SqlParameter("@LatestDatePE", SqlDbType.DateTime)
};
DateTime now = DateTime.Now;
array[0].Value = model.IDCard;
array[1].Value = model.CustomerName;
array[2].Value = model.ID_Gender;
array[3].Value = model.GenderName;
array[4].Value = model.BirthDay;
if (model.NationID.Value == -1)
{
array[5].Value = DBNull.Value;
}
else
{
array[5].Value = model.NationID;
}
array[6].Value = model.NationName;
array[7].Value = model.Photo;
array[8].Value = now;
array[9].Value = now;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
protected void GetCustomerInfo(long ID_Customer, ref VelocityContext vltContext)
{
DataSet custRelationCustPEInfo = CommonCustExam.Instance.GetCustRelationCustPEInfo(ID_Customer, "", "");
if (custRelationCustPEInfo != null && 0 < custRelationCustPEInfo.Tables[0].Rows.Count)
{
List <PEIS.Model.OnCustRelationCustPEInfo> list = PEIS.BLL.OnCustRelationCustPEInfo.Instance.DataTableToList(custRelationCustPEInfo.Tables[0]);
if (list == null)
{
base.Response.Write("<script> jQuery(document).ready(function () { ReLoginConfirm();}); </script>");
base.Response.End();
}
else
{
vltContext.Put("ExamState", list[0].ExamState);
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = null;
PEIS.Model.OnArcCust modelByCache = PEIS.BLL.OnArcCust.Instance.GetModelByCache(int.Parse(list[0].ID_ArcCustomer.ToString()));
if (list[0].ExamState == 0)
{
onCustPhysicalExamInfo = PEIS.BLL.OnCustPhysicalExamInfo.Instance.GetModel(list[0].ID_Customer.Value);
}
if (modelByCache != null)
{
vltContext.Put("ExamCardNo", modelByCache.ExamCard);
vltContext.Put("IDCardNo", modelByCache.IDCard);
vltContext.Put("CustomerName", modelByCache.CustomerName);
vltContext.Put("MarriageName", modelByCache.MarriageName);
vltContext.Put("GenderName", modelByCache.GenderName);
vltContext.Put("txtGenderID", (modelByCache.ID_Gender == 1) ? "1" : "0");
vltContext.Put("MobileNo", modelByCache.MobileNo);
int finishedNum = modelByCache.FinishedNum;
int num = (!modelByCache.UnfinishedNum.HasValue) ? 0 : modelByCache.UnfinishedNum.Value;
int num2 = finishedNum + num;
vltContext.Put("totalExamNumber", num2);
}
if (onCustPhysicalExamInfo != null)
{
vltContext.Put("Is_FeeSettled", onCustPhysicalExamInfo.Is_FeeSettled);
vltContext.Put("CustomerSecurityLevel", onCustPhysicalExamInfo.SecurityLevel);
vltContext.Put("DiseaseLevel", onCustPhysicalExamInfo.DiseaseLevel);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_SectionLock", onCustPhysicalExamInfo.Is_SectionLock);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("Is_Paused", onCustPhysicalExamInfo.Is_Paused);
vltContext.Put("Is_ReportReceipted", onCustPhysicalExamInfo.Is_ReportReceipted);
}
}
}
}
public int UpdateCustomerPicInfo(string ID_Customer, PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("UPDATE OnCustPhysicalExamInfo SET PHOTO=@Photo WHERE ID_Customer=@ID_Customer;\r\nUPDATE OnArcCust SET Photo=@Photo WHERE ID_ArcCustomer=(select ID_ArcCustomer from OnCustRelationCustPEInfo where ID_Customer=@ID_Customer);\r\nselect 1;");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@IDCard", SqlDbType.VarChar),
new SqlParameter("@CustomerName", SqlDbType.VarChar),
new SqlParameter("@ID_Customer", SqlDbType.VarChar)
};
DateTime now = DateTime.Now;
if (model.Photo == null || model.Photo.Length == 0)
{
array[0].Value = DBNull.Value;
}
else
{
array[0].Value = model.Photo;
}
array[1].Value = model.IDCard;
array[2].Value = model.CustomerName;
array[3].Value = ID_Customer;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public int UpdateCustomerPicInfo(PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnArcCust set Photo=@Photo where IDCard=@IDCard AND CustomerName=@CustomerName;select 1;");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@IDCard", SqlDbType.VarChar),
new SqlParameter("@CustomerName", SqlDbType.VarChar)
};
DateTime now = DateTime.Now;
if (model.Photo == null || model.Photo.Length == 0)
{
array[0].Value = DBNull.Value;
}
else
{
array[0].Value = model.Photo;
}
array[1].Value = model.IDCard;
array[2].Value = model.CustomerName;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public List <PEIS.Model.OnArcCust> DataTableToList(DataTable dt)
{
List <PEIS.Model.OnArcCust> list = new List <PEIS.Model.OnArcCust>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.OnArcCust onArcCust = new PEIS.Model.OnArcCust();
if (dt.Rows[i]["ID_ArcCustomer"].ToString() != "")
{
onArcCust.ID_ArcCustomer = int.Parse(dt.Rows[i]["ID_ArcCustomer"].ToString());
}
if (dt.Rows[i]["ID_Gender"].ToString() != "")
{
onArcCust.ID_Gender = new int?(int.Parse(dt.Rows[i]["ID_Gender"].ToString()));
}
if (dt.Rows[i]["ID_Marriage"].ToString() != "")
{
onArcCust.ID_Marriage = new int?(int.Parse(dt.Rows[i]["ID_Marriage"].ToString()));
}
if (dt.Rows[i]["NationID"].ToString() != "")
{
onArcCust.NationID = new int?(int.Parse(dt.Rows[i]["NationID"].ToString()));
}
if (dt.Rows[i]["CultrulID"].ToString() != "")
{
onArcCust.CultrulID = new int?(int.Parse(dt.Rows[i]["CultrulID"].ToString()));
}
if (dt.Rows[i]["VocationID"].ToString() != "")
{
onArcCust.VocationID = new int?(int.Parse(dt.Rows[i]["VocationID"].ToString()));
}
onArcCust.CustomerName = dt.Rows[i]["CustomerName"].ToString();
onArcCust.IDCard = dt.Rows[i]["IDCard"].ToString();
onArcCust.ExamCard = dt.Rows[i]["ExamCard"].ToString();
if (dt.Rows[i]["Photo"].ToString() != "")
{
onArcCust.Photo = (byte[])dt.Rows[i]["Photo"];
}
if (dt.Rows[i]["BirthDay"].ToString() != "")
{
onArcCust.BirthDay = new DateTime?(DateTime.Parse(dt.Rows[i]["BirthDay"].ToString()));
}
onArcCust.GenderName = dt.Rows[i]["GenderName"].ToString();
onArcCust.MarriageName = dt.Rows[i]["MarriageName"].ToString();
onArcCust.NationName = dt.Rows[i]["NationName"].ToString();
onArcCust.Address = dt.Rows[i]["Address"].ToString();
onArcCust.MobileNo = dt.Rows[i]["MobileNo"].ToString();
onArcCust.Email = dt.Rows[i]["Email"].ToString();
onArcCust.CultrulName = dt.Rows[i]["CultrulName"].ToString();
onArcCust.VocationName = dt.Rows[i]["VocationName"].ToString();
if (dt.Rows[i]["FinishedNum"].ToString() != "")
{
onArcCust.FinishedNum = int.Parse(dt.Rows[i]["FinishedNum"].ToString());
}
if (dt.Rows[i]["UnfinishedNum"].ToString() != "")
{
onArcCust.UnfinishedNum = new int?(int.Parse(dt.Rows[i]["UnfinishedNum"].ToString()));
}
if (dt.Rows[i]["FirstDatePE"].ToString() != "")
{
onArcCust.FirstDatePE = new DateTime?(DateTime.Parse(dt.Rows[i]["FirstDatePE"].ToString()));
}
if (dt.Rows[i]["LatestDatePE"].ToString() != "")
{
onArcCust.LatestDatePE = new DateTime?(DateTime.Parse(dt.Rows[i]["LatestDatePE"].ToString()));
}
list.Add(onArcCust);
}
}
return(list);
}
public bool Update(PEIS.Model.OnArcCust model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.OnArcCust model)
{
return(this.dal.Add(model));
}
protected void GetCustomerInfo(long ID_Customer, ref VelocityContext vltContext)
{
DataSet custRelationCustPEInfo = CommonCustExam.Instance.GetCustRelationCustPEInfo(ID_Customer, "", "");
if (custRelationCustPEInfo != null && 0 < custRelationCustPEInfo.Tables[0].Rows.Count)
{
List <PEIS.Model.OnCustRelationCustPEInfo> list = PEIS.BLL.OnCustRelationCustPEInfo.Instance.DataTableToList(custRelationCustPEInfo.Tables[0]);
if (list != null)
{
vltContext.Put("ExamState", list[0].ExamState);
PEIS.Model.OnCustPhysicalExamInfo onCustPhysicalExamInfo = null;
PEIS.Model.OnArcCust modelByCache = PEIS.BLL.OnArcCust.Instance.GetModelByCache(int.Parse(list[0].ID_ArcCustomer.ToString()));
if (list[0].ExamState == 0)
{
onCustPhysicalExamInfo = PEIS.BLL.OnCustPhysicalExamInfo.Instance.GetModel(list[0].ID_Customer.Value);
}
if (modelByCache != null)
{
vltContext.Put("ExamCardNo", modelByCache.ExamCard);
vltContext.Put("IDCardNo", modelByCache.IDCard);
vltContext.Put("CustomerName", modelByCache.CustomerName);
vltContext.Put("MarriageName", modelByCache.MarriageName);
vltContext.Put("GenderName", modelByCache.GenderName);
vltContext.Put("MobileNo", modelByCache.MobileNo);
int finishedNum = modelByCache.FinishedNum;
int num = (!modelByCache.UnfinishedNum.HasValue) ? 0 : modelByCache.UnfinishedNum.Value;
int num2 = finishedNum + num;
vltContext.Put("totalExamNumber", num2);
}
if (onCustPhysicalExamInfo != null)
{
vltContext.Put("Is_FeeSettled", onCustPhysicalExamInfo.Is_FeeSettled);
vltContext.Put("CustomerSecurityLevel", onCustPhysicalExamInfo.SecurityLevel);
vltContext.Put("DiseaseLevel", onCustPhysicalExamInfo.DiseaseLevel);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_SectionLock", onCustPhysicalExamInfo.Is_SectionLock);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("ID_FinalDoctor", onCustPhysicalExamInfo.ID_FinalDoctor);
vltContext.Put("FinalDoctor", onCustPhysicalExamInfo.FinalDoctor);
vltContext.Put("FinalDate", onCustPhysicalExamInfo.FinalDate.HasValue ? DateTime.Parse(onCustPhysicalExamInfo.FinalDate.ToString()).ToString("yyyy-MM-dd") : "");
vltContext.Put("FinalDateDetail", onCustPhysicalExamInfo.FinalDate);
vltContext.Put("Is_FinalFinished", onCustPhysicalExamInfo.Is_FinalFinished);
vltContext.Put("Is_GuideSheetReturned", onCustPhysicalExamInfo.Is_GuideSheetReturned);
vltContext.Put("Is_GuideSheetPrinted", onCustPhysicalExamInfo.Is_GuideSheetPrinted);
vltContext.Put("Is_Paused", onCustPhysicalExamInfo.Is_Paused);
vltContext.Put("Is_ReportReceipted", onCustPhysicalExamInfo.Is_ReportReceipted);
vltContext.Put("Is_Checked", onCustPhysicalExamInfo.Is_Checked);
vltContext.Put("ID_Checker", onCustPhysicalExamInfo.ID_Checker);
vltContext.Put("Checker", onCustPhysicalExamInfo.Checker);
vltContext.Put("CheckedDate", onCustPhysicalExamInfo.CheckedDate.HasValue ? DateTime.Parse(onCustPhysicalExamInfo.CheckedDate.ToString()).ToString("yyyy-MM-dd") : "");
vltContext.Put("FinalOverView", onCustPhysicalExamInfo.FinalOverView.Replace("\n", "<br/>"));
vltContext.Put("FinalConclusion", onCustPhysicalExamInfo.FinalConclusion.Replace("\n", "<br/>"));
vltContext.Put("ResultCompare", onCustPhysicalExamInfo.ResultCompare.Replace("\n", "<br/>"));
vltContext.Put("MainDiagnose", onCustPhysicalExamInfo.MainDiagnose.Replace("\n", "<br/>"));
vltContext.Put("FinalDietGuide", onCustPhysicalExamInfo.FinalDietGuide.Replace("\n", "<br/>"));
vltContext.Put("FinalSportGuide", onCustPhysicalExamInfo.FinalSportGuide.Replace("\n", "<br/>"));
vltContext.Put("FinalHealthKnowlage", onCustPhysicalExamInfo.FinalHealthKnowlage.Replace("\n", "<br/>"));
if (onCustPhysicalExamInfo.Is_Checked == false)
{
vltContext.Put("RefuseReason", this.GetCustomerRefuseReason(ID_Customer));
}
}
}
}
}
public int UpdateCustomerPicInfo(PEIS.Model.OnArcCust model)
{
return(this.dal.UpdateCustomerPicInfo(model));
}
public int AddCustomerManageArcInfo(PEIS.Model.OnArcCust model)
{
return(this.dal.AddCustomerManageArcInfo(model));
}
public int UpdateCustomerPicInfo(string ID_Customer, PEIS.Model.OnArcCust model)
{
return(this.dal.UpdateCustomerPicInfo(ID_Customer, model));
}
public int AddCustomerManageArcInfo(PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("--通过客户IDCard和CustomerName修改客户体检信息 xmhuang 2014-04-21\r\nUPDATE OnCustPhysicalExamInfo SET CustomerName=@CustomerName,ID_Gender=@ID_Gender,GenderName=@GenderName,BirthDay=@BirthDay,ID_Marriage=@ID_Marriage,MarriageName=@MarriageName,Photo=@Photo,NationID=@NationID,NationName=@NationName,IDCard=@IDCard,MobileNo=@MobileNo WHERE \r\nIDCard=(SELECT IDCard FROM OnArcCust WHERE ID_ArcCustomer=@ID_ArcCustomer) AND CustomerName=(SELECT CustomerName FROM OnArcCust WHERE ID_ArcCustomer=@ID_ArcCustomer);\r\nupdate OnArcCust set CustomerName=@CustomerName,ID_Gender=@ID_Gender,GenderName=@GenderName,BirthDay=@BirthDay,ID_Marriage=@ID_Marriage,MarriageName=@MarriageName,Photo=@Photo,NationID=@NationID,NationName=@NationName,IDCard=@IDCard,MobileNo=@MobileNo\r\nwhere ID_ArcCustomer=@ID_ArcCustomer;select 1;");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ArcCustomer", SqlDbType.Int),
new SqlParameter("@CustomerName", SqlDbType.VarChar),
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@GenderName", SqlDbType.VarChar),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@ID_Marriage", SqlDbType.Int, 4),
new SqlParameter("@MarriageName", SqlDbType.VarChar),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@NationID", SqlDbType.Int),
new SqlParameter("@NationName", SqlDbType.VarChar),
new SqlParameter("@IDCard", SqlDbType.VarChar),
new SqlParameter("@MobileNo", SqlDbType.VarChar)
};
DateTime now = DateTime.Now;
array[0].Value = model.ID_ArcCustomer;
array[1].Value = model.CustomerName;
array[2].Value = model.ID_Gender;
array[3].Value = model.GenderName;
array[4].Value = model.BirthDay;
int arg_14D_0 = model.ID_Marriage.Value;
if (model.ID_Marriage.Value == -1)
{
array[5].Value = DBNull.Value;
}
else
{
array[5].Value = model.ID_Marriage;
}
array[6].Value = model.MarriageName;
array[7].Value = model.Photo;
if (model.NationID.Value == -1)
{
array[8].Value = DBNull.Value;
}
else
{
array[8].Value = model.NationID;
}
array[9].Value = model.NationName;
array[10].Value = model.IDCard;
array[11].Value = model.MobileNo;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public void SaveCustomerManage()
{
int @int = base.GetInt("ID_ArcCustomer", -1);
if (@int > -1)
{
string text = base.GetString("CustomerName").Trim();
int int2 = base.GetInt("Gender", -1);
string genderName = base.GetString("GenderName").Trim();
string text2 = base.GetString("IDCard").Trim();
string s = base.GetString("Birthday").Trim();
string mobileNo = base.GetString("MobileNo").Trim();
string s2 = base.GetString("Base64Photo").Trim();
int int3 = base.GetInt("NationID", -1);
string nationName = base.GetString("NationName").Trim();
int int4 = base.GetInt("ID_Marriage", -1);
string marriageName = base.GetString("MarriageName").Trim();
if (!this.IsIDCard(text2))
{
Log4J.Instance.Error(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",保存客户存档信息失败 存档ID：",
@int,
",身份证号:",
text2
}));
this.jsonInfo = "{\"success\":\"0\",\"Message\":\"证件号格式不正确！\"}";
this.OutPutMessage(this.jsonInfo);
}
else
{
string sql = string.Format("SELECT ID_ArcCustomer,IDCard,CustomerName,BirthDay,ID_Gender FROM OnArcCust WHERE IDCard='{0}' AND CustomerName='{1}';", text2, text);
DataTable dataTable = CommonExcuteSql.Instance.ExcuteSql(sql).Tables[0];
DataRow[] array = dataTable.Select("ID_ArcCustomer='" + @int + "'");
if ((array.Length > 0 && dataTable.Rows.Count == 1) || dataTable.Rows.Count == 0)
{
PEIS.Model.OnArcCust onArcCust = new PEIS.Model.OnArcCust();
onArcCust.ID_ArcCustomer = @int;
onArcCust.CustomerName = text;
onArcCust.ID_Gender = new int?(int2);
onArcCust.GenderName = genderName;
onArcCust.IDCard = text2;
onArcCust.BirthDay = new DateTime?(DateTime.Parse(s));
onArcCust.MobileNo = mobileNo;
onArcCust.NationID = new int?(int3);
onArcCust.NationName = nationName;
onArcCust.ID_Marriage = new int?(int4);
onArcCust.MarriageName = marriageName;
byte[] array2 = Convert.FromBase64String(s2);
MemoryStream memoryStream = new MemoryStream(array2);
onArcCust.Photo = array2;
int num = CommonUser.Instance.AddCustomerManageArcInfo(onArcCust);
string msg = string.Empty;
if (num > 0)
{
DataTable dataTable2 = null;
if (this.Session["CustomerManage"] != null)
{
dataTable2 = (this.Session["CustomerManage"] as DataTable);
}
if (dataTable2 != null)
{
if (!Directory.Exists(this.FilePath))
{
Directory.CreateDirectory(this.FilePath);
}
string fileName = string.Concat(new object[]
{
this.FilePath,
"\\",
@int,
"_",
DateTime.Now.ToString("yyyyMMddhhmmss"),
".l"
});
dataTable2.WriteXml(fileName, XmlWriteMode.IgnoreSchema, true);
dataTable2.Dispose();
}
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",保存客户存档信息 存档ID：",
@int,
",身份证号:",
text2
}));
string text3 = string.Format("/*****************************修改在线库未领取体检报告的客户名称 Begin***********************************/\r\n--通过客户存档ID获取其对应的所有客户体检号\r\nSELECT ID_Customer INTO #OnArct@RandNum FROM OnCustRelationCustPEInfo WHERE ID_ArcCustomer IN({0})\r\nAND NOT EXISTS(SELECT ID_Customer FROM(SELECT ID_Customer FROM OnCustReportManage WHERE Is_ReportReceipted=1)OnCustReportManage\r\nWHERE OnCustRelationCustPEInfo.ID_Customer=OnCustReportManage.ID_Customer);\r\n\r\n--修改关系表中的证件号\r\nUPDATE OnCustRelationCustPEInfo SET IDCardNo='{2}' WHERE ID_ArcCustomer IN({0});\r\n\r\n--修改体检信息表中客户名称\r\nUPDATE OnCustPhysicalExamInfo SET CustomerName='{1}' WHERE EXISTS(SELECT ID_Customer FROM #OnArct@RandNum WHERE OnCustPhysicalExamInfo.ID_Customer=#[email protected]_Customer);\r\n\r\n--修改体检者检查科室结论表中客户名称\r\nUPDATE OnCustExamSection SET CustomerName='{1}' WHERE EXISTS(SELECT ID_Customer FROM #OnArct@RandNum WHERE OnCustExamSection.ID_Customer=#[email protected]_Customer);\r\n\r\n--修改总审表中客户名称 \r\nUPDATE OnFianlCheck SET CustomerName='{1}' WHERE EXISTS(SELECT ID_Customer FROM #OnArct@RandNum WHERE OnFianlCheck.ID_Customer=#[email protected]_Customer);\r\n\r\n--删除中间表\r\nDROP TABLE #OnArct@RandNum;\r\n/*****************************修改在线库未领取体检报告的客户名称 End***********************************/", @int, text, text2);
List <string> list = new List <string>(1);
text3 = text3.Replace("@RandNum", Public.GetGuid("-", string.Empty));
list.Add(text3);
int num2 = CommonExcuteSql.Instance.ExecuteSqlTran(list);
if (num2 > 0)
{
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",成功修改客户存档ID：",
@int,
",在线库客户名称为:",
text
}));
}
else
{
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",修改客户存档ID失败：",
@int,
",在线库客户名称为:",
text
}));
}
msg = "{\"success\":\"1\",\"Message\":\"修改成功！\"}";
this.OutPutMessage(msg);
}
else
{
Log4J.Instance.Error(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",保存客户存档信息失败 存档ID：",
@int,
",身份证号:",
text2
}));
msg = "{\"success\":\"0\",\"Message\":\"修改失败！\"}";
this.OutPutMessage(msg);
}
memoryStream.Close();
memoryStream.Dispose();
}
else
{
this.jsonInfo = string.Concat(new string[]
{
"{\"success\":\"0\",\"Message\":\"已存在客户名称[",
text,
"],证件号[",
text2,
"]的信息，不允许修改！\"}"
});
this.OutPutMessage(this.jsonInfo);
}
}
}
}
public int Add(PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OnArcCust(");
stringBuilder.Append("ID_Gender,ID_Marriage,NationID,CultrulID,VocationID,CustomerName,IDCard,ExamCard,Photo,BirthDay,GenderName,MarriageName,NationName,Address,MobileNo,Email,CultrulName,VocationName,FinishedNum,UnfinishedNum,FirstDatePE,LatestDatePE)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_Gender,@ID_Marriage,@NationID,@CultrulID,@VocationID,@CustomerName,@IDCard,@ExamCard,@Photo,@BirthDay,@GenderName,@MarriageName,@NationName,@Address,@MobileNo,@Email,@CultrulName,@VocationName,@FinishedNum,@UnfinishedNum,@FirstDatePE,@LatestDatePE)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@ID_Marriage", SqlDbType.Int, 4),
new SqlParameter("@NationID", SqlDbType.Int, 4),
new SqlParameter("@CultrulID", SqlDbType.Int, 4),
new SqlParameter("@VocationID", SqlDbType.Int, 4),
new SqlParameter("@CustomerName", SqlDbType.VarChar, 30),
new SqlParameter("@IDCard", SqlDbType.VarChar, 30),
new SqlParameter("@ExamCard", SqlDbType.VarChar, 30),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@GenderName", SqlDbType.VarChar, 8),
new SqlParameter("@MarriageName", SqlDbType.VarChar, 8),
new SqlParameter("@NationName", SqlDbType.VarChar, 10),
new SqlParameter("@Address", SqlDbType.VarChar, 120),
new SqlParameter("@MobileNo", SqlDbType.VarChar, 30),
new SqlParameter("@Email", SqlDbType.VarChar, 80),
new SqlParameter("@CultrulName", SqlDbType.VarChar, 10),
new SqlParameter("@VocationName", SqlDbType.VarChar, 10),
new SqlParameter("@FinishedNum", SqlDbType.Int, 4),
new SqlParameter("@UnfinishedNum", SqlDbType.Int, 4),
new SqlParameter("@FirstDatePE", SqlDbType.DateTime),
new SqlParameter("@LatestDatePE", SqlDbType.DateTime)
};
array[0].Value = model.ID_Gender;
array[1].Value = model.ID_Marriage;
array[2].Value = model.NationID;
array[3].Value = model.CultrulID;
array[4].Value = model.VocationID;
array[5].Value = model.CustomerName;
array[6].Value = model.IDCard;
array[7].Value = model.ExamCard;
array[8].Value = model.Photo;
array[9].Value = model.BirthDay;
array[10].Value = model.GenderName;
array[11].Value = model.MarriageName;
array[12].Value = model.NationName;
array[13].Value = model.Address;
array[14].Value = model.MobileNo;
array[15].Value = model.Email;
array[16].Value = model.CultrulName;
array[17].Value = model.VocationName;
array[18].Value = model.FinishedNum;
array[19].Value = model.UnfinishedNum;
array[20].Value = model.FirstDatePE;
array[21].Value = model.LatestDatePE;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public PEIS.Model.OnArcCust GetModel(int ID_ArcCustomer)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_ArcCustomer,ID_Gender,ID_Marriage,NationID,CultrulID,VocationID,CustomerName,IDCard,ExamCard,Photo,BirthDay,GenderName,MarriageName,NationName,Address,MobileNo,Email,CultrulName,VocationName,FinishedNum,UnfinishedNum,FirstDatePE,LatestDatePE from OnArcCust ");
stringBuilder.Append(" where ID_ArcCustomer=@ID_ArcCustomer");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ArcCustomer", SqlDbType.Int, 4)
};
array[0].Value = ID_ArcCustomer;
PEIS.Model.OnArcCust onArcCust = new PEIS.Model.OnArcCust();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.OnArcCust result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_ArcCustomer"].ToString() != "")
{
onArcCust.ID_ArcCustomer = int.Parse(dataSet.Tables[0].Rows[0]["ID_ArcCustomer"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_Gender"].ToString() != "")
{
onArcCust.ID_Gender = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Gender"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_Marriage"].ToString() != "")
{
onArcCust.ID_Marriage = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Marriage"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["NationID"].ToString() != "")
{
onArcCust.NationID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["NationID"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["CultrulID"].ToString() != "")
{
onArcCust.CultrulID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["CultrulID"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["VocationID"].ToString() != "")
{
onArcCust.VocationID = new int?(int.Parse(dataSet.Tables[0].Rows[0]["VocationID"].ToString()));
}
onArcCust.CustomerName = dataSet.Tables[0].Rows[0]["CustomerName"].ToString();
onArcCust.IDCard = dataSet.Tables[0].Rows[0]["IDCard"].ToString();
onArcCust.ExamCard = dataSet.Tables[0].Rows[0]["ExamCard"].ToString();
if (dataSet.Tables[0].Rows[0]["Photo"].ToString() != "")
{
onArcCust.Photo = (byte[])dataSet.Tables[0].Rows[0]["Photo"];
}
if (dataSet.Tables[0].Rows[0]["BirthDay"].ToString() != "")
{
onArcCust.BirthDay = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["BirthDay"].ToString()));
}
onArcCust.GenderName = dataSet.Tables[0].Rows[0]["GenderName"].ToString();
onArcCust.MarriageName = dataSet.Tables[0].Rows[0]["MarriageName"].ToString();
onArcCust.NationName = dataSet.Tables[0].Rows[0]["NationName"].ToString();
onArcCust.Address = dataSet.Tables[0].Rows[0]["Address"].ToString();
onArcCust.MobileNo = dataSet.Tables[0].Rows[0]["MobileNo"].ToString();
onArcCust.Email = dataSet.Tables[0].Rows[0]["Email"].ToString();
onArcCust.CultrulName = dataSet.Tables[0].Rows[0]["CultrulName"].ToString();
onArcCust.VocationName = dataSet.Tables[0].Rows[0]["VocationName"].ToString();
if (dataSet.Tables[0].Rows[0]["FinishedNum"].ToString() != "")
{
onArcCust.FinishedNum = int.Parse(dataSet.Tables[0].Rows[0]["FinishedNum"].ToString());
}
if (dataSet.Tables[0].Rows[0]["UnfinishedNum"].ToString() != "")
{
onArcCust.UnfinishedNum = new int?(int.Parse(dataSet.Tables[0].Rows[0]["UnfinishedNum"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["FirstDatePE"].ToString() != "")
{
onArcCust.FirstDatePE = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["FirstDatePE"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["LatestDatePE"].ToString() != "")
{
onArcCust.LatestDatePE = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["LatestDatePE"].ToString()));
}
result = onArcCust;
}
else
{
result = null;
}
return(result);
}
public bool Update(PEIS.Model.OnArcCust model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnArcCust set ");
stringBuilder.Append("ID_Gender=@ID_Gender,");
stringBuilder.Append("ID_Marriage=@ID_Marriage,");
stringBuilder.Append("NationID=@NationID,");
stringBuilder.Append("CultrulID=@CultrulID,");
stringBuilder.Append("VocationID=@VocationID,");
stringBuilder.Append("CustomerName=@CustomerName,");
stringBuilder.Append("IDCard=@IDCard,");
stringBuilder.Append("ExamCard=@ExamCard,");
stringBuilder.Append("Photo=@Photo,");
stringBuilder.Append("BirthDay=@BirthDay,");
stringBuilder.Append("GenderName=@GenderName,");
stringBuilder.Append("MarriageName=@MarriageName,");
stringBuilder.Append("NationName=@NationName,");
stringBuilder.Append("Address=@Address,");
stringBuilder.Append("MobileNo=@MobileNo,");
stringBuilder.Append("Email=@Email,");
stringBuilder.Append("CultrulName=@CultrulName,");
stringBuilder.Append("VocationName=@VocationName,");
stringBuilder.Append("FinishedNum=@FinishedNum,");
stringBuilder.Append("UnfinishedNum=@UnfinishedNum,");
stringBuilder.Append("FirstDatePE=@FirstDatePE,");
stringBuilder.Append("LatestDatePE=@LatestDatePE");
stringBuilder.Append(" where ID_ArcCustomer=@ID_ArcCustomer");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Gender", SqlDbType.Int, 4),
new SqlParameter("@ID_Marriage", SqlDbType.Int, 4),
new SqlParameter("@NationID", SqlDbType.Int, 4),
new SqlParameter("@CultrulID", SqlDbType.Int, 4),
new SqlParameter("@VocationID", SqlDbType.Int, 4),
new SqlParameter("@CustomerName", SqlDbType.VarChar, 30),
new SqlParameter("@IDCard", SqlDbType.VarChar, 30),
new SqlParameter("@ExamCard", SqlDbType.VarChar, 30),
new SqlParameter("@Photo", SqlDbType.Image),
new SqlParameter("@BirthDay", SqlDbType.DateTime),
new SqlParameter("@GenderName", SqlDbType.VarChar, 8),
new SqlParameter("@MarriageName", SqlDbType.VarChar, 8),
new SqlParameter("@NationName", SqlDbType.VarChar, 10),
new SqlParameter("@Address", SqlDbType.VarChar, 120),
new SqlParameter("@MobileNo", SqlDbType.VarChar, 30),
new SqlParameter("@Email", SqlDbType.VarChar, 80),
new SqlParameter("@CultrulName", SqlDbType.VarChar, 10),
new SqlParameter("@VocationName", SqlDbType.VarChar, 10),
new SqlParameter("@FinishedNum", SqlDbType.Int, 4),
new SqlParameter("@UnfinishedNum", SqlDbType.Int, 4),
new SqlParameter("@FirstDatePE", SqlDbType.DateTime),
new SqlParameter("@LatestDatePE", SqlDbType.DateTime),
new SqlParameter("@ID_ArcCustomer", SqlDbType.Int, 4)
};
array[0].Value = model.ID_Gender;
array[1].Value = model.ID_Marriage;
array[2].Value = model.NationID;
array[3].Value = model.CultrulID;
array[4].Value = model.VocationID;
array[5].Value = model.CustomerName;
array[6].Value = model.IDCard;
array[7].Value = model.ExamCard;
array[8].Value = model.Photo;
array[9].Value = model.BirthDay;
array[10].Value = model.GenderName;
array[11].Value = model.MarriageName;
array[12].Value = model.NationName;
array[13].Value = model.Address;
array[14].Value = model.MobileNo;
array[15].Value = model.Email;
array[16].Value = model.CultrulName;
array[17].Value = model.VocationName;
array[18].Value = model.FinishedNum;
array[19].Value = model.UnfinishedNum;
array[20].Value = model.FirstDatePE;
array[21].Value = model.LatestDatePE;
array[22].Value = model.ID_ArcCustomer;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
