Collaborative_Team
/
YXHY_WCS_YL
2
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
宜昌华友-原料库
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
0 Tags
23 MiB
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
YXHY_WCS_YL/ControlMonitorClient-/FrmModifyMonitor.cs

624 lines
29 KiB
Raw Permalink Normal View History

添加项目文件。
3 months ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DBFactory;
using System.Net.Sockets;
using System.Threading;
using System.ServiceModel;
namespace wcfControlMonitorClient
{
/// <summary>
/// Creator:Richard.liu
/// �豸ָ�����й���
/// </summary>
public partial class FrmModifyMonitor : Form
{
string _monstatus = " F_Status>=-1 ";
private static FrmModifyMonitor _formInstance;
public static FrmModifyMonitor FormInstance
{
get
{
if (_formInstance == null)
{
_formInstance = new FrmModifyMonitor();
}
return _formInstance;
}
set { _formInstance = value; }
}
DBOperator dbo = CStaticClass.dbo;
DBOperator dboM = CStaticClass.dboM;
public FrmModifyMonitor()
{
InitializeComponent();
_formInstance = this;
}
private void cmMonitor_Opening(object sender, CancelEventArgs e)
{
if (this.dgvMonitor.CurrentRow == null)
{
TSMonitor.Visible = false;
TSMManager.Visible = false;
TSMmonitorOK.Visible = false;
TSMRestore.Visible = false;
TSMmonitorDel.Visible = false;
toolStripSeparator2.Visible = false;
tsmAGV.Visible = false;
tsmAGVGet.Visible = false;
tsmAGVSend.Visible = false;
tsmAGVBank.Visible = false;
tsmAGVGoods.Visible = false;
return;
}
if (Convert.ToInt32(this.dgvMonitor.CurrentRow.Cells["������������"].Value) > 0)
{
TSMonitor.Visible = true;
TSMManager.Visible = true;
//TSMSimulateRun.Visible = true;
TSMmonitorOK.Visible = true;
TSMmonitorDel.Visible = true;
TSMRestore.Visible = true;
toolStripSeparator2.Visible = true;
TSMManager.Text = "���룺" + this.dgvMonitor.CurrentRow.Cells["����"].Value.ToString() +
"����������������" + this.dgvMonitor.CurrentRow.Cells["������������"].Value.ToString();
TSMonitor.Text = "�豸ָ��������" + this.dgvMonitor.CurrentRow.Cells["�豸ָ������"].Value.ToString();
//string CorrelRGV = "12008,12016,12024,32008,32016,32024,42008,42016,42024";//-1,-3
//string Upok = "32027,32040";//+2,+6
//int device=Convert.ToInt32(this.dgvMonitor.CurrentRow.Cells["�豸����"].Value);
//TSMmonitorOK.DropDownItems.Clear();
//if (CorrelRGV.IndexOf(device.ToString()) >= 0)
//{
// ToolStripMenuItem tsmi = new ToolStripMenuItem(Convert.ToInt32(device - 1).ToString());
// tsmi.Click += new EventHandler(TSMmonitorOK_Click);
// TSMmonitorOK.DropDownItems.Add(tsmi);
// ToolStripMenuItem tsmi1 = new ToolStripMenuItem(Convert.ToInt32(device - 3).ToString());
// TSMmonitorOK.DropDownItems.Add(tsmi1);
// tsmi1.Click += new EventHandler(TSMmonitorOK_Click);
//}
//else if (Upok.IndexOf(device.ToString()) >= 0)
//{
// ToolStripMenuItem tsmi = new ToolStripMenuItem(Convert.ToInt32(device +2).ToString());
// tsmi.Click += new EventHandler(TSMmonitorOK_Click);
// TSMmonitorOK.DropDownItems.Add(tsmi);
// ToolStripMenuItem tsmi1 = new ToolStripMenuItem(Convert.ToInt32(device + 6).ToString());
// tsmi1.Click += new EventHandler(TSMmonitorOK_Click);
// TSMmonitorOK.DropDownItems.Add(tsmi1);
//}
//if (this.dgvMonitor.CurrentRow.Cells[3].Value.ToString() == "1001")
//{
// TSMSimulateRun.Visible = false;
// TSMmonitorOK.Visible = false;
// TSMRestore.Visible = true;
// toolStripSeparator2.Visible = false;
// tsmAGV.Visible = true;
// tsmAGVGet.Visible = true;
// tsmAGVSend.Visible = true;
// if (this.dgvMonitor.CurrentRow.Cells[5].Value.ToString() == "2")//1219�����̻���
// {
// tsmAGVGoods.Visible = false;
// tsmAGVBank.Visible = true;
// tsmAGVSend.Visible = false;
// return;
// }
// else
// {
// tsmAGVSend.Visible = true;
// tsmAGVBank.Visible = false;
// }
// if (this.dgvMonitor.CurrentRow.Cells[5].Value.ToString() == "3")//1220�����̻���
// {
// tsmAGVBank.Visible = false;
// tsmAGVGoods.Visible = true;
// tsmAGVSend.Visible = false;
// return;
// }
// else
// {
// tsmAGVSend.Visible = true;
// tsmAGVGoods.Visible = false;
// }
//}
//else
//{
tsmAGV.Visible = false;
tsmAGVGet.Visible = false;
tsmAGVSend.Visible = false;
tsmAGVBank.Visible = false;
tsmAGVGoods.Visible = false;
//}
}
}
private void TSMmonitorOK_Click(object sender, EventArgs e)
{
ToolStripMenuItem tsm = sender as ToolStripMenuItem;
if (tsm.DropDownItems.Count > 0) return;
int deviceindex = 0;
int.TryParse(tsm.Text, out deviceindex);
char[] cc = new char[1] { '��' };
string[] split = TSMonitor.Text.Split(cc);
if (split[1] == "") return;
try
{
DataView dv = dbo.ExceSQL("SELECT * FROM T_Monitor_Task Where F_MonitorIndex=" +
Convert.ToInt32(split[1])).Tables[0].DefaultView;
if (dv.Count > 0)
{
//20100108�м�ָ���������ʱ������ʾ�;���
DataView dv0 = dbo.ExceSQL("SELECT MIN(F_MonitorIndex) AS mmi FROM dbo.T_Monitor_Task WHERE (F_ManageTaskIndex = " + dv[0]["F_ManageTaskIndex"] + ") AND (F_ManageTASKKINDINDEX = " + dv[0]["F_ManageTASKKINDINDEX"] + ")").Tables[0].DefaultView;
if (dv0.Count > 0)
{
if ((dv0[0]["mmi"] != DBNull.Value) && (dv0[0]["mmi"].ToString() != split[1]))
{
if (MessageBox.Show("���룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "��֮ǰ����ûִ�����ɵĵ�����������ǰ���������ɡ������ɵ����������ң���ȷ��Ҫ������������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
}
}
dv0 = null;
//20100108������ϻ��������������
if (MessageBox.Show("��ȷ�����룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "���Ѿ���������������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
string sss = "�豸����:" + dv[0]["F_DeviceIndex"].ToString() + ";�豸ָ������:" + dv[0]["F_MonitorIndex"].ToString();
//20100108������ϻ��������������
CommonClassLib.CCarryConvert.WriteDarkCasket("�豸ָ������", "�ֹ���������", "���룺" + dv[0]["F_TxtParam"].ToString(), sss);
string errtext = string.Empty;
if (deviceindex == 0)
{
deviceindex = Convert.ToInt32(dv[0]["F_DeviceIndex"]);
}
if (dv[0]["F_NumParam4"].ToString() != "0" && CStaticClass.GetDeviceKindIdx(deviceindex) == 2)
{//20120906���ͻ����ͳ�ָ����յ����ͻ���Ϊ���������豸
deviceindex = Convert.ToInt32(dv[0]["F_NumParam4"]);
}
CStaticClass.WcfControl.BeginModifyMonitorTask(deviceindex,Convert.ToInt32(dv[0]["F_MonitorIndex"]), Model.CGeneralFunction.TASKFINISH, new AsyncCallback(ModifyMonitorTaskCallBack), null);
//{
// MessageBox.Show(errtext, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
TSMMonitorRefresh_Click();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void TSMRestore_Click(object sender, EventArgs e)
{
char[] cc = new char[1] { '��' };
string[] split = TSMonitor.Text.Split(cc);
if (split[1] == "") return;
try
{
string errtext = string.Empty;
int devKind;
int mindex = Convert.ToInt32(split[1]);
int fid = 0;
int mankind =0;
//20100108��Ϊselect *
DataView dv = dbo.ExceSQL("select * from T_Monitor_Task where F_MonitorIndex=" + mindex).Tables[0].DefaultView;
if (dv.Count > 0)
{
fid = Convert.ToInt32(dv[0]["F_ManageTaskIndex"]);
mankind = Convert.ToInt32(dv[0]["F_ManageTASKKINDINDEX"]);
//20100108�м�ָ���λʱ������ʾ�;���
DataView dv0 = dbo.ExceSQL("SELECT MIN(F_MonitorIndex) AS mmi FROM dbo.T_Monitor_Task WHERE (F_ManageTaskIndex = " + fid + ") AND (F_ManageTASKKINDINDEX = " + mankind + ")").Tables[0].DefaultView;
if (dv0.Count > 0)
{
if ((dv0[0]["mmi"] != DBNull.Value) && (dv0[0]["mmi"].ToString() != mindex.ToString()))
{
if (MessageBox.Show("���룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "��֮ǰ����ûִ�����ɵĵ�����������ǰ����λ�������ɵ����������ң���ȷ��Ҫ������������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
}
}
dv0 = null;
//20100108������ϻ��������������
if (MessageBox.Show("��ȷ�����룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "����Ҫ�����·��ͺ��豸��������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
//20091107
devKind =CStaticClass.GetDeviceKindIdx (Convert.ToInt32(dv[0]["F_DeviceIndex"]));
if ((devKind == 6) && (dv[0]["F_AgvNo"] != DBNull.Value))
{
if (MessageBox.Show("��Ҫ��λ��AGV�����Ѿ�����AGV���ţ�" + dv[0]["F_AgvNo"].ToString() + "��ȷ��Ҫ���������´�AGV��������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
}
string sss = "�豸����:" + dv[0]["F_DeviceIndex"].ToString() + ";�豸ָ������:" + dv[0]["F_MonitorIndex"].ToString();
//20100108������ϻ��������������
CommonClassLib.CCarryConvert.WriteDarkCasket("�豸ָ������", "�ֹ���λ", "����:" + dv[0]["F_TxtParam"].ToString(), sss);
CStaticClass.WcfControl.BeginModifyMonitorTask(Convert.ToInt32(dv[0]["F_DeviceIndex"]), Convert.ToInt32(dv[0]["F_MonitorIndex"]), Model.CGeneralFunction.TASKRESTORE,
new AsyncCallback(ModifyMonitorTaskCallBack), null);
//{
// MessageBox.Show(errtext, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
TSMMonitorRefresh_Click();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void rbmonAll_CheckedChanged(object sender, EventArgs e)
{
RadioButton rb = (RadioButton)sender;
if (rb.Checked == true)
{
_monstatus = " F_Status>=-1 ";
}
TSMMonitorRefresh_Click();
}
private void TSMMonitorRefresh_Click()
{
this.dgvMonitor.DataSource = dbo.ExceSQL("select * from V_Monitor_Task where " + _monstatus + " order by �豸ָ������ asc ").Tables[0].DefaultView;
}
private void rbmonRun_CheckedChanged(object sender, EventArgs e)
{
if (rbmonRun.Checked == true)
{
_monstatus = " (F_Status>=1) ";
}
TSMMonitorRefresh_Click();
}
private void rbmonWait_CheckedChanged(object sender, EventArgs e)
{
RadioButton rb = (RadioButton)sender;
if (rb.Checked == true)
{
_monstatus = " F_Status=0 ";
}
TSMMonitorRefresh_Click();
}
public void button1_Click(object sender, EventArgs e)
{//20140218
try
{
if (this.textBox1.Text.Trim().Length == 0) return;
string _manstatus = " F_Status>=-1 ";
if (this.comboBox1.Text == "����")
{
_monstatus = " ����='" + this.textBox1.Text.Trim() + "' ";
_manstatus = " ���� like '%" + this.textBox1.Text.Trim() + "%' ";
}
if (this.comboBox1.Text == "�豸ָ������")
{
_monstatus = " �豸ָ������='" + this.textBox1.Text.Trim() + "' ";
_manstatus = " ������������='" + CStaticClass.GetManageTaskIndexfromMonitor(Convert.ToInt32(this.textBox1.Text.Trim())) + "' ";
}
if (this.comboBox1.Text == "������������")
{
_monstatus = " ������������='" + this.textBox1.Text.Trim() + "' ";
_manstatus = " ������������='" + this.textBox1.Text.Trim() + "' ";
}
if (this.comboBox1.Text == "�豸����")//20130817richard
{
_monstatus = " F_Status<>0 and �豸����='" + this.textBox1.Text.Trim() + "' ";
int manFID = Convert.ToInt32(dbo.GetSingle("SELECT F_ManageTaskIndex,F_DeviceIndex,F_Status FROM T_Monitor_Task where F_Status<>0 and F_DeviceIndex='" + this.textBox1.Text.Trim() + "' "));
_manstatus = " ������������='" + manFID + "' ";
}
TSMMonitorRefresh_Click();
this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task where " + _manstatus).Tables[0].DefaultView;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button2_Click(object sender, EventArgs e)
{
_monstatus = " F_Status>=-1 ";
TSMMonitorRefresh_Click();
}
private void dgvMonitor_DataSourceChanged(object sender, EventArgs e)
{
dgvMonitor.Columns["F_Status"].Visible = false;
}
private void FrmModifyMonitor_Load(object sender, EventArgs e)
{
rbmonRun_CheckedChanged(sender, e);
}
private void tsmAGVGet_Click(object sender, EventArgs e)
{
string sql = "";
//��T_Monitor_Task���л���F_NumParam2�ֶ�ֵ ��������Ϣ���ص�С��������
DataTable tableMonitorTask = dbo.ExceSQL("SELECT F_ManageTASKKINDINDEX,F_ManageTaskIndex,F_NumParam2,F_AgvTask,F_AgvNo FROM T_MONITOR_TASK WHERE F_DeviceIndex=1001 and F_MonitorIndex=" + this.dgvMonitor.CurrentRow.Cells[2].Value + "").Tables[0];
if (tableMonitorTask.Rows.Count > 0)
{
if (MessageBox.Show("��ȷ���ֹ�����AGV������������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
sql = "UPDATE T_Monitor_Task SET F_Status = 2 WHERE (F_MonitorIndex =" + this.dgvMonitor.CurrentRow.Cells[2].Value + ")";
dbo.ExceSQL(sql);
//��T_Base_AGV_Gate���л���F_AGVGateDeviceIndex�ֶ�ֵ ������T_Base_AGV_Gate.F_Address = T_Monitor_Task.F_NumParam2
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(tableMonitorTask.Rows[0]["F_NumParam2"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
if (MessageBox.Show("��ȷ��Ҫ���豸:" + tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"] + "�óɡ������̡�״̬����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
//����T_Base_Device���е�F_HaveGoods�ֶ�ֵΪ0��������T_Base_Device.F_DeviceIndex = T_Base_AGV_Gate.F_AGVGateDeviceIndex
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='-',F_HAVEGOODS = 0 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
string errtext=string.Empty;
if (tableMonitorTask.DefaultView[0]["F_ManageTASKKINDINDEX"].ToString() == "1")
{
//20090817����������������Ϣ
dboM.ExecuteSql("UPDATE T_ITEMDEVICE SET devicestatus ='0' WHERE devicecode = '" + tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"] + "'");
}
}
string sss = "AGV����:" + tableMonitorTask.Rows[0]["F_AgvNo"].ToString() + ";�豸ָ������:" + this.dgvMonitor.CurrentRow.Cells[2].Value.ToString();
CommonClassLib.CCarryConvert.WriteDarkCasket("�豸ָ������", "�ֹ�����AGV��������", tableMonitorTask.Rows[0]["F_AgvNo"].ToString() + "�ų�", sss);
}
else
{
MessageBox.Show("ֻ��AGV�����ſ����ֹ�����AGV�������ɣ�", "��������ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void tsmAGVSend_Click(object sender, EventArgs e)
{
//��T_Monitor_Task���л���F_NumParam5�ֶ�ֵ ��������Ϣ���ص�С��������
DataTable tableMonitorTask = dbo.ExceSQL("SELECT F_TxtParam,F_NumParam5,F_AgvTask,F_AgvNo FROM T_MONITOR_TASK WHERE F_DeviceIndex=1001 and F_MonitorIndex=" + this.dgvMonitor.CurrentRow.Cells[2].Value + "").Tables[0];
if (tableMonitorTask.Rows.Count > 0)
{
if (MessageBox.Show("��ȷ���ֹ�����AGVж����������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
//��T_Base_AGV_Gate���л���F_AGVGateDeviceIndex�ֶ�ֵ ������T_Base_AGV_Gate.F_Address = T_Monitor_Task.F_NumParam2
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(tableMonitorTask.Rows[0]["F_NumParam5"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
if (MessageBox.Show("��ȷ��Ҫ���豸:" + tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"] + "�óɡ������̡�״̬����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
//����T_Base_Device���е�F_HaveGoods�ֶ�ֵΪ0��������T_Base_Device.F_DeviceIndex = T_Base_AGV_Gate.F_AGVGateDeviceIndex
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='" + tableMonitorTask.Rows[0]["F_TxtParam"] + "',F_HAVEGOODS = 1 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
string sss = "AGV����:" + tableMonitorTask.Rows[0]["F_AgvNo"].ToString() + ";�豸ָ������:" + this.dgvMonitor.CurrentRow.Cells[2].Value.ToString();
CommonClassLib.CCarryConvert.WriteDarkCasket("�豸ָ������", "�ֹ�����AGVж������", tableMonitorTask.Rows[0]["F_AgvNo"].ToString() + "�ų�", sss);
CStaticClass.WcfControl.BeginModifyMonitorTask(1001,Convert.ToInt32(this.dgvMonitor.CurrentRow.Cells[2].Value), Model.CGeneralFunction.TASKFINISH ,new AsyncCallback(ModifyMonitorTaskCallBack), null);
}
else
{
MessageBox.Show("ֻ��AGV�����ſ����ֹ�����AGV�Ż����ɣ�", "��������ʾ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
private void tsmAGVBank_Click(object sender, EventArgs e)
{
string errtext=string.Empty;
CStaticClass.WcfControl.BeginModifyMonitorTask(1001,Convert.ToInt32(this.dgvMonitor.CurrentRow.Cells[2].Value), Model.CGeneralFunction.TASKFINISH, new AsyncCallback(ModifyMonitorTaskCallBack), null);
}
private void tsmAGVGoods_Click(object sender, EventArgs e)
{
string errtext = string.Empty;
CStaticClass.WcfControl.BeginModifyMonitorTask(1001,Convert.ToInt32(this.dgvMonitor.CurrentRow.Cells[2].Value), Model.CGeneralFunction.TASKFINISH ,new AsyncCallback(ModifyMonitorTaskCallBack), null);
}
private void dgvMonitor_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
foreach (DataGridViewRow DGVRow in this.dgvMonitor.Rows)
{
if (DGVRow != null)
{
if (Convert.ToInt32(DGVRow.Cells["f_status"].Value) >= 30)
{
DGVRow.DefaultCellStyle.BackColor = Color.Red;
}
}
}
}
private void TSMmonitorDel_Click(object sender, EventArgs e)
{
char[] cc = new char[1] { '��' };
string[] split = TSMonitor.Text.Split(cc);
if (split[1] == "") return;
try
{
DataView dv = dbo.ExceSQL("SELECT * FROM T_Monitor_Task Where F_MonitorIndex=" +
Convert.ToInt32(split[1])).Tables[0].DefaultView;
if (dv.Count > 0)
{
//20100108�м�ָ���������ʱ������ʾ�;���
DataView dv0 = dbo.ExceSQL("SELECT MIN(F_MonitorIndex) AS mmi FROM dbo.T_Monitor_Task WHERE (F_ManageTaskIndex = " + dv[0]["F_ManageTaskIndex"] + ") AND (F_ManageTASKKINDINDEX = " + dv[0]["F_ManageTASKKINDINDEX"] + ")").Tables[0].DefaultView;
if (dv0.Count > 0)
{
if ((dv0[0]["mmi"] != DBNull.Value) && (dv0[0]["mmi"].ToString() != split[1]))
{
if (MessageBox.Show("���룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "��֮ǰ����ûִ�����ɵĵ�����������ǰ��ɾ���豸ָ������ɵ����������ң���ȷ��Ҫ������������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
}
}
dv0 = null;
//20100108������ϻ��������������
if (MessageBox.Show("��ȷ�����룺" + dv[0]["F_TxtParam"].ToString() + "���豸����:��" + this.dgvMonitor.CurrentRow.Cells["�豸����"].Value.ToString() + ";�豸����:" + this.dgvMonitor.CurrentRow.Cells["�豸��������"].Value.ToString() + "���Ѿ�����Ҫ�豸ִ��������", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
string sss = "�豸����:" + dv[0]["F_DeviceIndex"].ToString() + ";�豸ָ������:" + dv[0]["F_MonitorIndex"].ToString();
//20100108������ϻ��������������
CommonClassLib.CCarryConvert.WriteDarkCasket("�豸ָ������", "�ֹ�ɾ���豸ָ��", "���룺" + dv[0]["F_TxtParam"].ToString(), sss);
CStaticClass.WcfControl.BeginModifyMonitorTask(Convert.ToInt32(dv[0]["F_DeviceIndex"]), Convert.ToInt32(dv[0]["F_MonitorIndex"]), Model.CGeneralFunction.TASKDELETE, new AsyncCallback(ModifyMonitorTaskCallBack), null);
//{
// MessageBox.Show(sss, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
TSMMonitorRefresh_Click();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string df = "";
string wherestr = " where 1=1 ";
switch (this.comboBox1.Text)
{
case "����":
df = "����";
break;
case "������������":
df = "������������";
break;
case "�豸ָ������":
df = "�豸ָ������";
wherestr = " where f_status<>0 ";
break;
case "�豸����":
df = "�豸����";//20130817richard
wherestr = " where f_status<>0 ";
break;
default:
return;
}
//20100208
string sql = "select distinct " + df + " from V_Monitor_Task " + wherestr;
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 dgvMonitor_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
{
string errtext = string.Empty;
if ((e.RowIndex >= 0))//&&(e.Button == MouseButtons.Right)
{
dgvMonitor.ClearSelection();
dgvMonitor.Rows[e.RowIndex].Selected = true;
dgvMonitor.CurrentCell = dgvMonitor.Rows[e.RowIndex].Cells[0];
}
}
void ModifyMonitorTaskCallBack(IAsyncResult ar)
{
if (this.IsDisposed == true) return;
string errtext = string.Empty;
this.BeginInvoke(new MethodInvoker(delegate()
{
if (CStaticClass.WcfControl.EndModifyMonitorTask(out errtext, ar) == false)
{
MessageBox.Show(errtext, "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
TSMMonitorRefresh_Click();
}));
}
private void FrmModifyMonitor_FormClosing(object sender, FormClosingEventArgs e)
{
_formInstance = null;
}
}
}