public frmBox(DB_Talk.Model.m_Box model, int operate) { InitializeComponent(); _operate = operate; if (operate == 0) { _mModelOld = null; this.FormTitle = "添加"; btnOK.Text = "添加"; this.txtIP.Text = "172.21.0.2"; //this.txtNetIP.Text= "10.21.0.2"; //this.txtMask.Text = "255.255.255.0"; this.txtNetIP.Enabled=false; this.txtMask.Enabled = false; this.txtDispatchIP1.Text = "172.21.0.41"; this.txtDispatchIP2.Text = "172.21.0.42"; this.txtRecordServerIP.Text = "172.21.0.21"; this.txtTimerIP.Text = ""; } else { btnTest.Visible = false; _mModel = model; _mModelOld = (DB_Talk.Model.m_Box)model.Clone(); this.FormTitle = "编辑"; btnOK.Text = "编辑"; ShowModel(); } //this.txtName.MaxLength = Global.Params.NameLen; }
//恢复出厂设置时清空数据库 private void ClearDB() { //路由 new DB_Talk.BLL.m_Route().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_RouteGroup().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_RouteRule().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); //中继 new DB_Talk.BLL.m_SAPPoint().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_SIPInterface().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_PRIChannel().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_PRIInterface().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_PRISigLink().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); //号码规则 new DB_Talk.BLL.m_CalinglSourceRule().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_CalledRule().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); new DB_Talk.BLL.m_CallingSource().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); //box DB_Talk.Model.m_Box model = new DB_Talk.Model.m_Box(); model.ID = Global.Params.BoxID; model.i_DispatchNumber = 0; model.i_EmergencyNumber = 0; model.vc_NumberHead = ""; model.i_NumberLen = 0; model.i_Flag = 1; new DB_Talk.BLL.m_Box().Update(model); //删除所有号码 new DB_Talk.BLL.m_Member().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); //new DB_Talk.BLL.m_Member().Delete(" i_Flag=0 and BoxID='" + Global.Params.BoxID + "' and i_IsDispatch=1"); //删除组成员 new DB_Talk.BLL.m_GroupMembers().Delete(string.Format(" BoxID='{0}'", Global.Params.BoxID)); //删除组,常用人员组不删除 new DB_Talk.BLL.m_Group().Delete(string.Format(" BoxID='{0}' and vc_Name!='{1}'", Global.Params.BoxID, Global.Params.gruopNormalName)); //删除部门信息,zhj说要删除的,多个站点时删除会有问题 new DB_Talk.BLL.m_Departments().Delete(""); //清日志,zhj说要删除的,多个站点时删除会有问题 // new DB_Talk.BLL.Data_SystemLog().Delete("boxid=" + Global.Params.BoxID); new DB_Talk.BLL.Data_Alarm().Delete("boxid=" + Global.Params.BoxID); new DB_Talk.BLL.Data_DispatchLog().Delete("boxid=" + Global.Params.BoxID); //时钟源恢复为默认值 DB_Talk.BLL.m_PRIClock BLL = new DB_Talk.BLL.m_PRIClock(); List<DB_Talk.Model.m_PRIClock> lst = BLL.GetModelList( string.Format(" i_Flag=0 and BoxID='{0}' ", Global.Params.BoxID)); foreach (DB_Talk.Model.m_PRIClock modelClock in lst) { modelClock.i_Type = MBoxSDK.ConfigSDK.EnumPriClockType.内部.GetHashCode(); modelClock.i_Port = 0; BLL.Update(modelClock); } }
public bool LoadBoxTest(string BoxIP) { //登录box Bestway.Windows.Forms.ProgressBarDialog procDlg = new Bestway.Windows.Forms.ProgressBarDialog(); bool b = false; try { procDlg.Show(Bestway.Windows.Forms.EnumDisplayType.LoadData, " 正在登录" + Global.Params.BOXNAME + "【" + BoxIP + "】,请稍等..."); int handle=MBoxSDK.ConfigSDK.MBOX_Login(BoxIP, "", "", ""); b = handle > 0 ? true : false; b = b && MBoxSDK.ConfigSDK.MBOX_IsDeviceOnline(BoxIP); if (b) { Global.Params.BoxHandle = handle; Global.Params.BoxIP = BoxIP; DB_Talk.Model.m_Box m = new DB_Talk.Model.m_Box(); if (_operate==0 && Tools.MBoxOperate.GetNodeInfo(handle, out m)) { txtMask.Text = m.vc_Mask; txtNetIP.Text = m.vc_NetIP; _mModel.vc_Mask = txtMask.Text.Trim(); _mModel.vc_NetIP = txtNetIP.Text.Trim(); } } } catch (Exception ex) { CommControl.Tools.WriteLog.AppendErrorLog(ex); } finally { procDlg.Dispose(); } return b; }
//获取节点信息 public static bool GetNodeInfo(int handle,out DB_Talk.Model.m_Box model) { model = new DB_Talk.Model.m_Box(); MBoxSDK.ConfigSDK.tagNode node = new MBoxSDK.ConfigSDK.tagNode();//new MBoxSDK.ConfigSDK().newTagNode(); bool b = MBoxSDK.ConfigSDK.MBOX_GetNodeInfo(handle, ref node); model.vc_Name = System.Text.ASCIIEncoding.Default.GetString(node.nodeName).Replace("\0", ""); model.vc_DspIP = System.Text.ASCIIEncoding.Default.GetString(node.dspSrcIP).Replace("\0", ""); model.vc_NetIP = System.Text.ASCIIEncoding.Default.GetString(node.netManegeInterfaceIP).Replace("\0", ""); string strnetIPMask = System.Text.ASCIIEncoding.Default.GetString(node.netManegeInterfaceMask).Replace("\0", ""); string strSerialNum = System.Text.ASCIIEncoding.Default.GetString(node.serialNumber).Replace("\0", ""); model.vc_IP = System.Text.ASCIIEncoding.Default.GetString(node.trafficInterfaceIp).Replace("\0", ""); model.vc_Mask = System.Text.ASCIIEncoding.Default.GetString(node.trafficInterfaceMask).Replace("\0", ""); string strVerInfo = System.Text.ASCIIEncoding.Default.GetString(node.versionInfo).Replace("\0", ""); return b; }
public void LoadData() { string inNumber = Tools.MBoxOperate.GetCalledNumbers(MBoxSDK.ConfigSDK.CALLED_RULE_TYPE.入局, ""); PreBoxModel.vc_NumberHead = inNumber; PreBoxModel = new DB_Talk.BLL.m_Box().GetModel(Global.Params.BoxID); //StringBuilder sb = new StringBuilder(); //if (PreBoxModel.i_DispatchNumber != null) sb.Append(",'" + PreBoxModel.i_DispatchNumber.ToString() + "'"); //if (PreBoxModel.i_EmergencyNumber != null) sb.Append(",'" + PreBoxModel.i_EmergencyNumber.ToString() + "'"); //if (PreBoxModel.vc_NumberHead != null) sb.Append(",'" + PreBoxModel.vc_NumberHead.ToString() + "'"); //string strW = string.Format(" i_Flag=0 and BoxID='{0}' ", Global.Params.BoxID); //if (sb.Length > 0) //{ // sb.Remove(0, 1); // strW = string.Format(" i_Flag=0 and BoxID='{0}' and vc_CalledNumber in ({1})", // Global.Params.BoxID, sb.ToString()); //} DB_Talk.Model.m_Member m = BLL.GetModel("i_Flag=0 and BoxID='" + Global.Params.BoxID + "' and i_IsDispatch='2'"); txtDispatch.Tag = m; preModelDispatch = m; if (m != null) { txtDispatch.Text = m.i_Number.ToString(); txtDispatchPassword.Text = m.i_NuPassword.ToString(); } string strW = string.Format(" i_Flag=0 and BoxID='{0}' and i_CalledType = '{1}'", Global.Params.BoxID,MBoxSDK.ConfigSDK.CALLED_RULE_TYPE.入局.GetHashCode()); OldlstCalledRule = new DB_Talk.BLL.m_CalledRule().GetModelList(strW); string strWhere = string.Format("i_Flag=0 and BoxID='" +Global.Params.BoxID+ "' and i_IsDispatch='1' order by ID"); //i_Number"); lstMember = BLL.GetModelList(strWhere); //dgvList.DataSource = lstModel; dgvList.Rows.Clear(); for (int i = 0; i < DispatchCount; i++) { DB_Talk.Model.m_Member model = new DB_Talk.Model.m_Member(); if (lstMember.Count > i) { model.ID = lstMember[i].ID; model.vc_Name = lstMember[i].vc_Name; model.i_Number = lstMember[i].i_Number; dgvList.Rows[dgvList.Rows.Add(ID, "调度员" + (i + 1).ToString(), lstMember[i].vc_Name, lstMember[i].i_Number != null && lstMember[i].i_Number.Value > 0 ? lstMember[i].i_Number.ToString() : "" )].Tag = lstMember[i]; } else { dgvList.Rows.Add("", "调度员" + (i + 1).ToString(), "", "", ""); lstMember.Add(model); } } dgvList.ClearSelection(); //if (lstModel.Count == DispatchCount) //{ // int index = 0; // foreach (DB_Talk.Model.m_Member item in lstModel) // { // dgvList.Rows[dgvList.Rows.Add(ID, // "调度员" + index.ToString(), // item.vc_Name, // item.i_Number // )].Tag = item; // } //} }
void Form1_Load(object sender, EventArgs e) { this.Width = 1; this.Height = 1; this.DoubleBuffered = true; this.Invalidate(); CommControl.Resolution.ChangeRes(); Pub._memberManage = new MemberManage(this); Pub._meetingManage = new MeetingManage(this, Pub._talkControl); Pub._memberManage.Init(); Pub._memberManage.LoadFap(); Pub._meetingManage.Init(); LoadAllUser(); if (superTabControlMeeting.Tabs.Count > 0) { _currentSelectedMeetingModel = (MeetingGroupModel)superTabControlMeeting.Tabs[0].Tag; superTabControlMeeting.SelectedTab = (SuperTabItem)superTabControlMeeting.Tabs[0]; } Pub._talkControl.OnMemberStateChanged += new TalkControl.MemberStateChanaged(_talkControl_OnMemberStateChanged); Pub._talkControl.OnWaitingQueensChanged += new TalkControl.WaitingQueensChaanged(_talkControl_OnWaitingQueensChanged); Pub._talkControl.OnDispatchStateChanged += new TalkControl.DispatchStateChanaged(_talkControl_OnDispatchStateChanged); Pub._talkControl.OnLemcQueensChanged += new TalkControl.LemcQueensChaanged(_talkControl_OnLemcQueensChanged); Pub._talkControl.OnHotStandbyChanged += new TalkControl.HotStandbyChaanged(_talkControl_OnHotStandbyChanged); // dgvWait.CellClick += new DataGridViewCellEventHandler(dgvWait_CellClick); waitControl1.OnSelect += new DispatchPlatform.Control.WaitControl.SelectWaitDelgate(waitControl1_OnSelect); _boxModel = new DB_Talk.BLL.m_Box().GetModel(Pub.manageModel.BoxID.Value); stiAllMember.Click += new EventHandler(MemberTabItem_Click); lblTitle.Text = Pub._configModel.Title; this.Text = Pub._configModel.Title; DB_Talk.Model.m_Box box = new DB_Talk.BLL.m_Box().GetModel(Pub.manageModel.BoxID.Value); if (box != null) { Pub.BoxName = box.vc_Name; } imgBtnDispatch.Checked = true; superTabControlMain.SelectedTab = superTabItemDispatch; superTabItemDispatch.Tag = CommControl.PublicEnums.EnumGroupType.Normal; superTabItemMeeting.Tag = CommControl.PublicEnums.EnumGroupType.Meeting; Pub._meetingManage.SetControlIsCanSelect(false); // lblUserName.Text = Pub.manageModel.vc_UserName; timer1.Enabled = true; timer1.Interval = Pub._configModel.CheckBoxOnLineInterval * 1000; // this.WindowState = FormWindowState.Maximized; Pub.SetAutoRun(Pub._configModel.IsAutoStartBySystem); Pub.CanDeleteMemberState = true; Pub.CanSort = true; _memberGroupIndex = 0; }