using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.ServiceModel; using DBFactory; using System.Net.Sockets; using System.Threading; using System.Net; using Microsoft.VisualBasic; namespace wcfControlMonitorClient { /// /// Creator:Richard.liu /// 调度任务管理 /// public partial class FrmSeeManage : Form { string _manstatus= " F_Status>=-1 "; private static FrmSeeManage _formInstance; public static FrmSeeManage FormInstance { get { if (_formInstance == null) { _formInstance = new FrmSeeManage(); } return _formInstance; } set { _formInstance = value; } } Model.MDevice devinfo; DBOperator dbo = CStaticClass.dbo; DBOperator dboM = CStaticClass.dboM; public FrmSeeManage() { InitializeComponent(); _formInstance = this; } private void rbmanAll_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " F_Status>=-1 "; } TSMrefresh_Click(); } private void TSMrefresh_Click() { this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task with(nolock) where " + _manstatus).Tables[0].DefaultView; } private void rbmanRun_CheckedChanged(object sender, EventArgs e) { if (rbmanRun.Checked == true) { _manstatus = " F_Status>=1 "; } TSMrefresh_Click(); } private void rbmanWait_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " F_Status=0 "; } TSMrefresh_Click(); } private void button1_Click(object sender, EventArgs e) { try { if (this.textBox1.Text.Trim().Length == 0) return; if (this.comboBox1.Text == "条码") { //20091016 _manstatus = " 条码 like '%" + this.textBox1.Text.Trim() + "%' "; } if (this.comboBox1.Text == "调度任务索引") { _manstatus = " 调度任务索引='" + this.textBox1.Text.Trim() + "' "; } TSMrefresh_Click(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void button2_Click(object sender, EventArgs e) { _manstatus = " F_Status>=-1 "; TSMrefresh_Click(); } private void dgvManager_DataSourceChanged(object sender, EventArgs e) { dgvManager.Columns["F_Status"].Visible = false; } private void FrmModifyManage_Load(object sender, EventArgs e) { rbmanRun_CheckedChanged(sender, e); } int GetDeviceKindIdx(int devIdx) { try { devinfo = Model.CGetInfo.GetDeviceInfo(devIdx); return devinfo.DeviceKind; } catch (Exception ex) { throw ex; } } int GetManageTaskIndexfromMonitor(int monitorIdx) { DataView dv = dbo.ExceSQL("SELECT F_ManageTaskIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView; if (dv.Count > 0) { return Convert.ToInt32(dv[0]["F_ManageTaskIndex"]); } else { return -1; } } int GetManageTaskKindIndexFromMonitor(int monitorIdx) { DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView; if (dv.Count > 0) { return Convert.ToInt32(dv[0]["F_ManageTaskKindIndex"]); } else { return -1; } } int GetDeviceOrderFromMonitor(int MonitorIndex) { try { string sql = "select F_DeviceCommandIndex from T_Monitor_Task where (F_DeviceCommandIndex IS NOT NULL) and F_MonitorIndex=" + MonitorIndex; DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView; if (dv.Count > 0) { return Convert.ToInt32(dv[0]["F_DeviceCommandIndex"]); } else { return -1; } } catch (Exception ex) { throw ex; } } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { string df = ""; switch (this.comboBox1.Text) { case "条码": df = "条码"; break; case "调度任务索引": df = "调度任务索引"; break; default: return; } //20100208 string sql = "select distinct " + df + " from V_Manage_Task with(nolock) "; DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView; if (dv.Count > 0) { this.textBox1.DataSource = null; this.textBox1.DisplayMember = df; this.textBox1.ValueMember = df; this.textBox1.DataSource = dv; } } catch (Exception ex) { throw ex; } } private void dgvManager_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e) { if ((e.ColumnIndex >= 0) && (e.RowIndex >= 0) && (e.Button == MouseButtons.Right))//20110309 { dgvManager.ClearSelection(); dgvManager.Rows[e.RowIndex].Selected = true; dgvManager.CurrentCell = dgvManager.Rows[e.RowIndex].Cells[e.ColumnIndex]; } } void ModifyManageTaskCallBack(IAsyncResult ar) { string errtext=string.Empty; if (CStaticClass.WcfControl.EndModifyManageTask(out errtext, ar) == false) { MessageBox.Show(errtext, "操作提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (this.IsDisposed == true) return; this.BeginInvoke(new MethodInvoker (delegate() { TSMrefresh_Click(); } )); } void ModifyManageTask1CallBack(IAsyncResult ar) { string errtext = string.Empty; if (CStaticClass.WcfControl.EndModifyManageTask1(out errtext, ar) == false) { MessageBox.Show(errtext, "操作提示:", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (this.IsDisposed == true) return; this.BeginInvoke(new MethodInvoker(delegate() { TSMrefresh_Click(); } )); } private void FrmModifyManage_FormClosing(object sender, FormClosingEventArgs e) { _formInstance = null; } private void dgvManager_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if ((e.ColumnIndex >= 0) && (e.RowIndex >= 0)) { dgvManager.ClearSelection(); dgvManager.Rows[e.RowIndex].Selected = true; dgvManager.CurrentCell = dgvManager.Rows[e.RowIndex].Cells[e.ColumnIndex]; FrmModifyMonitor.FormInstance.comboBox1.Text = "条码"; FrmModifyMonitor.FormInstance.textBox1.Text = dgvManager.CurrentRow.Cells["条码"].Value.ToString(); FrmModifyMonitor.FormInstance.Show(); FrmModifyMonitor.FormInstance.button1_Click(sender, e); this.Visible = false; } } private void radioButton1_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " 条码 like '%PAT%' "; } TSMrefresh_Click(); } private void radioButton2_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " 条码 like '%BOX%' "; } TSMrefresh_Click(); } private void radioButton4_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " 条码 like '%PAT%' and F_Status>=1"; } TSMrefresh_Click(); } private void radioButton3_CheckedChanged(object sender, EventArgs e) { RadioButton rb = (RadioButton)sender; if (rb.Checked == true) { _manstatus = " 条码 like '%BOX%' and F_Status>=1"; } TSMrefresh_Click(); } } }