通过供应商和物料直接生成金蝶采购订单

llj

8 天以前 1cac6b2533fd098c81233f3dabefd6c487074cb1

通过供应商和物料直接生成金蝶采购订单

 CLOUDWEB/WebService1.asmx.cs

@@ -31493,8 +31493,8 @@
                sRemark = sRemark + " ；生成出采购单据" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:ffff");
                string billTypeCode = "CGDD01_SYS";
                //todo 
                Ds = oCn.RunProcReturn("SELECT * FROM Cg_POOrderBill_kf where HInterID="+oMain.HInterID, "Cg_POOrderBill_kf");
                if (DateTime.TryParse(Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDate"]), out billDate))
                Ds = oCn.RunProcReturn("select HNumber SupNumber FROM Gy_Supplier where HItemID=" + oMain.HSupID, "Gy_Supplier");
                if (DateTime.TryParse(Pub_Class.ClsPub.isStrNull(oMain.HDate), out billDate))
                {
                    dateValue = billDate.ToString("yyyy-MM-dd");
                }
@@ -31504,8 +31504,8 @@
                }
                string billNo = oMain.HBillNo;
                string supplierNumber = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["SupNumber"]);
                string purchaseOrgNumber =Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["orgNumber"]);//100
                string settleCurrId = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPSStyleID"]);
                string purchaseOrgNumber ="100";//100
                //string settleCurrId = Pub_Class.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPSStyleID"]);
                string sJson_StockStyle = "";
                    string sJson_Date = "";         //单据日期
                        sJson_StockStyle = "";
@@ -31572,7 +31572,7 @@
                 "\"FPOOrderEntry\":[";

                string sJson_Entry = "";
                DataSet dds = oCn.RunProcReturn("SELECT *,v.HNumber,org.HNumber orgnumber,gu.HNumber UnitNumber FROM Cg_POOrderBillSub a LEFT JOIN Gy_Material v on a.HMaterID=v.HItemID left join Xt_ORGANIZATIONS org on a.HRECEIVEORGID=org.HItemID LEFT JOIN Gy_Unit gu on gu.HItemID=a.HUnitID WHERE HInterID =" + Ds.Tables[0].Rows[0]["HInterID"], "Cg_POOrderBillSub");
                DataSet dds = oCn.RunProcReturn("select HNumber FROM Gy_Material where HItemID =" + oMain.HEmpID, "Gy_Material");

                // 检查是否有明细数据
                if (dds == null || dds.Tables[0].Rows.Count == 0)
@@ -31590,11 +31590,11 @@

                    // 从数据库获取字段值
                    string materialId = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HNumber"]);
                    string unitId = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["UnitNumber"]);
                    string quantity = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HQty"]);
                    string price = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HPrice"]);
                    string taxRate = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HTaxRate"]);
                    string orgnumber = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["orgnumber"]);
                    //string unitId = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["UnitNumber"]);
                    //string quantity = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HQty"]);
                    //string price = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HPrice"]);
                    //string taxRate = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["HTaxRate"]);
                    //string orgnumber = Pub_Class.ClsPub.isStrNull(dds.Tables[0].Rows[i]["orgnumber"]);

                    // 验证必填字段
                    if (string.IsNullOrEmpty(materialId))
@@ -31604,10 +31604,10 @@
                    }

                    // 设置默认值
                    if (string.IsNullOrEmpty(unitId)) unitId = "Pcs";
                    if (string.IsNullOrEmpty(quantity) || quantity == "0") quantity = "1";
                    if (string.IsNullOrEmpty(price)) price = "0";
                    if (string.IsNullOrEmpty(taxRate)) taxRate = "13";
                    string unitId = "Pcs";
                    string quantity = "1";
                    string price = "0";
                    string taxRate = "13";

                    // 转换数据类型
                    decimal qty = 1;
@@ -31704,8 +31704,8 @@
            }
            catch (Exception e)
            {
                oCn.RunProc("delete from Cg_POOrderBillMain where HInterID="+oMain.HInterID);
                oCn.RunProc("delete from Cg_POOrderBillSub where HInterID=" + oMain.HInterID);
                //oCn.RunProc("delete from Cg_POOrderBillMain where HInterID="+oMain.HInterID);
                //oCn.RunProc("delete from Cg_POOrderBillSub where HInterID=" + oMain.HInterID);
                LogService.Write("生成回滚" + e.Message + sRemark);
                sErrMsg = "生成采购单失败！" + e.Message;
                oCn.RollBack();