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