/// <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> /// 绑定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 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 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; }
void BindGrid1() { ItemGYFlowDtsRule rule = new ItemGYFlowDtsRule(); DataTable dt = rule.RShow(" AND MainID=" + _WPItemID + " ORDER BY Seq", ProcessGrid.GetQueryField(gridView1)); WCommon.AddDtRow(dt, 10); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 初始化刷新数据(窗体加载时或用户刷新按钮时调用) /// </summary> public override void IniRefreshData() { Common.BindItemClass(drpItemClassID, (int)EnumItemType.面料, true); //Common.BindItemType(drpItemTypeID, true); //Common.BindNeedle(txtNeedle, true); Common.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.工厂, (int)EnumVendorType.供应商 }, true); Common.BindCLS(drpItemUnit, "Data_Item", "ItemUnitFab", true); WCommon.BindCLS(drpItemName, "Data_Item", "ItemName", true); new ItemProcResLookUP(BaseFocusLabel, gridView2, new string[3] { "DtsItemCode", "DtsItemName", "DtsItemStd" }, drpDtsItemCode, txtDtsItemName, new int[] { (int)EnumItemType.纱线 }, "", "ItemStd", true, true); new ItemProcResLookUP(BaseFocusLabel, gridView4, new string[3] { "GreyFabItemCode", "ItemName", "ItemStd" }, drpGridItemCodeFab, txtGridItemNameFab, new int[] { (int)EnumItemType.坯布 }, "", "ItemStd", true, true); }
/// <summary> /// 处理默认数据源 /// 因为特殊性 /// </summary> void ProcItemCompositeDtsDefault() { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改)//处理默认数据源 { DataTable dt = (DataTable)gridView2.GridControl.DataSource; if (dt.Rows.Count < 2) { WCommon.AddDtRow(dt, 2); } if (SysConvert.ToInt32(dt.Rows[0]["ComTypeID"]) == 0)//面布 { dt.Rows[0]["ComTypeID"] = 1; } if (SysConvert.ToInt32(dt.Rows[1]["ComTypeID"]) == 0)//底布 { dt.Rows[1]["ComTypeID"] = 2; } } }
/// <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 (chkFormDate.Checked) { tempStr += " AND FormDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != string.Empty) { tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)); } if (!Common.CheckLookUpEditBlank(drpSaleOPID)) { tempStr += " AND SaleOPID=" + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue)); //tempStr += " AND VendorID IN (SELECT VendorID FROM Data_Vendor WHERE InSaleOP="+SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue))+" )"; } if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")"; } if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")"; } //if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.审核2)) //{ // tempStr += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(FParamConfig.LoginID) + ")"; //} HTDataConditionStr = tempStr; }
private void setItemNews(string p_Str) { string[] orderid = p_Str.Split(','); int index = checkRowSet(); int length = 0; int f = gridView1.RowCount; for (int i = index; i < orderid.Length + index; i++) { if (i >= f) { WCommon.DataTableAddRow((DataTable)gridView1.GridControl.DataSource, i - 1); } string sql = "SELECT * FROM UV1_WH_IOFormDts WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[length])); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count == 1) { dt.Rows[0]["Qty"] = SysConvert.ToDecimal(dt.Rows[0]["Qty"].ToString()) - SysConvert.ToDecimal(dt.Rows[0]["YQQty"].ToString()); //??? gridView1.SetRowCellValue(i, "DLOADID", SysConvert.ToString(dt.Rows[0]["ID"])); gridView1.SetRowCellValue(i, "DLOADSEQ", SysConvert.ToString(dt.Rows[0]["Seq"])); gridView1.SetRowCellValue(i, "DLOADNO", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "DLOADDtsID", SysConvert.ToString(dt.Rows[0]["DtsID"])); gridView1.SetRowCellValue(i, "FormNM", SysConvert.ToString(dt.Rows[0]["FormNM"]));//单据类型 gridView1.SetRowCellValue(i, "WHFormNo", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "WHFormDate", SysConvert.ToString(dt.Rows[0]["FormDate"])); gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"])); gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"])); gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"])); gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); gridView1.SetRowCellValue(i, "Batch", SysConvert.ToString(dt.Rows[0]["Batch"])); gridView1.SetRowCellValue(i, "VendorBatch", SysConvert.ToString(dt.Rows[0]["VendorBatch"])); gridView1.SetRowCellValue(i, "JarNum", SysConvert.ToString(dt.Rows[0]["JarNum"])); gridView1.SetRowCellValue(i, "DtsOrderFormNo", SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); //gridView1.SetRowCellValue(i, "MLType", SysConvert.ToInt32(dt.Rows[0]["MLType"])); gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); gridView1.SetRowCellValue(i, "DCheckDYPrice", SysConvert.ToDecimal(dt.Rows[0]["DYPrice"]));//打样费用 gridView1.SetRowCellValue(i, "DYPrice", SysConvert.ToDecimal(dt.Rows[0]["DYPrice"])); if (FormListAID == 3)//销售对账 { sql = "Select * from UV1_Sale_SaleOrderDts where 1=1"; sql += " AND FormNo=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); sql += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ItemCode"])); sql += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorNum"])); sql += " AND ColorName=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorName"])); DataTable dtS = SysUtils.Fill(sql); if (dtS.Rows.Count != 0) { gridView1.SetRowCellValue(i, "FAmount1", SysConvert.ToDecimal(dtS.Rows[0]["FAmount1"])); // gridView1.SetRowCellValue(i, "FAmount2", SysConvert.ToDecimal(dtS.Rows[0]["FAmount2"])); // gridView1.SetRowCellValue(i, "FAmount3", SysConvert.ToDecimal(dtS.Rows[0]["FAmount3"])); // gridView1.SetRowCellValue(i, "FAmount4", SysConvert.ToDecimal(dtS.Rows[0]["FAmount4"])); // } } decimal DZQty = SysConvert.ToDecimal(dt.Rows[0]["DZQty"]); //对账数量 decimal DZAmount = SysConvert.ToDecimal(dt.Rows[0]["DZAmount"]); //对账金额 if (SysConvert.ToString(dt.Rows[0]["Qty"]) != string.Empty) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Qty"])); //出入库数量 gridView1.SetRowCellValue(i, "Weight", SysConvert.ToString(SysConvert.ToDecimal(dt.Rows[0]["Weight"]))); //出入库公斤数 gridView1.SetRowCellValue(i, "Yard", SysConvert.ToString(SysConvert.ToDecimal(dt.Rows[0]["Yard"]))); //出入库码数 if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/KG" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/KG") { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Weight"]) - DZQty); gridView1.SetRowCellValue(i, "Weight", 0 - SysConvert.ToDecimal(dt.Rows[0]["Weight"])); } else if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/M" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/M") { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); gridView1.SetRowCellValue(i, "Qty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } else if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/Y" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/Y") { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Yard"]) - DZQty); gridView1.SetRowCellValue(i, "Yard", 0 - SysConvert.ToDecimal(dt.Rows[0]["Yard"])); } else { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); gridView1.SetRowCellValue(i, "Qty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } } else { if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/KG" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/KG") { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Weight"]) - DZQty); } else if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/M" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/M") { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); } else if (SysConvert.ToString(dt.Rows[0]["Unit"]) == "RMB/Y" || SysConvert.ToString(dt.Rows[0]["Unit"]) == "USD/Y") { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Yard"]) - DZQty); } else { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); } } } if (SysConvert.ToString(dt.Rows[0]["SinglePrice"]) != string.Empty)//出入库单价 { gridView1.SetRowCellValue(i, "SinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); gridView1.SetRowCellValue(i, "DCheckSinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); } if (SysConvert.ToString(dt.Rows[0]["Amount"]) != string.Empty) //出入库金额 { gridView1.SetRowCellValue(i, "Amount", SysConvert.ToString(dt.Rows[0]["Amount"])); if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { gridView1.SetRowCellValue(i, "DCheckAmount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); gridView1.SetRowCellValue(i, "Amount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"])); } else { gridView1.SetRowCellValue(i, "DCheckAmount", SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); } } if (SysConvert.ToString(dt.Rows[0]["PieceQty"]) != string.Empty)//匹数 { gridView1.SetRowCellValue(i, "PieceQty", SysConvert.ToString(dt.Rows[0]["PieceQty"])); } length++; } } }
private void setItemTotalNews(string p_Str) { string[] orderid = p_Str.Split(','); int index = checkRowSet(); int length = 0; int f = gridView1.RowCount; for (int i = index; i < orderid.Length + index; i++) { if (i >= f) { WCommon.DataTableAddRow((DataTable)gridView1.GridControl.DataSource, i - 1); } string sql = "SELECT distinct(FormNo),ID,CompanyTypeID,FromIOFormID,WHTypeID,HeadType,SubType, VendorID,OutDep,Indep,DutyOP,WHOP,PassOP,SOID,SpecialNo,FormDate,CardNo,CheckDate,ConfirmFlag,CheckOP,WHID,WHType,LastUpdTime,DelFlag,SubmitFlag,LastUpdOP,Remark,JHCode,XZ,SaleOPID,DM,InvoiceNo,Expr1,Expr3,SectionID,DtsVendorID,SBitID,ItemCode,ItemName,ItemStd,ItemModel,VendorBatch,ColorNum,ColorName,YarnStatus,YarnTypeID,SizeName,Unit,(ISNULL(SinglePrice,0)*ISNULL(TotalQty,0)) as Amount,SinglePrice,WAmount,DtsSO,DtsSaleOPID,Needle,SourceWeight,SourceQty,MoveQty,MoveWeight,SourceTubeQty,TubeGW,TubeQty,MoveTubeQty,SourcePieceQty,MovePieceQty,PieceQty,PieceQtyDesc,JarNo,Twist,DLCode,GoodsCode,VColorNum,VColorName,VItemCode,PFPrice,SaleOPName,TotalQty,TotalAmount,SubmitOPID,SubmitTime,ToWHID,ToSectionID,ToSBitID,WHNM,FormNM,DZNo,DZTime,DZOPID,DZFlag,DZAmount,DZSinglePrice,DZQty,DtsInvoiceNo,DtsInvoiceDelTime,DtsInvoiceDelOPID,DtsInvoiceDelFlag,PayAmount,InvoiceQty,InOrderFormNo,InSO,DtsInVendorID,WeightUnit,MWeight,MWidth,GoodsLevel,DtsOrderFormNo,InvoiceAmount,FreeNum1,InSaleOPID,VendorName,VendorAttn,FormDZFlag,FormDZType,MLType,FHTypeID,KDNo,DYPrice,DEFlag,YQQty,AQty,NOKPQty,NoKPAmount,Volume,VConvertXS,QtyConvertXS,DVendorID,LoadDtsID,MakeOPName,DCOPID,MainID,SaleFlag,ColorFlag,BuyFlag,DtsRemark,Qty,Batch,DtsID FROM UV1_WH_LoadIOFormDtsTotal WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[length])); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count >= 1) { dt.Rows[0]["Qty"] = SysConvert.ToDecimal(dt.Rows[0]["TotalQty"].ToString()); gridView1.SetRowCellValue(i, "DLOADID", SysConvert.ToString(dt.Rows[0]["ID"])); gridView1.SetRowCellValue(i, "DLOADSEQ", index); gridView1.SetRowCellValue(i, "DLOADNO", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "DLOADDtsID", SysConvert.ToString(dt.Rows[0]["DtsID"])); gridView1.SetRowCellValue(i, "FormNM", SysConvert.ToString(dt.Rows[0]["FormNM"]));//单据类型 gridView1.SetRowCellValue(i, "WHFormNo", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "WHFormDate", SysConvert.ToString(dt.Rows[0]["FormDate"])); gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"])); gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"])); gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"])); gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); gridView1.SetRowCellValue(i, "Batch", SysConvert.ToString(dt.Rows[0]["Batch"])); gridView1.SetRowCellValue(i, "VendorBatch", SysConvert.ToString(dt.Rows[0]["VendorBatch"])); gridView1.SetRowCellValue(i, "DtsOrderFormNo", SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); //gridView1.SetRowCellValue(i, "MLType", SysConvert.ToInt32(dt.Rows[0]["MLType"])); gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); gridView1.SetRowCellValue(i, "DCheckDYPrice", SysConvert.ToDecimal(dt.Rows[0]["DYPrice"]));//打样费用 gridView1.SetRowCellValue(i, "DYPrice", SysConvert.ToDecimal(dt.Rows[0]["DYPrice"])); if (FormListAID == 3)//销售对账 { sql = "Select * from UV1_Sale_SaleOrderDts where 1=1"; sql += " AND FormNo=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); sql += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ItemCode"])); sql += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorNum"])); sql += " AND ColorName=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorName"])); DataTable dtS = SysUtils.Fill(sql); if (dtS.Rows.Count != 0) { gridView1.SetRowCellValue(i, "FAmount1", SysConvert.ToDecimal(dtS.Rows[0]["FAmount1"])); // gridView1.SetRowCellValue(i, "FAmount2", SysConvert.ToDecimal(dtS.Rows[0]["FAmount2"])); // gridView1.SetRowCellValue(i, "FAmount3", SysConvert.ToDecimal(dtS.Rows[0]["FAmount3"])); // gridView1.SetRowCellValue(i, "FAmount4", SysConvert.ToDecimal(dtS.Rows[0]["FAmount4"])); // } } decimal DZQty = SysConvert.ToDecimal(dt.Rows[0]["DZQty"]); //对账数量 decimal DZAmount = SysConvert.ToDecimal(dt.Rows[0]["DZAmount"]); //对账金额 if (SysConvert.ToString(dt.Rows[0]["Qty"]) != string.Empty) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Qty"]));//出入库数量 if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); gridView1.SetRowCellValue(i, "Qty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } else { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); } } if (SysConvert.ToString(dt.Rows[0]["SinglePrice"]) != string.Empty)//出入库单价 { gridView1.SetRowCellValue(i, "SinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); gridView1.SetRowCellValue(i, "DCheckSinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); } if (SysConvert.ToString(dt.Rows[0]["Amount"]) != string.Empty) //出入库金额 { gridView1.SetRowCellValue(i, "Amount", SysConvert.ToString(dt.Rows[0]["Amount"])); if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { gridView1.SetRowCellValue(i, "DCheckAmount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); gridView1.SetRowCellValue(i, "Amount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"])); } else { gridView1.SetRowCellValue(i, "DCheckAmount", SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); } } if (SysConvert.ToString(dt.Rows[0]["PieceQty"]) != string.Empty)//匹数 { gridView1.SetRowCellValue(i, "PieceQty", SysConvert.ToString(dt.Rows[0]["PieceQty"])); } length++; } } }
/// <summary> /// 绑定Grid /// </summary> public override void GetCondtion() { string tempStr = string.Empty; if (chkAll.Checked == true) { if (chkJSTime.Checked) { tempStr += " AND JSDate BETWEEN " + SysString.ToDBString(txtJSDateS.DateTime) + " AND " + SysString.ToDBString(txtJSDateE.DateTime); } if (chkMakeDate.Checked) { tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtMakeDateE.DateTime); } if (txtPostCode.Text.Trim() != string.Empty) { tempStr += " AND PostCode = " + SysString.ToDBString(txtPostCode.Text.Trim()); } if (SysConvert.ToString(drpTransComID.EditValue) != "") { tempStr += " AND PostComID = " + SysString.ToDBString(SysConvert.ToString(drpTransComID.EditValue)); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)); } if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { tempStr += " AND MakeOPID IN(" + WCommon.GetStructureMemberOPStr() + ")"; } //if (chkJSFlag.Checked) //{ // tempStr += " AND JSFlag=1"; //} if (txtFJR.Text.Trim() != "") { tempStr += " AND FJR LIKE " + SysString.ToDBString("%" + txtFJR.Text.Trim() + "%"); } if (txtFKType.Text.Trim() != "") { tempStr += " AND SKType=" + SysString.ToDBString(txtFKType.Text.Trim()); } if (txtPostType.Text.Trim() != "") { tempStr += " AND PostType=" + SysString.ToDBString(txtPostType.Text.Trim()); } if (txtSJR.Text.Trim() != "") { tempStr += " AND RecName LIKE" + SysString.ToDBString("%" + txtSJR.Text.Trim() + "%"); } if (txtRecPhone.Text.Trim() != "") { tempStr += " AND RecPhone LIKE " + SysString.ToDBString("%" + txtRecPhone.Text.Trim() + "%"); } if (SysConvert.ToInt32(drpPostFormType.EditValue) > 0) { tempStr += " AND PostFormType=" + SysString.ToDBString(SysConvert.ToInt32(drpPostFormType.EditValue)); } if (txtConFormNo.Text.Trim() != "") { tempStr += " AND ConFormNo LIKE " + SysString.ToDBString("%" + txtConFormNo.Text.Trim() + "%"); } if (chkJSFlag.Checked == false) { tempStr += " AND ISNULL(PostFee,0)=0 "; } if (chkJSFlag1.Checked == false) { tempStr += " AND ISNULL(PostFee,0)!=0 "; } tempStr += " ORDER BY FormNo DESC "; HTDataConditionStr = tempStr; } }
/// <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 (SysConvert.ToString(drpVendorID.EditValue) != "") { tempStr += " AND DVendorID =" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (chkQMakeDate.Checked) { tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQMakeDateB.DateTime) + " AND " + SysString.ToDBString(txtQMakeDateE.DateTime); } 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 (txtItemModel.Text.Trim() != "") { tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.Text.Trim() + "%"); } //if (txtVendorID.Text.Trim() != "") //{ // tempStr += " AND VendorID like "+SysString.ToDBString("%"+txtVendorID.Text.Trim()+"%"); //} //if (txtGBCode.Text.Trim() != "") //{ // tempStr += " AND GBCode LIKE "+SysString.ToDBString("%"+txtGBCode.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.ToString(drpSaleOPID.EditValue) != "") { tempStr += " AND SaleOPID=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()); } if (chkAuto.Checked) { tempStr += " AND ISNULL(SubmitFlag,0)=1 "; } if (chkNoAuto.Checked) { tempStr += " AND ISNULL(SubmitFlag,0)<>1"; } if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")"; } tempStr += " ORDER BY FormNo DESC"; HTDataConditionStr = tempStr; }
/// <summary> /// 数据初始化(填写表名、绑定控制、初始化界面属性等) /// </summary> public override void IniData() { this.HTDataTableName = "UV1_Finance_CostRecord"; this.HTDataList = gridView1; string ConditionV = string.Empty; if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { ConditionV = " AND ID IN(Select MainID from Data_VendorSaleOP where OPID in(" + WCommon.GetStructureMemberOPStr() + "))"; } DevMethod.BindVendor(drpVendorID, new int[] { (int)EnumVendorType.客户 }, ConditionV, true); txtFormDateS.DateTime = DateTime.Now.AddMonths(-1).Date; txtFormDateE.DateTime = DateTime.Now.Date; }
private void setItemTotalNews(string p_Str) { string[] orderid = p_Str.Split(','); int index = checkRowSet(); int length = 0; int f = gridView1.RowCount; for (int i = index; i < orderid.Length + index; i++) { if (i >= f) { WCommon.DataTableAddRow((DataTable)gridView1.GridControl.DataSource, i - 1); } string sql = "SELECT ID,FormNo,FormDate,ItemCode,DtsOrderFormNo,WHNM,FormNM,ColorNum,ColorName,GoodsCode,MWidth,MWeight,SinglePrice,SUM(Amount) Amount,ItemName,ItemStd,ItemModel,SUM(Qty) Qty,SUM(PieceQty) PieceQty,Unit,DZAmount,DZQty,FormDZFlag FROM UV1_WH_IOFormDts2 WHERE 1=1 AND ID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[length])) + "GROUP BY FormNo,FormDate,ItemCode,DtsOrderFormNo,WHNM,FormNM,ColorNum,ColorName,MWidth,MWeight,SinglePrice,ID,ItemName,ItemStd,ItemModel,GoodsCode,Unit,DZAmount,DZQty,FormDZFlag"; DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count >= 1) { gridView1.SetRowCellValue(i, "DLOADID", SysConvert.ToString(dt.Rows[0]["ID"])); gridView1.SetRowCellValue(i, "DLOADNO", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "FormNM", SysConvert.ToString(dt.Rows[0]["FormNM"]));//单据类型 gridView1.SetRowCellValue(i, "WHFormNo", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "WHFormDate", SysConvert.ToString(dt.Rows[0]["FormDate"])); gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"])); gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"])); gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"])); gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); gridView1.SetRowCellValue(i, "DtsOrderFormNo", SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); if (FormListAID == 3)//销售对账 { sql = "Select * from UV1_Sale_SaleOrderDts where 1=1"; sql += " AND FormNo=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["DtsOrderFormNo"])); sql += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ItemCode"])); sql += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorNum"])); sql += " AND ColorName=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["ColorName"])); DataTable dtS = SysUtils.Fill(sql); if (dtS.Rows.Count != 0) { gridView1.SetRowCellValue(i, "FAmount1", SysConvert.ToDecimal(dtS.Rows[0]["FAmount1"])); // gridView1.SetRowCellValue(i, "FAmount2", SysConvert.ToDecimal(dtS.Rows[0]["FAmount2"])); // gridView1.SetRowCellValue(i, "FAmount3", SysConvert.ToDecimal(dtS.Rows[0]["FAmount3"])); // gridView1.SetRowCellValue(i, "FAmount4", SysConvert.ToDecimal(dtS.Rows[0]["FAmount4"])); // } } decimal DZQty = SysConvert.ToDecimal(dt.Rows[0]["DZQty"]); //对账数量 decimal DZAmount = SysConvert.ToDecimal(dt.Rows[0]["DZAmount"]); //对账金额 if (SysConvert.ToString(dt.Rows[0]["Qty"]) != string.Empty) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Qty"]));//出入库数量 if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { gridView1.SetRowCellValue(i, "DCheckQty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); gridView1.SetRowCellValue(i, "Qty", 0 - SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } else { gridView1.SetRowCellValue(i, "DCheckQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"]) - DZQty); } } if (SysConvert.ToString(dt.Rows[0]["SinglePrice"]) != string.Empty)//出入库单价 { gridView1.SetRowCellValue(i, "SinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); gridView1.SetRowCellValue(i, "DCheckSinglePrice", SysConvert.ToString(dt.Rows[0]["SinglePrice"])); } if (SysConvert.ToString(dt.Rows[0]["Amount"]) != string.Empty) //出入库金额 { gridView1.SetRowCellValue(i, "Amount", SysConvert.ToString(dt.Rows[0]["Amount"])); if (SysConvert.ToInt32(dt.Rows[0]["FormDZFlag"]) == (int)EnumDZFlag.对帐负) { gridView1.SetRowCellValue(i, "DCheckAmount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); gridView1.SetRowCellValue(i, "Amount", 0 - SysConvert.ToDecimal(dt.Rows[0]["Amount"])); } else { gridView1.SetRowCellValue(i, "DCheckAmount", SysConvert.ToDecimal(dt.Rows[0]["Amount"]) - DZAmount); } } if (SysConvert.ToString(dt.Rows[0]["PieceQty"]) != string.Empty)//匹数 { gridView1.SetRowCellValue(i, "PieceQty", SysConvert.ToString(dt.Rows[0]["PieceQty"])); } length++; } } }
/// <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 (chkOrderDate.Checked) { tempStr += " AND OrderDate BETWEEN " + SysString.ToDBString(txtOrderDateS.DateTime) + " AND " + SysString.ToDBString(txtOrderDateE.DateTime); } if (chkReqDate.Checked) { tempStr += " AND ReqDate BETWEEN " + SysString.ToDBString(txtReqDateS.DateTime) + " AND " + SysString.ToDBString(txtReqDateE.DateTime); } if (chkMakeDate.Checked) { tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtMakeDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != string.Empty) { tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)); } if (txtCustomerCode.Text.Trim() != string.Empty) { tempStr += " AND CustomerCode LIKE " + SysString.ToDBString("%" + txtCustomerCode.Text.Trim() + "%"); } if (SysConvert.ToString(drpOrderTypeID.EditValue) != string.Empty) { tempStr += " AND OrderTypeID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderTypeID.EditValue)); } if (SysConvert.ToString(drpOrderLevelID.EditValue) != string.Empty) { tempStr += " AND OrderLevelID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderLevelID.EditValue)); } if (txtItemCode.Text.Trim() != string.Empty) { tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } if (txtGoodsCode.Text.Trim() != string.Empty) { tempStr += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtColorNum.Text.Trim() != string.Empty) { tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtColorNum.Text.Trim() + "%"); } if (txtColorName.Text.Trim() != string.Empty) { tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtColorName.Text.Trim() + "%"); } if (txtMWeightS.Text.Trim() != string.Empty) { tempStr += " AND MWeight>" + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightS.Text.Trim())); } if (txtMWeightE.Text.Trim() != string.Empty) { tempStr += " AND MWeight<" + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightE.Text.Trim())); } if (txtMWidth.Text.Trim() != string.Empty) { tempStr += " AND MWidth=" + SysString.ToDBString(txtMWidth.Text.Trim()); } if (txtItemName.Text.Trim() != string.Empty) { tempStr += " AND ItemName LIKE " + SysString.ToDBString("%" + txtItemName.Text.Trim() + "%"); } if (txtVColorNum.Text.Trim() != string.Empty) { tempStr += " AND VColorNum LIKE " + SysString.ToDBString("%" + txtVColorNum.Text.Trim() + "%"); } if (txtVColorName.Text.Trim() != string.Empty) { tempStr += " AND VColorName LIKE " + SysString.ToDBString("%" + txtVColorName.Text.Trim() + "%"); } if (chkSubmitFlag.Checked) { tempStr += " AND SubmitFlag=1"; } if (txtItemModel.Text.Trim() != "") { tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.Text.Trim() + "%"); } //if (txtItemVendorID.Text.Trim() != "") //{ // tempStr += " AND ItemCode IN (SELECT ItemCode FROM Data_Item WHERE VendorID LIKE" + SysString.ToDBString("%" + txtItemVendorID.Text.Trim() + "%") + ")" ; //} //if (chkNOSK.Checked) //{ // tempStr += " AND FormNo+ItemCode NOT IN(SELECT ISNULL(HTNO+HTItemCode,'') FROM Finance_RecPayHTDts)"; //} //if (chkSK.Checked) //{ // tempStr += " AND FormNo+ItemCode IN(SELECT ISNULL(HTNO+HTItemCode,'') FROM Finance_RecPayHTDts)"; //} if (!Common.CheckLookUpEditBlank(drpSaleOPID)) { tempStr += " AND SaleOPID=" + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue)); //tempStr += " AND VendorID IN (SELECT VendorID FROM Data_Vendor WHERE InSaleOP="+SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue))+" )"; } if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5430)) && !FParamConfig.LoginHTFlag)//销售订单业务员只查看自己的的订单 { tempStr += " AND SaleOPID IN(" + WCommon.GetStructureMemberOPStr() + ")"; } if (ProductParamSet.GetIntValueByID(5421) == (int)YesOrNo.Yes)//内销外销 { tempStr += " AND ISNULL(FAID,0)=1"; } if (chkNoShow.Checked) { tempStr += " AND ISNULL(Qty,0)*0.8>ISNULL(TotalRecQty,0)"; } //if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.审核2)) //{ // tempStr += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(FParamConfig.LoginID) + ")"; //} HTDataConditionStr = tempStr; }
/// <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 (txtVendorAttn.Text.Trim() != string.Empty) { tempStr += " AND VendorAttn LIKE " + SysString.ToDBString("%" + txtVendorAttn.Text.Trim() + "%"); } if (txtSaleOPName.Text.Trim() != string.Empty) { tempStr += " AND SaleOPName LIKE " + SysString.ToDBString("%" + txtSaleOPName.Text.Trim() + "%"); } if (chkOrderDate.Checked) { tempStr += " AND OrderDate BETWEEN " + SysString.ToDBString(txtOrderDateS.DateTime) + " AND " + SysString.ToDBString(txtOrderDateE.DateTime); } if (chkReqDate.Checked) { tempStr += " AND ReqDate BETWEEN " + SysString.ToDBString(txtReqDateS.DateTime) + " AND " + SysString.ToDBString(txtReqDateE.DateTime); } if (chkMakeDate.Checked) { tempStr += " AND MakeDate BETWEEN " + SysString.ToDBString(txtMakeDateS.DateTime) + " AND " + SysString.ToDBString(txtMakeDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != string.Empty) { tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)); } if (txtCustomerCode.Text.Trim() != string.Empty) { tempStr += " AND CustomerCode LIKE " + SysString.ToDBString("%" + txtCustomerCode.Text.Trim() + "%"); } if (SysConvert.ToString(drpOrderTypeID.EditValue) != string.Empty) { tempStr += " AND OrderTypeID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderTypeID.EditValue)); } if (SysConvert.ToString(drpOrderLevelID.EditValue) != string.Empty) { tempStr += " AND OrderLevelID=" + SysString.ToDBString(SysConvert.ToInt32(drpOrderLevelID.EditValue)); } if (txtItemCode.Text.Trim() != string.Empty) { tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } if (txtGoodsCode.Text.Trim() != string.Empty) { tempStr += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtColorNum.Text.Trim() != string.Empty) { tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtColorNum.Text.Trim() + "%"); } if (txtColorName.Text.Trim() != string.Empty) { tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtColorName.Text.Trim() + "%"); } if (txtMWeightS.Text.Trim() != string.Empty) { tempStr += " AND MWeight>" + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightS.Text.Trim())); } if (txtMWeightE.Text.Trim() != string.Empty) { tempStr += " AND MWeight<" + SysString.ToDBString(SysConvert.ToDecimal(txtMWeightE.Text.Trim())); } if (txtMWidth.Text.Trim() != string.Empty) { tempStr += " AND MWidth=" + SysString.ToDBString(txtMWidth.Text.Trim()); } if (txtItemModel.Text.Trim() != string.Empty) { tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.Text.Trim() + "%"); } if (txtVColorNum.Text.Trim() != string.Empty) { tempStr += " AND VColorNum LIKE " + SysString.ToDBString("%" + txtVColorNum.Text.Trim() + "%"); } if (txtVColorName.Text.Trim() != string.Empty) { tempStr += " AND VColorName LIKE " + SysString.ToDBString("%" + txtVColorName.Text.Trim() + "%"); } if (chkSubmitFlag.Checked) { tempStr += " AND SubmitFlag=1"; } 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 (chkNoShow.Checked) { tempStr += " AND ISNULL(Qty,0)*0.8>ISNULL(TotalRecQty,0)"; } //if (ProductParamSet.GetIntValueByID(5421) == (int)YesOrNo.Yes)//内销外销 //{ tempStr += " AND ISNULL(FAID,0)=1"; // } HTDataConditionStr = tempStr; }