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