/// <summary>
/// 处理数据源欠数
/// </summary>
/// <param name="dt"></param>
void ProcDataSourceQty(DataTable dt)
{
foreach (DataRow dr in dt.Rows)
{
dr["RemainQty"] = SysConvert.ToDecimal(dr["Qty"]) - SysConvert.ToDecimal(dr["TotalRecQty"]);
if (SysConvert.ToDecimal(dr["Qty"]) != 0)
{
dr["RemainRate"] = SysConvert.ToDecimal(SysConvert.ToDecimal(dr["RemainQty"]) / SysConvert.ToDecimal(dr["Qty"]), 3);
}
}
}
/// <summary>
/// 获得ItemClass字符串
/// </summary>
private void drpItemClass_EditValueChanged(object sender, System.EventArgs e)
{
try
{
//DataTable dt = SysUtils.Fill("exec USP1_Data_ItemClass_SubClass " + SysString.ToDBString(SaveItemClassID));
DataTable dt = SysUtils.Fill("exec USP1_Data_ItemClass_SubClass " + SysString.ToDBString(SysConvert.ToString(drpQItemClass.EditValue)));
if (dt.Rows.Count != 0)
{
ItemClassArray = dt.Rows[0][0].ToString();
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
try
{
if (SysConvert.ToString(drpQVendorID.EditValue) == "")
{
this.ShowMessage("请选择往来单位查询");
return;
}
decimal TotalQC = 0.0m;
decimal TotalInvoiceQC = 0.0m;
decimal QCAmount = 0.0m; //期初金额
decimal SQSaleAmount = 0.0m; //销售金额
decimal SQRecAmount = 0.0m; //收款金额
decimal SQInvoiceAmount = 0.0m;
decimal SQHKAmount = 0.0m; //期初货款处理
string sql = "Select SUM(BAmount) QCAmount ";
sql += " from Finance_BVendorAmount where 1=1";
sql += HTDataConditionStr;
DataTable dt3 = SysUtils.Fill(sql);
if (dt3.Rows.Count != 0)
{
QCAmount = SysConvert.ToDecimal(dt3.Rows[0]["QCAmount"]);
}
sql = "Select SUM(DZAmount) Amount";//对账金额
sql += " from UV1_WH_IOFOrmDts where 1=1";
if (FormListAID == 1)
{
sql += " AND ISNULL(BuyFlag,0)=1";
}
if (FormListAID == 2)
{
sql += " AND ISNULL(ColorFlag,0)=1";
}
if (FormListAID == 3)
{
sql += " AND ISNULL(SaleFlag,0)=1";
}
sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交
sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND formdate <" + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd"));
}
DataTable dt1 = SysUtils.Fill(sql);
if (dt1.Rows.Count != 0)
{
SQSaleAmount = SysConvert.ToDecimal(dt1.Rows[0]["Amount"]);
}
sql = " Select SUM(TotalAmount) InvoiceAmount";
sql += " from Finance_InvoiceOperation where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND MakeDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd"));
}
dt1 = SysUtils.Fill(sql);
if (dt1.Rows.Count != 0)
{
SQInvoiceAmount = SysConvert.ToDecimal(dt1.Rows[0]["InvoiceAmount"]);
}
sql = "Select Sum(ExAmount) RecAmount";
sql += " from Finance_RecPay where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND ExDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd"));
}
DataTable dt2 = SysUtils.Fill(sql);
if (dt2.Rows.Count != 0)
{
SQRecAmount = SysConvert.ToDecimal(dt2.Rows[0]["RecAmount"]);
}
///货款处理信息
sql = " Select SUM(Amount) ExAmount";
sql += " from Finance_PaymentHandle where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd"));
}
dt2 = SysUtils.Fill(sql);
if (dt2.Rows.Count != 0)
{
SQHKAmount = SysConvert.ToDecimal(dt2.Rows[0]["ExAmount"]);
}
TotalQC = QCAmount + SQSaleAmount - SQRecAmount - SQHKAmount;
TotalInvoiceQC = QCAmount + SQSaleAmount - SQInvoiceAmount;
//sql = "Select ID,Seq,WHNM,FormDate,'销售' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,Qty,SinglePrice,DZAmount Amount,0.0 RecAmount,0.0 LeftAmount1,0.0 LeftAmount2";//对账金额
//sql += " from UV1_WH_IOFOrmDts where 1=1";
#region FormListAID ==1
if (FormListAID == 1)
{
sql = "Select ID,Seq,WHNM,FormDate,'采购' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,'' Remark,Qty,DZSinglePrice AS SinglePrice,";
//sql += " Amount= Case when ISNULL(DZAmount,0)=0 then Amount";
//sql += " When ISNULL(DZAmount,0)<>0 then DZAmount end";
sql += " DZAmount Amount";
sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额
sql += " from UV1_WH_IOFOrmDts where 1=1";
sql += " AND ISNULL(BuyFlag,0)=1";
sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交
sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,ExDate ASFormDate,'付款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_RecPay where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_InvoiceOperation where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
///货款信息
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_PaymentHandle where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
//sql += " Order BY FormDate";
}
#endregion
#region FormListAID ==2
if (FormListAID == 2)
{
sql = "Select ID,Seq,WHNM,FormDate,'加工' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,'' Remark,Qty,DZSinglePrice AS SinglePrice,";
//sql += " Amount= Case when ISNULL(DZAmount,0)=0 then Amount";
//sql += " When ISNULL(DZAmount,0)<>0 then DZAmount end";
sql += " DZAmount Amount";
sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额
sql += " from UV1_WH_IOFOrmDts where 1=1";
sql += " AND ISNULL(ColorFlag,0)=1";
sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交
sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,ExDate ASFormDate,'付款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_RecPay where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_InvoiceOperation where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
///货款信息
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_PaymentHandle where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
// sql += " Order BY FormDate";
}
#endregion
#region FormListAID ==3
if (FormListAID == 3)
{
//替换之前的CompanyTypeName
//sql = "Select ID,Seq,WHNM,FormDate,'销售' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,Qty,SinglePrice,Amount,0.0 RecAmount,0.0 LeftAmount1,0.0 LeftAmount2";//对账金额
//sql += " from UV1_WH_IOFOrmDts where 1=1";
//sql += " AND ISNULL(SaleFlag,0)=1";
//sql += " AND ISNULL(SubmitFlag,0)=1";//已提交
if (this.FormListBID == 1)
{
sql = "Select distinct(ID),1 Seq,WHNM,FormDate,";
sql += " FormTypeName= Case when FormDZFlag=1 then '销售'";
sql += "When FormDZFlag=2 then '退货' end ,ItemCode,ItemName,ItemStd,ItemModel,Unit,";
sql += "' 合同号:'";
sql += "+DtsOrderFormNo+";
sql += "' 开票金额:'+CONVERT(nvarchar(50),InvoiceAmount) Remark,DZQty Qty,DZSinglePrice as SinglePrice,";
sql += "Amount= Case When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount ";
sql += "When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount ";
sql += "end ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from UV1_WH_IOFOrmDts2 where 1=1";
sql += "AND ISNULL(SaleFlag,0)=1";
sql += "AND ISNULL(SubmitFlag,0)=1";
sql += "AND ISNULL(DZFlag,0)=1";
}
else
{
sql = "Select ID,Seq,WHNM,FormDate,";
sql += " FormTypeName= Case when FormDZFlag=1 then '销售'";
sql += " When FormDZFlag=2 then '退货' end";
sql += " ,ItemCode,ItemName,ItemStd,ItemModel,Unit,";
sql += " '发票号:'+DtsInvoiceNo+' 合同号:'+DtsOrderFormNo+' 开票日期:'+CONVERT(nvarchar(50), DtsInvoiceDelTime,102 )+' 开票金额:'+CONVERT(nvarchar(50),InvoiceAmount) Remark,";//备注显示发票号、发票金额
sql += " Qty,DZSinglePrice as SinglePrice,";
//sql += " Amount= Case when FormDZFlag=1 AND ISNULL(DZAmount,0)=0 then Amount";
//sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)=0 then 0-Amount ";
//sql += " When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount ";
//sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount ";
//sql+=" end";
sql += " Amount= Case When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount ";
sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount ";
sql += " end";
sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额
sql += " from UV1_WH_IOFOrmDts where 1=1";
sql += " AND ISNULL(SaleFlag,0)=1";
sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交
sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据
}
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,ExDate AS FormDate,'收款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_RecPay where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
///开票信息
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_InvoiceOperation where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
///货款信息
sql += " UNION";
sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,";
sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,";
sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";
sql += " from Finance_PaymentHandle where 1=1";
sql += HTDataConditionStr;
if (chkINDate.Checked)
{
sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
//sql += " Order BY FormDate";
}
#endregion
DataTable dt = SysUtils.Fill(sql);
DataRow dr = dt.NewRow();
if (TotalQC >= 0)
{
dr["LeftAmount1"] = TotalQC;
}
else
{
dr["LeftAmount2"] = 0 - TotalQC;
}
dr["LeftAmount3"] = TotalInvoiceQC;;
//dr["LeftAmount"] = TotalQC;
dr["FormTypeName"] = "期初余额";
dr["FormDate"] = txtQIndateS.DateTime.Date.AddDays(-1);
dr["ID"] = "-1";
dr["Seq"] = "-1";
dt.Rows.Add(dr);
//dt.DefaultView.Sort = " FormDate ASC";
DataRow[] rows = dt.Select("", "FormDate asc");
DataTable t = dt.Clone();
t.Clear();
foreach (DataRow row in rows)
{
t.ImportRow(row);
}
dt = t;
ProductAmount(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
gridView1.OptionsCustomization.AllowFilter = false;
gridView1.OptionsCustomization.AllowSort = false;
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
string sql = "SELECT '采购' KPName,* FROM UV1_WH_IOFormDts WHERE 1=1";
sql += " AND SubmitFlag=1";
sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZFlag=" + (int)EnumDZFlag.对帐正 + ")";
sql += " AND VendorID=" + SysString.ToDBString(m_VendorID);
sql += " AND FormDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee);
sql += " AND DtsID NOT IN(SELECT ISNULL(DLOADDtsID,0) FROM UV1_Finance_InvoiceOperationDts WHERE SubmitFlag=1)";
DataTable dt3 = SysUtils.Fill(sql);
foreach (DataRow dr in dt3.Rows)
{
dr["Qty"] = SysConvert.ToDecimal(dr["Qty"]) + SysConvert.ToDecimal(dr["YQQty"]);
dr["Amount"] = SysConvert.ToDecimal(dr["Qty"]) * SysConvert.ToDecimal(dr["SinglePrice"]);
}
sql = "SELECT * FROM UV1_WH_IOFormDts WHERE 1=1";
sql += " AND SubmitFlag=1";
sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZFlag=" + (int)EnumDZFlag.对帐负 + ")";
sql += " AND VendorID=" + SysString.ToDBString(m_VendorID);
sql += " AND FormDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee);
sql += " AND DtsID NOT IN(SELECT ISNULL(DLOADDtsID,0) FROM UV1_Finance_InvoiceOperationDts WHERE SubmitFlag=1)";
DataTable dt4 = SysUtils.Fill(sql);
for (int i = 0; i < dt4.Rows.Count; i++)
{
DataRow dr = dt3.NewRow();
dr["KPName"] = "采购退货";
dr["FormDate"] = dt4.Rows[i]["FormDate"];
dr["ItemCode"] = dt4.Rows[i]["ItemCode"];
dr["SinglePrice"] = dt4.Rows[i]["SinglePrice"];
dr["GoodsCode"] = dt4.Rows[i]["GoodsCode"];
dr["Qty"] = 0 - SysConvert.ToDecimal(dt4.Rows[i]["Qty"]) - SysConvert.ToDecimal(dt4.Rows[i]["YQQty"]);
dr["Amount"] = SysConvert.ToDecimal(dr["Qty"]) * SysConvert.ToDecimal(dr["SinglePrice"]);
dt3.Rows.Add(dr);
}
sql = "SELECT KPName,MakeDate,ItemCode,GoodsCode,Qty,Amount,SinglePrice from UV1_Finance_InvoiceYOperationDts WHERE SubmitFlag=1 ";
sql += " AND KPType=" + (int)EnumKPType.预开票;
sql += " AND VendorID=" + SysString.ToDBString(m_VendorID);
sql += " AND MakeDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee);
sql += " AND DtsID NOT IN (SELECT ISNULL(DLOADID,0) FROM UV2_Finance_InvoiceOperationDts WHERE DLOADNO='预开票')";
DataTable dt5 = SysUtils.Fill(sql);
for (int j = 0; j < dt5.Rows.Count; j++)
{
DataRow dr = dt3.NewRow();
dr["KPName"] = "预开票";
dr["FormDate"] = dt5.Rows[j]["MakeDate"];
dr["ItemCode"] = dt5.Rows[j]["ItemCode"];
dr["GoodsCode"] = dt5.Rows[j]["GoodsCode"];
dr["SinglePrice"] = dt5.Rows[j]["SinglePrice"];
dr["Qty"] = 0 - SysConvert.ToDecimal(dt5.Rows[j]["Qty"]);
dr["Amount"] = 0 - SysConvert.ToDecimal(dt5.Rows[j]["Amount"]);
dt3.Rows.Add(dr);
}
DataView dv = dt3.DefaultView;
dv.Sort = "FormDate Asc";
DataTable dto = dv.ToTable();
gridView1.GridControl.DataSource = dto;
gridView1.GridControl.Show();
}
/// <summary>
/// 按传入的SQL语句查询后给属性赋值
/// </summary>
/// <param name="p_Sql">SQL语句</param>
/// <returns>记录存在回true，不存在返回false</returns>
protected override bool Select(string p_Sql)
{
DataTable MasterTable=new DataTable();
if(!this.sqlTransFlag)
{
MasterTable=this.Fill(p_Sql);
}
else
{
MasterTable=sqlTrans.Fill(p_Sql);
}
if (MasterTable.Rows.Count>0)
{
//查询主表记录
m_ID=SysConvert.ToInt32(MasterTable.Rows[0]["ID"]);
m_FormNo=SysConvert.ToString(MasterTable.Rows[0]["FormNo"]);
m_SFormNo=SysConvert.ToString(MasterTable.Rows[0]["SFormNo"]);
m_FormDate=SysConvert.ToDateTime(MasterTable.Rows[0]["FormDate"]);
m_SampleType=SysConvert.ToInt32(MasterTable.Rows[0]["SampleType"]);
m_SOType=SysConvert.ToInt32(MasterTable.Rows[0]["SOType"]);
m_FactoryID=SysConvert.ToString(MasterTable.Rows[0]["FactoryID"]);
m_ReqDate=SysConvert.ToDateTime(MasterTable.Rows[0]["ReqDate"]);
m_SaleOPID=SysConvert.ToString(MasterTable.Rows[0]["SaleOPID"]);
m_PBItemCode=SysConvert.ToString(MasterTable.Rows[0]["PBItemCode"]);
m_PBDensity=SysConvert.ToString(MasterTable.Rows[0]["PBDensity"]);
m_PBMWidth=SysConvert.ToString(MasterTable.Rows[0]["PBMWidth"]);
m_PBMWeight=SysConvert.ToString(MasterTable.Rows[0]["PBMWeight"]);
m_FactoryID2=SysConvert.ToString(MasterTable.Rows[0]["FactoryID2"]);
m_CPItemCode=SysConvert.ToString(MasterTable.Rows[0]["CPItemCode"]);
m_CPDensity=SysConvert.ToString(MasterTable.Rows[0]["CPDensity"]);
m_CPMWidth=SysConvert.ToString(MasterTable.Rows[0]["CPMWidth"]);
m_CPMWeight=SysConvert.ToString(MasterTable.Rows[0]["CPMWeight"]);
m_FactoryID3=SysConvert.ToString(MasterTable.Rows[0]["FactoryID3"]);
m_LightSource=SysConvert.ToString(MasterTable.Rows[0]["LightSource"]);
m_PrintingMethod=SysConvert.ToString(MasterTable.Rows[0]["PrintingMethod"]);
m_TecReq=SysConvert.ToString(MasterTable.Rows[0]["TecReq"]);
m_PBQty=SysConvert.ToDecimal(MasterTable.Rows[0]["PBQty"]);
m_BCPSampleQty=SysConvert.ToDecimal(MasterTable.Rows[0]["BCPSampleQty"]);
m_PBSampleQty=SysConvert.ToDecimal(MasterTable.Rows[0]["PBSampleQty"]);
m_MakeOPID=SysConvert.ToString(MasterTable.Rows[0]["MakeOPID"]);
m_MakeOPName=SysConvert.ToString(MasterTable.Rows[0]["MakeOPName"]);
m_MakeDate=SysConvert.ToDateTime(MasterTable.Rows[0]["MakeDate"]);
m_SubmitFlag=SysConvert.ToInt32(MasterTable.Rows[0]["SubmitFlag"]);
m_SubmitOPID=SysConvert.ToString(MasterTable.Rows[0]["SubmitOPID"]);
m_SubmitTime=SysConvert.ToDateTime(MasterTable.Rows[0]["SubmitTime"]);
m_DelFlag=SysConvert.ToInt32(MasterTable.Rows[0]["DelFlag"]);
m_Remark=SysConvert.ToString(MasterTable.Rows[0]["Remark"]);
m_CPItemName=SysConvert.ToString(MasterTable.Rows[0]["CPItemName"]);
m_CPItemStd=SysConvert.ToString(MasterTable.Rows[0]["CPItemStd"]);
m_VendorOPID=SysConvert.ToString(MasterTable.Rows[0]["VendorOPID"]);
m_GenDan=SysConvert.ToString(MasterTable.Rows[0]["GenDan"]);
m_SO=SysConvert.ToString(MasterTable.Rows[0]["SO"]);
m_LightSource2=SysConvert.ToString(MasterTable.Rows[0]["LightSource2"]);
m_LightSource3=SysConvert.ToString(MasterTable.Rows[0]["LightSource3"]);
m_AllMWidth=SysConvert.ToString(MasterTable.Rows[0]["AllMWidth"]);
MasterTable.Dispose();
return true;
}
else
{
MasterTable.Dispose();
return false;
}
}
/// <summary>
/// 新增(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RAdd(int p_ID, string p_IDStr, IDBTransAccess sqlTrans)
{
try
{
string sql = "SELECT SectionID,JarNum,Batch FROM WH_PackBox WHERE ID IN (" + p_IDStr + ")";
sql += " GROUP BY SectionID,JarNum,Batch";
DataTable dt = sqlTrans.Fill(sql);
int MaxSeq = GetMaxSeq(p_ID);
decimal Qty = 0;
IOFormDtsRule rule = new IOFormDtsRule();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i == 0)//第一行更新
{
sql = "SELECT * FROM WH_PackBox WHERE ID IN (" + p_IDStr + ")";
sql += " AND SectionID=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["SectionID"]));
sql += " AND JarNum=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["JarNum"]));
sql += " AND Batch=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["Batch"]));
DataTable dtsql = sqlTrans.Fill(sql);
IOFormDts entitydts = new IOFormDts(sqlTrans);
entitydts.ID = p_ID;
entitydts.SelectByID();
entitydts.SectionID = SysConvert.ToString(dt.Rows[i]["SectionID"]);
entitydts.JarNum = SysConvert.ToString(dt.Rows[i]["JarNum"]);
entitydts.Batch = SysConvert.ToString(dt.Rows[i]["Batch"]);
entitydts.Qty = SysConvert.ToDecimal(dtsql.Compute("SUM(Qty)", ""));
entitydts.PieceQty = dtsql.Rows.Count;
entitydts.PackFlag = 1;
entitydts.Amount = entitydts.Qty * entitydts.SinglePrice;
rule.RUpdate(entitydts, sqlTrans);
IOFormDtsPackRule prule = new IOFormDtsPackRule();
sql = "DELETE WH_IOFormDtsPack WHERE MainID=" + SysString.ToDBString(entitydts.MainID);
sql += " AND Seq=" + SysString.ToDBString(entitydts.Seq);
sqlTrans.ExecuteNonQuery(sql);
for (int j = 0; j < dtsql.Rows.Count; j++)
{
IOFormDtsPack pentity = new IOFormDtsPack(sqlTrans);
pentity.MainID = entitydts.MainID;
pentity.Seq = entitydts.Seq;
pentity.SubSeq = j + 1;
pentity.BoxNo = SysConvert.ToString(dtsql.Rows[j]["BoxNo"]);
pentity.Qty = SysConvert.ToDecimal(dtsql.Rows[j]["Qty"]);
pentity.DID = entitydts.ID;
prule.RAdd(pentity, sqlTrans);
}
}
else
{
sql = "SELECT * FROM WH_PackBox WHERE ID IN (" + p_IDStr + ")";
sql += " AND SectionID=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["SectionID"]));
sql += " AND JarNum=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["JarNum"]));
sql += " AND Batch=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[i]["Batch"]));
DataTable dtsql = sqlTrans.Fill(sql);
IOFormDts entitydts = new IOFormDts(sqlTrans);
entitydts.ID = p_ID;
entitydts.SelectByID();
entitydts.Seq = MaxSeq + i;
entitydts.SectionID = SysConvert.ToString(dt.Rows[i]["SectionID"]);
entitydts.JarNum = SysConvert.ToString(dt.Rows[i]["JarNum"]);
entitydts.Batch = SysConvert.ToString(dt.Rows[i]["Batch"]);
entitydts.Qty = SysConvert.ToDecimal(dtsql.Compute("SUM(Qty)", ""));
entitydts.PieceQty = dtsql.Rows.Count;
entitydts.PackFlag = 1;
entitydts.Amount = entitydts.Qty * entitydts.SinglePrice;
sql = "SELECT ID FROM WH_IOFormDts WHERE MainID=" + SysString.ToDBString(entitydts.MainID);
sql += " AND Seq=" + SysString.ToDBString(entitydts.Seq);
if (sqlTrans.Fill(sql).Rows.Count > 0)
{
throw new BaseException("不能增行，该行已存在");
}
rule.RAdd(entitydts, sqlTrans);
IOFormDtsPackRule prule = new IOFormDtsPackRule();
sql = "DELETE WH_IOFormDtsPack WHERE MainID=" + SysString.ToDBString(entitydts.MainID);
sql += " AND Seq=" + SysString.ToDBString(entitydts.Seq);
sqlTrans.ExecuteNonQuery(sql);
for (int j = 0; j < dtsql.Rows.Count; j++)
{
IOFormDtsPack pentity = new IOFormDtsPack(sqlTrans);
pentity.MainID = entitydts.MainID;
pentity.Seq = entitydts.Seq;
pentity.SubSeq = j + 1;
pentity.BoxNo = SysConvert.ToString(dtsql.Rows[j]["BoxNo"]);
pentity.Qty = SysConvert.ToDecimal(dtsql.Rows[j]["Qty"]);
pentity.DID = entitydts.ID;
prule.RAdd(pentity, sqlTrans);
}
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
public void RSave(CheckOperation p_Entity, BaseEntity[] p_BE, BaseEntity[] p_BE2, BaseEntity[] p_BE3, IDBTransAccess sqlTrans)
{
try
{
string sql = "DELETE FROM Finance_CheckOperationDts WHERE MainID=" + p_Entity.ID.ToString();
sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist(p_BE));
sqlTrans.ExecuteNonQuery(sql); //删除原单据里应该删除的明细数据，即数据库里有但是UI里已经删除的数据
sql = "SELECT ISNULL(MAX(Seq),0)+1 As MSEQ FROM Finance_CheckOperationDts WHERE MainID=" + p_Entity.ID.ToString(); ////找到最大的Seq 将获得最大Seq的语句放到循环外更高效(多人操作时会有问题吗?)
int MSEQ = SysConvert.ToInt32(sqlTrans.Fill(sql).Rows[0][0].ToString());
for (int i = 0; i < p_BE.Length; i++)
{
CheckOperationDts entitydts = (CheckOperationDts)p_BE[i];
if (entitydts.ID != 0)//ID不为0说明数据库中已经存在
{
this.RUpdate(entitydts, sqlTrans);
}
else
{
entitydts.Seq = MSEQ;
entitydts.MainID = p_Entity.ID;
this.RAdd(entitydts, sqlTrans);
MSEQ++;//最大值加1
}
}
sql = "DELETE FROM Finance_CheckOperationInvDts WHERE MainID=" + p_Entity.ID.ToString();
sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist2(p_BE2));
sqlTrans.ExecuteNonQuery(sql); //删除原单据里应该删除的明细数据，即数据库里有但是UI里已经删除的数据
sql = "SELECT ISNULL(MAX(Seq),0)+1 As MSEQ FROM Finance_CheckOperationInvDts WHERE MainID=" + p_Entity.ID.ToString(); ////找到最大的Seq 将获得最大Seq的语句放到循环外更高效(多人操作时会有问题吗?)
MSEQ = SysConvert.ToInt32(sqlTrans.Fill(sql).Rows[0][0].ToString());
for (int i = 0; i < p_BE2.Length; i++)
{
CheckOperationInvDtsRule rule2 = new CheckOperationInvDtsRule();
CheckOperationInvDts entityInvDts = (CheckOperationInvDts)p_BE2[i];
if (entityInvDts.ID != 0)//ID不为0说明数据库中已经存在
{
rule2.RUpdate(entityInvDts, sqlTrans);
}
else
{
entityInvDts.Seq = MSEQ;
entityInvDts.MainID = p_Entity.ID;
rule2.RAdd(entityInvDts, sqlTrans);
MSEQ++;//最大值加1
}
}
sql = "DELETE FROM Finance_CheckOperationPayDts WHERE MainID=" + p_Entity.ID.ToString();
sql += " AND ID NOT IN" + string.Format("({0})", GetIDExist3(p_BE3));
sqlTrans.ExecuteNonQuery(sql); //删除原单据里应该删除的明细数据，即数据库里有但是UI里已经删除的数据
sql = "SELECT ISNULL(MAX(Seq),0)+1 As MSEQ FROM Finance_CheckOperationPayDts WHERE MainID=" + p_Entity.ID.ToString(); ////找到最大的Seq 将获得最大Seq的语句放到循环外更高效(多人操作时会有问题吗?)
MSEQ = SysConvert.ToInt32(sqlTrans.Fill(sql).Rows[0][0].ToString());
for (int i = 0; i < p_BE3.Length; i++)
{
CheckOperationPayDtsRule rule3 = new CheckOperationPayDtsRule();
CheckOperationPayDts entityPayDts = (CheckOperationPayDts)p_BE3[i];
if (entityPayDts.ID != 0)//ID不为0说明数据库中已经存在
{
rule3.RUpdate(entityPayDts, sqlTrans);
}
else
{
entityPayDts.Seq = MSEQ;
entityPayDts.MainID = p_Entity.ID;
rule3.RAdd(entityPayDts, sqlTrans);
MSEQ++;//最大值加1
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
///保存分色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btnSaveColor_Click(object sender, EventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
for (int i = 0; i < gridView2.RowCount; i++)
{
int p_ID = SysConvert.ToInt32(gridView2.GetRowCellValue(i, "ID"));
string sql = "Update WH_PackBox set SplitColor=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "SplitColor")));
sql += ",MiddleDiff=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "MiddleDiff")));
sql += ",HeadTailDiff=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "HeadTailDiff")));
sql += ",ReHandle=" + SysString.ToDBString(SysConvert.ToString(gridView2.GetRowCellValue(i, "ReHandle")));
sql += " where ID=" + p_ID;
SysUtils.ExecuteNonQuery(sql);
}
this.ShowInfoMessage("保存成功");
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 单据类型改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void drpSubType_EditValueChanged(object sender, EventArgs e)
{
try
{
txtFormNo_DoubleClick(null, null);
Common.BindVendorByFormListID(drpVendorID, SysConvert.ToInt32(drpSubType.EditValue), true);//设置客户
string sql = "SELECT * FROM Enum_FormList WHERE ID=" + SysString.ToDBString(SysConvert.ToInt32(drpSubType.EditValue));
DataTable dt = SysUtils.Fill(sql);
if (dt.Rows.Count != 0)
{
saveLoadFormType = SysConvert.ToInt32(dt.Rows[0]["LoadFormTypeID"].ToString());
saveTHLoadFormListIDStr = dt.Rows[0]["THLoadFormListIDStr"].ToString();
string VendorCaption = dt.Rows[0]["VendorIDCaption"].ToString();
if (VendorCaption != string.Empty)
{
labVendorID.Text = VendorCaption;
drpVendorID.ToolTip = VendorCaption;
}
}
else
{
saveLoadFormType = 0; //清空加载类型
saveTHLoadFormListIDStr = string.Empty; //清空加载默认条件
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
///通用 重新设置实体
///
/// </summary>
public override void gridViewRowChanged1(object sender)
{
try
{
//SysFile.WriteFrameworkLog("A3");
this.BaseFocusLabel.Focus();
ColumnView view = sender as ColumnView;
string whid = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "WHID"));
string ItemCode = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ItemCode"));
string ColorNum = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorNum"));
string ColorName = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorName"));
string Batch = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "Batch"));
string VendorBatch = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "VendorBatch"));
string VendorID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "VendorID"));
string SectionID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "SectionID"));
string JarNum = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "JarNum"));
string DtsSO = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "SO"));
string ItemUnit = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "Unit"));
decimal MWidth = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWidth"));
decimal MWeight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWeight"));
#region 查找仓库结算类型
string sql = "SELECT FieldName FROM UV1_WH_WH WHERE WHID=" + SysString.ToDBString(whid);//获得仓库结算类型字段
DataTable dt = SysUtils.Fill(sql);
string FieldNamestr = string.Empty;
if (dt.Rows.Count != 0)
{
FieldNamestr += SysConvert.ToString(dt.Rows[0]["FieldName"]);
}
#endregion
sql = "SELECT * FROM WH_PackBox WHERE 1=1";
sql += " AND WHID=" + SysString.ToDBString(whid);
sql += " AND SectionID=" + SysString.ToDBString(SectionID);
int CalFieldName = (int)WHCalMethodFieldName.ItemCode;
if (FieldNamestr != string.Empty)
{
string[] FieldName = FieldNamestr.Split('+');
for (int i = 0; i < FieldName.Length; i++)
{
string sqlFieldName = "SELECT ID FROM Enum_WHCalMethodFieldName WHERE Name=" + SysString.ToDBString(FieldName[i]);//找到库存结算字段对应的ID
DataTable dtFieldName = SysUtils.Fill(sqlFieldName);
if (dtFieldName.Rows.Count != 0 && dtFieldName.Rows[0]["ID"].ToString() != "")
{
CalFieldName = SysConvert.ToInt32(dtFieldName.Rows[0]["ID"]);
}
switch (CalFieldName)
{
case (int)WHCalMethodFieldName.ItemCode: //产品编码
sql += " AND ISNULL(ItemCode,'')=" + SysString.ToDBString(ItemCode);
break;
case (int)WHCalMethodFieldName.ColorNum: //色号
sql += " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(ColorNum);
break;
case (int)WHCalMethodFieldName.ColorName: //颜色
sql += " AND ISNULL(ColorName,'')=" + SysString.ToDBString(ColorName);
break;
case (int)WHCalMethodFieldName.Batch: //批号
sql += " AND ISNULL(Batch,'')=" + SysString.ToDBString(Batch);
break;
case (int)WHCalMethodFieldName.VendorBatch: //客户批号
sql += " AND ISNULL(VendorBatch,'')=" + SysString.ToDBString(VendorBatch);
break;
case (int)WHCalMethodFieldName.VendorID: //客户
sql += " AND ISNULL(DtsVendorID,'')=" + SysString.ToDBString(VendorID);
break;
case (int)WHCalMethodFieldName.JarNum: //缸号
sql += " AND ISNULL(JarNum,'')=" + SysString.ToDBString(JarNum);
break;
case (int)WHCalMethodFieldName.Unit: //缸号
sql += " AND ISNULL(Unit,'')=" + SysString.ToDBString(ItemUnit);
break;
case (int)WHCalMethodFieldName.MWidth: //门幅
sql += " AND ISNULL(MWidth,0)=" + SysString.ToDBString(MWidth);
break;
case (int)WHCalMethodFieldName.MWeight: //克重
sql += " AND ISNULL(MWeight,0)=" + SysString.ToDBString(MWeight);
break;
default:
throw new Exception("结算异常，结算定义的字段底层未对应：" + CalFieldName + ",请联系管理员");
}
}
}
sql += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库);
sql += " AND ISNULL(Qty,0)>0";
DataTable dt1 = SysUtils.Fill(sql);
gridView2.GridControl.DataSource = dt1;
gridView2.GridControl.Show();
//SysFile.WriteFrameworkLog("A4");
gridView2.Columns["ReHandle"].OptionsColumn.AllowEdit = true;
gridView2.Columns["ReHandle"].OptionsColumn.ReadOnly = false;
gridView2.Columns["SplitColor"].OptionsColumn.AllowEdit = true;
gridView2.Columns["SplitColor"].OptionsColumn.ReadOnly = false;
gridView2.Columns["MiddleDiff"].OptionsColumn.AllowEdit = true;
gridView2.Columns["MiddleDiff"].OptionsColumn.ReadOnly = false;
gridView2.Columns["HeadTailDiff"].OptionsColumn.AllowEdit = true;
gridView2.Columns["HeadTailDiff"].OptionsColumn.ReadOnly = false;
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
if (SysConvert.ToString(drpWHID.EditValue) != string.Empty)
{
tempStr += " AND WHID=" + SysString.ToDBString(drpWHID.EditValue.ToString());
}
if (SysConvert.ToString(drpSection.EditValue) != string.Empty)
{
tempStr += " AND SectionID = " + SysString.ToDBString(SysConvert.ToString(drpSection.EditValue));
}
if (SysConvert.ToString(drpSBits.EditValue) != string.Empty)
{
tempStr += " AND SBitID = " + SysString.ToDBString(SysConvert.ToString(drpSBits.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)
{
if (SysConvert.ToInt32(ProductParamSet.GetIntValueByID(8009)) == 0)//查询模式 0：模糊查询； 1精确查询
{
tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtColorNum.Text.Trim() + "%");
}
else
{
tempStr += " AND ColorNum = " + SysString.ToDBString(txtColorNum.Text.Trim());
}
}
if (txtColorName.Text.Trim() != string.Empty)
{
if (SysConvert.ToInt32(ProductParamSet.GetIntValueByID(8009)) == 0)//查询模式 0：模糊查询； 1精确查询
{
tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtColorName.Text.Trim() + "%");
}
else
{
tempStr += " AND ColorName = " + SysString.ToDBString(txtColorName.Text.Trim());
}
}
if (txtItemModel.Text.Trim() != string.Empty)
{
tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.Text.Trim() + "%");
}
if (txtOrderFormNo.Text.Trim() != string.Empty)
{
tempStr += " AND OrderFormNo LIKE " + SysString.ToDBString("%" + txtOrderFormNo.Text.Trim() + "%");
}
if (txtJarNum.Text.Trim() != string.Empty)
{
tempStr += " AND JarNum LIKE " + SysString.ToDBString("%" + txtJarNum.Text.Trim() + "%");
}
if (txtBatch.Text.Trim() != string.Empty)
{
tempStr += " AND Batch LIKE " + SysString.ToDBString("%" + txtBatch.Text.Trim() + "%");
}
//if (FormListAID == 21)//正品库存
//{
// tempStr += " AND WHID='ML002'";
//}
//else if (FormListAID == 19)//样品
//{
// tempStr += " AND WHID='ML003'";
//}
//else if (FormListAID == 1)//样品
//{
// tempStr += " AND WHID='ML001'";
//}
//else
//{
tempStr += " AND WHID IN (SELECT WHID FROM WH_WH WHERE WHType IN(SELECT WHTypeID FROM Enum_FormList WHERE ParentID=" + SysString.ToDBString(this.FormListAID) + "))";
//}
HTDataConditionStr = tempStr;
}
private void ProcDataTable(DataTable p_dt)
{
foreach (DataRow dr in p_dt.Rows)
{
string WHID = SysConvert.ToString(dr["WHID"]);
string SectionID = SysConvert.ToString(dr["SectionID"]);
string ItemCode = SysConvert.ToString(dr["ItemCode"]);
string ColorNum = SysConvert.ToString(dr["ColorNum"]);
string ColorName = SysConvert.ToString(dr["ColorName"]);
string GoodsCode = SysConvert.ToString(dr["GoodsCode"]);
string Batch = SysConvert.ToString(dr["Batch"]);
decimal MWidth = SysConvert.ToDecimal(dr["MWidth"]);
decimal MWeight = SysConvert.ToDecimal(dr["MWeight"]);
string VendorID = SysConvert.ToString(dr["VendorID"]);
string GoodsLevel = SysConvert.ToString(dr["GoodsLevel"]);
string VendorBatch = SysConvert.ToString(dr["VendorBatch"]);
string JarNum = SysConvert.ToString(dr["JarNum"]);
string ItemUnit = SysConvert.ToString(dr["Unit"]);
decimal PieceQty = SysConvert.ToDecimal(dr["PieceQty"]);
decimal Qty = SysConvert.ToDecimal(dr["Qty"]);
#region 查找仓库结算类型
string sql = "SELECT FieldName FROM UV1_WH_WH WHERE WHID=" + SysString.ToDBString(WHID);//获得仓库结算类型字段
DataTable dt = SysUtils.Fill(sql);
string FieldNamestr = string.Empty;
if (dt.Rows.Count != 0)
{
FieldNamestr += SysConvert.ToString(dt.Rows[0]["FieldName"]);
}
#endregion
int PackPieceQty = 0;
decimal PackQty = 0.0m;
sql = "SELECT * FROM WH_PackBox WHERE 1=1";
sql += " AND WHID =" + SysString.ToDBString(WHID);
sql += " AND SectionID = " + SysString.ToDBString(SectionID);
int CalFieldName = (int)WHCalMethodFieldName.ItemCode;
if (FieldNamestr != string.Empty)
{
string[] FieldName = FieldNamestr.Split('+');
for (int i = 0; i < FieldName.Length; i++)
{
string sqlFieldName = "SELECT ID FROM Enum_WHCalMethodFieldName WHERE Name=" + SysString.ToDBString(FieldName[i]);//找到库存结算字段对应的ID
DataTable dtFieldName = SysUtils.Fill(sqlFieldName);
if (dtFieldName.Rows.Count != 0 && dtFieldName.Rows[0]["ID"].ToString() != "")
{
CalFieldName = SysConvert.ToInt32(dtFieldName.Rows[0]["ID"]);
}
switch (CalFieldName)
{
case (int)WHCalMethodFieldName.WHID: //库 上方已处理
break;
case (int)WHCalMethodFieldName.SectionID: //区
break;
case (int)WHCalMethodFieldName.SBitID: //位
break;
case (int)WHCalMethodFieldName.ItemCode: //产品编码
sql += " AND ISNULL(ItemCode,'')=" + SysString.ToDBString(ItemCode);
break;
case (int)WHCalMethodFieldName.JarNum: //缸号
sql += " AND ISNULL(JarNum,'')=" + SysString.ToDBString(JarNum);
break;
case (int)WHCalMethodFieldName.ColorNum: //色号
sql += " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(ColorNum);
break;
case (int)WHCalMethodFieldName.ColorName: //颜色
sql += " AND ISNULL(ColorName,'')=" + SysString.ToDBString(ColorName);
break;
case (int)WHCalMethodFieldName.MWidth: //门幅
sql += " AND ISNULL(MWidth,0)=" + SysString.ToDBString(MWidth);
break;
case (int)WHCalMethodFieldName.MWeight: //克重
sql += " AND ISNULL(MWeight,0)=" + SysString.ToDBString(MWeight);
break;
case (int)WHCalMethodFieldName.VendorID: //客户
sql += " AND ISNULL(VendorID,'')=" + SysString.ToDBString(VendorID);
break;
case (int)WHCalMethodFieldName.GoodsCode: //商品码
sql += " AND ISNULL(GoodsCode,'')=" + SysString.ToDBString(GoodsCode);
break;
case (int)WHCalMethodFieldName.GoodsLevel: //等级
sql += " AND ISNULL(GoodsLevel,'')=" + SysString.ToDBString(GoodsLevel);
break;
case (int)WHCalMethodFieldName.Batch: //批号
sql += " AND ISNULL(Batch,'')=" + SysString.ToDBString(Batch);
break;
case (int)WHCalMethodFieldName.Unit: //单位
sql += " AND ISNULL(Unit,'')=" + SysString.ToDBString(ItemUnit);
break;
case (int)WHCalMethodFieldName.VendorBatch: //客户批号
sql += " AND ISNULL(VendorBatch,'')=" + SysString.ToDBString(VendorBatch);
break;
default:
throw new Exception("结算异常，结算定义的字段底层未对应：" + CalFieldName);
}
}
}
sql += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库);
sql += " AND(ISNULL(Qty,0)>0)";
DataTable dt1 = SysUtils.Fill(sql);
if (dt1.Rows.Count != 0)
{
for (int i = 0; i < dt1.Rows.Count; i++)
{
PackQty += SysConvert.ToDecimal(dt1.Rows[i]["Qty"]);
}
PackPieceQty = dt1.Rows.Count;
}
if (PackQty != Qty || PackPieceQty != PieceQty)
{
dr["YCFlag"] = 1;
}
}
}
/// <summary>
/// 更新表单设置的值
/// </summary>
/// <param name="p_ID"></param>
/// <param name="p_TableName"></param>
/// <param name="p_FiledName"></param>
/// <param name="p_Value"></param>
/// <param name="sqlTrans"></param>
public void UpdateFiledSet(int p_ID, int p_FiledSetID, string p_Value, IDBTransAccess sqlTrans)
{
try
{
FiledSet entity = new FiledSet(sqlTrans);
entity.ID = p_FiledSetID;
entity.SelectByID();
string sql = "";
if (entity.UpDateFlag == 1) //更新标志
{
if (entity.FiledType == "string")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToString(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "decimal")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDecimal(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "int")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToInt32(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
if (entity.FiledType == "datetime")
{
sql = "Update " + entity.MainTable;
sql += " Set " + entity.FiledName + "=" + SysString.ToDBString(SysConvert.ToDateTime(p_Value));
sql += " where ID=" + p_ID;
sqlTrans.ExecuteNonQuery(sql);
}
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
int saveNoLoadCheckDayNum = 0;//未加载比对天数，防止随着时间的推移系统变慢
#region 自定义虚方法定义[需要修改]
/// <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 FormDate 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 (txtDyeFactory.Text.Trim() != string.Empty)
{
tempStr += " AND DyeFactoryName LIKE " + SysString.ToDBString("%" + txtDyeFactory.Text.Trim() + "%");
}
if (drpDyeFactorty.EditValue != string.Empty)
{
tempStr += " AND DyeFactorty LIKE " + SysString.ToDBString("%" + drpDyeFactorty.EditValue + "%");
}
if (txtItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtItemModel.Text.Trim() != string.Empty)
{
tempStr += " AND ItemModel LIKE " + SysString.ToDBString("%" + txtItemModel.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 (txtDtsSO.Text.Trim() != string.Empty) //合同号使用从表中的DtsSO
{
tempStr += " AND DtsSO LIKE " + SysString.ToDBString("%" + txtDtsSO.Text.Trim() + "%");;
}
if (SysConvert.ToString(drpSaleOPID.EditValue) != "")
{
tempStr += " AND SaleOPID=" + SysString.ToDBString(SysConvert.ToString(drpSaleOPID.EditValue));
}
tempStr += " AND ProcessTypeID=1"; //染整加工单
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 (chkOrderDate.Checked)
{
tempStr += " AND FormDate BETWEEN " + SysString.ToDBString(txtOrderDateS.DateTime) + " AND " + SysString.ToDBString(txtOrderDateE.DateTime);
}
if (txtVendorID.Text.Trim() != string.Empty)
{
tempStr += " AND VendorID=" + SysString.ToDBString(txtVendorID.Text.Trim());
}
if (SysConvert.ToString(drpVendorID.EditValue) != "")
{
tempStr += " AND VendorID=" + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue));
}
if (drpXZ.Text.Trim() != string.Empty)
{
tempStr += " AND XZ=" + SysString.ToDBString(drpXZ.Text.Trim());
}
//if (txtDM.Text.Trim() != string.Empty)
//{
// tempStr += " AND DM LIKE "+SysString.ToDBString("%"+txtDM.Text.Trim()+"%");
//}
//if(txtInvoiceNo.Text.Trim()!=string.Empty)
//{
// tempStr+=" AND InvoiceNo LIKE "+SysString.ToDBString("%"+txtInvoiceNo.Text.Trim()+"%");
//}
if (txtQDtsSO.Text.Trim() != string.Empty)
{
tempStr += " AND DtsSO LIKE " + SysString.ToDBString("%" + txtQDtsSO.Text.Trim() + "%");
}
if (txtItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtGoodsCode.Text.Trim() != string.Empty)
{
tempStr += " AND GoodsCode=" + 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 (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 (txtVItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND VItemCode LIKE " + SysString.ToDBString("%" + txtVItemCode.Text.Trim() + "%");
}
//if(txtBatch.Text.Trim()!=string.Empty)
//{
// tempStr+=" AND Batch="+SysString.ToDBString(txtBatch.Text.Trim());
//}
//if(txtJarNum.Text.Trim()!=string.Empty)
//{
// tempStr+=" AND JarNum LIKE "+SysString.ToDBString("%"+txtJarNum.Text.Trim()+"%");
//}
if (SysConvert.ToString(drpSubType.EditValue) != string.Empty)
{
tempStr += " AND SubType=" + SysString.ToDBString(SysConvert.ToInt32(drpSubType.EditValue));
}
if (this.FormListAID != 0)
{
tempStr += " AND HeadType=" + this.FormListAID;
}
tempStr += Common.GetWHRightCondition();
tempStr += " AND DEFlag=1";
tempStr += " ORDER BY FormDate DESC";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 检验结束
/// </summary>
/// <param name="p_BE">要删除的实体</param>
/// <param name="sqlTrans">事务类</param>
public int RJYEnd(int p_BE, CheckOrderISN entity2, int p_PackID, decimal Qty, decimal YMQty, int ReelNo, IDBTransAccess sqlTrans)
{
try
{
if (p_BE == 0)//如果是0 则表示没有疵点
{
entity2.MainID = p_PackID;
CheckOrderISNRule rulebp = new CheckOrderISNRule();
rulebp.RAdd(entity2, sqlTrans);
p_BE = entity2.ID;
}
CheckOrderISN entity = new CheckOrderISN(sqlTrans);
entity.ID = p_BE;
entity.SelectByID();
entity.MainID = p_PackID;
entity.ChkQty = Qty;//码表数量
entity.ColorName = entity2.ColorName; //颜色
entity.ColorNum = entity2.ColorNum; //色号
entity.MWidth = entity2.MWidth; //平均门幅
entity.MWeight = entity2.MWeight; //平均克重
string sqls = "SELECT MAX(Seq) Seq FROM Chk_CheckOrderISN WHERE JarNum=" + SysString.ToDBString(entity.JarNum);
sqls += " AND MainID=" + p_BE;
//string sqls = "Select ISNULL(Max(ReelNo),0) From Chk_CheckOrderISN where JarNum=" + SysString.ToDBString(SysConvert.ToString(entity.JarNum));
//sqls += " AND ItemCode=" + SysString.ToDBString(SysConvert.ToString(entity.ItemCode));
//sqls += " AND ColorNum=" + SysString.ToDBString(SysConvert.ToString(entity.ColorNum));
DataTable dts = sqlTrans.Fill(sqls);
if ((SysConvert.ToInt32(dts.Rows[0][0]) + 1) != ReelNo)
{
entity.ReelNo = SysConvert.ToString(SysConvert.ToInt32(dts.Rows[0][0]) + 1);//卷号
}
else
{
entity.ReelNo = SysConvert.ToString(ReelNo);//卷号
}
//entity.YQty = SysConvert.ToDecimal(Qty * 1.0936132983377m, 2);//米数转码数
CheckOrderISNRule rule = new CheckOrderISNRule();
rule.RUpdate(entity, sqlTrans);
#region 统计合计数据
entity.KJQty = 0.0m;//开剪数量合计
string sql = "SELECT SUM(cast(Deduction as decimal(10,2))) Deduction FROM Chk_CheckOrderISNFault WHERE 1=1";
sql += " AND MainID=" + p_BE;
sql += " AND FaultType=3";//开剪
sql += " AND ISNUMERIC(Deduction)=1";
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count != 0)
{
entity.KJQty = SysConvert.ToDecimal(dt.Rows[0]["Deduction"]);
}
entity.Qty = SysConvert.ToDecimal(entity.ChkQty - entity.KJQty, 2);//实际数量=码表数量-裁剪数量
CheckOrderISNRule rulebp2 = new CheckOrderISNRule();
rulebp2.RUpdate(entity, sqlTrans);
#endregion
#region 合计检验米数汇总到待检清单
sql = "Select SUM(Qty) Qty from Chk_CheckOrderISN where MainID=" + p_PackID;
DataTable dtS = sqlTrans.Fill(sql);
if (dtS.Rows.Count != 0)
{
sql = "Update Chk_CheckOrderDts Set CheckQty=" + SysConvert.ToDecimal(dtS.Rows[0]["Qty"]);
sql += " where ID=" + p_PackID;
sqlTrans.ExecuteNonQuery(sql);
}
#endregion
#region 计算同个缸号的平均门幅、克重
//decimal AvgMWidth = 0.0m;
//decimal AvgMWeight = 0.0m;
//sql = "Select Avg(MWidth) MWidth,Avg(MWeight) MWeight from WO_BProductCheckDtsFault where 1=1";
//sql += " AND MainID in(select ID from WO_BProductCheckDts where 1=1 AND MainID=" + entity.MainID + ")";
//sql += " AND ISNULL(MWidth,0)<>0 AND ISNULL(MWeight,0)<>0 ";
//DataTable dtAvg = sqlTrans.Fill(sql);
//if (dtAvg.Rows.Count != 0)
//{
// AvgMWidth = SysConvert.ToDecimal(dtAvg.Rows[0]["MWidth"]);
// AvgMWeight = SysConvert.ToDecimal(dtAvg.Rows[0]["MWeight"]);
//}
//sql = "Update WO_BProductCheckDts set JarNumMWidth =" + AvgMWidth;
//sql += ",JarNumMWeight=" + AvgMWeight;
//sql += " where 1=1 AND MainID=" + entity.MainID;
//sqlTrans.ExecuteNonQuery(sql);
#endregion
return(p_BE);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 保存(传入事务处理)
/// </summary>
/// <param name="p_BE">要新增的实体</param>
/// <param name="sqlTrans">事务类</param>
public void RSave(int p_ID, int p_MainID, int p_Seq, BaseEntity[] p_BE, bool p_UpdateFlag, IDBTransAccess sqlTrans)
{
try
{
string sql = "";
if (p_UpdateFlag) //修改状态下首先清除被删除的码单明细
{
string idStr = string.Empty; //ID字符串
idStr = "0";
for (int i = 0; i < p_BE.Length; i++)
{
IOFormDtsPack entity = (IOFormDtsPack)p_BE[i];
if (entity.ID != 0)//有ID
{
if (idStr != string.Empty)
{
idStr += ",";
}
idStr += entity.ID.ToString();
}
}
if (idStr != string.Empty)
{
sql = "DELETE FROM WH_PackBox WHERE BoxNo IN (SELECT BoxNo FROM WH_IOFormDtsPack WHERE DID=" + SysString.ToDBString(p_ID) + " AND ID NOT IN(" + idStr + ") )";
sqlTrans.ExecuteNonQuery(sql); //执行条形码删除
sql = "DELETE FROM WH_IOFormDtsPack WHERE DID=" + SysString.ToDBString(p_ID) + " AND ID NOT IN(" + idStr + ")"; //WH_IOFormDtsPack WH_PackBox
sqlTrans.ExecuteNonQuery(sql);
}
}
else//新增状态
{
sql = "SELECT TOP 1 ID FROM WH_IOFormDtsPack WHERE DID=" + SysString.ToDBString(p_ID);
DataTable dt = sqlTrans.Fill(sql);
if (dt.Rows.Count > 0)
{
throw new BaseException("不能重复保存！");
}
}
IOForm p_Main = new IOForm(sqlTrans);
p_Main.ID = p_MainID;
p_Main.SelectByID();
IOFormDts p_MainDts = new IOFormDts(sqlTrans);
p_MainDts.ID = p_ID;
p_MainDts.SelectByID();
IOFormDtsPackRule rule = new IOFormDtsPackRule();
PackBoxRule Brule = new PackBoxRule();
decimal Qty = 0;
decimal PieceQty = 0;
for (int i = 0; i < p_BE.Length; i++)
{
FormNoControlRule frule = new FormNoControlRule();
IOFormDtsPack entity = (IOFormDtsPack)p_BE[i];
int boxNoCreateTypeID = 0;//箱号条码来源
if (entity.ID == 0)
{
if (entity.BoxNo == string.Empty)//没有箱号条码
{
entity.BoxNo = frule.RGetFormNo((int)FormNoControlEnum.码单箱号, sqlTrans);
rule.RAdd(entity, sqlTrans);
frule.RAddSort((int)FormNoControlEnum.码单箱号, sqlTrans);
}
else//有箱号条码说明是验布产生的条码
{
boxNoCreateTypeID = 1;//验布来源
}
}
else
{
rule.RUpdate(entity, sqlTrans);
}
PackBox entityBox = new PackBox();
if (entity.ID != 0)//仓库明细已生成，则寻找箱号ID 此处判断其实无意义，经过上面的代码肯定有ID值了
{
sql = "SELECT ID FROM WH_PackBox WHERE BoxNo=" + SysString.ToDBString(entity.BoxNo);
DataTable dtPackBox = sqlTrans.Fill(sql);
if (dtPackBox.Rows.Count != 0)//如果找到条码
{
entityBox.ID = SysConvert.ToInt32(dtPackBox.Rows[0]["ID"]);
}
else//如果未找到条码
{
entityBox.CreateSourceID = boxNoCreateTypeID;////原始条码表加个字段表示来源 0:表示入库录入
}
}
entityBox.BoxNo = entity.BoxNo;
entityBox.WHID = p_MainDts.WHID;
entityBox.SectionID = p_MainDts.SectionID;
entityBox.SBitID = p_MainDts.SBitID;
entityBox.ColorName = p_MainDts.ColorName;
entityBox.ColorNum = p_MainDts.ColorNum;
entityBox.CompanyTypeID = p_MainDts.CompanyTypeID;
entityBox.GoodsCode = p_MainDts.GoodsCode;
entityBox.GoodsLevel = p_MainDts.GoodsLevel;
entityBox.ItemCode = p_MainDts.ItemCode;
entityBox.ItemName = p_MainDts.ItemName;
entityBox.ItemStd = p_MainDts.ItemStd;
entityBox.JarNum = p_MainDts.JarNum;
entityBox.Batch = p_MainDts.Batch;
entityBox.VendorBatch = p_MainDts.VendorBatch;
entityBox.MWeight = p_MainDts.MWeight;
entityBox.MWidth = p_MainDts.MWidth;
entityBox.Qty = entity.Qty;
entityBox.Unit = p_MainDts.Unit;
entityBox.BoxStatusID = (int)EnumBoxStatus.未入库;
entityBox.DID = p_ID;
entityBox.InFormNo = p_Main.FormNo;
entityBox.OrderFormNo = p_MainDts.DtsOrderFormNo;//合同号明细
if (entityBox.ID == 0)//没有ID则新增
{
Brule.RAdd(entityBox, sqlTrans);
}
else//有ID则修改
{
Brule.RUpdate(entityBox, sqlTrans);
}
Qty += entity.Qty;
PieceQty++;
}
//if (PieceQty == 0)
//{
// throw new BaseException("请填写细码后点击保存");
//}
sql = "UPDATE WH_IOFormDts SET Qty=" + SysString.ToDBString(Qty);
sql += ",PieceQty=" + SysString.ToDBString(PieceQty);
sql += ",PackFlag=1 ";
sql += " WHERE ID=" + SysString.ToDBString(p_ID);
sqlTrans.ExecuteNonQuery(sql);
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 审核
/// </summary>
/// <param name="p_FormID">单据ID</param>
/// <param name="p_Type">0/1/2/3:弃审/审核</param>
public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans)
{
try
{
int p_TempType = p_Type;//处理状态
string sql = string.Empty;
ItemBuyForm entity = new ItemBuyForm(sqlTrans);
entity.ID = p_FormID;
entity.SelectByID();
if (entity.SubmitFlag == p_Type)//如果相同异常
{
throw new Exception("单据状态重复设置，请关闭程序重新打开操作");
}
if (p_Type == (int)ConfirmFlag.未提交) //撤销提交验证
{
if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5609))) //采购单有仓库单据不允许修改
{
bool allowOPFlag = true;
string refuseMessage = string.Empty;
DataTable dtSOFlow;
if (allowOPFlag)
{
//仓库流程单据
sql = "SELECT TOP 1 ID,FormNo FROM UV1_WH_IOFormDts WHERE DtsSO=" + SysString.ToDBString(entity.FormNo);
dtSOFlow = SysUtils.Fill(sql);
if (dtSOFlow.Rows.Count != 0)
{
allowOPFlag = false;
refuseMessage = "此单已有仓库单据(单号):" + dtSOFlow.Rows[0]["FormNo"].ToString() + "，不允许撤销";
}
}
if (!allowOPFlag)//不允许操作
{
throw new Exception(refuseMessage);
}
}
}
sql = "UPDATE Buy_ItemBuyForm SET SubmitFlag=" + SysString.ToDBString(p_Type);
//if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝)
//{
//sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now);
//}
sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态
sqlTrans.ExecuteNonQuery(sql);
int tempSaleProcedureID = 0;
switch (entity.FormAID)//1/2/3/4/5：成品，坯布，纱线，色坯，辅料
{
case 1:
tempSaleProcedureID = (int)EnumSaleProcedure.成品采购单;
break;
case 2:
tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单;
break;
case 3:
tempSaleProcedureID = (int)EnumSaleProcedure.纱线采购单;
break;
case 4:
tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单;
break;
case 5: //辅料
tempSaleProcedureID = (int)EnumSaleProcedure.辅料采购单;
break;
}
if (p_Type == (int)YesOrNo.Yes)
{
if (tempSaleProcedureID != (int)EnumSaleProcedure.坯布采购单)
{
sql = "SELECT DtsSO,ItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
DataTable dtDts = sqlTrans.Fill(sql);
SaleOrderRule salerule = new SaleOrderRule();
foreach (DataRow dr in dtDts.Rows)
{
salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["ItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans);
}
}
else //坯布采购加载订单时候 将订单里的 ItemCode 加载到 CPItemCode
{
sql = "SELECT DtsSO,CPItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
DataTable dtDts = sqlTrans.Fill(sql);
SaleOrderRule salerule = new SaleOrderRule();
foreach (DataRow dr in dtDts.Rows)
{
salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["CPItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans);
}
}
}
//#region 回填采购完成数
//if (p_Type == (int)YesOrNo.Yes)//提交
//{
// if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯)
// {
// decimal TotalQty = 0m;
// sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts = sqlTrans.Fill(sql);
// if (dtDts.Rows.Count != 0)
// {
// TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]);
// }
// sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")";
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count != 0)
// {
// while (TotalQty > 0m)//开始回填
// {
// for (int i = 0; i < dtorder.Rows.Count;i++ )
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]);
// bool findR=orderentity.SelectByID();
// if (i == dtorder.Rows.Count - 1)
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// orderentity.PSCGQty += TotalQty;
// TotalQty = 0;
// break;
// case (int)EnumMLType.白坯:
// orderentity.PBCGQty += TotalQty;
// TotalQty = 0;
// break;
// default:
// break;
// }
// }
// else
// {
// // decimal HTQty = DifQty <= TotalQty ? DifQty : TotalQty;
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty;
// if (TotalQty <= DifPSQty)
// {
// orderentity.PSCGQty += TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (DifPSQty > 0)
// {
// orderentity.PSCGQty += DifPSQty;
// TotalQty -= DifPSQty;
// break;
// }
// }
// break;
// case (int)EnumMLType.白坯:
// decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty;
// if (TotalQty <= DifPBQty)
// {
// orderentity.PBCGQty += TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (DifPBQty > 0)
// {
// orderentity.PBCGQty += DifPBQty;
// TotalQty -= DifPBQty;
// break;
// }
// }
// break;
// default:
// break;
// }
// }
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// } //For循环结尾
// } //While结尾
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单");
// }
// }
// if (entity.MLType == (int)EnumMLType.成品)
// {
// sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts1 = sqlTrans.Fill(sql);
// foreach(DataRow dr in dtDts1.Rows)
// {
// sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo);
// sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
// sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString());
// sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString());
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count == 1)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]);
// bool findR=orderentity.SelectByID();
// orderentity.CPCGQty += SysConvert.ToDecimal(dr["Qty"]);
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单 订单号："+entity.FormNo);
// }
// }
// }
//}
//else //撤销提交回填数量
//{
// if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯)
// {
// decimal TotalQty = 0m;
// sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts = sqlTrans.Fill(sql);
// if (dtDts.Rows.Count != 0)
// {
// TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]);
// }
// sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")";
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count != 0)
// {
// while (TotalQty > 0m)//开始回填
// {
// for (int i = 0; i < dtorder.Rows.Count; i++)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]);
// bool findR=orderentity.SelectByID();
// if (i == dtorder.Rows.Count - 1)
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// orderentity.PSCGQty -= TotalQty;
// //if (orderentity.PSCGQty < 0)
// //{
// // orderentity.PSCGQty = 0;
// //}
// TotalQty = 0;
// break;
// case (int)EnumMLType.白坯:
// orderentity.PBCGQty -= TotalQty;
// //if (orderentity.PBCGQty < 0)
// //{
// // orderentity.PBCGQty = 0;
// //}
// TotalQty = 0;
// break;
// default:
// break;
// }
// }
// else
// {
// switch (entity.MLType)
// {
// case (int)EnumMLType.纱线:
// // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty;
// if (TotalQty <= orderentity.PSCGQty)
// {
// orderentity.PSCGQty -= TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (orderentity.PSCGQty > 0)
// {
// TotalQty -= orderentity.PSCGQty;
// orderentity.PSCGQty =0;
// break;
// }
// }
// break;
// case (int)EnumMLType.白坯:
// //decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty;
// if (TotalQty <= orderentity.PBCGQty)
// {
// orderentity.PBCGQty -= TotalQty;
// TotalQty = 0;
// break;
// }
// else
// {
// if (orderentity.PBCGQty > 0)
// {
// TotalQty -= orderentity.PBCGQty;
// orderentity.PBCGQty= 0;
// break;
// }
// }
// break;
// default:
// break;
// }
// }
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// } //For循环结尾
// } //While结尾
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单");
// }
// }
// if (entity.MLType == (int)EnumMLType.成品)
// {
// sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID;
// DataTable dtDts1 = sqlTrans.Fill(sql);
// foreach (DataRow dr in dtDts1.Rows)
// {
// sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo);
// sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString());
// sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString());
// sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString());
// DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单
// if (dtorder.Rows.Count == 1)
// {
// SaleOrderDts orderentity = new SaleOrderDts(sqlTrans);
// orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]);
// bool findR= orderentity.SelectByID();
// orderentity.CPCGQty -= SysConvert.ToDecimal(dr["Qty"]);
// if (findR)
// {
// SaleOrderDtsRule rule = new SaleOrderDtsRule();
// rule.RUpdate(orderentity, sqlTrans);
// }
// }
// else
// {
// throw new Exception("数据出现异常未找到原始订单 订单号：" + entity.FormNo);
// }
// }
// }
//}
//#endregion
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private FabricProcessDts[] EntityDtsGet()
{
int index = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemCode")) != string.Empty)
{
index++;
}
}
FabricProcessDts[] entitydts = new FabricProcessDts[index];
index = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemCode")) != string.Empty)
{
entitydts[index] = new FabricProcessDts();
entitydts[index].ID = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "ID"));
entitydts[index].SelectByID();
entitydts[index].MainID = HTID;
entitydts[index].Seq = i + 1;
entitydts[index].ItemCode = SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemCode"));
entitydts[index].GoodsCode = SysConvert.ToString(gridView1.GetRowCellValue(i, "GoodsCode"));
entitydts[index].ColorNum = SysConvert.ToString(gridView1.GetRowCellValue(i, "ColorNum"));
entitydts[index].ColorName = SysConvert.ToString(gridView1.GetRowCellValue(i, "ColorName"));
entitydts[index].MWidth = SysConvert.ToString(gridView1.GetRowCellValue(i, "MWidth"));
entitydts[index].MWeight = SysConvert.ToString(gridView1.GetRowCellValue(i, "MWeight"));
entitydts[index].WeightUnit = SysConvert.ToString(gridView1.GetRowCellValue(i, "WeightUnit"));
entitydts[index].ItemName = SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemName"));
entitydts[index].ItemModel = SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemModel"));
entitydts[index].ItemStd = SysConvert.ToString(gridView1.GetRowCellValue(i, "ItemStd"));
entitydts[index].VColorNum = SysConvert.ToString(gridView1.GetRowCellValue(i, "VColorNum"));
entitydts[index].VColorName = SysConvert.ToString(gridView1.GetRowCellValue(i, "VColorName"));
entitydts[index].VItemCode = SysConvert.ToString(gridView1.GetRowCellValue(i, "VItemCode"));
entitydts[index].Qty = SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty"));
entitydts[index].Unit = SysConvert.ToString(gridView1.GetRowCellValue(i, "Unit"));
entitydts[index].SingPrice = SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "SingPrice"));
entitydts[index].Amount = entitydts[index].Qty * entitydts[index].SingPrice;
entitydts[index].DVendorID = SysConvert.ToString(gridView1.GetRowCellValue(i, "DVendorID"));
entitydts[index].DtsSO = SysConvert.ToString(gridView1.GetRowCellValue(i, "DtsSO"));
entitydts[index].CalNum = SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "CalNum"));
entitydts[index].CalUnit = SysConvert.ToString(gridView1.GetRowCellValue(i, "CalUnit"));
entitydts[index].DtsRemark = SysConvert.ToString(gridView1.GetRowCellValue(i, "DtsRemark"));
entitydts[index].DesignNo = SysConvert.ToString(gridView1.GetRowCellValue(i, "DesignNo"));
entitydts[index].EditionOK = SysConvert.ToString(gridView1.GetRowCellValue(i, "EditionOK"));
entitydts[index].PieceQty = SysConvert.ToInt32(gridView1.GetRowCellValue(i, "PieceQty"));
entitydts[index].FreeStr1 = SysConvert.ToString(gridView1.GetRowCellValue(i, "FreeStr1"));
entitydts[index].FreeStr2 = SysConvert.ToString(gridView1.GetRowCellValue(i, "FreeStr2"));
entitydts[index].FreeStr3 = SysConvert.ToString(gridView1.GetRowCellValue(i, "FreeStr3"));
entitydts[index].FreeStr4 = SysConvert.ToString(gridView1.GetRowCellValue(i, "FreeStr4"));
entitydts[index].FreeStr5 = SysConvert.ToString(gridView1.GetRowCellValue(i, "FreeStr5"));
entitydts[index].CPItemCode = SysConvert.ToString(gridView1.GetRowCellValue(i, "CPItemCode"));
entitydts[index].CPItemName = SysConvert.ToString(gridView1.GetRowCellValue(i, "CPItemName"));
entitydts[index].CPItemStd = SysConvert.ToString(gridView1.GetRowCellValue(i, "CPItemStd"));
entitydts[index].CPItemModel = SysConvert.ToString(gridView1.GetRowCellValue(i, "CPItemModel"));
entitydts[index].SL = SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "SL"));
entitydts[index].PBWeight = SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "PBWeight"));
entitydts[index].Needle = SysConvert.ToString(gridView1.GetRowCellValue(i, "Needle"));
index++;
}
}
return(entitydts);
}
/// <summary>
/// 获得ArrayList
/// </summary>
/// <param name="p_Al">ArrayList</param>
/// <param name="p_Nodes">节点数组</param>
/// <returns></returns>
private void GetEntityOPWinList(ArrayList p_Al, TreeListNodes p_Nodes)
{
for (int i = 0; i < p_Nodes.Count; i++)
{
if (((CheckState)p_Nodes[i].Tag == CheckState.Checked || (CheckState)p_Nodes[i].Tag == CheckState.Indeterminate))
{
if (SysConvert.ToString(p_Nodes[i].GetValue("MenuID")) != string.Empty && SysConvert.ToString(p_Nodes[i].GetValue("ParentID")) != "0")//有菜单且ParentID不为0
{
OPWinList entity = new OPWinList();
entity.OPID = OPID;
entity.WinListID = SysConvert.ToInt32(p_Nodes[i].GetValue("ID"));
entity.HeadTypeID = SysConvert.ToInt32(p_Nodes[i].GetValue("HeadTypeID"));
entity.SubTypeID = SysConvert.ToInt32(p_Nodes[i].GetValue("SubTypeID"));
if (entity.WinListID != 0)//必须有值
{
p_Al.Add(entity);
}
}
}
GetEntityOPWinList(p_Al, p_Nodes[i].Nodes);
}
}
private VendorFile GetSVendorFile()
{
VendorFile entity = new VendorFile();
int picNum = SysConvert.ToInt32(drpPicNum.EditValue);
switch (picNum)
{
case 1:
if (img1.Image != null)
{
entity.Context = TemplatePic.ImageToByte(img1.Image);
entity.FileTypeID = picNum;
entity.FileLength = SysConvert.ToDecimal(img1.Image.Width);
entity.UploadOPID = FParamConfig.LoginID;
entity.UploadTime = DateTime.Now.Date;
entity.Remark = txtRemark1.Text.Trim();
}
break;
case 2:
if (img2.Image != null)
{
entity.Context = TemplatePic.ImageToByte(img2.Image);
entity.FileTypeID = picNum;
entity.FileLength = SysConvert.ToDecimal(img2.Image.Width);
entity.UploadOPID = FParamConfig.LoginID;
entity.UploadTime = DateTime.Now.Date;
entity.Remark = txtRemark2.Text.Trim();
}
break;
case 3:
if (img3.Image != null)
{
entity.Context = TemplatePic.ImageToByte(img3.Image);
entity.FileTypeID = picNum;
entity.FileLength = SysConvert.ToDecimal(img3.Image.Width);
entity.UploadOPID = FParamConfig.LoginID;
entity.UploadTime = DateTime.Now.Date;
entity.Remark = txtRemark3.Text.Trim();
}
break;
case 4:
if (img4.Image != null)
{
entity.Context = TemplatePic.ImageToByte(img4.Image);
entity.FileTypeID = picNum;
entity.FileLength = SysConvert.ToDecimal(img4.Image.Width);
entity.UploadOPID = FParamConfig.LoginID;
entity.UploadTime = DateTime.Now.Date;
entity.Remark = txtRemark4.Text.Trim();
}
break;
case 5:
if (img5.Image != null)
{
entity.Context = TemplatePic.ImageToByte(img5.Image);
entity.FileTypeID = picNum;
entity.FileLength = SysConvert.ToDecimal(img5.Image.Width);
entity.UploadOPID = FParamConfig.LoginID;
entity.UploadTime = DateTime.Now.Date;
entity.Remark = txtRemark5.Text.Trim();
}
break;
default:
break;
}
return(entity);
}
/// <summary>
/// 设置接点状态
/// </summary>
/// <param name="node"></param>
/// <param name="p_SubFlag"></param>
private void SetCheckBoxState(TreeListNode node, bool p_SubFlag)
{
if (CheckIDExist(SysConvert.ToInt32(node.GetValue("ID")), SysConvert.ToInt32(node.GetValue("HeadTypeID")), SysConvert.ToInt32(node.GetValue("SubTypeID")), p_SubFlag))
{
node.Tag = CheckState.Checked;
SetCheckedChildNodes(node, CheckState.Checked);
SetCheckedParentNodes(node, CheckState.Checked);
}
else
{
node.Tag = CheckState.Unchecked;
SetCheckedChildNodes(node, CheckState.Unchecked);
SetCheckedParentNodes(node, CheckState.Unchecked);
}
}
/// <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 FormDate BETWEEN " + SysString.ToDBString(txtOrderDateS.DateTime) + " AND " + SysString.ToDBString(txtOrderDateE.DateTime);
}
if (txtVendorID.Text.Trim() != string.Empty)
{
tempStr += " AND VendorID=" + SysString.ToDBString(txtVendorID.Text.Trim());
}
if (drpXZ.Text.Trim() != string.Empty)
{
tempStr += " AND XZ=" + SysString.ToDBString(drpXZ.Text.Trim());
}
if (txtDM.Text.Trim() != string.Empty)
{
tempStr += " AND DM LIKE " + SysString.ToDBString("%" + txtDM.Text.Trim() + "%");
}
if (txtInvoiceNo.Text.Trim() != string.Empty)
{
tempStr += " AND InvoiceNo LIKE " + SysString.ToDBString("%" + txtInvoiceNo.Text.Trim() + "%");
}
if (txtQDtsSO.Text.Trim() != string.Empty)
{
tempStr += " AND DtsSO LIKE " + SysString.ToDBString("%" + txtQDtsSO.Text.Trim() + "%");
}
if (txtItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtGoodsCode.Text.Trim() != string.Empty)
{
tempStr += " AND GoodsCode=" + 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 (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 (txtVItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND VItemCode LIKE " + SysString.ToDBString("%" + txtVItemCode.Text.Trim() + "%");
}
if (txtBatch.Text.Trim() != string.Empty)
{
tempStr += " AND Batch=" + SysString.ToDBString(txtBatch.Text.Trim());
}
if (txtJarNum.Text.Trim() != string.Empty)
{
tempStr += " AND JarNum LIKE " + SysString.ToDBString("%" + txtJarNum.Text.Trim() + "%");
}
if (SysConvert.ToString(drpSubType.EditValue) != string.Empty)
{
tempStr += " AND SubType=" + SysString.ToDBString(SysConvert.ToInt32(drpSubType.EditValue));
}
if (SysConvert.ToString(drpWHType.EditValue) != string.Empty)
{
tempStr += " AND HeadType=" + SysString.ToDBString(SysConvert.ToInt32(drpWHType.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 (chkOrderDate.Checked)
{
tempStr += " AND FormDate BETWEEN " + SysString.ToDBString(txtOrderDateS.DateTime) + " AND " + SysString.ToDBString(txtOrderDateE.DateTime);
}
if (txtItemCode.Text.Trim() != string.Empty)
{
tempStr += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%");
}
if (txtGoodsCode.Text.Trim() != string.Empty)
{
tempStr += " AND GoodsCode=" + 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 (txtBatch.Text.Trim() != string.Empty)
{
tempStr += " AND Batch=" + SysString.ToDBString(txtBatch.Text.Trim());
}
if (txtJarNum.Text.Trim() != string.Empty)
{
tempStr += " AND JarNum LIKE " + SysString.ToDBString("%" + txtJarNum.Text.Trim() + "%");
}
if (SysConvert.ToString(drpSubType.EditValue) != "")
{
tempStr += " AND SubType=" + SysString.ToDBString(SysConvert.ToInt32(drpSubType.EditValue));
}
if (this.FormListAID != 0)
{
tempStr += " AND HeadType=" + this.FormListAID;
}
if (txtPackNo.Text.Trim() != "")
{
tempStr += " AND BoxNo LIKE " + SysString.ToDBString("%" + txtPackNo.Text.Trim() + "%");
}
tempStr += Common.GetWHRightCondition();
tempStr += " ORDER BY FormNo DESC";
HTDataConditionStr = tempStr;
}
/// <summary>
/// 根据编码查询
/// </summary>
/// <param name="p_Code"></param>
/// <returns></returns>
public decimal RShowDecimalByID(int p_ID)
{
string str = RShowStrByID(p_ID);
return(SysConvert.ToDecimal(str));
}
private void txtQty_Leave(object sender, EventArgs e)
{
try
{
decimal Qtyt = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty1")) > 0)
{
Qtyt += SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty1")) + SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty2"))
+ SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty3")) + SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty4"))
+ SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty5")) + SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty6"))
+ SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty7")) + SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty8"))
+ SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty9")) + SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty10"));
}
}
lbCount.Text = Qtyt.ToString();
}
catch (Exception E)
{
}
}
private void ProductAmount(DataTable p_Dt)
{
decimal LeftAmount = 0.0m;
decimal LeftAmount3 = 0.0m;
foreach (DataRow dr in p_Dt.Rows)
{
LeftAmount = LeftAmount + SysConvert.ToDecimal(dr["LeftAmount1"]) - SysConvert.ToDecimal(dr["LeftAmount2"]) + SysConvert.ToDecimal(dr["Amount"]) - SysConvert.ToDecimal(dr["RecAmount"]) - SysConvert.ToDecimal(dr["PaymentHandleAmount"]);
if (LeftAmount >= 0)
{
dr["LeftAmount1"] = LeftAmount;
}
else
{
dr["LeftAmount2"] = 0 - LeftAmount;
}
LeftAmount3 = LeftAmount3 + SysConvert.ToDecimal(dr["Amount"]) - SysConvert.ToDecimal(dr["InvoiceAmount"]);
dr["LeftAmount3"] = LeftAmount3;
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void GetCondtion()
{
string tempStr = string.Empty;
//
if (txtQCompactNo.Text.Trim() != "")
{
tempStr += " AND CompactNo LIKE " + SysString.ToDBString("%" + txtQCompactNo.Text.Trim() + "%");
}
if (SysConvert.ToString(drpQVendorID.EditValue) != "")
{
tempStr += " AND VendorID = " + SysString.ToDBString(SysConvert.ToString(drpQVendorID.EditValue));
}
if (SysConvert.ToString(drpQSaleOPID.EditValue) != "")
{
tempStr += " AND SaleOPID = " + SysString.ToDBString(SysConvert.ToString(drpQSaleOPID.EditValue));
}
if (SysConvert.ToString(drpQItemCode.EditValue) != "")
{
tempStr += " AND ItemCode = " + SysString.ToDBString(SysConvert.ToString(drpQItemCode.EditValue));
}
if (SysConvert.ToString(drpQYarnTypeID.EditValue) != "")
{
tempStr += " AND YarnTypeID = " + SysString.ToDBString(SysConvert.ToString(drpQYarnTypeID.EditValue));
}
if (txtQStyleNo.Text.Trim() != "")
{
tempStr += " AND StyleNo LIKE " + SysString.ToDBString("%" + txtQStyleNo.Text.Trim() + "%");
}
if (txtQSStyleNo.Text.Trim() != "")
{
tempStr += " AND SStyleNo LIKE " + SysString.ToDBString("%" + txtQSStyleNo.Text.Trim() + "%");
}
if (txtQDSN.Text.Trim() != "")
{
tempStr += " AND DSN LIKE " + SysString.ToDBString("%" + txtQDSN.Text.Trim() + "%");
}
if (txtQSSN.Text.Trim() != "")
{
tempStr += " AND SSN LIKE " + SysString.ToDBString("%" + txtQSSN.Text.Trim() + "%");
}
if (chkCompactDate.Checked)
{
tempStr += " AND CompactDate BETWEEN " + SysString.ToDBString(txtQCompactDateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQCompactDateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59");
}
if (txtQItemName.Text.Trim() != "")
{
tempStr += " AND ItemName LIKE " + SysString.ToDBString("%" + txtQItemName.Text.Trim() + "%");
}
if (txtQItemStd.Text.Trim() != "")
{
tempStr += " AND ItemStd LIKE " + SysString.ToDBString("%" + txtQItemStd.Text.Trim() + "%");
}
if (txtQColorName.Text.Trim() != "")
{
tempStr += " AND ColorName LIKE " + SysString.ToDBString("%" + txtQColorName.Text.Trim() + "%");
}
if (txtQColorNum.Text.Trim() != "")
{
tempStr += " AND ColorNum LIKE " + SysString.ToDBString("%" + txtQColorNum.Text.Trim() + "%");
}
HTDataConditionStr = tempStr;
}
/// <summary>
/// 设计
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void btnDesign_Click(object sender, EventArgs e)
{
try
{
//base.btnDesign_Click(sender, e);
//VendorID = drpQVendorID.EditValue.ToString();
//if (VendorID == string.Empty)
//{
// this.ShowMessage("请选择要操作的记录");
// return;
//}
//DevComponents.DotNetBar.ComboBoxItem ci = this.ToolBarCItemGet(-1, ToolButtonName.drpPrintFile.ToString());
//if (ci.SelectedItem == null)
//{
// this.ShowMessage("请选择报表模板");
// return;
//}
//int tempReportID = SysConvert.ToInt32(((DevComponents.Editors.ComboItem)ci.SelectedItem).Tag);
//if (tempReportID == 0)
//{
// this.ShowMessage("请选择报表模板");
// return;
//}
//FastReport.ReportRun(tempReportID, (int)ReportPrintType.设计, new string[] { "VendorID" }, new string[] { VendorID.ToString() });
if (HTDataID == 0)
{
this.ShowMessage("请选择要操作的记录");
return;
}
DevComponents.DotNetBar.ComboBoxItem ci = this.ToolBarCItemGet(-1, ToolButtonName.drpPrintFile.ToString());
if (ci.SelectedItem == null)
{
this.ShowMessage("请选择报表模板");
return;
}
int tempReportID = SysConvert.ToInt32(((DevComponents.Editors.ComboItem)ci.SelectedItem).Tag);
if (tempReportID == 0)
{
this.ShowMessage("请选择报表模板");
return;
}
if (tempReportID == 125)//固定报表格式
{
DataTable dtMain = new DataTable();
dtMain.TableName = "Main";
dtMain.Columns.Add(new DataColumn("VendorAttn", typeof(string)));
dtMain.Columns.Add(new DataColumn("DataTime1", typeof(DateTime)));
dtMain.Columns.Add(new DataColumn("DataTime2", typeof(DateTime)));
DataRow dr = dtMain.NewRow();
dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(drpQVendorID.EditValue));
dr["DataTime1"] = txtQIndateS.DateTime.Date;
dr["DataTime2"] = txtQIndateE.DateTime.Date;
dtMain.Rows.Add(dr);
DataTable dtDetail = (DataTable)gridView1.GridControl.DataSource;
dtDetail.TableName = "Detail";
//FastReport.ReportRunTable(tempReportID, (int)ReportPrintType.设计, new DataTable[] { dtMain, dtDetail });
}
else
{
//FastReport.ReportRun(tempReportID, (int)ReportPrintType.设计, new string[] { "ID", "MainID" }, new string[] { HTDataID.ToString(), HTDataID.ToString() });
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
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++;
}
}
}
