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