public List<BussinessOR> selectBankData(string orgbhWhere) { if (string.IsNullOrEmpty(orgbhWhere)) return null; string sql = @"select bu.* from t_Bussiness 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<BussinessOR> listBussi = new List<BussinessOR>(); foreach (DataRow dr in dt.Rows) { BussinessOR obj = new BussinessOR(dr); listBussi.Add(obj); } return listBussi; }
/// <summary> /// 获取插入数据 /// </summary> public string GetInsertSql(BussinessOR bussiness) { string sql = string.Format(@"insert into t_Bussiness (Id, Name, EnglishName, TypeName, WaitTime1, PriorTime1, WaitTime2, PriorTime2, WaitTime3, PriorTime3, TicketMethod, MondayFlag, MondayTime, TuesdayFlag, TuesdayTime, WednesdayFlag, WednesdayTime, ThurdayFlag, ThurdayTime, FridayFlag, FridayTime, SaturdayFlag, SaturdayTime, SundayFlag, SundayTime, Description, OrgBH,prefix) values ('@Id', '@Name', '@EnglishName', '@TypeName', @WaitTime1, @PriorTime1, @WaitTime2,@PriorTime2, @WaitTime3, @PriorTime3, @TicketMethod, @MondayFlag, '@MondayTime', @TuesdayFlag, '@TuesdayTime', @WednesdayFlag, '@WednesdayTime', @ThurdayFlag, '@ThurdayTime', @FridayFlag, '@FridayTime', @SaturdayFlag, '@SaturdayTime', @SundayFlag, '@SundayTime', '@Description', '@OrgBH','@prefix')"); sql = sql.Replace("@Id", bussiness.Id); sql = sql.Replace("@Name", bussiness.Name); sql = sql.Replace("@EnglishName", bussiness.Englishname); sql = sql.Replace("@TypeName", bussiness.Typename); sql = sql.Replace("@WaitTime1", bussiness.Waittime1.ToString()); sql = sql.Replace("@PriorTime1", bussiness.Priortime1.ToString()); sql = sql.Replace("@WaitTime2", bussiness.Waittime2.ToString()); sql = sql.Replace("@PriorTime2", bussiness.Priortime2.ToString()); sql = sql.Replace("@WaitTime3", bussiness.Waittime3.ToString()); sql = sql.Replace("@PriorTime3", bussiness.Priortime3.ToString()); sql = sql.Replace("@TicketMethod", bussiness.Ticketmethod.ToString()); sql = sql.Replace("@MondayFlag", boolGetFlag(bussiness.Mondayflag)); sql = sql.Replace("@MondayTime", bussiness.Mondaytime); sql = sql.Replace("@TuesdayFlag", boolGetFlag(bussiness.Tuesdayflag)); sql = sql.Replace("@TuesdayTime", bussiness.Tuesdaytime); sql = sql.Replace("@WednesdayFlag", boolGetFlag(bussiness.Wednesdayflag)); sql = sql.Replace("@WednesdayTime", bussiness.Wednesdaytime); sql = sql.Replace("@ThurdayFlag", boolGetFlag(bussiness.Thurdayflag)); sql = sql.Replace("@ThurdayTime", bussiness.Thurdaytime); sql = sql.Replace("@FridayFlag", boolGetFlag(bussiness.Fridayflag)); sql = sql.Replace("@FridayTime", bussiness.Fridaytime); sql = sql.Replace("@SaturdayFlag", boolGetFlag(bussiness.Saturdayflag)); sql = sql.Replace("@SaturdayTime", bussiness.Saturdaytime); sql = sql.Replace("@SundayFlag", boolGetFlag(bussiness.Sundayflag)); sql = sql.Replace("@SundayTime", bussiness.Sundaytime); sql = sql.Replace("@Description", bussiness.Description); sql = sql.Replace("@OrgBH", bussiness.Orgbh); sql = sql.Replace("@prefix", bussiness.Prefix); return sql; }
public BussinessOR selectARowDate(string m_id) { string sql = string.Format("select * from t_Bussiness where Id='{0}'", m_id); DataTable dt = null; try { dt = dbMsSql.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; BussinessOR m_Buss = new BussinessOR(dr); return m_Buss; }
/// <summary> /// 获取业务优先时间 /// </summary> /// <param name="TimeLen"></param> /// <param name="obj"></param> /// <returns></returns> private int GetPriorTime(int TimeLen, BussinessOR obj) { if (TimeLen > obj.Waittime3) { return obj.Priortime3; } else if (TimeLen > obj.Waittime2) { return obj.Priortime2; } else if (TimeLen > obj.Waittime1) { return obj.Priortime1; } return 0; }
public List<BussinessOR> selectAllBussiness() { string sql = "select * from t_Bussiness"; DataTable dt = null; try { dt = dbMySql.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } if (dt == null) { return null; } List<BussinessOR> listBuss = new List<BussinessOR>(); foreach (DataRow dr in dt.Rows) { BussinessOR obj = new BussinessOR(dr); listBuss.Add(obj); } return listBuss; }
public void Init(BussinessOR obj) { // this.Id = obj.Id; // 业务名称 this.Name = obj.Name; // 英文的业务名称,用于界面显示(可选) this.Englishname = obj.Englishname; // 业务种类,相当于业务名称的缩写,比如业务名称为“存取款和缴费”,则业务种类为“M1” this.Typename = obj.Typename; // 等候时间1 this.Waittime1 = obj.Waittime1; // 优先时间1 。“等候时间1”和“优先时间1”指客户等待时间1大于XX秒时,排队优先时间1等于YY秒 this.Priortime1 = obj.Priortime1; // 等候时间2 this.Waittime2 = obj.Waittime2; // 优先时间2。同理,等候时间2需大于等候时间1 this.Priortime2 = obj.Priortime2; // 等候时间3 this.Waittime3 = obj.Waittime3; // 优先时间3。同理,等候时间3需大于等候时间2 this.Priortime3 = obj.Priortime3; // 取号方式。1是刷卡取号----此队列必须刷卡取号。2是直接取号----直接取号无需刷卡。3是刷卡直接取号----可以直接取号也可刷卡取号 this.Ticketmethod = obj.Ticketmethod; // 周一是否办理的标记,1表示办理,0表示不能办理 this.Mondayflag = obj.Mondayflag; // 周一工作时间,不能超过3个时间段,各时间段以分号隔开。如08301200;13001400;15001800;表示从8:30到12:00,然后13:00到14:00,然后15:00到18:00.只有1个时间段时为08301200;;; this.Mondaytime = obj.Mondaytime; // 周二办理标记 this.Tuesdayflag = obj.Tuesdayflag; // 周二工作时间 this.Tuesdaytime = obj.Tuesdaytime; // 周三办理标记 this.Wednesdayflag = obj.Wednesdayflag; // 周三工作时间 this.Wednesdaytime = obj.Wednesdaytime; // 周l四办理标记 this.Thurdayflag = obj.Thurdayflag; // 周四工作时间 this.Thurdaytime = obj.Thurdaytime; // 周五办理标记 this.Fridayflag = obj.Fridayflag; // 周五工作时间 this.Fridaytime = obj.Fridaytime; // 周六办理标记 this.Saturdayflag = obj.Saturdayflag; // 周六办理标记 this.Saturdaytime = obj.Saturdaytime; // 周日办理标记 this.Sundayflag = obj.Sundayflag; // 周日工作时间 this.Sundaytime = obj.Sundaytime; // 描述 this.Description = obj.Description; // 机构编号 this.Orgbh = obj.Orgbh; //前缀 this.Prefix = obj.Prefix; }