/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuSchedule> GetBuScheduleList(string Where)
{
List <BuSchedule> list = new List <BuSchedule>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuSchedule ent = new BuSchedule();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 根据ScheduleId得到 BuSchedule 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuSchedule GetBuSchedule(int ScheduleId)
{
BuSchedule ent = null;
string sql = DalSql;
sql = sql + " And ScheduleId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("ScheduleId", ScheduleId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuSchedule();
SetEnt(ent, reader);
}
}
return(ent);
}
public void SetEnt(BuSchedule ent, IDataReader dr)
{
ent.ScheduleId = MyConvert.ToInt(dr["ScheduleId"]);
ent.ScheduleName = MyConvert.ToString(dr["ScheduleName"]);
ent.CreateMan = MyConvert.ToString(dr["CreateMan"]);
ent.CreateDate = MyConvert.ToDateTime(dr["CreateDate"]);
ent.UpdateMan = MyConvert.ToString(dr["UpdateMan"]);
ent.UpdateDate = MyConvert.ToString(dr["UpdateDate"]);
ent.ScheduleStatus = MyConvert.ToString(dr["ScheduleStatus"]);
ent.ScheduleKind = MyConvert.ToInt(dr["ScheduleKind"]);
ent.StationId = MyConvert.ToString(dr["StationId"]);
ent.StationBossId = MyConvert.ToString(dr["StationBossId"]);
ent.ExecuteDate = MyConvert.ToDateTime(dr["ExecuteDate"]);
ent.ApplyDate = MyConvert.ToDateTime(dr["ApplyDate"]);
ent.StartAddress = MyConvert.ToString(dr["StartAddress"]);
ent.BigStationId = MyConvert.ToInt(dr["BigStationId"]);
ent.TakeTime = MyConvert.ToDateTime(dr["TakeTime"]);
ent.AddTime = MyConvert.ToDateTime(dr["AddTime"]);
ent.TargetAddress = MyConvert.ToString(dr["TargetAddress"]);
ent.NeedTime = MyConvert.ToDateTime(dr["NeedTime"]);
}
