protected void GetEditConclusionInfo(int ID_Conclusion, ref VelocityContext vltContext)
{
if (ID_Conclusion > 0)
{
PEIS.Model.BusConclusion model = PEIS.BLL.BusConclusion.Instance.GetModel(ID_Conclusion);
if (null != model)
{
vltContext.Put("ID_Conclusion", model.ID_Conclusion);
vltContext.Put("ID_ConclusionType", model.ID_ConclusionType);
vltContext.Put("ConclusionName", Secret.AES.DecryptPrefix(model.ConclusionName));
vltContext.Put("DispOrder", model.DispOrder);
vltContext.Put("ForGender", model.ForGender);
vltContext.Put("InputCode", model.InputCode);
vltContext.Put("Explanation", Secret.AES.DecryptPrefix(model.Explanation));
vltContext.Put("Suggestion", Secret.AES.DecryptPrefix(model.Suggestion));
vltContext.Put("DietGuide", Secret.AES.DecryptPrefix(model.DietGuide));
vltContext.Put("SportsGuide", Secret.AES.DecryptPrefix(model.SportsGuide));
vltContext.Put("Is_Banned", model.Is_Banned);
vltContext.Put("BanOperator", model.BanOperator);
vltContext.Put("ID_BanOpr", model.ID_BanOpr);
vltContext.Put("BanDescribe", model.BanDescribe);
vltContext.Put("BanDate", model.BanDate);
vltContext.Put("ID_Createopr", model.ID_Createopr);
vltContext.Put("CreateOperator", model.CreateOperator);
vltContext.Put("CreateDate", model.CreateDate);
vltContext.Put("HealthKnowledge", Secret.AES.DecryptPrefix(model.HealthKnowledge));
vltContext.Put("TeamConclusionName", Secret.AES.DecryptPrefix(model.TeamConclusionName));
if (model.ID_ConclusionType.HasValue)
{
string value = CommonConclusion.Instance.GetConclusionTypeName(int.Parse(model.ID_ConclusionType.ToString()));
vltContext.Put("ConclusionTypeName", value);
}
vltContext.Put("ID_ICD", model.ID_ICD);
if (model.ID_ICD.HasValue)
{
string value = CommonConfig.Instance.GetICDCNName(int.Parse(model.ID_ICD.ToString()));
vltContext.Put("ICDCNName", value);
}
vltContext.Put("ID_FinalConclusionType", model.ID_FinalConclusionType);
if (model.ID_FinalConclusionType.HasValue)
{
string value = CommonConfig.Instance.GetFinalConclusionTypeName(int.Parse(model.ID_FinalConclusionType.ToString()));
vltContext.Put("FinalConclusionTypeName", value);
}
}
}
}
public bool Update(PEIS.Model.BusConclusion model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update BusConclusion set ");
stringBuilder.Append("ID_ConclusionType=@ID_ConclusionType,");
stringBuilder.Append("ConclusionName=@ConclusionName,");
stringBuilder.Append("Explanation=@Explanation,");
stringBuilder.Append("Suggestion=@Suggestion,");
stringBuilder.Append("DietGuide=@DietGuide,");
stringBuilder.Append("SportsGuide=@SportsGuide,");
stringBuilder.Append("HealthKnowledge=@HealthKnowledge,");
stringBuilder.Append("Forsex=@Forsex,");
stringBuilder.Append("InputCode=@InputCode,");
stringBuilder.Append("DispOrder=@DispOrder,");
stringBuilder.Append("TeamConclusionName=@TeamConclusionName,");
stringBuilder.Append("ID_Createopr=@ID_Createopr,");
stringBuilder.Append("CreateOperator=@CreateOperator,");
stringBuilder.Append("CreateDate=@CreateDate,");
stringBuilder.Append("Is_Banned=@Is_Banned,");
stringBuilder.Append("ID_BanOpr=@ID_BanOpr,");
stringBuilder.Append("BanOperator=@BanOperator,");
stringBuilder.Append("BanDate=@BanDate,");
stringBuilder.Append("BanDescribe=@BanDescribe,");
stringBuilder.Append("ID_ICD=@ID_ICD,");
stringBuilder.Append("ID_FinalConclusionType=@ID_FinalConclusionType");
stringBuilder.Append(" where ID_Conclusion=@ID_Conclusion");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ConclusionType", SqlDbType.Int, 4),
new SqlParameter("@ConclusionName", SqlDbType.VarChar, 50),
new SqlParameter("@Explanation", SqlDbType.Text),
new SqlParameter("@Suggestion", SqlDbType.Text),
new SqlParameter("@DietGuide", SqlDbType.Text),
new SqlParameter("@SportsGuide", SqlDbType.Text),
new SqlParameter("@HealthKnowledge", SqlDbType.Text),
new SqlParameter("@Forsex", SqlDbType.Int, 4),
new SqlParameter("@InputCode", SqlDbType.VarChar, 20),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@TeamConclusionName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Createopr", SqlDbType.Int, 4),
new SqlParameter("@CreateOperator", SqlDbType.VarChar, 30),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Is_Banned", SqlDbType.Bit, 1),
new SqlParameter("@ID_BanOpr", SqlDbType.Int, 4),
new SqlParameter("@BanOperator", SqlDbType.VarChar, 30),
new SqlParameter("@BanDate", SqlDbType.DateTime),
new SqlParameter("@BanDescribe", SqlDbType.VarChar, 100),
new SqlParameter("@ID_ICD", SqlDbType.Int, 4),
new SqlParameter("@ID_FinalConclusionType", SqlDbType.Int, 4),
new SqlParameter("@ID_Conclusion", SqlDbType.Int, 4)
};
array[0].Value = model.ID_ConclusionType;
array[1].Value = model.ConclusionName;
array[2].Value = model.Explanation;
array[3].Value = model.Suggestion;
array[4].Value = model.DietGuide;
array[5].Value = model.SportsGuide;
array[6].Value = model.HealthKnowledge;
array[7].Value = model.ForGender;
array[8].Value = model.InputCode;
array[9].Value = model.DispOrder;
array[10].Value = model.TeamConclusionName;
array[11].Value = model.ID_Createopr;
array[12].Value = model.CreateOperator;
array[13].Value = model.CreateDate;
array[14].Value = model.Is_Banned;
array[15].Value = model.ID_BanOpr;
array[16].Value = model.BanOperator;
array[17].Value = model.BanDate;
array[18].Value = model.BanDescribe;
array[19].Value = model.ID_ICD;
array[20].Value = model.ID_FinalConclusionType;
array[21].Value = model.ID_Conclusion;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public int Add(PEIS.Model.BusConclusion model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into BusConclusion(");
stringBuilder.Append("ID_ConclusionType,ConclusionName,Explanation,Suggestion,DietGuide,SportsGuide,HealthKnowledge,Forsex,InputCode,DispOrder,TeamConclusionName,ID_Createopr,CreateOperator,CreateDate,Is_Banned,ID_BanOpr,BanOperator,BanDate,BanDescribe,ID_ICD,ID_FinalConclusionType)");
stringBuilder.Append(" values (");
stringBuilder.Append("@ID_ConclusionType,@ConclusionName,@Explanation,@Suggestion,@DietGuide,@SportsGuide,@HealthKnowledge,@Forsex,@InputCode,@DispOrder,@TeamConclusionName,@ID_Createopr,@CreateOperator,@CreateDate,@Is_Banned,@ID_BanOpr,@BanOperator,@BanDate,@BanDescribe,@ID_ICD,@ID_FinalConclusionType)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_ConclusionType", SqlDbType.Int, 4),
new SqlParameter("@ConclusionName", SqlDbType.VarChar, 50),
new SqlParameter("@Explanation", SqlDbType.Text),
new SqlParameter("@Suggestion", SqlDbType.Text),
new SqlParameter("@DietGuide", SqlDbType.Text),
new SqlParameter("@SportsGuide", SqlDbType.Text),
new SqlParameter("@HealthKnowledge", SqlDbType.Text),
new SqlParameter("@Forsex", SqlDbType.Int, 4),
new SqlParameter("@InputCode", SqlDbType.VarChar, 20),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@TeamConclusionName", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Createopr", SqlDbType.Int, 4),
new SqlParameter("@CreateOperator", SqlDbType.VarChar, 30),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Is_Banned", SqlDbType.Bit, 1),
new SqlParameter("@ID_BanOpr", SqlDbType.Int, 4),
new SqlParameter("@BanOperator", SqlDbType.VarChar, 30),
new SqlParameter("@BanDate", SqlDbType.DateTime),
new SqlParameter("@BanDescribe", SqlDbType.VarChar, 100),
new SqlParameter("@ID_ICD", SqlDbType.Int, 4),
new SqlParameter("@ID_FinalConclusionType", SqlDbType.Int, 4)
};
array[0].Value = model.ID_ConclusionType;
array[1].Value = model.ConclusionName;
array[2].Value = model.Explanation;
array[3].Value = model.Suggestion;
array[4].Value = model.DietGuide;
array[5].Value = model.SportsGuide;
array[6].Value = model.HealthKnowledge;
array[7].Value = model.ForGender;
array[8].Value = model.InputCode;
array[9].Value = model.DispOrder;
array[10].Value = model.TeamConclusionName;
array[11].Value = model.ID_Createopr;
array[12].Value = model.CreateOperator;
array[13].Value = model.CreateDate;
array[14].Value = model.Is_Banned;
array[15].Value = model.ID_BanOpr;
array[16].Value = model.BanOperator;
array[17].Value = model.BanDate;
array[18].Value = model.BanDescribe;
array[19].Value = model.ID_ICD;
array[20].Value = model.ID_FinalConclusionType;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public PEIS.Model.BusConclusion GetModel(int ID_Conclusion)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_Conclusion,ID_ConclusionType,ConclusionName,Explanation,Suggestion,DietGuide,SportsGuide,HealthKnowledge,ForGender,InputCode,DispOrder,TeamConclusionName,ID_Createopr,CreateOperator,CreateDate,Is_Banned,ID_BanOpr,BanOperator,BanDate,BanDescribe,ID_ICD,ID_FinalConclusionType from BusConclusion ");
stringBuilder.Append(" where ID_Conclusion=@ID_Conclusion");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_Conclusion", SqlDbType.Int, 4)
};
array[0].Value = ID_Conclusion;
PEIS.Model.BusConclusion busConclusion = new PEIS.Model.BusConclusion();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.BusConclusion result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_Conclusion"].ToString() != "")
{
busConclusion.ID_Conclusion = int.Parse(dataSet.Tables[0].Rows[0]["ID_Conclusion"].ToString());
}
if (dataSet.Tables[0].Rows[0]["ID_ConclusionType"].ToString() != "")
{
busConclusion.ID_ConclusionType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ConclusionType"].ToString()));
}
busConclusion.ConclusionName = dataSet.Tables[0].Rows[0]["ConclusionName"].ToString();
busConclusion.Explanation = dataSet.Tables[0].Rows[0]["Explanation"].ToString();
busConclusion.Suggestion = dataSet.Tables[0].Rows[0]["Suggestion"].ToString();
busConclusion.DietGuide = dataSet.Tables[0].Rows[0]["DietGuide"].ToString();
busConclusion.SportsGuide = dataSet.Tables[0].Rows[0]["SportsGuide"].ToString();
busConclusion.HealthKnowledge = dataSet.Tables[0].Rows[0]["HealthKnowledge"].ToString();
if (dataSet.Tables[0].Rows[0]["ForGender"].ToString() != "")
{
busConclusion.ForGender = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ForGender"].ToString()));
}
busConclusion.InputCode = dataSet.Tables[0].Rows[0]["InputCode"].ToString();
if (dataSet.Tables[0].Rows[0]["DispOrder"].ToString() != "")
{
busConclusion.DispOrder = new int?(int.Parse(dataSet.Tables[0].Rows[0]["DispOrder"].ToString()));
}
busConclusion.TeamConclusionName = dataSet.Tables[0].Rows[0]["TeamConclusionName"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Createopr"].ToString() != "")
{
busConclusion.ID_Createopr = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Createopr"].ToString()));
}
busConclusion.CreateOperator = dataSet.Tables[0].Rows[0]["CreateOperator"].ToString();
if (dataSet.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
busConclusion.CreateDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["CreateDate"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["Is_Banned"].ToString() != "")
{
if (dataSet.Tables[0].Rows[0]["Is_Banned"].ToString() == "1" || dataSet.Tables[0].Rows[0]["Is_Banned"].ToString().ToLower() == "true")
{
busConclusion.Is_Banned = new bool?(true);
}
else
{
busConclusion.Is_Banned = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_BanOpr"].ToString() != "")
{
busConclusion.ID_BanOpr = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_BanOpr"].ToString()));
}
busConclusion.BanOperator = dataSet.Tables[0].Rows[0]["BanOperator"].ToString();
if (dataSet.Tables[0].Rows[0]["BanDate"].ToString() != "")
{
busConclusion.BanDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["BanDate"].ToString()));
}
busConclusion.BanDescribe = dataSet.Tables[0].Rows[0]["BanDescribe"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_ICD"].ToString() != "")
{
busConclusion.ID_ICD = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_ICD"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["ID_FinalConclusionType"].ToString() != "")
{
busConclusion.ID_FinalConclusionType = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_FinalConclusionType"].ToString()));
}
result = busConclusion;
}
else
{
result = null;
}
return(result);
}
public int SaveConclusion(PEIS.Model.BusConclusion ConclusionModel)
{
return(CommonConclusion.dal.SaveConclusion(ConclusionModel));
}
public List <PEIS.Model.BusConclusion> DataTableToList(DataTable dt)
{
List <PEIS.Model.BusConclusion> list = new List <PEIS.Model.BusConclusion>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.BusConclusion busConclusion = new PEIS.Model.BusConclusion();
if (dt.Rows[i]["ID_Conclusion"].ToString() != "")
{
busConclusion.ID_Conclusion = int.Parse(dt.Rows[i]["ID_Conclusion"].ToString());
}
if (dt.Rows[i]["ID_ConclusionType"].ToString() != "")
{
busConclusion.ID_ConclusionType = new int?(int.Parse(dt.Rows[i]["ID_ConclusionType"].ToString()));
}
busConclusion.ConclusionName = dt.Rows[i]["ConclusionName"].ToString();
busConclusion.Explanation = dt.Rows[i]["Explanation"].ToString();
busConclusion.Suggestion = dt.Rows[i]["Suggestion"].ToString();
busConclusion.DietGuide = dt.Rows[i]["DietGuide"].ToString();
busConclusion.SportsGuide = dt.Rows[i]["SportsGuide"].ToString();
busConclusion.HealthKnowledge = dt.Rows[i]["HealthKnowledge"].ToString();
if (dt.Rows[i]["Forsex"].ToString() != "")
{
busConclusion.ForGender = new int?(int.Parse(dt.Rows[i]["ForGender"].ToString()));
}
busConclusion.InputCode = dt.Rows[i]["InputCode"].ToString();
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
busConclusion.DispOrder = new int?(int.Parse(dt.Rows[i]["DispOrder"].ToString()));
}
busConclusion.TeamConclusionName = dt.Rows[i]["TeamConclusionName"].ToString();
if (dt.Rows[i]["ID_Createopr"].ToString() != "")
{
busConclusion.ID_Createopr = new int?(int.Parse(dt.Rows[i]["ID_Createopr"].ToString()));
}
busConclusion.CreateOperator = dt.Rows[i]["CreateOperator"].ToString();
if (dt.Rows[i]["CreateDate"].ToString() != "")
{
busConclusion.CreateDate = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateDate"].ToString()));
}
if (dt.Rows[i]["Is_Banned"].ToString() != "")
{
if (dt.Rows[i]["Is_Banned"].ToString() == "1" || dt.Rows[i]["Is_Banned"].ToString().ToLower() == "true")
{
busConclusion.Is_Banned = new bool?(true);
}
else
{
busConclusion.Is_Banned = new bool?(false);
}
}
if (dt.Rows[i]["ID_BanOpr"].ToString() != "")
{
busConclusion.ID_BanOpr = new int?(int.Parse(dt.Rows[i]["ID_BanOpr"].ToString()));
}
busConclusion.BanOperator = dt.Rows[i]["BanOperator"].ToString();
if (dt.Rows[i]["BanDate"].ToString() != "")
{
busConclusion.BanDate = new DateTime?(DateTime.Parse(dt.Rows[i]["BanDate"].ToString()));
}
busConclusion.BanDescribe = dt.Rows[i]["BanDescribe"].ToString();
if (dt.Rows[i]["ID_ICD"].ToString() != "")
{
busConclusion.ID_ICD = new int?(int.Parse(dt.Rows[i]["ID_ICD"].ToString()));
}
if (dt.Rows[i]["ID_FinalConclusionType"].ToString() != "")
{
busConclusion.ID_FinalConclusionType = new int?(int.Parse(dt.Rows[i]["ID_FinalConclusionType"].ToString()));
}
list.Add(busConclusion);
}
}
return(list);
}
public bool Update(PEIS.Model.BusConclusion model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.BusConclusion model)
{
return(this.dal.Add(model));
}
