using System;
using System.Collections;
using System.ComponentModel;
using System.IO;
using System.Diagnostics;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinMaskedEdit;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using Core.StlMes.Client.LgCommon;
using Core.Mes.Client.Comm.Control;
namespace Core.StlMes.Client.LgIntegrationQuery
{
public partial class frmPerformanceLog : frmStyleBase
{
public string _devNum = "";
public string workShopNo = "";
public frmPerformanceLog()
{
InitializeComponent();
}
private void frmPerformanceLog_Load(object sender, EventArgs e)
{
workShopNo = this.CustomInfo;
this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
this.ultraMaskedEdit2.Enabled = false;
this.cmbPosition.Enabled = false;
initPos();
cmbPosition.SelectedIndex = 0;
QueryData();
}
// 初始化岗位
///
/// 初始化岗位
///
public void initPos()
{
cmbPosition.Items.Clear();
cmbPosition.Items.Add("B01", "1#脱硫站");
cmbPosition.Items.Add("C01", "1#转炉");
cmbPosition.Items.Add("C02", "2#转炉");
cmbPosition.Items.Add("C03", "3#转炉");
cmbPosition.Items.Add("C04", "4#转炉");
cmbPosition.Items.Add("C05", "5#转炉");
cmbPosition.Items.Add("D01", "1#吹氩站");
cmbPosition.Items.Add("D02", "2#吹氩站");
cmbPosition.Items.Add("D03", "3#吹氩站");
cmbPosition.Items.Add("D04", "4#吹氩站");
cmbPosition.Items.Add("D05", "5#吹氩站");
cmbPosition.Items.Add("E01", "1#精炼炉");
cmbPosition.Items.Add("E02", "2#精炼炉");
cmbPosition.Items.Add("E03", "3#精炼炉");
cmbPosition.Items.Add("G01", "1#连铸机");
cmbPosition.Items.Add("G02", "2#连铸机");
cmbPosition.Items.Add("G03", "3#连铸机");
cmbPosition.Items.Add("G04", "4#连铸机");
cmbPosition.Items.Add("G05", "5#连铸机");
//if (workShopNo == "1")
//{
// cmbPosition.Items.Add("A01", "1#脱硫站");
// cmbPosition.Items.Add("B01", "1#转炉");
// cmbPosition.Items.Add("B02", "2#转炉");
// cmbPosition.Items.Add("E01", "1#吹氩站");
// cmbPosition.Items.Add("E02", "2#吹氩站");
// cmbPosition.Items.Add("F01", "1#精炼炉");
// cmbPosition.Items.Add("G01", "1#连铸机");
// cmbPosition.Items.Add("G02", "2#连铸机");
//}
//else
//{
// cmbPosition.Items.Add("B03", "3#转炉");
// cmbPosition.Items.Add("B04", "4#转炉");
// cmbPosition.Items.Add("B05", "5#转炉");
// cmbPosition.Items.Add("E03", "3#吹氩站");
// cmbPosition.Items.Add("E04", "4#吹氩站");
// cmbPosition.Items.Add("E05", "5#吹氩站");
// cmbPosition.Items.Add("F02", "2#精炼炉");
// cmbPosition.Items.Add("F03", "3#精炼炉");
// cmbPosition.Items.Add("G03", "3#连铸机");
// cmbPosition.Items.Add("G04", "4#连铸机");
// cmbPosition.Items.Add("G05", "5#连铸机");
//}
}
// 根据编码获得岗位信息
///
/// 根据编码获得岗位信息
///
///
public Hashtable getPos()
{
Hashtable pos_table = new Hashtable();
pos_table.Clear();
pos_table.Add("B01", "1#脱硫站");
pos_table.Add("B02", "2#脱硫站");
pos_table.Add("C01", "1#转炉");
pos_table.Add("C02", "2#转炉");
pos_table.Add("C03", "3#转炉");
pos_table.Add("C04", "4#转炉");
pos_table.Add("C05", "5#转炉");
pos_table.Add("D01", "1#吹氩站");
pos_table.Add("D02", "2#吹氩站");
pos_table.Add("D03", "3#吹氩站");
pos_table.Add("D04", "4#吹氩站");
pos_table.Add("D05", "5#吹氩站");
pos_table.Add("E01", "1#精炼炉");
pos_table.Add("E02", "2#精炼炉");
pos_table.Add("E03", "3#精炼炉");
pos_table.Add("G01", "1#连铸机");
pos_table.Add("G02", "2#连铸机");
pos_table.Add("G03", "3#连铸机");
pos_table.Add("G04", "4#连铸机");
pos_table.Add("G05", "5#连铸机");
return pos_table;
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "Query":
QueryData();
break;
case "Export":
try
{
//Core.Mes.Client.Common.Globals.ulGridToExcel(ultraGrid, Text);
GridHelper.ulGridToExcel(ultraGrid, Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case "Exit":
this.Close();
break;
default:
break;
}
}
// 获取实绩修改信息
///
/// 获取实绩修改信息
///
private void QueryData()
{
try
{
string strStartTime = "";
string strEndTime = "";
string strHeatno = "";
string strStacode = "";
string strErr = "";
if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
{
MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
strStartTime = this.uldtBeginTime.DateTime.ToString("yyyyMMddHHmmss");
strEndTime = this.uldtEndTime.DateTime.ToString("yyyyMMddHHmmss");
}
if (chkSmeltId.Checked == true)
{
if (this.ultraMaskedEdit2.Text == "")
{
ultraMaskedEdit2.Focus();
MessageBox.Show("熔炼号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
if (!string.IsNullOrEmpty(ultraMaskedEdit2.Text))
strHeatno = ultraMaskedEdit2.Text.ToString();
}
}
if (chkPosition.Checked)
{
if (this.cmbPosition.SelectedIndex<0)
{
cmbPosition.Focus();
MessageBox.Show("岗位不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
strStacode = cmbPosition.Value.ToString();
}
//获取实绩修改日志信息
string NowTime = DateTime.Now.ToString("yyyy-MM-dd");
ArrayList arry = new ArrayList();
arry.Add("frmPerformanceLog.select");
arry.Add(strHeatno);
arry.Add(strStacode);
arry.Add(strStartTime == "" ? NowTime : strStartTime);
arry.Add(strEndTime == "" ? NowTime : strEndTime);
CommonClientToServer cctos = new CommonClientToServer();
cctos.ob = this.ob;
DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
"doSimpleQuery", arry, out strErr);
dataSet.Clear(); //清空原有行
Hashtable p_table = getPos();
if (strErr == "" && ds != null)
{
foreach (DataRow Dr in ds.Tables[0].Rows)
{
DataRow dr1 = dataSet.Tables[0].NewRow();
dr1["HEATNO"] = Dr["HEATNO"].ToString();
dr1["DISPOSALTIME"] = Dr["DISPOSALTIME"].ToString();
//dr1["DESCRIPTION"] = Dr["DESCRIPTION"].ToString();
dr1["MODIFYNAME"] = Dr["MODIFYNAME"].ToString();
dr1["MODIFYDATE"] = Dr["MODIFYDATE"].ToString();
dr1["ID"] = Dr["ID"].ToString();
dr1["MODIFYCOLUMNCAPTION"] = Dr["MODIFYCOLUMNCAPTION"].ToString();
dr1["MODIFYBEFORE"] = Dr["MODIFYBEFORE"].ToString();
dr1["MODIFYAFTER"] = Dr["MODIFYAFTER"].ToString();
dr1["MODIFYCOLUMNNAME"] = Dr["MODIFYCOLUMNNAME"].ToString();
if (p_table.Contains(Dr["STATIONCODE"].ToString()))
{
dr1["STATIONCODE"] = p_table[Dr["STATIONCODE"].ToString()].ToString();
}
else
{
dr1["STATIONCODE"] = Dr["STATIONCODE"].ToString();
}
dataSet.Tables[0].Rows.Add(dr1);
}
}
PublicMethod.RefreshAndAutoSize(ultraGrid);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
Infragistics.Win.UltraWinEditors.UltraTextEditor ume = (Infragistics.Win.UltraWinEditors.UltraTextEditor)sender;
switch (e.Button.Key)
{
case "edit":
frmNumberWriter frm = new frmNumberWriter();
frm._strText = ume.Text.Trim();
frm.Location = GetChildWindowLocation(frm.Size);
frm.ShowDialog();
ume.Text = frm._strText;
ultraMaskedEdit2.SelectionStart = ultraMaskedEdit2.Text.ToString().Length;
break;
case "clear":
if (ume.Text.Trim().Length > 0)
{
ume.Tag = ume.Text.Trim();
ume.Text = "";
}
else
{
if (ume.Tag != null)
ume.Text = ume.Tag.ToString();
}
break;
}
}
// 获取子窗体弹出的位置坐标
///
/// 获取子窗体弹出的位置坐标
///
private Point GetChildWindowLocation(Size ChildWindowSize)
{
int width = Cursor.Position.X + ChildWindowSize.Width - Screen.PrimaryScreen.Bounds.Width;
int height = Cursor.Position.Y + ChildWindowSize.Height - Screen.PrimaryScreen.Bounds.Height + 30;
if (width > 0)
width = Cursor.Position.X - width;
else
width = Cursor.Position.X;
if (height > 0)
height = Cursor.Position.Y - height + 10;
else
height = Cursor.Position.Y + 10;
return new Point(width, height);
}
private void cmbPosition_ValueChanged(object sender, EventArgs e)
{
switch (this.cmbPosition.SelectedIndex) //edit on 2009-04-23
{
case 0:
_devNum = "X00"; //调度岗位
break;
case 1:
_devNum = "B01";
break;
case 2:
_devNum = "B02";
break;
case 3:
_devNum = "C01";
break;
case 4:
_devNum = "C02";
break;
case 5:
_devNum = "D01";
break;
case 6:
_devNum = "D02";
break;
case 7:
_devNum = "E01";
break;
case 8:
_devNum = "E02";
break;
case 9:
_devNum = "F01";
break;
case 10:
_devNum = "I01";
break;
case 11:
_devNum = "G01";
break;
case 12:
_devNum = "G02";
break;
case 13:
_devNum = "G03";
break;
default:
break;
}
QueryData();
}
private void chkSmeltId_CheckedChanged(object sender, EventArgs e)
{
ultraMaskedEdit2.Enabled = chkSmeltId.Checked;
if (ultraMaskedEdit2.Enabled == false)
{
ultraMaskedEdit2.BackColor = Color.WhiteSmoke;
}
}
private void chkPosition_CheckedChanged(object sender, EventArgs e)
{
cmbPosition.Enabled = chkPosition.Checked;
}
private void ultraMaskedEdit1_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b'))
{
e.Handled = true;
}
}
}
}