public int Add(PEIS.Model.OnCustExamItem model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into OnCustExamItem("); stringBuilder.Append("ID_CustFee,ID_Fee,ID_ExamItem,ExamItemName,DiseaseLevel,ResultLabValues,ResultNumber,ResultLabLowLimit,ResultLabHighLimit,ResultLabUnit,ResultLabMark,ResultSummary,ID_SummaryDoctor,SummaryDoctorName,TypistName,ExamItemSummaryDate,ID_Typist,ResultLabRange,ID_Customer,AbbrExamName,DetectionMethod,SCO,ID_CustApply)"); stringBuilder.Append(" values ("); stringBuilder.Append("@ID_CustFee,@ID_Fee,@ID_ExamItem,@ExamItemName,@DiseaseLevel,@ResultLabValues,@ResultNumber,@ResultLabLowLimit,@ResultLabHighLimit,@ResultLabUnit,@ResultLabMark,@ResultSummary,@ID_SummaryDoctor,@SummaryDoctorName,@TypistName,@ExamItemSummaryDate,@ID_Typist,@ResultLabRange,@ID_Customer,@AbbrExamName,@DetectionMethod,@SCO,@ID_CustApply)"); stringBuilder.Append(";select @@IDENTITY"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_CustFee", SqlDbType.Int, 4), new SqlParameter("@ID_Fee", SqlDbType.Int, 4), new SqlParameter("@ID_ExamItem", SqlDbType.Int, 4), new SqlParameter("@ExamItemName", SqlDbType.VarChar, 50), new SqlParameter("@DiseaseLevel", SqlDbType.Int, 4), new SqlParameter("@ResultLabValues", SqlDbType.VarChar, 240), new SqlParameter("@ResultNumber", SqlDbType.Float, 8), new SqlParameter("@ResultLabLowLimit", SqlDbType.Float, 8), new SqlParameter("@ResultLabHighLimit", SqlDbType.Float, 8), new SqlParameter("@ResultLabUnit", SqlDbType.VarChar, 10), new SqlParameter("@ResultLabMark", SqlDbType.VarChar, 60), new SqlParameter("@ResultSummary", SqlDbType.Text), new SqlParameter("@ID_SummaryDoctor", SqlDbType.Int, 4), new SqlParameter("@SummaryDoctorName", SqlDbType.VarChar, 30), new SqlParameter("@TypistName", SqlDbType.VarChar, 30), new SqlParameter("@ExamItemSummaryDate", SqlDbType.DateTime), new SqlParameter("@ID_Typist", SqlDbType.Int, 4), new SqlParameter("@ResultLabRange", SqlDbType.VarChar, 100), new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8), new SqlParameter("@AbbrExamName", SqlDbType.VarChar, 60), new SqlParameter("@DetectionMethod", SqlDbType.VarChar, 60), new SqlParameter("@SCO", SqlDbType.VarChar, 20), new SqlParameter("@ID_CustApply", SqlDbType.VarChar, 60) }; array[0].Value = model.ID_CustFee; array[1].Value = model.ID_Fee; array[2].Value = model.ID_ExamItem; array[3].Value = model.ExamItemName; array[4].Value = model.DiseaseLevel; array[5].Value = model.ResultLabValues; array[6].Value = model.ResultNumber; array[7].Value = model.ResultLabLowLimit; array[8].Value = model.ResultLabHighLimit; array[9].Value = model.ResultLabUnit; array[10].Value = model.ResultLabMark; array[11].Value = model.ResultSummary; array[12].Value = model.ID_SummaryDoctor; array[13].Value = model.SummaryDoctorName; array[14].Value = model.TypistName; array[15].Value = model.ExamItemSummaryDate; array[16].Value = model.ID_Typist; array[17].Value = model.ResultLabRange; array[18].Value = model.ID_Customer; array[19].Value = model.AbbrExamName; array[20].Value = model.DetectionMethod; array[21].Value = model.SCO; array[22].Value = model.ID_CustApply; object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array); int result; if (single == null) { result = 0; } else { result = Convert.ToInt32(single); } return(result); }
public PEIS.Model.OnCustExamItem GetModel(int ID_CustExamItem) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 ID_CustExamItem,ID_CustFee,ID_Fee,ID_ExamItem,ExamItemName,DiseaseLevel,ResultLabValues,ResultNumber,ResultLabRange,ResultLabLowLimit,ResultLabHighLimit,ResultLabUnit,ResultLabMark,ResultSummary,ID_SummaryDoctor,SummaryDoctorName,TypistName,ExamItemSummaryDate,ID_Typist from OnCustExamItem "); stringBuilder.Append(" where ID_CustExamItem=@ID_CustExamItem"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_CustExamItem", SqlDbType.Int, 4) }; array[0].Value = ID_CustExamItem; PEIS.Model.OnCustExamItem onCustExamItem = new PEIS.Model.OnCustExamItem(); DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array); PEIS.Model.OnCustExamItem result; if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows[0]["ID_CustExamItem"].ToString() != "") { onCustExamItem.ID_CustExamItem = int.Parse(dataSet.Tables[0].Rows[0]["ID_CustExamItem"].ToString()); } if (dataSet.Tables[0].Rows[0]["ID_CustFee"].ToString() != "") { onCustExamItem.ID_CustFee = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_CustFee"].ToString())); } if (dataSet.Tables[0].Rows[0]["ID_Fee"].ToString() != "") { onCustExamItem.ID_Fee = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Fee"].ToString())); } if (dataSet.Tables[0].Rows[0]["ID_ExamItem"].ToString() != "") { onCustExamItem.ID_ExamItem = int.Parse(dataSet.Tables[0].Rows[0]["ID_ExamItem"].ToString()); } onCustExamItem.ExamItemName = dataSet.Tables[0].Rows[0]["ExamItemName"].ToString(); if (dataSet.Tables[0].Rows[0]["DiseaseLevel"].ToString() != "") { onCustExamItem.DiseaseLevel = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DiseaseLevel"].ToString())); } onCustExamItem.ResultLabValues = dataSet.Tables[0].Rows[0]["ResultLabValues"].ToString(); if (dataSet.Tables[0].Rows[0]["ResultNumber"].ToString() != "") { onCustExamItem.ResultNumber = new decimal?(decimal.Parse(dataSet.Tables[0].Rows[0]["ResultNumber"].ToString())); } onCustExamItem.ResultLabRange = dataSet.Tables[0].Rows[0]["ResultLabRange"].ToString(); if (dataSet.Tables[0].Rows[0]["ResultLabLowLimit"].ToString() != "") { onCustExamItem.ResultLabLowLimit = new decimal?(decimal.Parse(dataSet.Tables[0].Rows[0]["ResultLabLowLimit"].ToString())); } if (dataSet.Tables[0].Rows[0]["ResultLabHighLimit"].ToString() != "") { onCustExamItem.ResultLabHighLimit = new decimal?(decimal.Parse(dataSet.Tables[0].Rows[0]["ResultLabHighLimit"].ToString())); } onCustExamItem.ResultLabUnit = dataSet.Tables[0].Rows[0]["ResultLabUnit"].ToString(); onCustExamItem.ResultLabMark = dataSet.Tables[0].Rows[0]["ResultLabMark"].ToString(); onCustExamItem.ResultSummary = dataSet.Tables[0].Rows[0]["ResultSummary"].ToString(); if (dataSet.Tables[0].Rows[0]["ID_SummaryDoctor"].ToString() != "") { onCustExamItem.ID_SummaryDoctor = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_SummaryDoctor"].ToString())); } onCustExamItem.SummaryDoctorName = dataSet.Tables[0].Rows[0]["SummaryDoctorName"].ToString(); onCustExamItem.TypistName = dataSet.Tables[0].Rows[0]["TypistName"].ToString(); if (dataSet.Tables[0].Rows[0]["ExamItemSummaryDate"].ToString() != "") { onCustExamItem.ExamItemSummaryDate = DateTime.Parse(dataSet.Tables[0].Rows[0]["ExamItemSummaryDate"].ToString()); } if (dataSet.Tables[0].Rows[0]["ID_Typist"].ToString() != "") { onCustExamItem.ID_Typist = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Typist"].ToString())); } result = onCustExamItem; } else { result = null; } return(result); }
public bool Update(PEIS.Model.OnCustExamItem model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update OnCustExamItem set "); stringBuilder.Append("ID_CustFee=@ID_CustFee,"); stringBuilder.Append("ID_Fee=@ID_Fee,"); stringBuilder.Append("ID_ExamItem=@ID_ExamItem,"); stringBuilder.Append("ExamItemName=@ExamItemName,"); stringBuilder.Append("DiseaseLevel=@DiseaseLevel,"); stringBuilder.Append("ResultLabValues=@ResultLabValues,"); stringBuilder.Append("ResultNumber=@ResultNumber,"); stringBuilder.Append("ResultLabLowLimit=@ResultLabLowLimit,"); stringBuilder.Append("ResultLabHighLimit=@ResultLabHighLimit,"); stringBuilder.Append("ResultLabUnit=@ResultLabUnit,"); stringBuilder.Append("ResultLabMark=@ResultLabMark,"); stringBuilder.Append("ResultSummary=@ResultSummary,"); stringBuilder.Append("ID_SummaryDoctor=@ID_SummaryDoctor,"); stringBuilder.Append("SummaryDoctorName=@SummaryDoctorName,"); stringBuilder.Append("TypistName=@TypistName,"); stringBuilder.Append("ExamItemSummaryDate=@ExamItemSummaryDate,"); stringBuilder.Append("ID_Typist=@ID_Typist,"); stringBuilder.Append("ResultLabRange=@ResultLabRange,"); stringBuilder.Append("ID_Customer=@ID_Customer,"); stringBuilder.Append("AbbrExamName=@AbbrExamName,"); stringBuilder.Append("DetectionMethod=@DetectionMethod,"); stringBuilder.Append("SCO=@SCO,"); stringBuilder.Append("ID_CustApply=@ID_CustApply"); stringBuilder.Append(" where ID_CustExamItem=@ID_CustExamItem"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_CustFee", SqlDbType.Int, 4), new SqlParameter("@ID_Fee", SqlDbType.Int, 4), new SqlParameter("@ID_ExamItem", SqlDbType.Int, 4), new SqlParameter("@ExamItemName", SqlDbType.VarChar, 50), new SqlParameter("@DiseaseLevel", SqlDbType.Int, 4), new SqlParameter("@ResultLabValues", SqlDbType.VarChar, 240), new SqlParameter("@ResultNumber", SqlDbType.Float, 8), new SqlParameter("@ResultLabLowLimit", SqlDbType.Float, 8), new SqlParameter("@ResultLabHighLimit", SqlDbType.Float, 8), new SqlParameter("@ResultLabUnit", SqlDbType.VarChar, 10), new SqlParameter("@ResultLabMark", SqlDbType.VarChar, 60), new SqlParameter("@ResultSummary", SqlDbType.Text), new SqlParameter("@ID_SummaryDoctor", SqlDbType.Int, 4), new SqlParameter("@SummaryDoctorName", SqlDbType.VarChar, 30), new SqlParameter("@TypistName", SqlDbType.VarChar, 30), new SqlParameter("@ExamItemSummaryDate", SqlDbType.DateTime), new SqlParameter("@ID_Typist", SqlDbType.Int, 4), new SqlParameter("@ResultLabRange", SqlDbType.VarChar, 100), new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8), new SqlParameter("@AbbrExamName", SqlDbType.VarChar, 60), new SqlParameter("@DetectionMethod", SqlDbType.VarChar, 60), new SqlParameter("@SCO", SqlDbType.VarChar, 20), new SqlParameter("@ID_CustApply", SqlDbType.VarChar, 60), new SqlParameter("@ID_CustExamItem", SqlDbType.Int, 4) }; array[0].Value = model.ID_CustFee; array[1].Value = model.ID_Fee; array[2].Value = model.ID_ExamItem; array[3].Value = model.ExamItemName; array[4].Value = model.DiseaseLevel; array[5].Value = model.ResultLabValues; array[6].Value = model.ResultNumber; array[7].Value = model.ResultLabLowLimit; array[8].Value = model.ResultLabHighLimit; array[9].Value = model.ResultLabUnit; array[10].Value = model.ResultLabMark; array[11].Value = model.ResultSummary; array[12].Value = model.ID_SummaryDoctor; array[13].Value = model.SummaryDoctorName; array[14].Value = model.TypistName; array[15].Value = model.ExamItemSummaryDate; array[16].Value = model.ID_Typist; array[17].Value = model.ResultLabRange; array[18].Value = model.ID_Customer; array[19].Value = model.AbbrExamName; array[20].Value = model.DetectionMethod; array[21].Value = model.SCO; array[22].Value = model.ID_CustApply; array[23].Value = model.ID_CustExamItem; int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array); return(num > 0); }
public List <PEIS.Model.OnCustExamItem> DataTableToList(DataTable dt) { List <PEIS.Model.OnCustExamItem> list = new List <PEIS.Model.OnCustExamItem>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.OnCustExamItem onCustExamItem = new PEIS.Model.OnCustExamItem(); if (dt.Rows[i]["ID_CustExamItem"].ToString() != "") { onCustExamItem.ID_CustExamItem = int.Parse(dt.Rows[i]["ID_CustExamItem"].ToString()); } if (dt.Rows[i]["ID_CustFee"].ToString() != "") { onCustExamItem.ID_CustFee = new int?(int.Parse(dt.Rows[i]["ID_CustFee"].ToString())); } if (dt.Rows[i]["ID_Fee"].ToString() != "") { onCustExamItem.ID_Fee = new int?(int.Parse(dt.Rows[i]["ID_Fee"].ToString())); } if (dt.Rows[i]["ID_ExamItem"].ToString() != "") { onCustExamItem.ID_ExamItem = int.Parse(dt.Rows[i]["ID_ExamItem"].ToString()); } onCustExamItem.ExamItemName = dt.Rows[i]["ExamItemName"].ToString(); if (dt.Rows[i]["DiseaseLevel"].ToString() != "") { onCustExamItem.DiseaseLevel = new int?(int.Parse(dt.Rows[i]["DiseaseLevel"].ToString())); } onCustExamItem.ResultLabValues = dt.Rows[i]["ResultLabValues"].ToString(); if (dt.Rows[i]["ResultNumber"].ToString() != "") { onCustExamItem.ResultNumber = new decimal?(decimal.Parse(dt.Rows[i]["ResultNumber"].ToString())); } if (dt.Rows[i]["ResultLabLowLimit"].ToString() != "") { onCustExamItem.ResultLabLowLimit = new decimal?(decimal.Parse(dt.Rows[i]["ResultLabLowLimit"].ToString())); } if (dt.Rows[i]["ResultLabHighLimit"].ToString() != "") { onCustExamItem.ResultLabHighLimit = new decimal?(decimal.Parse(dt.Rows[i]["ResultLabHighLimit"].ToString())); } onCustExamItem.ResultLabUnit = dt.Rows[i]["ResultLabUnit"].ToString(); onCustExamItem.ResultLabMark = dt.Rows[i]["ResultLabMark"].ToString(); onCustExamItem.ResultSummary = dt.Rows[i]["ResultSummary"].ToString(); if (dt.Rows[i]["ID_SummaryDoctor"].ToString() != "") { onCustExamItem.ID_SummaryDoctor = new int?(int.Parse(dt.Rows[i]["ID_SummaryDoctor"].ToString())); } onCustExamItem.SummaryDoctorName = dt.Rows[i]["SummaryDoctorName"].ToString(); onCustExamItem.TypistName = dt.Rows[i]["TypistName"].ToString(); if (dt.Rows[i]["ExamItemSummaryDate"].ToString() != "") { onCustExamItem.ExamItemSummaryDate = DateTime.Parse(dt.Rows[i]["ExamItemSummaryDate"].ToString()); } if (dt.Rows[i]["ID_Typist"].ToString() != "") { onCustExamItem.ID_Typist = new int?(int.Parse(dt.Rows[i]["ID_Typist"].ToString())); } onCustExamItem.ResultLabRange = dt.Rows[i]["ResultLabRange"].ToString(); if (dt.Rows[i]["ID_Customer"].ToString() != "") { onCustExamItem.ID_Customer = new long?(long.Parse(dt.Rows[i]["ID_Customer"].ToString())); } onCustExamItem.AbbrExamName = dt.Rows[i]["AbbrExamName"].ToString(); onCustExamItem.DetectionMethod = dt.Rows[i]["DetectionMethod"].ToString(); onCustExamItem.SCO = dt.Rows[i]["SCO"].ToString(); onCustExamItem.ID_CustApply = dt.Rows[i]["ID_CustApply"].ToString(); list.Add(onCustExamItem); } } return(list); }
public bool Update(PEIS.Model.OnCustExamItem model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.OnCustExamItem model) { return(this.dal.Add(model)); }