public int Add(PEIS.Model.OnCustExamItemResult model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into OnCustExamItemResult("); stringBuilder.Append("ID_CustExamItem,ID_Symptom)"); stringBuilder.Append(" values ("); stringBuilder.Append("@ID_CustExamItem,@ID_Symptom)"); stringBuilder.Append(";select @@IDENTITY"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_CustExamItem", SqlDbType.Int, 4), new SqlParameter("@ID_Symptom", SqlDbType.Int, 4) }; array[0].Value = model.ID_CustExamItem; array[1].Value = model.ID_Symptom; 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.OnCustExamItemResult> DataTableToList(DataTable dt) { List <PEIS.Model.OnCustExamItemResult> list = new List <PEIS.Model.OnCustExamItemResult>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.OnCustExamItemResult onCustExamItemResult = new PEIS.Model.OnCustExamItemResult(); if (dt.Rows[i]["ID_ExamItemResult"].ToString() != "") { onCustExamItemResult.ID_ExamItemResult = int.Parse(dt.Rows[i]["ID_ExamItemResult"].ToString()); } if (dt.Rows[i]["ID_CustExamItem"].ToString() != "") { onCustExamItemResult.ID_CustExamItem = new int?(int.Parse(dt.Rows[i]["ID_CustExamItem"].ToString())); } if (dt.Rows[i]["ID_Symptom"].ToString() != "") { onCustExamItemResult.ID_Symptom = new int?(int.Parse(dt.Rows[i]["ID_Symptom"].ToString())); } list.Add(onCustExamItemResult); } } return(list); }
public bool Update(PEIS.Model.OnCustExamItemResult model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update OnCustExamItemResult set "); stringBuilder.Append("ID_CustExamItem=@ID_CustExamItem,"); stringBuilder.Append("ID_Symptom=@ID_Symptom"); stringBuilder.Append(" where ID_ExamItemResult=@ID_ExamItemResult"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_CustExamItem", SqlDbType.Int, 4), new SqlParameter("@ID_Symptom", SqlDbType.Int, 4), new SqlParameter("@ID_ExamItemResult", SqlDbType.Int, 4) }; array[0].Value = model.ID_CustExamItem; array[1].Value = model.ID_Symptom; array[2].Value = model.ID_ExamItemResult; int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array); return(num > 0); }
public PEIS.Model.OnCustExamItemResult GetModel(int ID_ExamItemResult) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 ID_ExamItemResult,ID_CustExamItem,ID_Symptom from OnCustExamItemResult "); stringBuilder.Append(" where ID_ExamItemResult=@ID_ExamItemResult"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_ExamItemResult", SqlDbType.Int, 4) }; array[0].Value = ID_ExamItemResult; PEIS.Model.OnCustExamItemResult onCustExamItemResult = new PEIS.Model.OnCustExamItemResult(); DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array); PEIS.Model.OnCustExamItemResult result; if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows[0]["ID_ExamItemResult"].ToString() != "") { onCustExamItemResult.ID_ExamItemResult = int.Parse(dataSet.Tables[0].Rows[0]["ID_ExamItemResult"].ToString()); } if (dataSet.Tables[0].Rows[0]["ID_CustExamItem"].ToString() != "") { onCustExamItemResult.ID_CustExamItem = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_CustExamItem"].ToString())); } if (dataSet.Tables[0].Rows[0]["ID_Symptom"].ToString() != "") { onCustExamItemResult.ID_Symptom = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Symptom"].ToString())); } result = onCustExamItemResult; } else { result = null; } return(result); }
public bool Update(PEIS.Model.OnCustExamItemResult model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.OnCustExamItemResult model) { return(this.dal.Add(model)); }