public List<ShutdownTimeOR> selectShutdownTimeData(string orgbhWhere)
{
if (string.IsNullOrEmpty(orgbhWhere))
return null;
string sql = @"select bu.* from t_ShutdownTime bu
inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere;
DataTable dt = null;
try
{
dt = dbMsSql.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
List<ShutdownTimeOR> listShut = new List<ShutdownTimeOR>();
foreach (DataRow dr in dt.Rows)
{
ShutdownTimeOR obj = new ShutdownTimeOR(dr);
listShut.Add(obj);
}
return listShut;
}
/// <summary>
/// 获取插入数据
/// </summary>
public string GetInsertSql(ShutdownTimeOR shutdownTime)
{
string sql = @"insert into t_ShutdownTime (Id,MondayTime,TuesdayTime,WednesdayTime,ThurdayTime,
FridayTime,SaturdayTime,SundayTime,Description,orgbh)
values ('@Id','@MondayTime','@TuesdayTime','@WednesdayTime','@ThurdayTime',
'@FridayTime','@SaturdayTime','@SundayTime','@Description','@orgbh')";
sql = sql.Replace("@Id", shutdownTime.Id); //
sql = sql.Replace("@MondayTime", shutdownTime.Mondaytime); //周一关机时间
sql = sql.Replace("@TuesdayTime", shutdownTime.Tuesdaytime); //周二关机时间
sql = sql.Replace("@WednesdayTime", shutdownTime.Wednesdaytime); //周三关机时间
sql = sql.Replace("@ThurdayTime", shutdownTime.Thurdaytime); //周四关机时间
sql = sql.Replace("@FridayTime", shutdownTime.Fridaytime); //周五关机时间
sql = sql.Replace("@SaturdayTime", shutdownTime.Saturdaytime); //周六关机时间
sql = sql.Replace("@SundayTime", shutdownTime.Sundaytime); //周日关机时间
sql = sql.Replace("@Description", shutdownTime.Description); //描述
sql = sql.Replace("@orgbh", shutdownTime.Orgbh); //所属机构
return sql;
}