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 CoreFS.CA06; using Core.StlMes.Client.SaleOrder; using System.Collections; using Core.Mes.Client.Comm.Control; using Core.StlMes.Client.SaleComm; using Infragistics.Win.UltraWinGrid; using Core.Mes.Client.Comm.Tool; using Core.Mes.Client.Comm.Server; using Core.StlMes.Client.SaleOrder.ReviewForm; using Core.StlMes.Client.SaleOrder.Dialog; using Infragistics.Win; using Core.Mes.Client.Comm; namespace Core.StlMes.Client.SaleOrder { public partial class frmOrderSaleAreaUpdate : FrmBase { public frmOrderSaleAreaUpdate() { InitializeComponent(); this.IsLoadUserView = true; } private void frmOrderEffect_Load(object sender, EventArgs e) { DateTime Today = DateTime.Now; this.date_starte.DateTime = Today.Date.AddMonths(-1); this.date_end.DateTime = DateTime.Today; this.utDate1.DateTime = Today.Date.AddMonths(-1); this.utDate2.DateTime = DateTime.Today; getAreaInfo("100101"); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "doQuery": this.Query(); break; case "queryInfo": queryInfo(); break; case "doUpdate": this.doUpdate(); break; case "doClose": this.Close(); break; } } public void Query() { string orderNo = ""; //合同号 string orderStart = ""; string orderEnd = ""; if (ord_no.Checked) { orderNo = orde_cho.Text.Trim(); } if (che_date.Checked) { orderStart = date_starte.DateTime.ToString("yyyy-MM-dd") + " 00:00:01"; orderEnd = date_end.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"; } else { orderStart = "1000-01-01 00:00:01"; orderEnd = "9999-12-31 23:59:59"; } String saleOrg = ""; if (radioXs.Checked) saleOrg = "100101"; if (radioGm.Checked) saleOrg = "100102"; DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.doQueryForUpdate", new Object[] { orderNo, orderStart, orderEnd, saleOrg }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderHeadDt, true); //列自适应 GridHelper.RefreshAndAutoSizeExceptColumns(gridOrder, new UltraGridColumn[] { }); GridHelper.SetColumnsActivateAndColor(gridOrder.Rows.Band, "SALE_AREA_NO", "CREATE_NAME","Choose"); } public void queryInfo() { string orderNo = ""; //合同号 string orderStart = ""; string orderEnd = ""; if (ckOrderNo.Checked) { orderNo = utOrderNo.Text.Trim(); } if (ckDate.Checked) { orderStart = utDate1.DateTime.ToString("yyyy-MM-dd") + " 00:00:01"; orderEnd = utDate2.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"; } else { orderStart = "1000-01-01 00:00:01"; orderEnd = "9999-12-31 23:59:59"; } DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.doQueryAreaInfo", new Object[] { orderNo, orderStart, orderEnd }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.areaInfo, true); //列自适应 GridHelper.RefreshAndAutoSizeExceptColumns(ulareaInfo, new UltraGridColumn[] { }); GridHelper.SetAllColumnsActive(ulareaInfo); } /// /// 修改 /// private void doUpdate() { gridOrder.UpdateData(); if (gridOrder.ActiveRow == null) return; List listRow = ComHelper.UltraGridGetOtherRows(gridOrder, "Choose"); if (listRow.Count <= 0) { MessageUtil.ShowTips("请选择需要保存的记录"); return; } if (MessageUtil.ShowQuestion("是否确认调整销售片区?").ToString().ToLower().Equals("no")) { return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow row in listRow) { if (row.Cells["SALE_AREA_NO"].Value.ToString() == row.Cells["SALE_AREA_NO"].Text) { MessageUtil.ShowTips("请选择正确的销售片区"); return; } if (row.Cells["CREATE_NAME"].Value.ToString() == row.Cells["CREATE_NAME"].Text) { MessageUtil.ShowTips("请选择正确的创建人"); return; } ArrayList list = new ArrayList(); list.Add(row.Cells["ORD_PK"].Value.ToString()); list.Add(row.Cells["SALE_AREA_NO"].Value.ToString()); list.Add(row.Cells["SALE_AREA_NO"].Text); list.Add(row.Cells["CREATE_NAME"].Text); list.Add(row.Cells["CREATE_NAME"].Value.ToString()); parm.Add(list); } CoreClientParam ccp = new CoreClientParam(); ccp.IfShowErrMsg = false; ccp.ServerName = "com.steering.pss.sale.order.CoreOrderManager"; ccp.MethodName = "updateOrderAreaDesc"; ccp.ServerParams = new object[] { parm, UserInfo.GetUserName() }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp == null) return; else { if (ccp.ReturnCode == -1) { MessageUtil.ShowWarning(ccp.ReturnObject.ToString()); return; } } MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Query(); } private void che_date_CheckedChanged(object sender, EventArgs e) { date_starte.Enabled = che_date.Checked; date_end.Enabled = che_date.Checked; } private void ord_no_CheckedChanged(object sender, EventArgs e) { orde_cho.Enabled = ord_no.Checked; } private void orde_cho_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) Query(); } private void getAreaInfo(String saleOrg) { //销售片区 DataTable areaDt = ServerHelper.GetData("com.steering.pss.sale.order.CopyCtrlOrderHead.doQuerySalesAreaNoDept", new Object[] { saleOrg }, ob); ValueList list = new ValueList(); Infragistics.Win.ValueListItem[] items = new Infragistics.Win.ValueListItem[areaDt.Rows.Count]; for (int i = 0; i < areaDt.Rows.Count; i++) { items[i] = new Infragistics.Win.ValueListItem(areaDt.Rows[i]["SALE_AREA_NO"].ToString(), areaDt.Rows[i]["SALE_AREA_DESC"].ToString()); } list.ValueListItems.AddRange(items); gridOrder.DisplayLayout.Bands[0].Columns["SALE_AREA_NO"].ValueList = list; } private void radioXs_CheckedChanged(object sender, EventArgs e) { if (radioXs.Checked) { radioGm.Checked = false; getAreaInfo("100101"); Query(); } } private void radioGm_CheckedChanged(object sender, EventArgs e) { if (radioGm.Checked) { radioXs.Checked = false; getAreaInfo("100102"); Query(); } } private void gridOrder_CellChange(object sender, CellEventArgs e) { gridOrder.UpdateData(); if (e.Cell.Column.Key.Equals("SALE_AREA_NO")) { DataTable userDt = ServerHelper.GetData("com.steering.pss.sale.order.CoreOrderManager.getUserByDept", new Object[] { e.Cell.Value.ToString() }, ob); ValueList list = new ValueList(); Infragistics.Win.ValueListItem[] items = new Infragistics.Win.ValueListItem[userDt.Rows.Count]; for (int i = 0; i < userDt.Rows.Count; i++) { items[i] = new Infragistics.Win.ValueListItem(userDt.Rows[i]["deptid"].ToString(), userDt.Rows[i]["USERNAME"].ToString()); } list.ValueListItems.AddRange(items); gridOrder.DisplayLayout.Bands[0].Columns["CREATE_NAME"].ValueList = list; } if (e.Cell.Column.Key.Equals("CREATE_NAME")) { UltraGridRow row = gridOrder.ActiveRow; String depId = row.Cells["CREATE_NAME"].Value.ToString(); row.Cells["DEPID"].Value = depId; } } private void ultraTabControl4_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e) { if (toolMenu == null) return; if (UtControl.SelectedTab == UtControl.Tabs[0]) { if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.False; } } else { if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.True; } } } private void frmOrderSaleAreaUpdate_Shown(object sender, EventArgs e) { if (toolMenu == null) return; if (UtControl.SelectedTab == UtControl.Tabs[0]) { if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.True; } if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.False; } } else { if (toolMenu.Toolbars[0].Tools.Exists("doQuery")) { toolMenu.Toolbars[0].Tools["doQuery"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("doUpdate")) { toolMenu.Toolbars[0].Tools["doUpdate"].InstanceProps.Visible = DefaultableBoolean.False; } if (toolMenu.Toolbars[0].Tools.Exists("queryInfo")) { toolMenu.Toolbars[0].Tools["queryInfo"].InstanceProps.Visible = DefaultableBoolean.True; } } } private void ckOrderNo_CheckedChanged(object sender, EventArgs e) { utOrderNo.Enabled = ckOrderNo.Checked; } private void ckDate_CheckedChanged(object sender, EventArgs e) { utDate1.Enabled = ckDate.Checked; utDate2.Enabled = ckDate.Checked; } } }