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