public List <PEIS.Model.DctFinalConclusionType> DataTableToList(DataTable dt)
{
List <PEIS.Model.DctFinalConclusionType> list = new List <PEIS.Model.DctFinalConclusionType>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.DctFinalConclusionType dctFinalConclusionType = new PEIS.Model.DctFinalConclusionType();
if (dt.Rows[i]["ID_FinalConclusionType"].ToString() != "")
{
dctFinalConclusionType.ID_FinalConclusionType = int.Parse(dt.Rows[i]["ID_FinalConclusionType"].ToString());
}
dctFinalConclusionType.FinalConclusionTypeName = dt.Rows[i]["FinalConclusionTypeName"].ToString();
dctFinalConclusionType.InputCode = dt.Rows[i]["InputCode"].ToString();
dctFinalConclusionType.Note = dt.Rows[i]["Note"].ToString();
if (dt.Rows[i]["ID_Creator"].ToString() != "")
{
dctFinalConclusionType.ID_Creator = new int?(int.Parse(dt.Rows[i]["ID_Creator"].ToString()));
}
if (dt.Rows[i]["CreateDate"].ToString() != "")
{
dctFinalConclusionType.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")
{
dctFinalConclusionType.Is_Banned = new bool?(true);
}
else
{
dctFinalConclusionType.Is_Banned = new bool?(false);
}
}
if (dt.Rows[i]["ID_BanOpr"].ToString() != "")
{
dctFinalConclusionType.ID_BanOpr = new int?(int.Parse(dt.Rows[i]["ID_BanOpr"].ToString()));
}
dctFinalConclusionType.BanDescribe = dt.Rows[i]["BanDescribe"].ToString();
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
dctFinalConclusionType.DispOrder = int.Parse(dt.Rows[i]["DispOrder"].ToString());
}
if (dt.Rows[i]["BanDate"].ToString() != "")
{
dctFinalConclusionType.BanDate = new DateTime?(DateTime.Parse(dt.Rows[i]["BanDate"].ToString()));
}
dctFinalConclusionType.BanOperator = dt.Rows[i]["BanOperator"].ToString();
dctFinalConclusionType.FinalConclusionSignCode = dt.Rows[i]["FinalConclusionSignCode"].ToString();
list.Add(dctFinalConclusionType);
}
}
return(list);
}
public bool Update(PEIS.Model.DctFinalConclusionType model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update DctFinalConclusionType set ");
stringBuilder.Append("FinalConclusionTypeName=@FinalConclusionTypeName,");
stringBuilder.Append("InputCode=@InputCode,");
stringBuilder.Append("Note=@Note,");
stringBuilder.Append("ID_Creator=@ID_Creator,");
stringBuilder.Append("CreateDate=@CreateDate,");
stringBuilder.Append("Is_Banned=@Is_Banned,");
stringBuilder.Append("ID_BanOpr=@ID_BanOpr,");
stringBuilder.Append("BanDescribe=@BanDescribe,");
stringBuilder.Append("DispOrder=@DispOrder,");
stringBuilder.Append("BanDate=@BanDate,");
stringBuilder.Append("BanOperator=@BanOperator,");
stringBuilder.Append("FinalConclusionSignCode=@FinalConclusionSignCode");
stringBuilder.Append(" where ID_FinalConclusionType=@ID_FinalConclusionType");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@FinalConclusionTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@InputCode", SqlDbType.VarChar, 20),
new SqlParameter("@Note", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Creator", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Is_Banned", SqlDbType.Bit, 1),
new SqlParameter("@ID_BanOpr", SqlDbType.Int, 4),
new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@BanDate", SqlDbType.DateTime),
new SqlParameter("@BanOperator", SqlDbType.VarChar, 30),
new SqlParameter("@FinalConclusionSignCode", SqlDbType.VarChar, 30),
new SqlParameter("@ID_FinalConclusionType", SqlDbType.Int, 4)
};
array[0].Value = model.FinalConclusionTypeName;
array[1].Value = model.InputCode;
array[2].Value = model.Note;
array[3].Value = model.ID_Creator;
array[4].Value = model.CreateDate;
array[5].Value = model.Is_Banned;
array[6].Value = model.ID_BanOpr;
array[7].Value = model.BanDescribe;
array[8].Value = model.DispOrder;
array[9].Value = model.BanDate;
array[10].Value = model.BanOperator;
array[11].Value = model.FinalConclusionSignCode;
array[12].Value = model.ID_FinalConclusionType;
int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array);
return(num > 0);
}
public int Add(PEIS.Model.DctFinalConclusionType model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into DctFinalConclusionType(");
stringBuilder.Append("FinalConclusionTypeName,InputCode,Note,ID_Creator,CreateDate,Is_Banned,ID_BanOpr,BanDescribe,DispOrder,BanDate,BanOperator,FinalConclusionSignCode)");
stringBuilder.Append(" values (");
stringBuilder.Append("@FinalConclusionTypeName,@InputCode,@Note,@ID_Creator,@CreateDate,@Is_Banned,@ID_BanOpr,@BanDescribe,@DispOrder,@BanDate,@BanOperator,@FinalConclusionSignCode)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@FinalConclusionTypeName", SqlDbType.VarChar, 50),
new SqlParameter("@InputCode", SqlDbType.VarChar, 20),
new SqlParameter("@Note", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Creator", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@Is_Banned", SqlDbType.Bit, 1),
new SqlParameter("@ID_BanOpr", SqlDbType.Int, 4),
new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@BanDate", SqlDbType.DateTime),
new SqlParameter("@BanOperator", SqlDbType.VarChar, 30),
new SqlParameter("@FinalConclusionSignCode", SqlDbType.VarChar, 30)
};
array[0].Value = model.FinalConclusionTypeName;
array[1].Value = model.InputCode;
array[2].Value = model.Note;
array[3].Value = model.ID_Creator;
array[4].Value = model.CreateDate;
array[5].Value = model.Is_Banned;
array[6].Value = model.ID_BanOpr;
array[7].Value = model.BanDescribe;
array[8].Value = model.DispOrder;
array[9].Value = model.BanDate;
array[10].Value = model.BanOperator;
array[11].Value = model.FinalConclusionSignCode;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
protected void GetEditFinalConclusionTypeInfo(int ID_FinalConclusionType, ref VelocityContext vltContext)
{
if (ID_FinalConclusionType > 0)
{
PEIS.Model.DctFinalConclusionType model = PEIS.BLL.DctFinalConclusionType.Instance.GetModel(ID_FinalConclusionType);
if (null != model)
{
vltContext.Put("ID_FinalConclusionType", model.ID_FinalConclusionType);
vltContext.Put("FinalConclusionTypeName", model.FinalConclusionTypeName);
vltContext.Put("Is_Banned", model.Is_Banned);
vltContext.Put("ID_BanOpr", model.ID_BanOpr);
vltContext.Put("BanOperator", model.BanOperator);
vltContext.Put("BanDescribe", model.BanDescribe);
vltContext.Put("BanDate", model.BanDate);
vltContext.Put("DispOrder", model.DispOrder);
vltContext.Put("Note", model.Note);
vltContext.Put("FinalConclusionSignCode", model.FinalConclusionSignCode);
}
}
}
public bool Update(PEIS.Model.DctFinalConclusionType model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.DctFinalConclusionType model)
{
return(this.dal.Add(model));
}
public int SaveFinalConclusionType(PEIS.Model.DctFinalConclusionType FinalConclusionTypeModel)
{
return(CommonConfig.dal.SaveFinalConclusionType(FinalConclusionTypeModel));
}
public PEIS.Model.DctFinalConclusionType GetModel(int ID_FinalConclusionType)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 ID_FinalConclusionType,FinalConclusionTypeName,InputCode,Note,ID_Creator,CreateDate,Is_Banned,ID_BanOpr,BanDescribe,DispOrder,BanDate,BanOperator,FinalConclusionSignCode from DctFinalConclusionType ");
stringBuilder.Append(" where ID_FinalConclusionType=@ID_FinalConclusionType");
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter("@ID_FinalConclusionType", SqlDbType.Int, 4)
};
array[0].Value = ID_FinalConclusionType;
PEIS.Model.DctFinalConclusionType dctFinalConclusionType = new PEIS.Model.DctFinalConclusionType();
DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array);
PEIS.Model.DctFinalConclusionType result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["ID_FinalConclusionType"].ToString() != "")
{
dctFinalConclusionType.ID_FinalConclusionType = int.Parse(dataSet.Tables[0].Rows[0]["ID_FinalConclusionType"].ToString());
}
dctFinalConclusionType.FinalConclusionTypeName = dataSet.Tables[0].Rows[0]["FinalConclusionTypeName"].ToString();
dctFinalConclusionType.InputCode = dataSet.Tables[0].Rows[0]["InputCode"].ToString();
dctFinalConclusionType.Note = dataSet.Tables[0].Rows[0]["Note"].ToString();
if (dataSet.Tables[0].Rows[0]["ID_Creator"].ToString() != "")
{
dctFinalConclusionType.ID_Creator = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_Creator"].ToString()));
}
if (dataSet.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
dctFinalConclusionType.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")
{
dctFinalConclusionType.Is_Banned = new bool?(true);
}
else
{
dctFinalConclusionType.Is_Banned = new bool?(false);
}
}
if (dataSet.Tables[0].Rows[0]["ID_BanOpr"].ToString() != "")
{
dctFinalConclusionType.ID_BanOpr = new int?(int.Parse(dataSet.Tables[0].Rows[0]["ID_BanOpr"].ToString()));
}
dctFinalConclusionType.BanDescribe = dataSet.Tables[0].Rows[0]["BanDescribe"].ToString();
if (dataSet.Tables[0].Rows[0]["DispOrder"].ToString() != "")
{
dctFinalConclusionType.DispOrder = int.Parse(dataSet.Tables[0].Rows[0]["DispOrder"].ToString());
}
if (dataSet.Tables[0].Rows[0]["BanDate"].ToString() != "")
{
dctFinalConclusionType.BanDate = new DateTime?(DateTime.Parse(dataSet.Tables[0].Rows[0]["BanDate"].ToString()));
}
dctFinalConclusionType.BanOperator = dataSet.Tables[0].Rows[0]["BanOperator"].ToString();
dctFinalConclusionType.FinalConclusionSignCode = dataSet.Tables[0].Rows[0]["FinalConclusionSignCode"].ToString();
result = dctFinalConclusionType;
}
else
{
result = null;
}
return(result);
}