public bool Update(PEIS.Model.OnCustConclusion model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update OnCustConclusion set ");
stringBuilder.Append("ID_Customer=@ID_Customer,");
stringBuilder.Append("ConclusionName=@ConclusionName,");
stringBuilder.Append("ConclusionTypeName=@ConclusionTypeName,");
stringBuilder.Append("Is_NoEntrySuggestion=@Is_NoEntrySuggestion,");
stringBuilder.Append("Explanation=@Explanation,");
stringBuilder.Append("Suggestion=@Suggestion,");
stringBuilder.Append("DietGuide=@DietGuide,");
stringBuilder.Append("SportGuide=@SportGuide,");
stringBuilder.Append("HealthKnowledge=@HealthKnowledge,");
stringBuilder.Append("ID_Doctor=@ID_Doctor,");
stringBuilder.Append("DoctorName=@DoctorName,");
stringBuilder.Append("ConclusionDate=@ConclusionDate,");
stringBuilder.Append("ID_Conclusion=@ID_Conclusion,");
stringBuilder.Append("DispOrder=@DispOrder,");
stringBuilder.Append("DiagnoseType=@DiagnoseType");
stringBuilder.Append(" where ID_CustConclusion=@ID_CustConclusion");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
new SqlParameter("@ConclusionName", SqlDbType.VarChar, 200),
new SqlParameter("@ConclusionTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Is_NoEntrySuggestion", SqlDbType.Bit, 1),
new SqlParameter("@Explanation", SqlDbType.Text),
new SqlParameter("@Suggestion", SqlDbType.Text),
new SqlParameter("@DietGuide", SqlDbType.Text),
new SqlParameter("@SportGuide", SqlDbType.Text),
new SqlParameter("@HealthKnowledge", SqlDbType.Text),
new SqlParameter("@ID_Doctor", SqlDbType.Int, 4),
new SqlParameter("@DoctorName", SqlDbType.VarChar, 30),
new SqlParameter("@ConclusionDate", SqlDbType.DateTime),
new SqlParameter("@ID_Conclusion", SqlDbType.Int, 4),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@DiagnoseType", SqlDbType.Int, 4),
new SqlParameter("@ID_CustConclusion", SqlDbType.Int, 4)
};
array[0].Value = model.ID_Customer;
array[1].Value = model.ConclusionName;
array[2].Value = model.ConclusionTypeName;
array[3].Value = model.Is_NoEntrySuggestion;
array[4].Value = model.Explanation;
array[5].Value = model.Suggestion;
array[6].Value = model.DietGuide;
array[7].Value = model.SportGuide;
array[8].Value = model.HealthKnowledge;
array[9].Value = model.ID_Doctor;
array[10].Value = model.DoctorName;
array[11].Value = model.ConclusionDate;
array[12].Value = model.ID_Conclusion;
array[13].Value = model.DispOrder;
array[14].Value = model.DiagnoseType;
array[15].Value = model.ID_CustConclusion;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public int Add(PEIS.Model.OnCustConclusion model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into OnCustConclusion(");
stringBuilder.Append("ID_Customer,ConclusionName,ConclusionTypeName,Is_NoEntrySuggestion,Explanation,Suggestion,DietGuide,SportGuide,HealthKnowledge,ID_Doctor,DoctorName,ConclusionDate,ID_Conclusion,DispOrder,DiagnoseType)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_Customer,@ConclusionName,@ConclusionTypeName,@Is_NoEntrySuggestion,@Explanation,@Suggestion,@DietGuide,@SportGuide,@HealthKnowledge,@ID_Doctor,@DoctorName,@ConclusionDate,@ID_Conclusion,@DispOrder,@DiagnoseType)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Customer", SqlDbType.BigInt, 8),
new SqlParameter("@ConclusionName", SqlDbType.VarChar, 200),
new SqlParameter("@ConclusionTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@Is_NoEntrySuggestion", SqlDbType.Bit, 1),
new SqlParameter("@Explanation", SqlDbType.Text),
new SqlParameter("@Suggestion", SqlDbType.Text),
new SqlParameter("@DietGuide", SqlDbType.Text),
new SqlParameter("@SportGuide", SqlDbType.Text),
new SqlParameter("@HealthKnowledge", SqlDbType.Text),
new SqlParameter("@ID_Doctor", SqlDbType.Int, 4),
new SqlParameter("@DoctorName", SqlDbType.VarChar, 30),
new SqlParameter("@ConclusionDate", SqlDbType.DateTime),
new SqlParameter("@ID_Conclusion", SqlDbType.Int, 4),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@DiagnoseType", SqlDbType.Int, 4)
};
array[0].Value = model.ID_Customer;
array[1].Value = model.ConclusionName;
array[2].Value = model.ConclusionTypeName;
array[3].Value = model.Is_NoEntrySuggestion;
array[4].Value = model.Explanation;
array[5].Value = model.Suggestion;
array[6].Value = model.DietGuide;
array[7].Value = model.SportGuide;
array[8].Value = model.HealthKnowledge;
array[9].Value = model.ID_Doctor;
array[10].Value = model.DoctorName;
array[11].Value = model.ConclusionDate;
array[12].Value = model.ID_Conclusion;
array[13].Value = model.DispOrder;
array[14].Value = model.DiagnoseType;
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.OnCustConclusion> DataTableToList(DataTable dt)
{
List <PEIS.Model.OnCustConclusion> list = new List <PEIS.Model.OnCustConclusion>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.OnCustConclusion onCustConclusion = new PEIS.Model.OnCustConclusion();
if (dt.Rows[i]["ID_CustConclusion"].ToString() != "")
{
onCustConclusion.ID_CustConclusion = int.Parse(dt.Rows[i]["ID_CustConclusion"].ToString());
}
if (dt.Rows[i]["ID_Customer"].ToString() != "")
{
onCustConclusion.ID_Customer = new long?(long.Parse(dt.Rows[i]["ID_Customer"].ToString()));
}
onCustConclusion.ConclusionName = dt.Rows[i]["ConclusionName"].ToString();
onCustConclusion.ConclusionTypeName = dt.Rows[i]["ConclusionTypeName"].ToString();
if (dt.Rows[i]["Is_NoEntrySuggestion"].ToString() != "")
{
if (dt.Rows[i]["Is_NoEntrySuggestion"].ToString() == "1" || dt.Rows[i]["Is_NoEntrySuggestion"].ToString().ToLower() == "true")
{
onCustConclusion.Is_NoEntrySuggestion = new bool?(true);
}
else
{
onCustConclusion.Is_NoEntrySuggestion = new bool?(false);
}
}
onCustConclusion.Explanation = dt.Rows[i]["Explanation"].ToString();
onCustConclusion.Suggestion = dt.Rows[i]["Suggestion"].ToString();
onCustConclusion.DietGuide = dt.Rows[i]["DietGuide"].ToString();
onCustConclusion.SportGuide = dt.Rows[i]["SportGuide"].ToString();
onCustConclusion.HealthKnowledge = dt.Rows[i]["HealthKnowledge"].ToString();
if (dt.Rows[i]["ID_Doctor"].ToString() != "")
{
onCustConclusion.ID_Doctor = new int?(int.Parse(dt.Rows[i]["ID_Doctor"].ToString()));
}
onCustConclusion.DoctorName = dt.Rows[i]["DoctorName"].ToString();
if (dt.Rows[i]["ConclusionDate"].ToString() != "")
{
onCustConclusion.ConclusionDate = DateTime.Parse(dt.Rows[i]["ConclusionDate"].ToString());
}
if (dt.Rows[i]["ID_Conclusion"].ToString() != "")
{
onCustConclusion.ID_Conclusion = new int?(int.Parse(dt.Rows[i]["ID_Conclusion"].ToString()));
}
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
onCustConclusion.DispOrder = new int?(int.Parse(dt.Rows[i]["DispOrder"].ToString()));
}
if (dt.Rows[i]["DiagnoseType"].ToString() != "")
{
onCustConclusion.DiagnoseType = new int?(int.Parse(dt.Rows[i]["DiagnoseType"].ToString()));
}
list.Add(onCustConclusion);
}
}
return(list);
}
public bool Update(PEIS.Model.OnCustConclusion model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.OnCustConclusion model)
{
return(this.dal.Add(model));
}
public PEIS.Model.OnCustConclusion GetModel(int ID_CustConclusion)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_CustConclusion,ID_Customer,ConclusionName,ConclusionTypeName,Is_NoEntrySuggestion,Explanation,Suggestion,DietGuide,SportGuide,HealthKnowledge,ID_Doctor,DoctorName,ConclusionDate,ID_Conclusion,DispOrder,DiagnoseType from OnCustConclusion ");
stringBuilder.Append(" where ID_CustConclusion=@ID_CustConclusion");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_CustConclusion", SqlDbType.Int, 4)
};
array[0].Value = ID_CustConclusion;
PEIS.Model.OnCustConclusion onCustConclusion = new PEIS.Model.OnCustConclusion();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.OnCustConclusion result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_CustConclusion"].ToString() != "")
{
onCustConclusion.ID_CustConclusion = int.Parse(dataSet.Tables[0].Rows[0]["ID_CustConclusion"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_Customer"].ToString() != "")
{
onCustConclusion.ID_Customer = new long?(long.Parse(dataSet.Tables[0].Rows[0]["ID_Customer"].ToString()));
}
onCustConclusion.ConclusionName = dataSet.Tables[0].Rows[0]["ConclusionName"].ToString();
onCustConclusion.ConclusionTypeName = dataSet.Tables[0].Rows[0]["ConclusionTypeName"].ToString();
if (dataSet.Tables[0].Rows[0]["Is_NoEntrySuggestion"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_NoEntrySuggestion"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_NoEntrySuggestion"].ToString().ToLower() == "true")
{
onCustConclusion.Is_NoEntrySuggestion = new bool?(true);
}
else
{
onCustConclusion.Is_NoEntrySuggestion = new bool?(false);
}
}
onCustConclusion.Explanation = dataSet.Tables[0].Rows[0]["Explanation"].ToString();
onCustConclusion.Suggestion = dataSet.Tables[0].Rows[0]["Suggestion"].ToString();
onCustConclusion.DietGuide = dataSet.Tables[0].Rows[0]["DietGuide"].ToString();
onCustConclusion.SportGuide = dataSet.Tables[0].Rows[0]["SportGuide"].ToString();
onCustConclusion.HealthKnowledge = dataSet.Tables[0].Rows[0]["HealthKnowledge"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Doctor"].ToString() != "")
{
onCustConclusion.ID_Doctor = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Doctor"].ToString()));
}
onCustConclusion.DoctorName = dataSet.Tables[0].Rows[0]["DoctorName"].ToString();
if (dataSet.Tables[0].Rows[0]["ConclusionDate"].ToString() != "")
{
onCustConclusion.ConclusionDate = DateTime.Parse(dataSet.Tables[0].Rows[0]["ConclusionDate"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_Conclusion"].ToString() != "")
{
onCustConclusion.ID_Conclusion = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Conclusion"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["DispOrder"].ToString() != "")
{
onCustConclusion.DispOrder = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DispOrder"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["DiagnoseType"].ToString() != "")
{
onCustConclusion.DiagnoseType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DiagnoseType"].ToString()));
}
result = onCustConclusion;
}
else
{
result = null;
}
return(result);
}
