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