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 FrmModifyManage : Form { string _manstatus= " F_Status>=-1 "; private static FrmModifyManage _formInstance; public static FrmModifyManage FormInstance { get { if (_formInstance == null) { _formInstance = new FrmModifyManage(); } return _formInstance; } set { _formInstance = value; } } Model.MDevice devinfo; DBOperator dbo = CStaticClass.dbo; DBOperator dboM = CStaticClass.dboM; public FrmModifyManage() { 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 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 = " 条码='" + 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 cmManager_Opening(object sender, CancelEventArgs e) { if (this.dgvManager.CurrentRow == null) { TSMmanagerOK.Visible = false; //TSMrefresh.Visible = false; TSManager.Visible = false; toolStripSeparator1.Visible = false; //TSMmanagerDisassemble.Visible = false; toolStripMenuItem1.Visible = false; toolStripSeparator2.Visible = false; return; } if (Convert.ToInt32(this.dgvManager.CurrentRow.Cells["调度任务索引"].Value) > 0) { TSMmanagerOK.Visible = true; TSManager.Visible = true; toolStripSeparator1.Visible = true; toolStripSeparator2.Visible = true; //TSMmanagerDisassemble.Visible = true; toolStripMenuItem1.Visible = true; TSManager.Text = "任务类型：" + this.dgvManager.CurrentRow.Cells["任务类型"].Value.ToString() + "；调度任务索引：" + this.dgvManager.CurrentRow.Cells["调度任务索引"].Value.ToString(); } } private void TSMmanagerOK_Click(object sender, EventArgs e) { char[] cc = new char[1] { '：' }; string[] split = TSManager.Text.Split(cc); if ((split[1] == "") || (split[2] == "")) { return; } try { char[] scc = new char[1] { '；' }; string[] strsplit = split[1].Split(scc); int mti = 0; int fid = Convert.ToInt32(split[2]); if (strsplit[0] == "") return; switch (strsplit[0]) { case "调度任务": mti = 1; break; case "自动任务": mti = 2; break; case "临时任务": mti = 3; break; case "手工任务": mti = 4; break; } string cap = strsplit[0]; string hw = ""; if (this.dgvManager.CurrentRow.Cells["终点货位"].Value.ToString() != "-") { hw = ",终点货位:" + this.dgvManager.CurrentRow.Cells["终点货位"].Value.ToString(); } //20100108 if (MessageBox.Show("您确认条码：“" + this.dgvManager.CurrentRow.Cells["条码"].Value.ToString() + "”，" + cap + split[2] + "已经被搬运到终点设备“" + this.dgvManager.CurrentRow.Cells["终点"].Value.ToString() + hw + "”了吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } string d = Dns.GetHostEntry("localhost").HostName; CStaticClass.WcfControl.BeginModifyManageTask1(d, mti, fid, Model.CGeneralFunction.TASKFINISH, new AsyncCallback(ModifyManageTask1CallBack), null); //{ // MessageBox.Show(cap, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); //} TSMrefresh_Click(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void TSMmanagerDisassemble_Click(object sender, EventArgs e) { char[] cc = new char[1] { '：' }; string[] split = TSManager.Text.Split(cc); if ((split[1] == "") || (split[2] == "")) { return; } char[] scc = new char[1] { '；' }; string[] strsplit = split[1].Split(scc); int mti = 0; int fid = Convert.ToInt32(split[2]); if (strsplit[0] == "") return; switch (strsplit[0]) { case "调度任务": mti = 1; break; case "自动任务": mti = 2; break; case "临时任务": mti = 3; break; case "手工任务": mti = 4; break; } if (mti == 1) { dbo.ExceSQL("update T_Manage_Task set FIntoStepOK='0' where FID=" + fid + " and FIntoStepOK='-' "); } TSMrefresh_Click(); } private void FrmModifyManage_Load(object sender, EventArgs e) { rbmanRun_CheckedChanged(sender, e); } private void toolStripMenuItem1_Click(object sender, EventArgs e) { //删除调度任务900 try { char[] cc = new char[1] { '：' }; string[] split = TSManager.Text.Split(cc); if ((split[1] == "") || (split[2] == "")) { return; } char[] scc = new char[1] { '；' }; string[] strsplit = split[1].Split(scc); int mti = 0; int fid = Convert.ToInt32(split[2]); if (strsplit[0] == "") return; switch (strsplit[0]) { case "调度任务": mti = 1; break; case "自动任务": mti = 2; break; case "临时任务": mti = 3; break; case "手工任务": mti = 4; break; } string hw = ""; if (this.dgvManager.CurrentRow.Cells["起点货位"].Value.ToString() != "-") { hw = ",起点货位:" + this.dgvManager.CurrentRow.Cells["起点货位"].Value.ToString(); } string cap = strsplit[0]; if (MessageBox.Show("您确认条码：“" + this.dgvManager.CurrentRow.Cells["条码"].Value.ToString() + "”，" + cap + split[2] + "已经被取消操作，而且人工搬运托盘退回到起点设备“" + this.dgvManager.CurrentRow.Cells["起点"].Value.ToString() + hw + "”了吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } string d = Dns.GetHostEntry("localhost").HostName; CStaticClass.WcfControl.BeginModifyManageTask1(d,mti, fid, Model.CGeneralFunction.TASKDELETE, new AsyncCallback(ModifyManageTask1CallBack), null); //{ // MessageBox.Show(cap, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); //} TSMrefresh_Click(); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); } } 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 "; 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 toolStripMenuItem3_Click(object sender, EventArgs e) { SetTaskLevel(100); } private void toolStripMenuItem4_Click(object sender, EventArgs e) { SetTaskLevel(50); } private void toolStripMenuItem5_Click(object sender, EventArgs e) { SetTaskLevel(0); } private void SetTaskLevel(int level) { string sql = string.Empty; try { char[] cc = new char[1] { '：' }; string[] split = TSManager.Text.Split(cc); if ((split[1] == "") || (split[2] == "")) { return; } char[] scc = new char[1] { '；' }; string[] strsplit = split[1].Split(scc); int mti = 0; int fid = Convert.ToInt32(split[2]); if (strsplit[0] == "") return; switch (strsplit[0]) { case "调度任务": mti = 1; break; case "自动任务": mti = 2; break; case "临时任务": mti = 3; break; case "手工任务": mti = 4; break; } sql = string.Format("update T_Manage_Task set FTASKLEVEL={0} where FID={1} and F_ManageTaskKindIndex={2}", level, fid, mti); dbo.ExceSQL(sql); sql = string.Format("update T_Monitor_Task set F_MonitorTaskLevel={0} where F_ManageTaskIndex={1} and F_ManageTASKKINDINDEX={2}", level, fid, mti); dbo.ExceSQL(sql); MessageBox.Show("修改完成", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.None); } catch (Exception ex) { MessageBox.Show(ex.Message, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error); } } 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(); } } }