/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Buy_ItemBuyForm";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ItemCode", "Qty" };//数据明细校验必须录入字段
//Common.BindPayMethod(drpPayMothodFlag, true);
//Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.工厂,(int)EnumVendorType.供应商 }, true);
new VendorProc(drpVendorID);
//Common.BindEnumUnit(restxtunit, true);
//Common.BindCLS(restxtunit, "Data_Item", "ItemUnitFab", true);
//Common.BindOP(drpSaleOPID, true);
//Common.BindOP(drpCGOPID, true);
//this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载", false, btnLoad_Click);
this.ToolBarItemAdd(29, ToolButtonName.btnLoad.ToString(), "加载产品", false, btnDevItemLoad_Click);
ParamSetRule psrule = new ParamSetRule();
saveNoLoadCheckDayNum = psrule.RShowIntByCode((int)ParamSetEnum.未加载数据比对天数);
this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载订单", false, btnLoadSO_Click);
//this.ToolBarItemAdd(28, ToolButtonName.btnLoad.ToString(), "加载订单算料", false, btnLoad_Click);
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5009)))//面料的坯布启用可替换坯布功能,影响到订单坯布算料、坯布采购、织造等
{
gridView1.Columns["ItemCode"].ColumnEdit = drpGridItemCode;
gridViewBaseRowChangedA1 += new gridViewBaseRowChangedA(gridViewRowChanged1);//绑定GridView1事件
gridViewBindEventA1(gridView1);
this.gridView1.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(this.gridView1_CellValueChanged);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Data_Item";
this.HTDataDts = gridView6;
this.HTDataDtsAttach = new DevExpress.XtraGrid.Views.Grid.GridView[] { gridView2, gridView3, gridView6 };
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5010)))//面料定义界面不要显示原料信息管理内容
{
xtraTabPage2.PageVisible = false;
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5012)))//
{
btnCalc.Visible = true;
}
SetTabIndex(0, groupControlMainten);
//txtItemCode.Properties.ReadOnly = true;
Common.BindCLS(txtWeightUnit, "Data_Item", "WeightUnit", true);
Common.BindCLS(txtMFUnit, "Data_Item", "MFUnit", true);
gridViewBaseRowChangedA3 += new gridViewBaseRowChangedA(gridViewRowChanged3);
gridViewBindEventA3(gridView6);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtFormNo.Text.Trim() != "")
{
tempStr = " AND FormNo LIKE " + SysString.ToDBString("%" + txtFormNo.Text.Trim() + "%");
}
if (txtSendCode.Text.Trim() != "")//查询d
{
tempStr = " AND SendCode LIKE " + SysString.ToDBString("%" + txtSendCode.Text.Trim() + "%");
}
if (SysConvert.ToString(drpQVendorID.EditValue) != "")
{
tempStr += " AND VendorID =" + SysString.ToDBString(drpQVendorID.EditValue.ToString());
}
if (ChkSendDate.Checked)
{
tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtQMakeDateE.DateTime);
}
if (SysConvert.ToString(drpSaleOPID.EditValue) != "")
{
tempStr += " AND SaleOPID =" + SysString.ToDBString(drpSaleOPID.EditValue.ToString());
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单
{
tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")";
}
if (txtItemCode.Text.Trim() != "")
{
tempStr += " AND ItemCode LIKE" + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtGoodsCode.Text.Trim() != "")
{
tempStr += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%");
}
if (txtColorNum.Text.Trim() != "")
{
tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtColorNum.Text.Trim() + "%");
}
if (txtColorName.Text.Trim() != "")
{
tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtColorName.Text.Trim() + "%");
}
if (SysConvert.ToInt32(drpFHTypeID.EditValue) != 0)
{
tempStr += " AND FHTypeID=" + SysString.ToDBString(SysConvert.ToInt32(drpFHTypeID.EditValue));
}
tempStr += " ORDER BY FormNo DESC";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Sale_SaleOrder";
this.HTDataList = gridView1;
Common.BindOrderType(drpOrderTypeID, true);
Common.BindOrderLevel(drpOrderLevelID, true);
txtOrderDateS.DateTime = DateTime.Now.AddMonths(-2).Date;
txtOrderDateE.DateTime = DateTime.Now.Date;
txtReqDateS.DateTime = DateTime.Now.AddMonths(-1).Date;
txtReqDateE.DateTime = DateTime.Now.Date;
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户 }, true);
new VendorProc(drpVendorID);
if (ProductParamSet.GetIntValueByID(5417) == (int)YesOrNo.Yes)//组织结构体系启用
{
chkOrderDate.Checked = false;
}
drpVendorID.EditValue = m_VendorID;
if (m_NoLoadCondition != string.Empty)//如果有未加载语句则显示查询类型
{
drpQueryType.Visible = true;
}
btnQuery_Click(null, null);
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Dev_ColorCard";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "ItemCode" };//数据明细校验必须录入字段
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户 }, true);
Common.BindVendor(drpShopID, new int[] { (int)EnumVendorType.工厂, (int)EnumVendorType.染厂, (int)EnumVendorType.其他加工厂 }, true);
if (ProductParamSet.GetIntValueByID(5020) == (int)YesOrNo.Yes)//组织结构体系启用
{
Common.BindOPID(drpSaleOPID, "Sale_SaleOrder", "SaleOPID", true);
}
else
{
Common.BindOPID(drpSaleOPID, true);
}
Common.BindOP(drpGYOPID, true);
Common.BindColorSampleType(drpSampleType, true);
new PopContainerUtil(chkFirstLightSource, Common.BindLightSource); //主灯光源
new PopContainerUtil(chkSencondLightSource, Common.BindLightSource); //副灯光源
this.ToolBarItemAdd(28, "btnkLoadItem", "加载产品", false, btnkLoadItem_Click);
}
/// <summary>
/// 加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCPLoad_Click(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
frmLoadFabric frm = new frmLoadFabric();
frm.SelectItemType = SysConvert.ToInt32(ProductParamSet.GetIntValueByID(5413)); //0：表示只支持加载产品 1：表示只支持选择加载产品或者坯布 2:表示坯布
frm.ShowDialog();
string str = string.Empty;
if (frm.GBID != null && frm.GBID.Length != 0)
{
for (int i = 0; i < frm.GBID.Length; i++)
{
if (str != string.Empty)
{
str += ",";
}
str += SysConvert.ToString(frm.GBID[i]);
}
setCPItemNews(str);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
//
if (txtFormNo.Text.Trim() != "")
{
tempStr += " AND FormNo LIKE " + SysString.ToDBString("%" + txtFormNo.Text.Trim() + "%");
}
if (txtSO.Text.Trim() != "")
{
tempStr += " AND SO LIKE " + SysString.ToDBString("%" + txtSO.Text.Trim() + "%");
}
if (SysConvert.ToString(drpSaleOPID.EditValue) != "")
{
tempStr += " AND SaleOPID = " + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue));
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单
{
tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")";
}
if (SysConvert.ToString(drpVendorID.EditValue) != "")
{
tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue));
}
HTDataConditionStr = tempStr;
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("ReceiveAmount", "0.0 ReceiveAmount"));
SaleOrderStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT COUNT( ID) FROM UV1_Sale_SaleOrderDts WHERE 1=1";
sql += HTDataConditionStr + " GROUP BY ID";
DataTable dtSO = SysUtils.Fill(sql);
if (dtSO.Rows.Count > 0)
{
lbCount.Text = "销售合同数：" + dtSO.Rows[0][0].ToString();
}
else
{
lbCount.Text = "销售合同数：0";
}
if (ProductParamSet.GetIntValueByID(5418) == (int)YesOrNo.Yes)//更新回签标志
{
sql = "UPDATE Sale_SaleOrder SET HQFlag=1 WHERE FormNo IN (SELECT ISNULL(FileProt2,'') FROM Data_WinListAttachFile WHERE FileProt1=" + SysString.ToDBString(this.Text) + ")";
SysUtils.ExecuteNonQuery(sql);
}
}
/// <summary>
/// 新增初始化
/// </summary>
public override void IniInsertSet()
{
//txtWeightUnit.Text = "g/m";
drpUseable.EditValue = 1;
txtItemDate.DateTime = DateTime.Now.Date;
drpItemUnit.Text = ProductParamSet.GetStrValueByID(5001);//面料默认单位设置
txtColorLoss.Text = ProductParamSet.GetStrValueByID(5006); //默认染损
txtLastLoss.Text = ProductParamSet.GetStrValueByID(5007); //默认整理损
if (ProductParamSet.GetIntValueByID(5022) == 1)//面料编码生成规格
{
txtItemCode_DoubleClick(null, null);
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5011)))//面料定义界面不要显示原料信息管理内容
{
txtWeightUnit.Text = SysConvert.ToString(ProductParamSet.GetStrValueByID(5011));
}
//iniFiledSet();
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Buy_ItemBuyForm";
this.HTDataList = gridView1;
this.HTQryContainer = groupControlQuery;
txtOrderDateS.DateTime = DateTime.Now.AddMonths(-1).Date;
txtOrderDateE.DateTime = DateTime.Now.Date;
txtReqDateS.DateTime = DateTime.Now.AddMonths(-1).Date;
txtReqDateE.DateTime = DateTime.Now.Date;
if (ItemBuyStatusProc.ColorIniFlag)
{
//ItemBuyStatusProc.ColorIniTextBox(new TextBox[] { txtColorSOStatus1, txtColorSOStatus2, txtColorSOStatus3, txtColorSOStatus4, txtColorSOStatus5 });
ucStatusBarStand1.UCDataSource = ItemBuyStatusProc.ColorStatusDt;
ucStatusBarStand1.UCAct();
}
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.供应商 }, true);
ParamSetRule psrule = new ParamSetRule();
saveNoLoadCheckDayNum = psrule.RShowIntByCode((int)ParamSetEnum.未加载数据比对天数);
this.ToolBarItemAdd(32, "btnUpdateOrderStatus", "修改合同状态", true, UpdateOrderStatusToolStripMenuItem_Click, eShortcut.F9);
if (ProductParamSet.GetIntValueByID(5020) == (int)YesOrNo.Yes)//组织结构体系启用
{
Common.BindOPID(drpSaleOPID, "Sale_SaleOrder", "SaleOPID", true);
}
else
{
Common.BindOPID(drpSaleOPID, true);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Data_Item";
this.HTDataDts = gridView1;
this.HTCheckDataField = new string[] { "DtsItemCode" };//数据明细校验必须录入字段
Common.BindCLS(drpItemUnit, "Data_Item", "ItemUnitYarn", true);
Common.BindCLS(drpItemrSeason, "Data_Item", "Season", true);
Common.BindCLS(drpItemCW, "Data_Item", "ItemCW", true);
Common.BindOP(drpCYOPID, (int)EnumOPDep.业务部, true);
Common.BindItemClass(drpItemType, this.FormListAID, true);//绑定物品分类
Common.BindVendor(drpBuyShopID, new int[] { (int)EnumVendorType.供应商 }, true);
this.SetPosCondition = " AND ItemTypeID=" + this.FormListAID;
new VendorProc(drpBuyShopID);
new ItemProcResLookUP(BaseFocusLabel, gridView1, new string[3] {
"DtsItemCode", "DtsItemName", "DtsItemStd"
}, drpDtsItemCode, txtDtsItemName, new int[] { (int)EnumItemType.纱线, (int)EnumItemType.原料 }, "", "DtsItemModel", true, true);
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5024)))//明细列表显示
{
groupControl1.Visible = true;
}
else
{
groupControl1.Visible = false;
}
SetTabIndex(0, groupControlMainten);
}
/// <summary>
/// 初始化刷新数据(窗体加载时或用户刷新按钮时调用)
/// </summary>
public override void IniRefreshData()
{
Common.BindOrderType(drpOrderTypeID, true);
Common.BindOrderLevel(drpOrderLevelID, true);
Common.BindWLAmount(drpWLAmountType, true);
Common.BindPayMethod(drpPayMothodFlag, true);
//Common.BindOP(drpSaleOPID, (int)EnumOPDep.业务部, true);
if (ProductParamSet.GetIntValueByID(5020) == (int)YesOrNo.Yes)//组织结构体系启用
{
Common.BindOPID(drpSaleOPID, "Sale_SaleOrder", "SaleOPID", true);
}
else
{
Common.BindOPID(drpSaleOPID, true);
}
Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户 }, true);
Common.BindVendor(drpDyeFactorty, new int[] { (int)EnumVendorType.染厂 }, true);
Common.BindCLS(txtSGReq, "WO_FabricProcess", "SGReq", true); //手感要求
Common.BindSOContext(drpSOContext, "", true);
Common.BindCLS(drpPackMethod, "WO_FabricProcess", "PackMethod", true);
Common.BindCLS(drpAfterFinish, "WO_FabricProcess", "AfterFinish", true);
Common.BindCLS(drpGridCalUnit, "WO_FabricProcessDts", "CalUnit", true);
Common.BindCLS(restxtunit, "Data_Item", "ItemUnitFab", true);
Common.BindCLS(drpShipMethod, "WO_FabricProcess", "ShipMethod", true);//运输方式
}
private void CalcQty(BProductCheckDts entity)
{
//==entity.KF25=1 开匹后新增加条码，entity.KF20 = 1，被开匹过的条码
if (entity.KF25 != 1 && entity.KF20 != 1) //不是开匹的才计算
{
entity.KF = entity.RCKF + entity.ZCKF; //合计扣分=织疵点+染疵点
entity.Qty = entity.SM - entity.CJRC - entity.CJZC - entity.FMZC - entity.FMRC - entity.CY - entity.MQty3;
entity.MQty4 = entity.SM - entity.CJRC - entity.CJZC - entity.FMZC - entity.FMRC - entity.CY - entity.MQty3;
if (entity.Qty != 0m)
{
entity.BMKF = entity.KF / entity.Qty;
}
if (entity.MQty4 != 0m)
{
entity.FMQty = SysConvert.ToDecimal(entity.MQty4 * 1.0936132983377m);
}
else
{
entity.FMQty = SysConvert.ToDecimal(entity.Qty * 1.0936132983377m);
}
if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6428)))//仓库出库选择客户直接带出该客户相关单据
{
entity.Qty = GetChangeQty(entity.Qty);
entity.FMQty = GetChangeQty(entity.FMQty);
}
}
}
/// <summary>
/// 值改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)
{
if (e.Column.FieldName == "ColorNum") //色号列值改变
{
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5820))) //染整加工单加载时开启染厂色号读取色卡管理的染厂色号
{
string itemCode = SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "ItemCode"));
string colorNum = SysConvert.ToString(gridView1.GetRowCellValue(e.RowHandle, "ColorNum"));
string desingNo = Common.GetDesignNoByItemAndColorNum(itemCode, colorNum);
if (desingNo != string.Empty)
{
gridView1.SetRowCellValue(e.RowHandle, "DesignNo", desingNo);
}
}
}
if (e.Column.FieldName == "SL" || e.Column.FieldName == "Qty")//根据缩率和成品重量计算坯布重量
{
decimal Qty = SysConvert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "Qty"));
decimal SL = SysConvert.ToDecimal(gridView1.GetRowCellValue(e.RowHandle, "SL"));
decimal PBWeight = Qty * (1 + SysConvert.ToDecimal(SL / 100, 2));
gridView1.SetRowCellValue(e.RowHandle, "PBWeight", PBWeight);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Data_Item";
this.HTDataDts = gridView6;
this.HTDataDtsAttach = new DevExpress.XtraGrid.Views.Grid.GridView[] { gridView1, gridView2, gridView3, gridView6 };
Common.BindVendor(drpGridFactoryID, new int [] { (int)EnumVendorType.工厂, (int)EnumVendorType.供应商 }, true);
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5012)))//
{
btnCalc.Visible = true;
}
SetTabIndex(0, groupControlMainten);
//txtItemCode.Properties.ReadOnly = true;
Common.BindCLS(txtWeightUnit, "Data_Item", "WeightUnit", true);
Common.BindCLS(txtOrgan, "Data_Item", "Organ", true);
Common.BindCLS(drpItemUnit, "Data_Item", "ItemUnit", true);
gridViewBaseRowChangedA3 += new gridViewBaseRowChangedA(gridViewRowChanged3);
gridViewBindEventA3(gridView6);
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
this.HTDataTableName = "Sale_SaleOrder";
this.HTDataList = gridView1;
//this.HTDataDtsAttach = new GridView[] { gridView4 };
this.HTQryContainer = groupControlQuery;
txtOrderDateS.DateTime = DateTime.Now.AddMonths(-2).Date;
txtOrderDateE.DateTime = DateTime.Now.Date;
txtMakeDateS.DateTime = DateTime.Now.AddMonths(-2).Date;
txtMakeDateE.DateTime = DateTime.Now.Date;
//this.ToolBarItemAdd(32, "btnUpdateOrderStep", "修改合同站别", true, UpdateOrderStepToolStripMenuItem_Click, eShortcut.None);
this.ToolBarItemAdd(32, "btnUpdateOrderStatus", "修改合同状态", true, UpdateOrderStatusToolStripMenuItem_Click, eShortcut.None);
// this.ToolBarItemAdd(32, "btnCancelOrder", "撤单", true, btnCancelOrder_Click, eShortcut.None);
// this.ToolBarItemAdd(32, "btnCancelCancelOrder_Click", "取消撤单", true, btnCancelCancelOrder_Click, eShortcut.None);
if (ProductParamSet.GetIntValueByID(5417) == (int)YesOrNo.Yes)//组织结构体系启用
{
chkOrderDate.Checked = false;
}
if (SaleOrderStepProc.ColorIniFlag)
{
ucStatusBarStand1.UCDataSource = SaleOrderStepProc.ColorStatusDt;
ucStatusBarStand1.UCAct();
}
if (SaleOrderStatusProc.ColorIniFlag)
{
ucStatusBarStand2.UCDataSource = SaleOrderStatusProc.ColorStatusDt;
ucStatusBarStand2.UCAct();
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
//
if (txtFormNo.Text.Trim() != string.Empty)
{
tempStr += " AND FormNo LIKE " + SysString.ToDBString("%" + txtFormNo.Text.Trim() + "%");
}
if (chkMakeDate.Checked)
{
tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtMakeDateE.DateTime);
}
if (SysConvert.ToString(drpSaleOPID.EditValue) != string.Empty)
{
tempStr += " AND SaleOPID=" + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue));
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单
{
tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")";
}
// tempStr += " AND SampleType=" + FormListBID;//打样类型
tempStr += " AND SOType=" + FormListAID;//订单类型
tempStr += " ORDER BY FormNo DESC";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 数据初始化(填写表名、绑定控制、初始化界面属性等)
/// </summary>
public override void IniData()
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, FormListAID, FormListBID); //设置列UI
//Common.BindOP(drpSaleOPID, true);
this.HTDataTableName = "Sale_FHForm";
this.HTDataList = gridView1;
this.HTQryContainer = groupControlQuery;
if (ProductParamSet.GetIntValueByID(5020) == (int)YesOrNo.Yes)//组织结构体系启用
{
Common.BindOPID(drpSaleOPID, "Sale_SaleOrder", "SaleOPID", true);
}
else
{
Common.BindOPID(drpSaleOPID, true);
}
// Common.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户 }, true);
DevMethod.BindVendor(drpQVendorID, new int[] { (int)EnumVendorType.客户 }, true);//2015.4.8 CX修改
Common.BindFHType(drpFHTypeID, true);
txtQMakeDateS.DateTime = DateTime.Now.AddDays(-10).Date;
txtQMakeDateE.DateTime = DateTime.Now;
if (FHFormStatusProc.ColorIniFlag)
{
//FHFormStatusProc.ColorIniTextBox(new TextBox[] { txtColorStatus1, txtColorStatus2});
ucStatusBarStand1.UCValueIni(FHFormStatusProc.ColorStatusName, FHFormStatusProc.ColorStatusColor);
ucStatusBarStand1.UCAct();
}
}
/// <summary>
/// 窗体加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmWait_Load(object sender, EventArgs e)
{
try
{
ProcessGrid.BindGridColumn(gridView1, this.FormID); //绑定列
ProcessGrid.SetGridColumnUI(gridView1, this.FormListAID, this.FormListBID); //设置列UI
SaleOrder entity = new SaleOrder();
entity.ID = m_ID;
entity.SelectByID();
SaleItemType = Common.GetSaleItemTypeByID(entity.SaleFlowModuleID);
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5009)))//面料的坯布启用可替换坯布功能,影响到订单坯布算料、坯布采购、织造等
{
}
else
{
gridView1.Columns["CPItemCode"].Visible = false;
}
BindGrid();
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增))
{
this.ShowMessage("你没有此操作权限");
return;
}
if (HTDataID == 0)
{
this.ShowMessage("请选择要操作的记录");
return;
}
//if (!CheckCorrect())
//{
// return;
//}
//sc 出库提交前校验细码与库存细码是否对上
if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6402)))//非 成品仓库不使用码单模式
{
for (int i = 0; i < ucFabView1.UCDataSource.Rows.Count; i++)
{
string sql = "SELECT Qty FROM WH_PackBox WHERE BoxNo = " + SysString.ToDBString(SysConvert.ToString((ucFabView1.UCDataSource.Rows[i]["BoxNo"])));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
if (SysConvert.ToDecimal(ucFabView1.UCDataSource.Rows[i]["Qty"]) != SysConvert.ToDecimal(dt.Rows[0]["Qty"]))
{
this.ShowMessage("此细码:" + SysConvert.ToString(ucFabView1.UCDataSource.Rows[i]["BoxNo"]) + " 已开过匹，与库存细码对应不上，请检查!");
return;
}
}
}
}
DBFormRule rule = new DBFormRule();
if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6402)))//非 成品仓库不使用码单模式
{
string o_ErrorMsg = string.Empty;
if (!rule.RCheckCorrectPackData(HTDataID, out o_ErrorMsg))// 如果校验不通过
{
this.ShowMessage(o_ErrorMsg);
return;
}
}
rule.RSubmit(HTDataID, (int)ConfirmFlag.已提交);
FCommon.AddDBLog(this.Text, FormStatus.提交.ToString(), "ID:" + HTDataID, "");
this.SetPosStatus(HTDataID);
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 新增单据初始化控件数据(哪些值需要设置的设定一下)
/// </summary>
public override void IniInsertSet()
{
txtItemDate.DateTime = DateTime.Now.Date;
txtMakeOPID.Text = Common.GetOPName(FParamConfig.LoginID);
txtItemCode_DoubleClick(null, null);
drpItemUnit.Text = ProductParamSet.GetStrValueByID(5004);//辅料默认单位设置
}
private void SetSaleOrderFabric(string str)
{
if (str != "")
{
int index = gridView1.FocusedRowHandle;//checkRowSet();
string sql = "SELECT ItemCode,ItemName,ItemModel,ItemStd,GoodsCode,FreeStr1,FormNo,Unit,CPItemCode,CPItemName,CPItemModel,CPItemStd,Sum(Qty) Qty";
sql += " FROM UV1_Sale_SaleOrderTFabric WHERE DtsID in (" + str + ")";
sql += " Group BY ItemCode,ItemName,ItemModel,ItemStd,GoodsCode,FreeStr1,FormNo,Unit,CPItemCode,CPItemName,CPItemModel,CPItemStd";
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
gridView1.SetRowCellValue(index + i, "ItemCode", SysConvert.ToString(dt.Rows[i]["ItemCode"]));
gridView1.SetRowCellValue(index + i, "ItemName", SysConvert.ToString(dt.Rows[i]["ItemName"]));
gridView1.SetRowCellValue(index + i, "ItemModel", SysConvert.ToString(dt.Rows[i]["ItemModel"]));
gridView1.SetRowCellValue(index + i, "ItemStd", SysConvert.ToString(dt.Rows[i]["ItemStd"]));
gridView1.SetRowCellValue(index + i, "GoodsCode", SysConvert.ToString(dt.Rows[i]["GoodsCode"])); //货号
gridView1.SetRowCellValue(index + i, "FreeStr1", SysConvert.ToString(dt.Rows[i]["FreeStr1"])); //画本号
//gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
gridView1.SetRowCellValue(index + i, "Qty", SysConvert.ToString(dt.Rows[i]["Qty"]));
gridView1.SetRowCellValue(index + i, "DtsSO", SysConvert.ToString(dt.Rows[i]["FormNo"]));
gridView1.SetRowCellValue(index + i, "Unit", SysConvert.ToString(dt.Rows[i]["Unit"]));
string[] itemInfo = Common.GetItemArrayByCode(SysConvert.ToString(dt.Rows[i]["ItemCode"]));
if (itemInfo.Length >= 6)
{
if (itemInfo[4] != string.Empty)
{
gridView1.SetRowCellValue(index + i, "MWidth", SysConvert.ToDecimal(itemInfo[4]));
}
if (itemInfo[5] != string.Empty)
{
gridView1.SetRowCellValue(index + i, "MWeight", SysConvert.ToDecimal(itemInfo[5]));
}
}
gridView1.SetRowCellValue(index + i, "CPItemCode", SysConvert.ToString(dt.Rows[i]["CPItemCode"]));
gridView1.SetRowCellValue(index + i, "CPItemName", SysConvert.ToString(dt.Rows[i]["CPItemName"]));
gridView1.SetRowCellValue(index + i, "CPItemModel", SysConvert.ToString(dt.Rows[i]["CPItemModel"]));
gridView1.SetRowCellValue(index + i, "CPItemStd", SysConvert.ToString(dt.Rows[i]["CPItemStd"]));
if (i == index)
{
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5009)))//面料的坯布启用可替换坯布功能,影响到订单坯布算料、坯布采购、织造等
{
Common.BindFabricItemByCPItemCode(drpGridItemCode, SysConvert.ToString(dt.Rows[i]["CPItemCode"]), true);
}
}
}
}
}
}
/// <summary>
/// 查询条件
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (txtVendorName.Text.Trim() != "")//查询。
{
tempStr = " AND VendorName LIKE " + SysString.ToDBString("%" + txtVendorName.Text.Trim() + "%");
}
if (txtVendorID.Text.Trim() != "")
{
tempStr = " AND VendorID LIKE " + SysString.ToDBString("%" + txtVendorID.Text.Trim() + "%");
}
if (txtTelPhone.Text.Trim() != "")
{
tempStr = " AND Tel LIKE " + SysString.ToDBString("%" + txtTelPhone.Text.Trim() + "%");
}
if (txtTelPerson.Text.Trim() != "")
{
tempStr = " AND Contact LIKE " + SysString.ToDBString("%" + txtTelPerson.Text.Trim() + "%");
}
if (txtArea.Text.Trim() != "")
{
tempStr = " AND Area LIKE " + SysString.ToDBString("%" + txtArea.Text.Trim() + "%");
}
if (txtVendorAttn.Text.Trim() != "")
{
tempStr += " AND VendorAttn LIKE " + SysString.ToDBString("%" + txtVendorAttn.Text.Trim() + "%");
}
if (txtCountry.Text.Trim() != "")
{
tempStr += " AND Country LIKE " + SysString.ToDBString("%" + txtCountry.Text.Trim() + "%");
}
if (txtProvince.Text.Trim() != "")
{
tempStr += " AND Province LIKE " + SysString.ToDBString("%" + txtProvince.Text.Trim() + "%");
}
tempStr += " AND ( VendorTypeID IN(0," + SysString.ToDBString(FormListAID) + ") OR";
tempStr += " VendorID IN(SELECT VendorID FROM Data_VendorTypeDts WHERE VendorTypeID IN(0," + SysString.ToDBString(FormListAID) + "))";
tempStr += ")";
//if (FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.审核2)&&!FParamConfig.LoginHTFlag)
//{
// tempStr+="AND InSaleOP="+SysString.ToDBString(FParamConfig.LoginID);
//}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单
{
tempStr += " AND InSaleOP IN(" + WCommon.GetStructureMemberOPStr() + ")";
}
tempStr += " ORDER BY ID";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 控件状态方法设置
/// </summary>
public override void SetInputStatus(bool p_Flag)
{
ProcessCtl.ProcControlEdit(gridControl3, p_Flag);
drpVendorLevel.Text = SysConvert.ToString(ProductParamSet.GetStrValueByID(5025));
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5021)))//客户编号自动生成
{
ProductCommon.FormNoCtlEditSet(txtVendorID, "Data_Vendor", "VendorID", this.FormListAID, p_Flag);
}
}
private void BindGrid()
{
SaleOrderDts entitydts = new SaleOrderDts();
entitydts.ID = m_DID;
entitydts.SelectByID();
string sql = "SELECT * FROM Sale_SaleOrderFabricCompSite WHERE MainID=" + SysString.ToDBString(m_ID);
sql += " AND DID=" + SysString.ToDBString(m_DID);
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
gridView1.GridControl.DataSource = SysUtils.Fill(sql);
gridView1.GridControl.Show();
decimal TotalQty = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
TotalQty += SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty"));
}
txtTotalQty.Text = TotalQty.ToString();
}
else
{
sql = "SELECT ItemCode,ItemName,ItemStd,ItemModel,ComTypeID FROM UV1_Data_ItemCompositeDts WHERE MainID IN (SELECT ID FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entitydts.ItemCode) + ")";
DataTable dto = SysUtils.Fill(sql);
for (int i = 0; i < dto.Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr["ItemCode"] = SysConvert.ToString(dto.Rows[i]["ItemCode"]);
dr["ItemName"] = SysConvert.ToString(dto.Rows[i]["ItemName"]);
dr["ItemStd"] = SysConvert.ToString(dto.Rows[i]["ItemStd"]);
dr["ComTypeID"] = SysConvert.ToInt32(dto.Rows[i]["ComTypeID"]);
dr["ColorName"] = entitydts.ColorName;
dr["ItemModel"] = SysConvert.ToString(dto.Rows[i]["ItemModel"]);
dr["SQty"] = entitydts.Qty;
dr["RQty"] = entitydts.Qty;
dr["Unit"] = "KG";
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5405))) //转换为默认单位模式开启,目前支持转换为公斤模式
{
string unitdefault = SysConvert.ToString(ProductParamSet.GetStrValueByID(5406)); //转换后默认单位
if (unitdefault != string.Empty)
{
dr["Unit"] = unitdefault;
//entitydts[index].Unit = unitdefault;//赋值转换后单位
}
}
dr["SO"] = m_SO;
dt.Rows.Add(dr);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
}
/// <summary>
/// 新增初始化
/// </summary>
public override void IniInsertSet()
{
txtWeightUnit.Text = "g/m";
txtItemCode_DoubleClick(null, null);
drpUseable.EditValue = 1;
drpPFlag.EditValue = 0;
drpXFlag.EditValue = 0;
txtItemDate.DateTime = DateTime.Now.Date;
drpItemUnit.Text = ProductParamSet.GetStrValueByID(5002);//坯布默认单位设置
}
/// <summary>
/// 控件状态方法设置
/// </summary>
public override void SetInputStatus(bool p_Flag)
{
ProcessCtl.ProcControlEdit(gridControl3, p_Flag);
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5021)))//客户编号自动生成
{
ProductCommon.FormNoCtlEditSet(txtVendorID, "Data_Vendor", "VendorID", this.FormListAID, p_Flag);
}
ProcessGrid.SetGridEdit(gridView6, new string[] { "Name" }, false);
ProcessGrid.SetGridColumnReadOnly(gridView6, new string[] { "Name" }, true);
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
IOFormRule rule = new IOFormRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("DtsVendorName", "'' DtsVendorName"));
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6425)))//查询带出订单客户
{
SetGirdDataSource(dt);
}
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
}
/// <summary>
/// 控制自动生成客户编号
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtVendorID_DoubleClick(object sender, EventArgs e)
{
try
{
if (HTFormStatus == FormStatus.新增 && SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5021)))
{
ProductCommon.FormNoIniSet(txtVendorID, "Data_Vendor", "VendorID", this.FormListAID);
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void SetSaleOrderFabric(string str)
{
string[] arr = str.Split(',');
//int index = gridView1.FocusedRowHandle;//checkRowSet();
int index = 0;//只保存一条数据
int length = 0;
for (int i = index; i < arr.Length + index; i++)
{
string sql = "SELECT * FROM UV1_Sale_SaleOrderTFabric WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(arr[length]));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count > 0)
{
gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"]));
gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"]));
gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"]));
gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"]));
gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"]));
gridView1.SetRowCellValue(i, "Qty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]));
gridView1.SetRowCellValue(i, "DtsSO", SysConvert.ToString(dt.Rows[0]["FormNo"]));
gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"]));
gridView1.SetRowCellValue(i, "CPItemCode", SysConvert.ToString(dt.Rows[0]["CPItemCode"]));
gridView1.SetRowCellValue(i, "CPItemName", SysConvert.ToString(dt.Rows[0]["CPItemName"]));
gridView1.SetRowCellValue(i, "CPItemModel", SysConvert.ToString(dt.Rows[0]["CPItemModel"]));
gridView1.SetRowCellValue(i, "CPItemStd", SysConvert.ToString(dt.Rows[0]["CPItemStd"]));
if (i == index) //第一行
{
if (groupControlItem.Visible) //物料用料控件容器可见 绑定物料使用
{
SetFabUseItemDts(SysConvert.ToString(dt.Rows[0]["ItemCode"]));
}
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5009)))//面料的坯布启用可替换坯布功能,影响到订单坯布算料、坯布采购、织造等
{
Common.BindFabricItemByCPItemCode(drpGridItemCode, SysConvert.ToString(dt.Rows[0]["CPItemCode"]), true);
}
}
}
length++;
}
if (groupControlItem.Visible) //物料用料控件容器可见 绑定物料使用
{
SetFabUseItemDtsCalc(); //计算用料
}
}