| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008 |
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Windows.Forms;
- using System.Collections;
- using CoreFS.CA06;
- using Infragistics.Win.UltraWinGrid;
- using System.Threading;
- using System.Diagnostics;
- using System.IO;
- using Core.StlMes.Client.LgCommon;
- using Infragistics.Win.UltraWinEditors;
- using Infragistics.Win.Misc;
- namespace Core.StlMes.Client.LgResMgt
- {
- public partial class frmScrapSteel : frmStyleBase
- {
- private System.Threading.Thread myThread_FG;
- private ArrayList MaterCode; //物料编码
- private ArrayList MaterName; //物料名称
- private ArrayList MaterValue; //物料重量
- private ArrayList EditorNameList;
- private ArrayList EditorValueList;
- private string _strSendSucceededForBof1 = "";
- private string _strSendSucceededForBof2 = "";
- private string _strSendSucceededForBof3 = "";
- private string _strSendSucceededForBof4 = "";
- private string _strSendSucceededForBof5 = "";
- private bool ok_flag = false;
- public string workshopNo = "";
- public frmScrapSteel()
- {
- InitializeComponent();
- CheckForIllegalCrossThreadCalls = false;
- MaterCode = new ArrayList();
- MaterName = new ArrayList();
- MaterValue = new ArrayList();
- EditorNameList = new ArrayList();
- EditorValueList = new ArrayList();
- }
- private void checkBox1_CheckedChanged(object sender, EventArgs e)
- {
- this.ute_DH.Enabled = checkBox1.Checked;
- }
-
- private void frmScrapSteel_Load(object sender, EventArgs e)
- {
- workshopNo = this.CustomInfo;
- label1.BackColor = Color.LightGreen;
- label3.BackColor = Color.LightCyan;
- label18.BackColor = Color.White;
- this.udte_StartTime.Text = System.DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd") + " 00:00:00";
- this.udte_EndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
- ultraTabControl1.Tabs[0].Selected = true;
- chkSend.Checked = true;
- InitFrm();
- GetZL_Thread();
- cbb_BC.SelectedIndex = 0;
- GetZL_SCJH();
- GetConfigMater();
- setMaterEnable();
- }
- // 根据体系显示控件
- /// <summary>
- /// 根据体系显示控件
- /// </summary>
- private void InitFrm()
- {
- EditorNameList.Add(materName1);
- EditorNameList.Add(materName2);
- EditorNameList.Add(materName3);
- EditorNameList.Add(materName4);
- EditorNameList.Add(materName5);
- EditorNameList.Add(materName6);
- EditorValueList.Add(materValue1);
- EditorValueList.Add(materValue2);
- EditorValueList.Add(materValue3);
- EditorValueList.Add(materValue4);
- EditorValueList.Add(materValue5);
- EditorValueList.Add(materValue6);
- if (workshopNo == "1")
- {
- ultraGroupBox2.Text = "1#转炉";
- ultraGroupBox3.Text = "2#转炉";
- ultraGroupBox4.Visible = false;
- splitter2.Visible = false;
- label15.Text = "1#转炉";
- label16.Text = "2#转炉";
- label17.Visible = false;
- ute_ZL3.Visible = false;
- button3.Visible = false;
- utlcbdevNo.Items.Clear();
- utlcbdevNo.Items.Add("01","1#转炉");
- utlcbdevNo.Items.Add("02","2#转炉");
- }
- else
- {
- ultraGroupBox2.Text = "3#转炉";
- ultraGroupBox3.Text = "4#转炉";
- ultraGroupBox4.Text = "5#转炉";
- ultraGroupBox4.Visible = true;
- splitter2.Visible = true;
- label15.Text = "3#转炉";
- label16.Text = "4#转炉";
- label17.Text = "5#转炉";
- utlcbdevNo.Items.Clear();
- utlcbdevNo.Items.Add("03","3#转炉");
- utlcbdevNo.Items.Add("04","4#转炉");
- utlcbdevNo.Items.Add("05","5#转炉");
- }
- }
- // 获取转炉生产计划记录
- /// <summary>
- /// 获取转炉生产计划记录
- /// </summary>
- private void GetZL_SCJH()
- {
- try
- {
- string szOut = "", strWhere = "";
- int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0;
- string strStartTime = "";
- string strEndTime = "";
- this.dataTable2.Rows.Clear();
- this.dataTable3.Rows.Clear();
- this.dataTable4.Rows.Clear();
- if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
- {
- MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- udte_EndTime.Focus();
- return;
- }
- else
- {
- strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
- strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
- }
- strWhere = " and PLAN_MAKING_TIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') ";
- //strWhere = " and a.aim_grade_code=b.steelcode and (heat_state='03' or heat_state='04') and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
- // strWhere = " and PLAN_MAKING_TIME between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
-
- ArrayList arry = new ArrayList();
- ArrayList sqlList = new ArrayList();
- arry.Add("GetZL_SCJH.query");
- sqlList.Add(strWhere);
- CoreClientParam CCP_LgEts = new CoreClientParam();
- DataTable dt = new DataTable();
- CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
- CCP_LgEts.MethodName = "doQuery";
- CCP_LgEts.ServerParams = new object[] { arry, sqlList };
- CCP_LgEts.SourceDataTable = dt;
- this.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
- DataSet ds = new DataSet();
- ds.Tables.Add(dt);
- szOut = CCP_LgEts.ReturnInfo;
- //DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetZYJH_Data", new object[] { strWhere }, out szOut);
- if (szOut == "")
- {
- if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
- {
- for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
- {
- if (workshopNo == "1") //1体系 1,2转炉
- {
- if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "1")
- {
- DataRow dr = this.dataTable2.NewRow();
- for (int j = 0; j < this.dataTable2.Columns.Count; j++)
- {
- dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
- }
- this.dataTable2.Rows.Add(dr);
- if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- {
- cell.Appearance.BackColor = Color.White;//计划状态
- }
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- cell.Appearance.BackColor = Color.LightGreen;//生产状态
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- cell.Appearance.BackColor = Color.LightCyan;//生产完成
- }
- RowID_1 += 1;
- }
- if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "2")
- {
- DataRow dr = this.dataTable3.NewRow();
- for (int j = 0; j < this.dataTable3.Columns.Count; j++)
- {
- dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
- }
- this.dataTable3.Rows.Add(dr);
- if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- {
- cell.Appearance.BackColor = Color.White;//计划状态
- }
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- cell.Appearance.BackColor = Color.LightGreen;//生产状态
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- cell.Appearance.BackColor = Color.LightCyan;//生产状态
- }
- RowID_2 += 1;
- }
-
- }
- else //2体系 3,4,5转炉
- {
- if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3")
- {
- DataRow dr = this.dataTable2.NewRow();
- for (int j = 0; j < this.dataTable2.Columns.Count; j++)
- {
- dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
- }
- this.dataTable2.Rows.Add(dr);
- if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- {
- cell.Appearance.BackColor = Color.White;//计划状态
- }
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- cell.Appearance.BackColor = Color.LightGreen;//生产状态
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
- {
- foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
- cell.Appearance.BackColor = Color.LightCyan;//生产完成
- }
- RowID_1 += 1;
- }
- if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "4")
- {
- DataRow dr = this.dataTable3.NewRow();
- for (int j = 0; j < this.dataTable3.Columns.Count; j++)
- {
- dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
- }
- this.dataTable3.Rows.Add(dr);
- if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- {
- cell.Appearance.BackColor = Color.White;//计划状态
- }
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- cell.Appearance.BackColor = Color.LightGreen;//生产状态
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
- {
- foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
- cell.Appearance.BackColor = Color.LightCyan;//生产状态
- }
- RowID_2 += 1;
- }
- if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "5")
- {
- DataRow dr = this.dataTable4.NewRow();
- for (int j = 0; j < this.dataTable4.Columns.Count; j++)
- {
- dr[this.dataTable4.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable4.Columns[j].ColumnName.ToString()].ToString();
- }
- this.dataTable4.Rows.Add(dr);
- if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
- {
- foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
- {
- cell.Appearance.BackColor = Color.White;//计划状态
- }
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
- {
- foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
- cell.Appearance.BackColor = Color.LightGreen;//计划状态
- }
- else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
- {
- foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
- cell.Appearance.BackColor = Color.LightCyan;//生成完成
- }
- RowID_3 += 1;
- }
- }
- }
- }
- }
- PublicMethod.RefreshAndAutoSize(ultraGrid2);
- PublicMethod.RefreshAndAutoSize(ultraGrid3);
- PublicMethod.RefreshAndAutoSize(ultraGrid4);
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
- // 获得已经配置的物料
- /// <summary>
- /// 获得已经配置的物料
- /// </summary>
- public void GetConfigMater()
- {
- try
- {
- string strErr = "";
- ArrayList arry = new ArrayList();
- arry.Add("ScrapSteel.Config");
- arry.Add(workshopNo);
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
- if (ds != null && ds.Tables[0].Rows.Count > 0)
- {
- string matercode = "";
- string matername = "";
- int m = 0;
- int count=ds.Tables[0].Rows.Count;
- for (int i = 0; i < count; i++)
- {
- matercode = ds.Tables[0].Rows[i]["SCRAPSTEELCODE"].ToString();
- matername = ds.Tables[0].Rows[i]["SCRAPSTEELNAME"].ToString();
- try
- {
- ((UltraLabel)EditorNameList[i]).Tag = matercode;
- ((UltraLabel)EditorNameList[i]).Text = matername;
- m++;
- }
- catch { }
- }
- for (int j = m; j < EditorNameList.Count; j++)
- {
- ((UltraLabel)EditorNameList[j]).Text = "";
- }
- for (int n = 0; n < EditorValueList.Count; n++)
- {
- ((UltraTextEditor)EditorValueList[n]).Text = "";
- }
- }
- setMaterEnable();
- }
- catch { }
- }
- // 取入炉明细数据主表
- /// <summary>
- /// 取入炉明细数据主表
- /// </summary>
- private void GetRLMX_Data()
- {
- try
- {
- this.ultraDataSource1.Rows.Clear();
- this.dataTable1.Rows.Clear();
- DataSet SetMain = new DataSet();
- string szOut = "", strWhere = "";
- string strStartTime = "";
- string strEndTime = "";
- if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
- {
- MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- udte_EndTime.Focus();
- return;
- }
- else
- {
- strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
- strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
- }
- strWhere = " where JOBDATE between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
- // strWhere = " where JOBDATE between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
- if (this.checkBox1.Checked)
- {
- strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' ";
- }
- if (this.chkSend.Checked)
- {
- strWhere += " and (heatno is null or stationcode is null) ";
- }
- //获取主表信息
- ArrayList arry = new ArrayList();
- ArrayList sqlList = new ArrayList();
- arry.Add("GetRLMX_Data.query");
- sqlList.Add(strWhere);
- CoreClientParam CCP_LgEts = new CoreClientParam();
- DataTable dt = new DataTable();
- CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
- CCP_LgEts.MethodName = "doQuery";
- CCP_LgEts.ServerParams = new object[] { arry, sqlList };
- CCP_LgEts.SourceDataTable = dt;
- this.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
- SetMain.Tables.Clear();
- SetMain.Tables.Add(dt.Copy());
- SetMain.Tables[0].TableName = "Main";
- DataSet ds = new DataSet();
- ds.Tables.Add(dt.Copy());
- szOut = CCP_LgEts.ReturnInfo;
- if (szOut != "" || ds.Tables[0].Rows.Count == 0)
- {
- ultraGrid1.DataSource = this.ultraDataSource1;
- return;
- }
- //获取从表信息
- strWhere = " where FEEDINGTIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
- if (this.chkSend.Checked)
- {
- strWhere += " and ISSEND ='0'";
- }
- ArrayList arry1 = new ArrayList();
- ArrayList sqlList1 = new ArrayList();
- arry1.Add("ScrapSteelMaterAdd.Query");
- sqlList1.Add(strWhere);
- CoreClientParam ccp = new CoreClientParam();
- DataTable dt1 = new DataTable();
- ccp.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
- ccp.MethodName = "doQuery";
- ccp.ServerParams = new object[] { arry1, sqlList1 };
- ccp.SourceDataTable = dt1;
- this.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal);
- DataSet ds1 = new DataSet();
- dt1.TableName = "Child";
- ds1.Tables.Add(dt1.Copy());
- szOut = CCP_LgEts.ReturnInfo;
- if (szOut != "" || ds1.Tables[0].Rows.Count == 0)
- {
- ultraGrid1.DataSource = this.ultraDataSource1;
- return;
- }
- SetMain.Tables.Add(ds1.Tables[0].Copy());
- SetMain.Relations.Clear();
- SetMain.Relations.Add("Band 1", SetMain.Tables["Main"].Columns["JOBID"], SetMain.Tables["Child"].Columns["JOBID"]);
- this.ultraGrid1.DataSource = SetMain;
- foreach (UltraGridRow row in ultraGrid1.Rows)
- {
- if (row.Cells["HEATNO"].Value.ToString().Trim() == "" && row.Cells["STATIONCODE"].Value.ToString().Trim() == "")
- {
- row.Appearance.BackColor = Color.LightCyan;//未发送状态
- }
- else if (row.Cells["HEATNO"].Value.ToString().Trim() != "" && row.Cells["STATIONCODE"].Value.ToString().Trim() != "")
- {
- row.Appearance.BackColor = Color.LightGreen;//发送状态
- }
- else
- {
- row.Appearance.BackColor = Color.White;//未知状态
- }
- }
-
- SetSteelSum();
- PublicMethod.RefreshAndAutoSize(ultraGrid1);
- }
-
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
- // 统计废钢重量
- /// <summary>
- /// 统计废钢重量
- /// </summary>
- private void SetSteelSum()
- {
- UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
- band.Summaries.Clear();
- SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[5]);
- summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
- summary.DisplayFormat = "合计:";
- for (int i = 6; i < 10; i++)
- {
- summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);
- summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
- summary.DisplayFormat = " {0:#####.00}";
- summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
- summary.Appearance.ForeColor = Color.DarkBlue;
- summary.Appearance.BackColor = Color.White;
- }
- band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
- }
- // 新增记录
- /// <summary>
- /// 新增记录
- /// </summary>
- private void AddNewData()
- {
- try
- {
- if (ute_DH2.Text.Trim().Length == 0)
- {
- MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- ute_DH2.Focus();
- return;
- }
- if (ute_ZZ.Text.Trim().Length == 0)
- {
- MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ute_ZZ.Text.Trim() == "0")
- {
- MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- //查询当前班次
- string strErr = "";
- string m_szCurrClass = "";
- ArrayList arry = new ArrayList();
- arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
- if (ds.Tables[0].Rows.Count > 0)
- {
- m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
- }
- GetAllMater();
- if (MaterCode.Count==0)
- {
- MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- strErr = "";
- string strSqlID = "frmScrapMater.Add";
- object[] sArgs = new object[12];
- sArgs[0] = MaterCode; //物料编码
- sArgs[1] = MaterName; //物料名称
- sArgs[2] = MaterValue; //物料重量
- sArgs[3] = ute_DH2.Text.Trim(); //料斗号
- sArgs[4] = (ute_RLSJ.Text.ToString() == ""?DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"):
- (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
- sArgs[5] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
- sArgs[6] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
- sArgs[7] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
- sArgs[8] = this.UserInfo.GetUserName(); //操作人
- sArgs[9] = m_szCurrClass.Substring(0,1) + cbb_BC.Value.ToString().Trim(); //班次班组
- sArgs[10] = ute_BZ.Text.Trim(); //备注
- sArgs[11] = workshopNo;
- try
- {
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- ok_flag = false;
- MessageBox.Show("新增失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
- return;
- }
- else
- {
- ok_flag = true;
- MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- catch { }
- }
- catch { }
- }
- // 获取物料值
- /// <summary>
- /// 获取物料值
- /// </summary>
- private void GetAllMater()
- {
- try
- {
- MaterCode.Clear();
- MaterName.Clear();
- MaterValue.Clear();
- GetAllMaterFun(materName1, materValue1);
- GetAllMaterFun(materName2, materValue2);
- GetAllMaterFun(materName3, materValue3);
- GetAllMaterFun(materName4, materValue4);
- GetAllMaterFun(materName5, materValue5);
- GetAllMaterFun(materName6, materValue6);
- }
- catch { }
- }
- private void GetAllMaterFun(UltraLabel editor1,UltraTextEditor editor2)
- {
- try
- {
- if (editor1.Text.Trim() != "")
- {
- MaterCode.Add(editor1.Tag.ToString());
- MaterName.Add(editor1.Text.Trim());
- MaterValue.Add(editor2.Text.Trim() == "" ? "0" : editor2.Text.Trim());
- }
- }
- catch { }
- }
- // 删除记录
- /// <summary>
- /// 删除记录
- /// </summary>
- private void DeleteDataRow()
- {
- try
- {
- if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
- {
- MessageBox.Show("没有有效的废钢信息可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
- {
- MessageBox.Show("选取的废钢信息已发送不能删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- string strXH = ultNo.Text.Trim();
- if (strXH == "") return;
- DialogResult dr = MessageBox.Show("是否确认删除废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
- if (dr == DialogResult.No) return;
- string strErr = "";
- string strSqlID = "frmScrapMater.Delete";
- object[] sArgs = new object[1];
- sArgs[0] = strXH; //序号
- try
- {
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- MessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- else
- {
- MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- GetRLMX_Data();
- }
- }
- catch { }
-
- }
- catch { }
- }
- // 清除编辑区内容
- /// <summary>
- /// 清除编辑区内容
- /// </summary>
- private void ClearData()
- {
- ute_DH2.Text = "";
- materValue1.Text = "";
- materValue2.Text = "";
- materValue3.Text = "";
- materValue4.Text = "";
- materValue5.Text = "";
- materValue6.Text = "";
- utlcbdevNo.SelectedIndex = -1;
- ute_RLZL.Text = "";
- ute_LH.Text = "";
- ute_ZZ.Text = "";
- cbb_BC.SelectedIndex=0;
- ute_DZ.Text = "";
- ute_RLSJ.Text = "";
- ute_BZ.Text = "";
- }
- // 清除编辑区内容
- /// <summary>
- /// 清除编辑区内容
- /// </summary>
- private void ClearData1()
- {
- ute_DH2.Text = "";
- materValue1.Text = "";
- materValue2.Text = "";
- materValue3.Text = "";
- materValue4.Text = "";
- materValue5.Text = "";
- materValue6.Text = "";
- ute_RLZL.Text = "";
- ute_LH.Text = "";
- ute_ZZ.Text = "";
- cbb_BC.SelectedIndex = 0;
- ute_DZ.Text = "";
- ute_RLSJ.Text = "";
- ute_BZ.Text = "";
- }
- // 修改记录
- /// <summary>
- /// 修改记录
- /// </summary>
- /// <param name="strXH"></param>
- private void UpdateDataRow(string strXH)
- {
- try
- {
- if (ute_DH2.Text.Trim().Length == 0)
- {
- MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- ute_DH2.Focus();
- return;
- }
- if (ute_ZZ.Text.Trim().Length == 0)
- {
- MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ute_ZZ.Text.Trim() == "0")
- {
- MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- //查询当前班次
- string strErr = "";
- string m_szCurrClass = "";
- ArrayList arry = new ArrayList();
- arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
- if (ds.Tables[0].Rows.Count > 0)
- {
- m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
- }
- GetAllMater();
- if (MaterCode.Count == 0)
- {
- MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- strErr = "";
- string strSqlID = "frmScrapMater.Update";
- object[] sArgs = new object[13];
- sArgs[0] = MaterCode; //物料编码
- sArgs[1] = MaterName; //物料名称
- sArgs[2] = MaterValue; //物料重量
- sArgs[3] = ultNo.Text.Trim(); //序号
- sArgs[4] = ute_DH2.Text.Trim(); //料斗号
- sArgs[5] = (ute_RLSJ.Text.ToString() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") :
- (Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
- sArgs[6] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
- sArgs[7] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
- sArgs[8] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
- sArgs[9] = this.UserInfo.GetUserName(); //操作人
- sArgs[10] = m_szCurrClass.Substring(0, 1) + cbb_BC.Value.ToString().Trim(); //班次班组
- sArgs[11] = ute_BZ.Text.Trim(); //备注
- sArgs[12] = workshopNo;
- try
- {
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- ok_flag = false;
- MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
- return;
- }
- else
- {
- ok_flag = true;
- MessageBox.Show(" 修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- catch { }
- }
- catch { }
- }
- // 取消发送
- /// <summary>
- /// 取消发送
- /// </summary>
- private void CancelSend()
- {
- try
- {
- string strXH = ultNo.Text.Trim();
- string strLH = ute_LH.Text.Trim();
- string strStation = "01";
- try
- {
- strStation = "0" + utlcbdevNo.Text.Trim().Substring(0, 1);
- }
- catch { }
- if (strLH == "")
- {
- MessageBox.Show("你选择的废钢信息还未发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (strLH != ute_ZL1.Text.Trim() && strLH != ute_ZL2.Text.Trim() && strLH != ute_ZL3.Text.Trim())
- {
- MessageBox.Show("该炉次号不在转炉工序,不能取消!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- DialogResult dr = MessageBox.Show("确定取消已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
- if (dr == DialogResult.No) return;
- String strErr = "";
- string strSqlID = "frmScrapMater.Cancel";
- object[] sArgs = new object[2];
- sArgs[0] = strLH; //炉号
- sArgs[1] = strXH; //序号
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- MessageBox.Show("废钢信息取消发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- else
- {
- MessageBox.Show("废钢信息取消发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- GetRLMX_Data();
- HeatNo_HudwId_Exist(strLH, strStation);
- }
- }
- catch { }
- }
- //实时刷新当前转炉正在冶炼的熔炼号
- ///<summary>
- ///实时刷新当前转炉正在冶炼的熔炼号
- ///</summary>
- private void GetZL_Thread()
- {
- try
- {
- myThread_FG = new Thread(new ThreadStart(getZLCurrentLH));
- myThread_FG.Priority = ThreadPriority.Normal;
- myThread_FG.Start();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- }
- // 取当前转炉正在冶炼熔炼号 C##01_DEVICE
- /// <summary>
- /// 取当前转炉正在冶炼熔炼号 CVT01_DEVICE
- /// </summary>
- private void getZLCurrentLH()
- {
- try
- {
- System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
- while (true)
- {
- if (!this.On_Off_Thread)
- {
- System.Threading.Thread.Sleep(500);
- continue;
- }
- this.ute_ZL1.Text = "";
- this.ute_ZL2.Text = "";
- this.ute_ZL3.Text = "";
- //初始化颜色
- ute_ZL1.Appearance.BackColor = Color.White;//.Gainsboro;
- ute_ZL2.Appearance.BackColor = Color.White;
- ute_ZL3.Appearance.BackColor = Color.White;
- string strError = "";
- ArrayList arry = new ArrayList();
- arry.Clear();
- arry.Add("getZLCurrentLH.query");
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strError);
- if (strError == "")
- {
- if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
- {
- //初始化颜色
- ute_ZL1.Appearance.BackColor = Color.White;
- ute_ZL2.Appearance.BackColor = Color.White;
- ute_ZL3.Appearance.BackColor = Color.White;
- for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
- {
- string v_ZLH = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, 2);
- string v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, ds.Tables[0].Rows[i]["objectid"].ToString().Length - 5));
- // if (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1) == "V") v_LH = "V" + v_LH;
- if (workshopNo == "1")
- {
- if (v_ZLH == "01")
- {
- this.ute_ZL1.Text = v_LH;
- HeatNo_HudwId_Exist(v_LH, "01");
- }
- if (v_ZLH == "02")
- {
- this.ute_ZL2.Text = v_LH;
- HeatNo_HudwId_Exist(v_LH, "02");
- }
- }
- else
- {
- if (v_ZLH == "03")
- {
- this.ute_ZL1.Text = v_LH;
- HeatNo_HudwId_Exist(v_LH, "03");
- }
- if (v_ZLH == "04")
- {
- this.ute_ZL2.Text = v_LH;
- HeatNo_HudwId_Exist(v_LH, "04");
-
- }
- if (v_ZLH == "05")
- {
- this.ute_ZL3.Text = v_LH;
- HeatNo_HudwId_Exist(v_LH, "05");
- }
- }
- }
- }
- }
- Thread.Sleep(10000);
- }
- }
- catch
- {
- }
- }
- // 判断是否已经发送废钢
- /// <summary>
- /// 判断是否已经发送废钢
- /// </summary>
- /// <熔炼号="strID"></param>
- /// <炉座号="strGw"></param>
- private void HeatNo_HudwId_Exist(string strID, string strGw)
- {
- string strErr = "";
- try
- {
- ArrayList arry = new ArrayList();
- arry.Add("HeatNo_HudwId_Exist.query");
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- arry.Add(strID);
- arry.Add(strID);
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
- if (strErr == "")
- {
- switch (strGw)
- {
- case "01":
- _strSendSucceededForBof1 = ds.Tables[0].Rows[0]["intCount"].ToString()=="0"?"N":"Y";
- if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White;
- if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
- break;
- case "02":
- _strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
- if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White;
- if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
- break;
- case "03":
- _strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
- if (_strSendSucceededForBof3 == "N") ute_ZL1.Appearance.BackColor = Color.White;
- if (_strSendSucceededForBof3 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
- break;
- case "04":
- _strSendSucceededForBof4 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
- if (_strSendSucceededForBof4 == "N") ute_ZL2.Appearance.BackColor = Color.White;
- if (_strSendSucceededForBof4 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
- break;
- case "05":
- _strSendSucceededForBof5 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
- if (_strSendSucceededForBof5 == "N") ute_ZL3.Appearance.BackColor = Color.White;
- if (_strSendSucceededForBof5 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue;
- break;
- default:
- break;
- }
- }
- }
- catch
- {
- }
- }
- // 点击修改或删除时显示确认和取消按钮
- /// <summary>
- /// 点击修改或删除时显示确认和取消按钮
- /// </summary>
- /// <param name="bEnable"></param>
- private void SetDetailToolBarEnable(bool bEnable,string flag)
- {
- int count = this.ultraToolbarsManager1.Tools.Count;
- for (int i = 0; i < count; i++)
- {
- this.ultraToolbarsManager1.Tools[i].SharedProps.Enabled = !bEnable;
- }
- if (bEnable == true && flag == "add")
- {
- this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = true;
- this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = true;
- }
- else
- {
- this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = false;
- this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = false;
- }
- this.ultraToolbarsManager1.Tools["ok"].SharedProps.Enabled = bEnable;
- this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Enabled = bEnable;
- this.ultraToolbarsManager1.Tools["ok"].SharedProps.Visible = bEnable;
- this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Visible = bEnable;
- }
- // 设置物料区域是否可编辑
- /// <summary>
- /// 设置物料区域是否可编辑
- /// </summary>
- /// <param name="t_Enable"></param>
- private void setMaterEnable()
- {
- try
- {
- setMaterEnableFun(materName1, materValue1);
- setMaterEnableFun(materName2, materValue2);
- setMaterEnableFun(materName3, materValue3);
- setMaterEnableFun(materName4, materValue4);
- setMaterEnableFun(materName5, materValue5);
- setMaterEnableFun(materName6, materValue6);
- }
- catch { }
- }
- private void setMaterEnableFun(UltraLabel editro1, UltraTextEditor editro2)
- {
- try
- {
- if (editro1.Text.Trim() == "")
- {
- editro1.Enabled = false;
- editro2.Enabled = false;
- }
- else
- {
- editro1.Enabled = true;
- editro2.Enabled = true;
- }
- }
- catch { }
- }
- // 设置编辑区域是否可编辑
- /// <summary>
- /// 设置编辑区域是否可编辑
- /// </summary>
- /// <param name="t_Enable"></param>
- private void setToolEnable(bool t_Enable)
- {
- try
- {
- ute_DH2.ReadOnly = t_Enable;
- materValue1.ReadOnly = t_Enable;
- materValue2.ReadOnly = t_Enable;
- materValue3.ReadOnly = t_Enable;
- materValue4.ReadOnly = t_Enable;
- materValue5.ReadOnly = t_Enable;
- materValue6.ReadOnly = t_Enable;
- ute_RLZL.ReadOnly = t_Enable;
- cbb_BC.ReadOnly = t_Enable;
- ute_DZ.ReadOnly = t_Enable;
- ute_RLSJ.ReadOnly = t_Enable;
- ute_BZ.ReadOnly = t_Enable;
- }
- catch { }
- }
- // 系统菜单栏
- /// <summary>
- /// 系统菜单栏
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="ToolbarKey"></param>
- public override void ToolBar_Click(object sender, string ToolbarKey)
- {
- base.ToolBar_Click(sender, ToolbarKey);
- switch (ToolbarKey)
- {
- case "Add"://新增
- try
- {
- ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- }
- catch
- {
- return;
- }
- AddNewData();
- GetRLMX_Data();
- break;
- case "Update"://修改
- if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(ultNo.Text.Trim()))
- {
- DialogResult result;
- string mk = "确实要修改吗?";
- result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
- MessageBoxIcon.Question);
- if (result == DialogResult.Yes)
- {
- if (ultraGrid1.ActiveRow != null)
- {
- try
- {
- DateTime aa = Convert.ToDateTime(ute_RLSJ.Text.ToString());
- string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
- // UpdateDataRow(strXH);
- GetRLMX_Data();
- }
- catch
- {
- MessageBox.Show("入炉时间 不是合法的日期时间!\n\n请重新选择入炉时间!", "提示");
- }
- }
- else
- {
- MessageBox.Show("请选择需要修改的记录!", "提示");
- }
- }
- }
- else
- MessageBox.Show("请选择需要修改的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- break;
- case "Delete"://删除
- if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(this.ultNo.Text.Trim()))
- {
- DialogResult result;
- string mk = "确实要删除吗?";
- result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
- MessageBoxIcon.Question);
- if (result == DialogResult.Yes)
- {
- string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
- DeleteDataRow();
- GetRLMX_Data();
- }
- }
- else
- {
- MessageBox.Show("请选择要删除的行!", "提示");
- }
- break;
- case "Query":// 查询
- if (ultraTabControl1.SelectedTab.Key == "Plan")
- {
- GetZL_SCJH();
- }
- else
- {
- GetRLMX_Data();
- }
- break;
- case "Config":
- try
- {
- frmSteelConfiger config = new frmSteelConfiger(ob);
- config.Tag = this;
- config.WorkShopNo = workshopNo;
- config.ShowDialog();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- break;
- case "Export"://导出Excel
- try
- {
- Core.Mes.Client.Comm.Globals.ulGridToExcel(ultraGrid1, Text);
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- break;
- case "Cancel"://取消发送
- try
- {
- CancelSend();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- break;
- case "Exit":
- this.Close();
- break;
- default:
- break;
- }
- }
- private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
- {
- try
- {
- if (this.ultraGrid1.Rows.Count == 0 || this.ultraGrid1.ActiveRow == null)
- {
- return;
- }
- UltraGridRow row = null;
- if (ultraGrid1.ActiveRow.HasParent())
- {
- row = ultraGrid1.ActiveRow.ParentRow;
- }
- else
- {
- row = ultraGrid1.ActiveRow;
- }
- SetDetailToolBarEnable(false,"");
- setToolEnable(true);
- ClearData();
-
- ultNo.Text = row.Cells["JOBID"].Value.ToString();
- ute_LH.Text = row.Cells["HEATNO"].Value.ToString();
- utlcbdevNo.Text = row.Cells["STATIONCODE"].Value.ToString();
- ute_DH2.Text = row.Cells["CHARGENO"].Value.ToString();
- ute_RLSJ.Text = row.Cells["JOBDATE"].Value.ToString();
- ute_RLZL.Text = row.Cells["JOINSTOVEWGT"].Value.ToString();
- ute_DZ.Text = row.Cells["CHUTEWGT"].Value.ToString();
- ute_ZZ.Text = row.Cells["TOTALWGT"].Value.ToString();
- ute_BZ.Text = row.Cells["MEMO"].Value.ToString();
- cbb_BC.Text = row.Cells["SHIFTCODE"].Value.ToString();
- if (row.HasChild())
- {
- string matercode = "";
- string matername = "";
- string matervalue = "";
- int m=0;
- for (int i = 0; i < row.ChildBands["Band 1"].Rows.Count; i++)
- {
- matercode = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELCODE"].Value.ToString();
- matername = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELNAME"].Value.ToString();
- matervalue = row.ChildBands["Band 1"].Rows[i].Cells["JMWGT"].Value.ToString();
- try
- {
- ((UltraLabel)EditorNameList[i]).Tag = matercode;
- ((UltraLabel)EditorNameList[i]).Text = matername;
- ((UltraTextEditor)EditorValueList[i]).Text = matervalue;
- m++;
- }
- catch { }
- }
- for (int j = m; j < EditorNameList.Count; j++)
- {
- ((UltraLabel)EditorNameList[j]).Text="";
- }
- setMaterEnable();
- }
- }
- catch { }
-
- }
- private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
- {
- try
- {
- frmSetTime frm = new frmSetTime(e.Context);
- //frm.Location = ClsControlPack.GetChildWindowLocation(frm.Size);
- frm.Location = new Point(556,376);//ClsControlPack.GetChildWindowLocation(frm.Size);
- frm.AutoSize = true;
- if (frm.ShowDialog() == DialogResult.OK)
- {
- ute_RLSJ.Text = (Convert.ToDateTime(frm.SelectDate.ToString())).ToString("yyyy-MM-dd HH:mm:ss");
- ute_RLSJ.Update();
- }
- }
- catch{}
- }
- // 发送废钢到1#或3#转炉
- /// <summary>
- /// 发送废钢到1#或3#转炉
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void button1_Click(object sender, EventArgs e)
- {
- try
- {
- string v_LH = this.ute_ZL1.Text.Trim().ToString();
- if (v_LH.Length == 0)
- {
- if (workshopNo == "1")
- {
- MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- else
- {
- MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- return;
- }
- if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
- {
- MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
- {
- MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ute_ZL1.Appearance.BackColor == Color.LightBlue)
- {
- DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
- if (dr == DialogResult.No) return;
- }
- this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
- string v_XH = this.ultNo.Text.Trim();
- string v_RLZL = ute_RLZL.Text.Trim();
- string v_ZLH = "";
- if (workshopNo == "1")
- {
- v_ZLH = "01";
- }
- else
- {
- v_ZLH = "03";
- }
- if (v_RLZL == "0" || v_RLZL == "")
- {
- MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (v_XH == "")
- {
- MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- string strErr = "";
- string strSqlID = "frmScrapMater.Send";
- object[] sArgs = new object[3];
- sArgs[0] = v_LH; //炉号
- sArgs[1] = v_ZLH; //炉座号
- sArgs[2] = v_XH; //序号
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- else
- {
- GetRLMX_Data();
- if (workshopNo == "1")
- {
- _strSendSucceededForBof1 = "Y";
- HeatNo_HudwId_Exist(v_LH, "01");
- }
- else
- {
- _strSendSucceededForBof3 = "Y";
- HeatNo_HudwId_Exist(v_LH, "03");
- }
- MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- catch { }
- }
- // 发送废钢到2#或4#转炉
- /// <summary>
- /// 发送废钢到2#或4#转炉
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void button2_Click(object sender, EventArgs e)
- {
- try
- {
- string v_LH = this.ute_ZL2.Text.Trim().ToString();
- if (v_LH.Length == 0)
- {
- if (workshopNo == "1")
- {
- MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- else
- {
- MessageBox.Show("4#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- return;
- }
- if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
- {
- MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
- {
- MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ute_ZL2.Appearance.BackColor == Color.LightBlue)
- {
- DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
- if (dr == DialogResult.No) return;
- }
- string v_XH = this.ultNo.Text.Trim();
- string v_RLZL = ute_RLZL.Text.Trim();
- string v_ZLH = "";
- if (workshopNo == "1")
- {
- v_ZLH = "02";
- }
- else
- {
- v_ZLH = "04";
- }
- if (v_RLZL == "0" || v_RLZL == "")
- {
- MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (v_XH == "")
- {
- MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- string strErr = "";
- string strSqlID = "frmScrapMater.Send";
- object[] sArgs = new object[3];
- sArgs[0] = v_LH; //炉号
- sArgs[1] = v_ZLH; //炉座号
- sArgs[2] = v_XH; //序号
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- else
- {
- GetRLMX_Data();
- if (workshopNo == "1")
- {
- _strSendSucceededForBof2 = "Y";
- HeatNo_HudwId_Exist(v_LH, "02");
- }
- else
- {
- _strSendSucceededForBof4 = "Y";
- HeatNo_HudwId_Exist(v_LH, "04");
- }
- MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- catch { }
- }
- // 发送废钢到5#转炉
- /// <summary>
- /// 发送废钢到5#转炉
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void button3_Click(object sender, EventArgs e)
- {
- try
- {
- string v_LH = this.ute_ZL3.Text.Trim().ToString();
- if (v_LH.Length == 0)
- {
- MessageBox.Show("5#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
- {
- MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
- {
- MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ute_ZL3.Appearance.BackColor == Color.LightBlue)
- {
- DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
- if (dr == DialogResult.No) return;
- }
- string v_XH = this.ultNo.Text.Trim();
- string v_RLZL = ute_RLZL.Text.Trim();
- string v_ZLH = "05";
- if (v_RLZL == "0" || v_RLZL == "")
- {
- MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (v_XH == "")
- {
- MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- string strErr = "";
- string strSqlID = "frmScrapMater.Send";
- object[] sArgs = new object[3];
- sArgs[0] = v_LH; //炉号
- sArgs[1] = v_ZLH; //炉座号
- sArgs[2] = v_XH; //序号
- CommonClientToServer ccTs = new CommonClientToServer();
- ccTs.ob = ob;
- string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
- "ExecProcWithCollParam", strSqlID, sArgs, out strErr);
- if (strErr != "")
- {
- MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- else
- {
- GetRLMX_Data();
- _strSendSucceededForBof5 = "Y";
- HeatNo_HudwId_Exist(v_LH, "05");
- MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- }
- }
- catch { }
- }
- // 选择生产计划隐藏相应功能
- /// <summary>
- /// 选择生产计划隐藏相应功能
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
- {
- if (e.Tab.Index == 1)
- GetZL_SCJH();
- if (ultraTabControl1.SelectedTab.Key == "Plan")
- {
- ultraToolbarsManager1.Enabled = false;
- this.ToolBarItemEnable(this, "Cancel", false);
- this.ToolBarItemEnable(this, "Export", false);
- label28.Text = "计划开始时间";
- label2.Text = "计划结束时间";
- groupBox6.Size=new System.Drawing.Size(228, 40);
- label1.Text = "生产状态";
- label1.BackColor = Color.LightGreen;
- label18.Text = "计划状态";
- label18.BackColor = Color.White;
- label3.Text = "结束状态";
- label3.Visible = true;
- checkBox1.Enabled = false;
- chkSend.Enabled = false;
- udte_EndTime.Location = new Point(317, 11);
- if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
- {
- //MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- udte_EndTime.Focus();
- return;
- }
- GetZL_SCJH();
- }
- else
- {
- ultraToolbarsManager1.Enabled = true;
- this.ToolBarItemEnable(this, "Cancel", true);
- this.ToolBarItemEnable(this, "Export", true);
- label28.Text = "入炉时间 从";
- label2.Text = "到";
- groupBox6.Size = new System.Drawing.Size(163, 40);
- label18.Text = "已发送";
- label18.BackColor = Color.LightGreen;
- label1.Text = "未发送";
- label1.BackColor = Color.LightCyan;
- label3.Visible = false;
- chkSend.Enabled = true;
- checkBox1.Enabled = true;
- udte_EndTime.Location = new Point(265, 11);
- if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
- {
- // MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- udte_EndTime.Focus();
- return;
- }
- GetRLMX_Data();
- }
- }
- private void ultraGrid3_Click(object sender, EventArgs e)
- {
- }
- private void ultraGrid2_Click(object sender, EventArgs e)
- {
- DialogResult dgr = new DialogResult();
- if (ultraGrid2.ActiveRow != null)
- {
- ute_LH.Text = ultraGrid2.ActiveRow.Cells["StoveID"].Value.ToString();
- utlcbdevNo.SelectedIndex = 0;
- string ShiftCode = "", str = "";
- if (dgr != DialogResult.Cancel)
- {
- //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
- ArrayList arry = new ArrayList();
- arry.Add("GetClassCode.query");
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- //arry.Add("");
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
- if (ds.Tables[0].Rows.Count > 0)
- {
- ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
- }
- if (!string.IsNullOrEmpty(ShiftCode))
- {
- cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
- }
- }
- }
- }
- private void ultraGrid4_Click(object sender, EventArgs e)
- {
- DialogResult dgr = new DialogResult();
- if (ultraGrid4.ActiveRow != null)
- {
- ute_LH.Text = ultraGrid4.ActiveRow.Cells["StoveID"].Value.ToString();
- utlcbdevNo.SelectedIndex = 2;
- string ShiftCode = "", str = "";
- if (dgr != DialogResult.Cancel)
- {
- //ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
- ArrayList arry = new ArrayList();
- arry.Add("GetClassCode.query");
- CommonClientToServer ccs = new CommonClientToServer();
- ccs.ob = this.ob;
- //arry.Add("");
- DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
- if (ds.Tables[0].Rows.Count > 0)
- {
- ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
- }
- if (!string.IsNullOrEmpty(ShiftCode))
- {
- cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
- }
- }
- }
- }
- private void ute_RLSJ_KeyPress(object sender, KeyPressEventArgs e)
- {
- if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b'))
- {
- e.Handled = true;
- }
- }
- private void ute_ZZ_ValueChanged(object sender, EventArgs e)
- {
- Double dRlzl = 0, dDz = 0, dFg = 0; //入炉重量,斗重, 废钢重量
- try
- {
- //废钢重量
- if (!string.IsNullOrEmpty(materValue1.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue1.Text.Trim());
- }
- if (!string.IsNullOrEmpty(materValue2.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue2.Text.Trim());
- }
- if (!string.IsNullOrEmpty(materValue3.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue3.Text.Trim());
- }
- if (!string.IsNullOrEmpty(materValue4.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue4.Text.Trim());
- }
- if (!string.IsNullOrEmpty(materValue5.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue5.Text.Trim());
- }
- if (!string.IsNullOrEmpty(materValue6.Text.Trim()))
- {
- dFg += Convert.ToDouble(materValue6.Text.Trim());
- }
- if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
- {
- dDz += Convert.ToDouble(ute_DZ.Text.Trim());
- }
- dRlzl = dFg;//入炉重量
- if (dRlzl == 0)
- {
- if (!string.IsNullOrEmpty(ute_RLZL.Text.Trim()))
- {
- dRlzl = Convert.ToDouble(ute_RLZL.Text.Trim());
- }
- }
- ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量
- ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
- }
- catch
- {
- }
- }
- private void ute_RLZL_ValueChanged(object sender, EventArgs e)
- {
- try
- {
- string strRlzl = ute_RLZL.Text.Trim();
- if (ute_RLZL.Focused)
- {
- for (int i = 0; i < EditorValueList.Count; i++)
- {
- ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
- }
- Double dRlzl = 0, dDz = 0;
- if (!string.IsNullOrEmpty(strRlzl))
- {
- dDz += Convert.ToDouble(strRlzl);
- }
- if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
- {
- dDz += Convert.ToDouble(ute_DZ.Text.Trim());
- }
- ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
- }
- }
- catch { }
- }
- private void NumberInput_KeyPress(object sender, KeyPressEventArgs e)
- {
- if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
- {
- e.Handled = true;
- }
- char[] arrary = ((UltraTextEditor)sender).Text.ToCharArray();
- if (e.KeyChar == '.')
- {
- if (arrary.Length == 0)
- {
- ((UltraTextEditor)sender).Text = "0.";
- ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
- e.Handled = true;
- }
- else
- {
- for (int i = 0; i < arrary.Length; i++)
- {
- if (arrary[i] == '.')
- e.Handled = true;
- }
- }
- }
- if (arrary.Length == 1)
- {
- if (e.KeyChar == '0')
- {
- if (arrary[0] == '0')
- e.Handled = true;
-
- }
- if (arrary[0] == '0' && e.KeyChar != '.' && e.KeyChar != '\b' && e.KeyChar != '0'&&!(Char.IsNumber(e.KeyChar)))
- {
- ((UltraTextEditor)sender).Text = e.KeyChar.ToString();
- ((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
- e.Handled = true;
- }
- }
- }
- private void HeatNoInput_KeyPress(object sender, KeyPressEventArgs e)
- {
- if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b'))
- {
- e.Handled = true;
- }
- }
- private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
- {
- string Job_ID = ultNo.Text.Trim();
- switch (e.Tool.Key)
- {
- case "add":
- // ClearData1();
- SetDetailToolBarEnable(true,"add");
- setToolEnable(false);
- this.uTbMTool.Tools["ok"].Tag = "add";
- ultNo.Clear();
- ute_LH.Clear();
- utlcbdevNo.SelectedIndex = -1;
- ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
- for (int i = 0; i < EditorValueList.Count; i++)
- {
- ((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
- }
- ute_RLZL.Text = "0";
- ute_DZ.Text = "0";
- ute_ZZ.Text = "0";
-
- break;
-
- case "edit":
- if (ultraGrid1.Rows.Count==0)
- {
- MessageBox.Show("无有效信息可以修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
- {
- MessageBox.Show("选取的废钢信息已发送不能修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
- return;
- }
- SetDetailToolBarEnable(true,"edit");
- setToolEnable(false);
- this.uTbMTool.Tools["ok"].Tag = "edit";
- break;
- case "del":
- if (Job_ID.Length == 0)
- {
- MessageBox.Show("无有效的数据可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- return;
- }
- DeleteDataRow();
-
- break;
- case "ok":
- string flag = this.uTbMTool.Tools["ok"].Tag.ToString();
- if (flag == "edit")
- {
- if (Job_ID.Length == 0)
- {
- MessageBox.Show("无有效的数据可操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- return;
- }
- }
- if (flag == "add")
- {
- AddNewData();
- }
- if (flag == "edit")
- {
- UpdateDataRow(Job_ID);
- }
- if (!ok_flag) return;
- SetDetailToolBarEnable(false,"");
- setToolEnable(true);
- GetRLMX_Data();
- break;
- case "cancel":
- SetDetailToolBarEnable(false,"");
- setToolEnable(true);
- ultraGrid1_AfterRowActivate(null,null);
- break;
- case "left":
- if (ultraGrid1.Rows.Count == 0) return;
- //将位置移动到前一条记录
- try
- {
- if (ultraGrid1.ActiveRow == null)
- {
- ultraGrid1.Rows[0].Activate();
- }
- else
- {
- int nIndex = ultraGrid1.ActiveRow.Index;
- nIndex = nIndex - 1;
- if (nIndex < 0) nIndex = ultraGrid1.Rows.Count-1;
- ultraGrid1.Rows[nIndex].Activate();
- }
- }
- catch { }
- break;
- case "right":
- if (ultraGrid1.Rows.Count == 0) return;
- //将位置移动到后一条记录
- try
- {
- if (ultraGrid1.ActiveRow == null)
- {
- ultraGrid1.Rows[0].Activate();
- }
- else
- {
- int nIndex = ultraGrid1.ActiveRow.Index;
- nIndex = nIndex + 1;
- if (nIndex >= ultraGrid1.Rows.Count) nIndex = 0;
- ultraGrid1.Rows[nIndex].Activate();
- }
- }
- catch { }
- break;
- case "Custom": //初始化物料
- try
- {
- GetConfigMater();
- materValue1.Text = "";
- materValue2.Text = "";
- materValue3.Text = "";
- materValue4.Text = "";
- materValue5.Text = "";
- materValue6.Text = "";
- }
- catch { }
- break;
- }
- }
- private void chkSend_CheckedChanged(object sender, EventArgs e)
- {
- GetRLMX_Data();
- }
- }
- }
|