using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using CoreFS.CA06; using Common; using Infragistics.Win.UltraWinGrid; namespace Core.LZMes.Client.UIF.UIF06 { public partial class UIF061040 : FrmBase { public UIF061040() { InitializeComponent(); } public override void ToolBar_Click(object sender, string ToolbarKey) { try { switch (ToolbarKey) { case "query": DoQuery(); break; case "send": Send(); break; case "unsend": UnSend(); break; case "Save": break; case "Exit": this.dataSet1.Dispose(); this.dataSet1 = null; this.Close(); break; } } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void init() { string commCodeCd = "F02004"; DataTable dt = new DataTable(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBQuery"; ccp.MethodName = "doSimpleQuery"; ArrayList paramArray = new ArrayList(); paramArray.Add("UIECOMM00_SELECT.COMM_CODE"); paramArray.Add(commCodeCd); ccp.ServerParams = new object[] { paramArray }; ccp.SourceDataTable = dt; this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); Core.LZMes.Client.UIE.UIE041.UIEBase.Init_ComboControl(this.ComboOrdProc, ref dt, "F02004"); } private void DoQuery() { try { dataSet1.Clear(); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIF.UIF06.UIF061020"; ccp.MethodName = "queryPLTCMReelPlanCoils"; ccp.SourceDataTable = dataSet1.Tables[0]; CoreClientParam obj = this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal); } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } /// /// 重卷计划下发 /// private void Send() { try { this.ultraGrid1.UpdateData(); System.Data.DataRow[] rows = this.dataSet1.Tables[0].Select("CHK='TRUE'"); if (rows.Length == 0) { MessageBox.Show("请选择你要下发的计划", Common.FixDBManager.MsgCaption); return; } string coilNos = ""; foreach(System.Data.DataRow row in rows) { //if (row["PACKAGE_LEVEL"].ToString().Trim().Equals("2") || // row["PACKAGE_LEVEL"].ToString().Trim().Equals("3") || // row["PACKAGE_LEVEL"].ToString().Trim().Equals("4")) { // MessageBox.Show(row["L_COIL_NO"].ToString().Trim()+"下发计划失败,请取消包装操作!", Common.FixDBManager.MsgCaption); // continue; //} coilNos += row["L_COIL_NO"].ToString().Trim() + ";"; } if (coilNos.Equals("")) { DoQuery(); return; } coilNos = coilNos.Substring(0, coilNos.Length - 1); //string ordPro = Convert.ToString(Common.FixDBManager.CheckNullStr(this.ComboOrdProc.Value)); string ComboOrdProc = Convert.ToString(Convert.ToString(Common.FixDBManager.CheckNullStr(Common.FixDBManager.splitArray(this.ComboOrdProc.Value, ',')))); string ex = ""; #region "校验下发可行性" Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", coilNos); paramHsmp.Add("i2",rows.Length); paramHsmp.Add("i3", ComboOrdProc); paramHsmp.Add("o4", ex); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new Object[] { "UIF061020.Send_pltcmReelPan", paramHsmp }; CoreClientParam obj = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); System.Collections.ArrayList err = obj.ReturnObject as System.Collections.ArrayList; if (err != null && err.Count > 0 && Common.FixDBManager.CheckNullStr(err[0]) != "1") { MessageBox.Show(err[0].ToString(), Common.FixDBManager.MsgCaption); return; } #endregion #region "执行下发" //paramHsmp = new Hashtable(); //paramHsmp.Add("i1", RollNO); //paramHsmp.Add("o2", ex); //ccp = new CoreClientParam(); //ccp.ServerName = "com.core.sip.xinyu.service.CalSendTelegramService"; //ccp.MethodName = "sendPlanByPlanNo"; //ccp.ServerParams = new Object[] { RollNO }; //obj = this.ExecuteQuery(ccp, CoreInvokeType.Internal); //if (Common.FixDBManager.CheckNullInt(obj.ReturnObject) <= 0) //{ // MessageBox.Show("下发失败", Common.FixDBManager.MsgCaption); //} //else //{ // DoQuery(); //} DoQuery(); #endregion } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } /// /// 对已下发(二级)的重卷计划进行撤销 /// private void UnSend() { try { this.ultraGrid1.UpdateData(); System.Data.DataRow[] rows = this.dataSet1.Tables[0].Select("CHK='TRUE'"); if (rows.Length == 0) { MessageBox.Show("请选择你要取消下发的计划", Common.FixDBManager.MsgCaption); return; } string coilNos = ""; foreach (System.Data.DataRow row in rows) { coilNos += row["L_COIL_NO"].ToString().Trim() + ";"; } coilNos = coilNos.Substring(0, coilNos.Length - 1); string ex = ""; #region "校验下发可行性" Hashtable paramHsmp = new Hashtable(); paramHsmp.Add("i1", coilNos); paramHsmp.Add("i2", rows.Length); paramHsmp.Add("i3", UserInfo.GetUserID()); paramHsmp.Add("o4", ex); CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "UIB.COM.ComDBProcedure"; ccp.MethodName = "doXmlProcedure"; ccp.ServerParams = new Object[] { "UIF061020.Usd_pltcmReelPlan", paramHsmp }; CoreClientParam obj = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); System.Collections.ArrayList err = obj.ReturnObject as System.Collections.ArrayList; if (err != null && err.Count > 0 && Common.FixDBManager.CheckNullStr(err[0]) != "1") { MessageBox.Show(err[0].ToString(), Common.FixDBManager.MsgCaption); return; } #endregion #region "执行下发" //paramHsmp = new Hashtable(); //paramHsmp.Add("i1", RollNO); //paramHsmp.Add("o2", ex); //ccp = new CoreClientParam(); //ccp.ServerName = "com.core.sip.xinyu.service.CalSendTelegramService"; //ccp.MethodName = "canclePlanByPlanNo"; //ccp.ServerParams = new Object[] { RollNO }; //obj = this.ExecuteQuery(ccp, CoreInvokeType.Internal); //if (Common.FixDBManager.CheckNullInt(obj.ReturnObject) <= 0) //{ // MessageBox.Show("下发失败", Common.FixDBManager.MsgCaption); //} //else //{ // DoQuery(); //} DoQuery(); #endregion } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } private void UIF061020_Load(object sender, EventArgs e) { init(); } private void ComboOrdProc_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { UltraGridColumn checkColumn = this.ComboOrdProc.DisplayLayout.Bands[0].Columns.Add("Selected"); checkColumn.DataType = typeof(bool); // Show the checkbox column at the beginning checkColumn.Header.VisiblePosition = 0; //-- this.ComboOrdProc.CheckedListSettings.EditorValueSource = Infragistics.Win.EditorWithComboValueSource.CheckedItems; // Hook this column up to the CheckedListSettings this.ComboOrdProc.CheckedListSettings.CheckStateMember = checkColumn.Key; // Ensure that the ValueMember is set to our other field this.ComboOrdProc.ValueMember = "LABEL"; } } }