采购订单增加控制和自动审核

Administrator

2024-04-21 fc9d6b654d1bf0b1eb6de4a55850fc1bd2aff7b1

采购订单增加控制和自动审核

 DAL/²Ö¿â¹ÜÀí/ClsKf_POStockInBill.cs

@@ -47,6 +47,10 @@
                {
                    oCn.RunProc("exec h_p_Cg_UpDatePOInStockRelation_Back_Del " + lngBillKey.ToString());
                }
                else if (omodel.HMainSourceBillType == "采购订单")
                {
                    oCn.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPOStockIn_Del " + lngBillKey.ToString());
                }
                else
                {

@@ -71,6 +75,10 @@
                else if (omodel.HMainSourceBillType == "退料通知单")
                {
                    oCn.RunProc("exec h_p_Cg_UpDatePOInStockRelation_Back_Add " + lngBillKey.ToString());
                }
                else if (omodel.HMainSourceBillType == "采购订单")
                {
                    oCn.RunProc("exec h_p_Cg_UpDateRelation_POOrderToPOStockIn_Add " + lngBillKey.ToString());
                }
                else
                {
@@ -176,8 +184,20 @@
                }
                //更新订单关联数量
                AddNewRelation(ref sReturn, omodel.HInterID);
                //控制关联数量

                //保存后控制
                DataSet ds2 = oCn.RunProcReturn("Exec h_p_Kf_POStockInBill_AfterSaveCtrl " + lngBillKey.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_POStockInBill_AfterSaveCtrl");
                if (ds2 == null)
                {
                    oCn.RollBack();
                    sReturn = "判断保存后控制失败！";
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCn.RollBack();
                    sReturn = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }
                //
                sReturn = "修改单据成功！";
                oCn.Commit();
@@ -248,7 +268,20 @@
                }
                //更新订单关联数量
                AddNewRelation(ref sReturn, omodel.HInterID);
                //
                //保存后控制
                DataSet ds2 = oCn.RunProcReturn("Exec h_p_Kf_POStockInBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_POStockInBill_AfterSaveCtrl");
                if (ds2 == null)
                {
                    oCn.RollBack();
                    sReturn = "判断保存后控制失败！";
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    oCn.RollBack();
                    sReturn = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }
                //
                sReturn = "新增单据成功！";
                oCn.Commit();

 ProM/²É¹º¹ÜÀí/Cg_POOrderBill.cs

@@ -1224,7 +1224,9 @@
                {
                    BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
                    BillOld.omodel.HInterID = BillNew.omodel.HInterID;
                    this.Sub_CheckBill();
                    this.Sub_ShowBill();

                }
                else if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify)
                {

 WarM/²Ö¿â¹ÜÀí/Kf_POStockInBill.cs

@@ -2466,6 +2466,18 @@
            grdMain.Rows[i].Cells[HPOOrderInterIDCol].Value = oTable.Rows[0]["hmainid"].ToString();
            grdMain.Rows[i].Cells[HPOOrderEntryIDCol].Value = oTable.Rows[0]["hsubid"].ToString();
            grdMain.Rows[i].Cells[HPOOrderBillNoCol].Value = oTable.Rows[0]["单据号"].ToString();
            //根据物料获取 é‡‡è´­å•ä»·
            DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
            if (oMater.GetInfoByID(DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value)))
            {
                grdMain.Rows[i].Cells[HOrderPriceCol].Value = oMater.omodel.HOrderPrice.ToString();
            }
            else
            {
                grdMain.Rows[i].Cells[HOrderPriceCol].Value = 0;
            }
            //

            Sub_RowCount(i, HQtyCol);
        }