/// <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() != 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> /// 绑定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> /// 查询条件 /// </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> /// 绑定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; }
/// <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; }
/// <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; }