public PEIS.Model.BusBackLogType GetModel(int ID_BackLogType) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 ID_BackLogType,BackLogTypeName,InputCode,DispOrder,Is_Banned,BanDescribe,ID_Operator,Operator,OperateDate,OperateType from BusBackLogType "); stringBuilder.Append(" where ID_BackLogType=@ID_BackLogType"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@ID_BackLogType", SqlDbType.Int, 4) }; array[0].Value = ID_BackLogType; PEIS.Model.BusBackLogType busBackLogType = new PEIS.Model.BusBackLogType(); DataSet dataSet = DbHelperSQL.Query(stringBuilder.ToString(), array); PEIS.Model.BusBackLogType result; if (dataSet.Tables[0].Rows.Count > 0) { if (dataSet.Tables[0].Rows[0]["ID_BackLogType"].ToString() != "") { busBackLogType.ID_BackLogType = int.Parse(dataSet.Tables[0].Rows[0]["ID_BackLogType"].ToString()); } busBackLogType.BackLogTypeName = dataSet.Tables[0].Rows[0]["BackLogTypeName"].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") { busBackLogType.Is_Banned = new bool?(true); } else { busBackLogType.Is_Banned = new bool?(false); } } if (dataSet.Tables[0].Rows[0]["ID_Operator"].ToString() != "") { busBackLogType.ID_Operator = int.Parse(dataSet.Tables[0].Rows[0]["ID_Operator"].ToString()); } if (dataSet.Tables[0].Rows[0]["DispOrder"].ToString() != "") { busBackLogType.DispOrder = int.Parse(dataSet.Tables[0].Rows[0]["DispOrder"].ToString()); } busBackLogType.BanDescribe = dataSet.Tables[0].Rows[0]["BanDescribe"].ToString(); busBackLogType.InputCode = dataSet.Tables[0].Rows[0]["InputCode"].ToString(); busBackLogType.Operator = dataSet.Tables[0].Rows[0]["Operator"].ToString(); if (dataSet.Tables[0].Rows[0]["OperateDate"].ToString() != "") { busBackLogType.OperateDate = DateTime.Parse(dataSet.Tables[0].Rows[0]["OperateDate"].ToString()); } if (dataSet.Tables[0].Rows[0]["OperateType"].ToString() != "") { busBackLogType.OperateType = int.Parse(dataSet.Tables[0].Rows[0]["OperateDate"].ToString()); } result = busBackLogType; } else { result = null; } return(result); }
public List <PEIS.Model.BusBackLogType> DataTableToList(DataTable dt) { List <PEIS.Model.BusBackLogType> list = new List <PEIS.Model.BusBackLogType>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { PEIS.Model.BusBackLogType busBackLogType = new PEIS.Model.BusBackLogType(); if (dt.Rows[i]["ID_BackLogType"].ToString() != "") { busBackLogType.ID_BackLogType = int.Parse(dt.Rows[i]["ID_BackLogType"].ToString()); } busBackLogType.BackLogTypeName = dt.Rows[i]["BackLogTypeName"].ToString(); if (dt.Rows[i]["Is_Banned"].ToString() != "") { if (dt.Rows[i]["Is_Banned"].ToString() == "1" || dt.Rows[i]["Is_Banned"].ToString().ToLower() == "true") { busBackLogType.Is_Banned = new bool?(true); } else { busBackLogType.Is_Banned = new bool?(false); } } if (dt.Rows[i]["ID_Operator"].ToString() != "") { busBackLogType.ID_Operator = int.Parse(dt.Rows[i]["ID_Operator"].ToString()); } if (dt.Rows[i]["DispOrder"].ToString() != "") { busBackLogType.DispOrder = int.Parse(dt.Rows[i]["DispOrder"].ToString()); } busBackLogType.BanDescribe = dt.Rows[i]["BanDescribe"].ToString(); busBackLogType.InputCode = dt.Rows[i]["InputCode"].ToString(); busBackLogType.Operator = dt.Rows[i]["Operator"].ToString(); if (dt.Rows[i]["OperateDate"].ToString() != "") { busBackLogType.OperateDate = DateTime.Parse(dt.Rows[i]["OperateDate"].ToString()); } if (dt.Rows[i]["OperateType"].ToString() != "") { busBackLogType.OperateType = int.Parse(dt.Rows[i]["OperateDate"].ToString()); } list.Add(busBackLogType); } } return(list); }
public int Add(PEIS.Model.BusBackLogType model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into BusBackLogType("); stringBuilder.Append("BackLogTypeName,InputCode,DispOrder,Is_Banned,BanDescribe,ID_Operator,Operator,OperateDate,OperateType)"); stringBuilder.Append(" values ("); stringBuilder.Append("@BackLogTypeName,@InputCode,@DispOrder,@Is_Banned,@BanDescribe,@ID_Operator,@Operator,@OperateDate,@OperateType)"); stringBuilder.Append(";select @@IDENTITY"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@BackLogTypeName", SqlDbType.VarChar, 50), new SqlParameter("@InputCode", SqlDbType.VarChar, 20), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@Is_Banned", SqlDbType.Bit, 1), new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50), new SqlParameter("@ID_Operator", SqlDbType.Int, 4), new SqlParameter("@Operator", SqlDbType.VarChar, 30), new SqlParameter("@OperateDate", SqlDbType.DateTime), new SqlParameter("@OperateType", SqlDbType.Int, 4) }; array[0].Value = model.BackLogTypeName; array[1].Value = model.InputCode; array[2].Value = model.DispOrder; array[3].Value = model.Is_Banned; array[4].Value = model.BanDescribe; array[5].Value = model.ID_Operator; array[6].Value = model.Operator; array[7].Value = model.OperateDate; array[8].Value = model.OperateType; object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), array); int result; if (single == null) { result = 0; } else { result = Convert.ToInt32(single); } return(result); }
public bool Update(PEIS.Model.BusBackLogType model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update BusBackLogType set "); stringBuilder.Append("BackLogTypeName=@BackLogTypeName,"); stringBuilder.Append("InputCode=@InputCode,"); stringBuilder.Append("DispOrder=@DispOrder,"); stringBuilder.Append("Is_Banned=@Is_Banned,"); stringBuilder.Append("BanDescribe=@BanDescribe,"); stringBuilder.Append("ID_Operator=@ID_Operator,"); stringBuilder.Append("Operator=@Operator,"); stringBuilder.Append("OperateDate=@OperateDate,"); stringBuilder.Append("OperateType=@OperateType,"); stringBuilder.Append(" where ID_BackLogType=@ID_BackLogType"); SqlParameter[] array = new SqlParameter[] { new SqlParameter("@BackLogTypeName", SqlDbType.VarChar, 50), new SqlParameter("@InputCode", SqlDbType.VarChar, 20), new SqlParameter("@DispOrder", SqlDbType.Int, 4), new SqlParameter("@Is_Banned", SqlDbType.Bit, 1), new SqlParameter("@BanDescribe", SqlDbType.VarChar, 50), new SqlParameter("@ID_Operator", SqlDbType.Int, 4), new SqlParameter("@Operator", SqlDbType.VarChar, 30), new SqlParameter("@OperateDate", SqlDbType.DateTime), new SqlParameter("@OperateType", SqlDbType.Int, 4), new SqlParameter("@ID_BackLogType", SqlDbType.Int, 4) }; array[0].Value = model.BackLogTypeName; array[1].Value = model.InputCode; array[2].Value = model.DispOrder; array[3].Value = model.Is_Banned; array[4].Value = model.BanDescribe; array[5].Value = model.ID_Operator; array[6].Value = model.Operator; array[7].Value = model.OperateDate; array[8].Value = model.OperateType; array[9].Value = model.ID_BackLogType; int num = DbHelperSQL.ExecuteSql(stringBuilder.ToString(), array); return(num > 0); }
public bool Update(PEIS.Model.BusBackLogType model) { return(this.dal.Update(model)); }
public int Add(PEIS.Model.BusBackLogType model) { return(this.dal.Add(model)); }