/// <summary> /// 初使化、 /// </summary> public QueueMian() { try { InitBankNo(); //Vip优先时间处理类 VipCardHeadObj = new VipCardHeadle(); VipCardHeadObj.Init(); List<BussinessOR> ListBuss = new List<BussinessOR>();//所有业务 //查询 所有的业务队列 ListBuss = _busDA.selectAllBussiness(); QhQueues = new List<BussinessQueueOR>(); //根据队列,取出已取号的排队信息。 foreach (BussinessOR obj in ListBuss) { BussinessQueueOR bussQue = new BussinessQueueOR(); bussQue.Init(obj); bussQue.BussQueues = _QueueDA.selectBussinessQueues(obj.Id);//获取此队列未办结的取号记录 foreach (QueueInfoOR qhObj in bussQue.BussQueues) { if (!string.IsNullOrEmpty(qhObj.Cardno)) { qhObj.VipFirstTime = VipCardHeadObj.GetFirstTime(qhObj.Cardno); } } QhQueues.Add(bussQue); } //初使化登录日志 ListWindowLogins = _WindowLoginDA.SelectToDayLogins(); //获取窗口 ListWindows = new WindowMySqlDA().SelectWindows(); //业务角色处理 BussRoleObj = new BussinessRoleHeadle(); BussRoleObj.Init(); //参数设置 _SysparaConfigObj = new SysParaMySqlDA().SelectConfigORByWdbh(); //读取config.xml文件 _Config = new ReadXmlConfig().Read(); List<DeviceOR> ListAllZP = new DeviceDAMySql().SelectAllDevices(); foreach (DeviceOR obj in ListAllZP) { if (obj.Devicetypeid == 4) { ListZPOR.Add(obj); } } } catch (Exception ex) { ErrorLog.WriteLog("QueueMian_Init#ex", ex.Message); } }
public SysParamConfigOR SelectConfigORByWdbh() { string sql = "select * from t_SysPara "; // if (_wdbh.Length > 6) // { // string topWdbh = _wdbh.Substring(0, 6); // sql += string.Format(@" or (orgbh='{0}' and (KeyStr='vipcardinfo' or KeyStr='othercardinfo' //or KeyStr='invalidcardinfo' or KeyStr='validcardcode'))", topWdbh); // } DataTable dt = dbMySql.ExecuteQuery(sql); SysParamConfigOR _obj = new SysParamConfigOR(); foreach (DataRow dr in dt.Rows) { string ValueStr = dr["ValueStr"].ToString(); switch (dr["KeyStr"].ToString().ToLower()) { case "popswiptime":// 提示刷卡界面停留时间 _obj.Popswiptime = ValueStr; break; case "contickettime":// 连续取号最短时间间隔等 _obj.Contickettime = ValueStr; break; case "cartickettime":// 同一张卡连续取号时间间隔 _obj.Cartickettime = ValueStr; break; case "calllimittime":// 呼叫限制 _obj.Calllimittime = ValueStr; break; case "curshowtime":// 每个排队曲线图显示时间,为0表示不显示 _obj.Curshowtime = ValueStr; break; case "windowinfo":// 窗口屏广告信息 _obj.Windowinfo = ValueStr; break; case "mainwindowinfo":// 主显屏广告信息 _obj.Mainwindowinfo = ValueStr; break; case "backgroundsound":// 呼叫提示音(1-无;2-提示音1;3-提示音2;4-提示音3) _obj.Backgroundsound = ValueStr; break; case "firstsound":// 第一遍呼叫(1-普通话、2-粤语、3-英语、4-不播报) _obj.Firstsound = ValueStr; break; case "secondsound":// 第二遍呼叫(1-普通话、2-粤语、3-英语、4-不播报) _obj.Secondsound = ValueStr; break; case "thirdsound":// 第三遍呼叫(1-普通话、2-粤语、3-英语、4-不播报) _obj.Thirdsound = ValueStr; break; case "callvolumn": // 语音呼叫音量(范围0-9) _obj.Callvolumn = ValueStr; break; case "backgroundvolumn":// 背景音乐音量(范围0-9) _obj.Backgroundvolumn = ValueStr; break; case "vipcardinfo":// 贵宾服务刷卡取号提示语 _obj.Vipcardinfo = ValueStr; break; case "othercardinfo":// 其他业务刷卡取号提示语 _obj.Othercardinfo = ValueStr; break; case "invalidcardinfo":// 无效卡提示语 _obj.Invalidcardinfo = ValueStr; break; case "validcardcode":// 无效卡提示语 _obj.ValidCardCode = ValueStr; break; } } return _obj; }