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