using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.PlnSaleOrd.BaseMethod; using Core.StlMes.Client.PlnSaleOrd.工序排产; using Core.StlMes.Client.PlnSaleOrd.工序排产.entity; using CoreFS.CA06; using Infragistics.Win; using Infragistics.Win.UltraWinGrid; 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; namespace Core.StlMes.Client.PlnSaleOrd { public partial class FrmBaseMandrelSpec : FrmBase { private string id = ""; public FrmBaseMandrelSpec() { InitializeComponent(); } private void FrmBaseMandrelSpec_Load(object sender, EventArgs e) { BaseHelper.NitializeDropDownBox(txtDimater, "com.steering.pss.plnsaleord.processOrder.FrmBaseMandrelSpec.initDimater",new Object[]{}, "DIAMETER_MANDREL", "MANDREL_ID", false, ob); PlanHelper.InitDropPline("D", "", txtPline1, this.ob); PlanHelper.InitDropPline("D", "", txtPline2, this.ob); BaseHelper.setOtherColumnReadOnly(entityGridMandrel, null); BaseHelper.InitCellPosition(entityGridMandrel, new string[] { "MinD", "MaxD", "MinH", "MaxH", "DiameterMandrel", "PassName" }); } public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query"://查询 Query(); break; case "Add"://新增 Add(); break; case "Update"://修改 q Update(); break; case "Delete"://删除 Delete(); break; case "Close"://关闭 this.Close(); break; case "Export": //导出 GridHelper.ulGridToExcel(entityGridMandrel, "芯棒产线适用规格信息"); break; default: break; } } private void Query() { string plineCode = ""; if (chcPline.Checked && txtPline1.Value != null) { plineCode = txtPline1.Value.ToString(); } List listSource = EntityHelper.GetData ("com.steering.pss.plnsaleord.processOrder.FrmBaseMandrelSpec.query", new object[] { plineCode }, ob); comBaseMandrelSpecEntityBindingSource.DataSource = listSource; if (!id.Equals("") && entityGridMandrel.Rows.Count > 0) { foreach (UltraGridRow ugr in entityGridMandrel.Rows) { if (ugr.Cells["RelationId"].Text.Equals(id)) { ugr.Activate(); break; } } } id = ""; } private bool CheckParams() { if (txtPline2.Value == null) { MessageUtil.ShowWarning("请选择产线!",txtPline2); return false; } if (txtPassModel.Value == null) { MessageUtil.ShowWarning("请选择孔型!", txtPassModel); return false; } if (txtDimater.Value == null) { MessageUtil.ShowWarning("请选择芯棒直径!", txtDimater); return false; } if (txtMinD == null || txtMinD.Value.ToString().Length == 0) { MessageUtil.ShowWarning("请输入外径最小值!", txtMinD); return false; } if (txtMaxD == null || txtMaxD.Value.ToString().Length == 0) { MessageUtil.ShowWarning("请输入外径最大值!", txtMaxD); return false; } if (txtMinH == null || txtMinH.Value.ToString().Length == 0) { MessageUtil.ShowWarning("请输入壁厚最小值!", txtMinH); return false; } if (txtMaxH == null || txtMaxH.Value.ToString().Length == 0) { MessageUtil.ShowWarning("请输入壁厚最大值!", txtMaxH); return false; } double minD = Convert.ToDouble(txtMinD.Value.ToString()); double maxD = Convert.ToDouble(txtMaxD.Value.ToString()); if (minD > maxD) { MessageUtil.ShowWarning("外径最小值不能大于外径最大值!", txtMinD); return false; } double minH = Convert.ToDouble(txtMinH.Value.ToString()); double maxH = Convert.ToDouble(txtMaxH.Value.ToString()); if (minH > maxH) { MessageUtil.ShowWarning("壁厚最小值不能大于壁厚最大值!", txtMinH); return false; } return true; } private void Add() { if (!CheckParams()) { return; } ComBaseMandrelSpecEntity entity = new ComBaseMandrelSpecEntity(); string plineCode = txtPline2.Value.ToString(); string plineName = txtPline2.Text.Trim(); string passCode = txtPassModel.Value.ToString(); string passName = txtPassModel.Text.Trim(); string dimaterId = txtDimater.Value.ToString(); string dimater = txtDimater.Text; string memo = txtMemo.Text.Trim(); string minD = txtMinD.Value.ToString(); string maxD = txtMaxD.Value.ToString(); string minH = txtMinH.Value.ToString(); string maxH = txtMaxH.Value.ToString(); entity.CreateName = UserInfo.GetUserName(); entity.DiameterMandrel =(decimal?)Convert.ToDouble( dimater); entity.MandrelId = dimaterId; entity.MaxD = (decimal?)Convert.ToDouble(maxD); entity.MinD = (decimal?)Convert.ToDouble(minD); entity.MaxH = (decimal?)Convert.ToDouble(maxH); entity.MinH = (decimal?)Convert.ToDouble(minH); entity.PlineCode = plineCode; entity.PlineName = plineName; entity.PassCode = passCode; entity.PassName = passName; entity.Memo = memo; if (MessageUtil.ShowYesNoAndQuestion("是否新增?") == DialogResult.No) { return; } string jsonStr = JSONFormat.Format(entity); int count = ServerHelper.SetData("com.steering.pss.plnsaleord.processOrder.FrmBaseMandrelSpec.add", new object[] { jsonStr }, ob); if (count == 0) { MessageUtil.ShowTips("服务端处理失败!"); return; } else { MessageUtil.ShowWarning("新增成功!", entityGridMandrel); Query(); } } private void Update() { UltraGridRow ugr = entityGridMandrel.ActiveRow; if (ugr == null) { MessageUtil.ShowWarning("请选择要修改的记录!", entityGridMandrel); return; } if (!CheckParams()) { return; } ComBaseMandrelSpecEntity entity = (ComBaseMandrelSpecEntity)ugr.ListObject; string plineCode = txtPline2.Value.ToString(); string plineName = txtPline2.Text.Trim(); string passCode = txtPassModel.Value.ToString(); string passName = txtPassModel.Text.Trim(); string dimaterId = txtDimater.Value.ToString(); string dimater = txtDimater.Text; string memo = txtMemo.Text.Trim(); string minD = txtMinD.Value.ToString(); string maxD = txtMaxD.Value.ToString(); string minH = txtMinH.Value.ToString(); string maxH = txtMaxH.Value.ToString(); entity.UpdateName = UserInfo.GetUserName(); entity.DiameterMandrel = (decimal?)Convert.ToDouble(dimater); entity.MandrelId = dimaterId; entity.MaxD = (decimal?)Convert.ToDouble(maxD); entity.MinD = (decimal?)Convert.ToDouble(minD); entity.MaxH = (decimal?)Convert.ToDouble(maxH); entity.MinH = (decimal?)Convert.ToDouble(minH); entity.PlineCode = plineCode; entity.PlineName = plineName; entity.PassCode = passCode; entity.PassName = passName; entity.Memo = memo; if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No) { return; } id = entity.MandrelId; string jsonStr = JSONFormat.Format(entity); int count = ServerHelper.SetData("com.steering.pss.plnsaleord.processOrder.FrmBaseMandrelSpec.update", new object[] { jsonStr }, ob); if (count == 0) { MessageUtil.ShowTips("服务端处理失败!"); return; } else { MessageUtil.ShowWarning("修改成功!", entityGridMandrel); Query(); } } private void Delete() { UltraGridRow ugr = entityGridMandrel.ActiveRow; if (ugr == null) { MessageUtil.ShowWarning("请选择要删除的记录!", entityGridMandrel); return; } if (!CheckParams()) { return; } ComBaseMandrelSpecEntity entity = (ComBaseMandrelSpecEntity)ugr.ListObject; string jsonStr = JSONFormat.Format(entity); if (MessageUtil.ShowYesNoAndQuestion("是否删除?") == DialogResult.No) { return; } int count = ServerHelper.SetData("com.steering.pss.plnsaleord.processOrder.FrmBaseMandrelSpec.delete", new object[] { jsonStr }, ob); if (count == 0) { MessageUtil.ShowTips("服务端处理失败!"); return; } else { MessageUtil.ShowWarning("删除成功!", entityGridMandrel); Query(); } } private void txtPline2_ValueChanged(object sender, EventArgs e) { if (txtPline2.Value == null) { txtPassModel.Clear(); return; } BaseHelper.NitializeDropDownBox(txtPassModel, "com.steering.pss.plnsaleord.processOrder.FrmPlnPassmodel.initPassModel", new Object[] { txtPline2.Value.ToString() }, "PASS_NAME", "PASS_CODE", false, ob); } private void chcPline_CheckedChanged(object sender, EventArgs e) { if (chcPline.Checked) { txtPline1.ReadOnly = false; } else { txtPline1.ReadOnly = true; } } private void entityGridMandrel_AfterRowActivate(object sender, EventArgs e) { UltraGridRow ugr = entityGridMandrel.ActiveRow; if (ugr == null) { return; } ComBaseMandrelSpecEntity entity = (ComBaseMandrelSpecEntity)ugr.ListObject; txtPline2.Value = entity.PlineCode; txtPassModel.Value = entity.PassCode; txtDimater.Value = entity.MandrelId; txtMemo.Value = entity.Memo; txtMinD.Value = entity.MinD; txtMinH.Value = entity.MinH; txtMaxD.Value = entity.MaxD; txtMaxH.Value = entity.MaxH; } } }