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;
}
}
}