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.Mes.Client.Common;
namespace Core.LgMes.Client.LgIntegrationQuery
{
public partial class frmPerformanceLog : Core.Mes.Client.Common.frmStyleBase
{
public frmPerformanceLog()
{
InitializeComponent();
}
public string _devNum = "";
private void frmPerformanceLog_Load(object sender, EventArgs e)
{
this.uldtBeginTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 00:00";
this.uldtEndTime.Value = DateTime.Today.ToString("yyyy-MM-dd") + " 23:59";
this.ultraMaskedEdit1.Enabled = false;
this.cmbPosition.Enabled = false;
chkTime.Checked = true;
//初始化UltraDropDown控件
//InitUltraDropDown();
cmbPosition.SelectedIndex = 0;
QueryData();
}
private void ckbTime_CheckedChanged(object sender, EventArgs e)
{
uldtBeginTime.Enabled = chkTime.Checked;
uldtEndTime.Enabled = chkTime.Checked;
}
private void chkSmeltId_CheckedChanged(object sender, EventArgs e)
{
ultraMaskedEdit1.Enabled = chkSmeltId.Checked;
}
private void chkPosition_CheckedChanged(object sender, EventArgs e)
{
cmbPosition.Enabled = chkPosition.Checked;
}
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "Query":
QueryData();
break;
case "Export":
if (ultraGrid.Rows.Count > 0)
{
ExportExcel();
}
else
MessageBox.Show("没有实绩修改信息。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
break;
case "Exit":
this.Close();
break;
default:
break;
}
}
///
/// 获取渣样信息
///
private void QueryData()
{
string strStartTime = "";
string strEndTime = "";
string strHeatno = "";
string strStacode = "";
string strErr = "";
if (chkTime.Checked == true)
{
if (Convert.ToDateTime(uldtBeginTime.Value) > Convert.ToDateTime(uldtEndTime.Value))
{
MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
strStartTime = this.uldtBeginTime.DateTime.ToString("yyyy-MM-dd");
strEndTime = this.uldtEndTime.DateTime.ToString("yyyy-MM-dd");
}
}
if (chkSmeltId.Checked == true)
{
if (this.ultraMaskedEdit1.Text == "")
{
MessageBox.Show("熔炼号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
if (!string.IsNullOrEmpty(ultraMaskedEdit1.Text))
strHeatno = ultraMaskedEdit1.Text.ToString();
}
}
//if (chkPosition.Checked == true)
//{
// 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(_devNum);
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(); //清空原有行
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();
dataSet.Tables[0].Rows.Add(dr1);
}
}
}
private void ultraMaskedEdit1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
UltraMaskedEdit ume = (UltraMaskedEdit)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;
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);
}
///
/// 导出Excel
///
private void ExportExcel()
{
try
{
string StrfileName = System.Windows.Forms.Application.StartupPath + "\\Report\\实绩修改日志.xls";
this.ultraGridExcelExporter1.Export(this.ultraGrid, StrfileName);
ProcessStartInfo p = new ProcessStartInfo(StrfileName);
p.WindowStyle = System.Diagnostics.ProcessWindowStyle.Maximized;
p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
Process.Start(p);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 初始化UltraDropDown控件(岗位)
///
private void InitUltraDropDown()
{
string strErr = "";
ArrayList arry = new ArrayList();
arry.Add("FrmYCJJB_Process.select");
CommonClientToServer cctos = new CommonClientToServer();
cctos.ob = this.ob;
DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
"doSimpleQuery", arry, out strErr);
if (strErr == "" && ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cmbPosition.Items.Add(i);
cmbPosition.Items[i].DisplayText = ds.Tables[0].Rows[i]["DESCRIPTION"].ToString();
cmbPosition.Items[i].DataValue = ds.Tables[0].Rows[i]["NAME_"].ToString();
}
}
}
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();
}
}
}