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); }