钉钉同步采购订单同步器具主档

llj

21 小时以前 ef0e5893c1b444d2e0b7a9ee13c90b9719c863f9

钉钉同步采购订单同步器具主档

 WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs

@@ -758,6 +758,7 @@
                var _value = sMainSub["sMainSub"].ToString();
                string msg1 = _value.ToString();
                oCN.BeginTran();
               
                //保存主表
                objJsonResult = AddBillMain(msg1);
                if (objJsonResult.code == "0")
@@ -770,6 +771,16 @@
                    return objJsonResult;
                }
                oCN.Commit();
                #region 生成金蝶单据（先保存到mes本地，通过本地调用生成金蝶单据）
                if (!jindieCloud(msg1))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "返回金蝶单据失败";  //成功！
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                #endregion
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "单据保存成功！";
@@ -787,7 +798,238 @@
                return objJsonResult;
            }
        }
        public bool jindieCloud(string msg1)
        {
            WebS.ClsCg_POOrderBillMain websLsmain = new WebS.ClsCg_POOrderBillMain();
            //WebS.ClsCg_POInStockBillMain websLsmain = new WebS.ClsKf_OtherOutBillMain();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString(); //主表数据
            string msg3 = sArray[1].ToString(); //子表数据
            int OperationType = int.Parse(sArray[2].ToString()); // 数据类型 1添加 3修改
            string user = sArray[3].ToString();
            string msg_allVal = sArray[4].ToString(); //主表+子表所有数据
            msg2 = "[" + msg2.ToString() + "]";
            List<ClsCg_POOrderBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillMain>>(msg2);
            websLsmain.HInterID = mainList[0].HInterID;
            websLsmain.HDate = mainList[0].HDate;
            websLsmain.HBillNo = mainList[0].HBillNo;
            websLsmain.HSupID = mainList[0].HSupID;
            websLsmain.HEmpID = mainList[0].HEmpID;
            websLsmain.HSTOCKORGID = mainList[0].HUSEORGID;
            websLsmain.HBillType = mainList[0].HBillType;
            if (!oWebs.set_Bill_New(websLsmain, "1100", ref DBUtility.ClsPub.sErrInfo))
            {
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "返回金蝶单据失败";  //成功！
                objJsonResult.data = null;
                return false;
            }
            objJsonResult = AddBillMould(msg1);
            if (objJsonResult.code == "0")
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = objJsonResult.Message;
                objJsonResult.data = null;
                return false;
            }
            return true;
        }
        public json AddBillMould(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            string msg3 = sArray[1].ToString();
            try
            {
                msg2 = "[" + msg2.ToString() + "]";
                List<Gy_Mould> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Mould>>(msg2);
                List<Gy_Mould> mainList1 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Mould>>(msg3);
                string BillType = "3899";
                //得到mainid
                long HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
                DateTime HDate = mainList[0].HDate;//日期
                int HYear = DBUtility.ClsPub.isInt(DateTime.Now.Year);
                double HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month);
                string HMouldNo = HInterID+"xxx";
                string HBarCode = HBillNo+"xxx";
                string HName = mainList[0].HName??"测试模具";
                string HModel = mainList[0].HModel?? "测试";
                string HModel2 = mainList[0].HModel2 ?? "测试";
                string HDiameter = mainList[0].HDiameter ?? "测试";
                string HSubjoin = mainList[0].HSubjoin ?? "测试";
                string HSubjoin2 = mainList[0].HSubjoin2 ?? "测试";
                string HPICNo = mainList[0].HPICNo ?? "测试";
                string HWorkMaterModel = mainList[0].HWorkMaterModel ?? "测试";
                long HMaterID = mainList1[0].HMaterID;
                long HMouleTypeID = 1;
                long HUnitID = mainList1[0].HUnitID;
                DateTime HOutComDate = DateTime.Now;
                string HOutComNo = mainList[0].HOutComNo ?? "测试";
                long HDeptID = 0;
                long HSupID = mainList[0].HSupID;
                string HMouldStatus = "0";
                long HWHID = 0;
                long HRoutingID = 0;
                long HBOMID = 0;
                string HVersion = "测试";
                long HSPGroupID = 0;
                long HSPID = 0;
                Double HDesignLife = 0;
                Double HUseLife = 0;
                Double HInitLife = 0;//上线初始化寿命
                Double HLeaveLife =0;
                Double HProdQty = 0;
                Double HProdWeight = 0;
                string HRemark = "测试";
                string HMaker = "admin";
                string HMaterNumber = "admin";
                string HSupNumber = "test";
                long HPrintQty =1;
                string HMouldOWNER = "test";
                string HSaveLife = "0";
                int HCaveQty = 0;
                int HMouldDotCheckRuleInterID =0;
                int HMouldMaintainRuleInterID = 0;
                int HNowSupID = 0;
                int HNowSupTypeID = 0;
                int HMadeSupID =0;
                string HMouldClass = "test";
                int HNowWHID = 0;
                int HNowSPID = 0;
                string HMouldUseStatus = "test";
                int HCREATEORGID = mainList[0].HCREATEORGID;
                int HUSEORGID = mainList[0].HUSEORGID;
                bool HTransPackFlag = false;     //周转容器标记
                bool HSendPackFlag = false;       //发货容器标记
                int HMouldLength =0;          //长
                int HMouldWidth = 0;            //宽
                int HMouldHeight = 0;          //高
                int HMouldFoldHeight =0;  //折叠高度

                int HUserID = 0;  // 使用人（Gy_Employee）
                string HBrand = "测试";  // 品牌
                string HCalibrationType = "测试";  // 校准类型 (内/外校)
                string HLocation = "测试";  // 位置
                DateTime HCalibrationDate =DateTime.Now;  // 校准日期
                string HCalibrationCycle = "测试";  // 校准周期
                string HProductDesignSize = "测试";  // 产品设计尺寸
                string HGaugeDesignSize = "测试";  // 检具设计尺寸
                int HProductQTY = 1;  // 产品数量

                //保存前控制=========================================
                string HBillNote = "";
                ds = oCN.RunProcReturn("Exec h_p_Gy_MouldFileMain_BeforeSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", "h_p_Gy_MouldFileMain_BeforeSaveCtrl");
                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存失败!原因:保存前判断失败，请与网络管理人员联系";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存失败!原因:" + ds.Tables[0].Rows[0]["HBackRemark"].ToString(); ;
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //=========================================================


                //主表
                oCN.RunProc("Insert Into Gy_MouldFileMain   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HMouldNo,HName,HModel,HModel2,HDiameter" +
                ",HSubjoin,HSubjoin2,HPICNo,HWorkMaterModel" +
                ",HMaterID,HMaterNumber,HMouldType,HUnitID" +
                ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" +
                ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" +
                ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" +
                ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID,HBarCode,HMadeSupID" +
                ",HMouldClass,HNowWHID,HNowSPID,HInitLife,HMouldUseStatus,HCREATEORGID,HUSEORGID " +
                 ",HMouldLength,HMouldWidth,HMouldHeight,HMouldFoldHeight,HTransPackFlag,HSendPackFlag," +
                 "HUserID,HBrand,HCalibrationType,HLocation,HCalibrationDate,HCalibrationCycle,HProductDesignSize,HGaugeDesignSize,HProductQTY ) " +

               " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" +
                "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" +
                ",'" + HMouldNo + "','" + HName + "','" + HModel + "','" + HModel2 + "','" + HDiameter + "'" +
                ",'" + HSubjoin + "','" + HSubjoin2 + "','" + HPICNo + "','" + HWorkMaterModel + "'" +
                "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID +
                ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" +
                "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID + "," + HCaveQty +
                "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID + "','" + HNowSupTypeID + "'" +
                ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID + "','" + HMouldMaintainRuleInterID + "','" + HBarCode + "'," + HMadeSupID +
                ",'" + HMouldClass + "'," + HNowWHID + "," + HNowSPID + ",'" + HInitLife + "','" + HMouldUseStatus + "'," + HCREATEORGID + "," + HUSEORGID +
                "," + HMouldLength + "," + HMouldWidth + "," + HMouldHeight + "," + HMouldFoldHeight + "," + Convert.ToString(HTransPackFlag ? 1 : 0) + "," + Convert.ToString(HSendPackFlag ? 1 : 0) + "," +
                "'" + HUserID + "','" + HBrand + "','" + HCalibrationType + "','" + HLocation + "','" + HCalibrationDate + "','" + HCalibrationCycle + "','" + HProductDesignSize + "','" + HGaugeDesignSize + "','" + HProductQTY + "') ");

                //子表
                oCN.RunProc("Insert into Gy_MouldFileSub " +
                    " (HInterID,HEntryID,HRemark" +
                    ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                    ") " +
                " values('" + HInterID + "',0,''" +
                ",0,0,'','',0,0 " +
                ") ");

                //objJsonResult = AddBillSub(msg5, msg6, msg7, HInterID, HBillNo);

                //保存后控制=========================================
                ds = oCN.RunProcReturn("Exec h_p_Gy_MouldFileMain_AfterSaveCtrl " + HInterID.ToString() + ", '" + HBillNo + "','" + HBillNote + "',1 ", "h_p_Gy_MouldFileMain_AfterSaveCtrl");
                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存失败!原因:保存前判断失败，请与网络管理人员联系";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存失败!原因:" + ds.Tables[0].Rows[0]["HBackRemark"].ToString(); ;
                    objJsonResult.data = null;
                    oCN.RollBack();
                    return objJsonResult;
                }
                //=========================================================


                if (objJsonResult.code == "0")
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = objJsonResult.Message;
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.HInterID = HInterID.ToString();
                objJsonResult.Message = null;
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception e)
            {
                oCN.RollBack();
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        public json AddBillMain(string msg1)
        {
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
@@ -801,7 +1043,6 @@
            {
                msg2 = "[" + msg2.ToString() + "]";
                List<ClsCg_POOrderBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsCg_POOrderBillMain>>(msg2);

                long HInterID = mainList[0].HInterID;//递入type得到的单据ID
                string HBillNo = mainList[0].HBillNo;//递入type得到的单据号
                long HPRDORGID = mainList[0].HPRDORGID;//组织
@@ -1225,6 +1466,8 @@
        }
        #endregion

        public WebS.WebService1 oWebs = new WebS.WebService1();
        
        /// <summary>
        ///删除功能
        /// </summary>

 WebAPI/Web References/WebS/Reference.cs

@@ -14812,6 +14812,16 @@
            sErrMsg = ((string)(results[1]));
            return ((bool)(results[0]));
        }
        [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/set_Bill_New", RequestNamespace = "http://tempuri.org/", ResponseNamespace = "http://tempuri.org/", Use = System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle = System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
        public bool set_Bill_New(ClsCg_POOrderBillMain oMain, string sHSourceType, ref string sErrMsg)
        {
            object[] results = this.Invoke("set_Bill_New", new object[] {
                        oMain,
                        sHSourceType,
                        sErrMsg});
            sErrMsg = ((string)(results[1]));
            return ((bool)(results[0]));
        }
        
        /// <remarks/>
        public void set_SaveOtherOutBill_NewAsync(ClsKf_OtherOutBillMain oMain, string sHSourceType, string sErrMsg) {
@@ -41535,7 +41545,226 @@
            }
        }
    }
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Xml", "4.8.9032.0")]
    [System.SerializableAttribute()]
    [System.Diagnostics.DebuggerStepThroughAttribute()]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.Xml.Serialization.XmlTypeAttribute(Namespace = "http://tempuri.org/")]
    public partial class ClsCg_POOrderBillMain : ClsXt_BaseBillMain
    {
    

        private long hSupIDField;

        private long hWHIDField;

        private long hSCWHIDField;

        private long hEmpIDField;

        private long hManagerIDField;

        private long hSecManagerIDField;

        private long hKeeperIDField;

        private long hDeptIDField;

        private string hExplanationField;

        private string hInnerBillNoField;

        private bool hRedBlueFlagField;

        private string hStockStyleField;

        private long hSTOCKORGIDField;

        private long hOWNERIDField;

        /// <remarks/>
        public long HSupID
        {
            get
            {
                return this.hSupIDField;
            }
            set
            {
                this.hSupIDField = value;
            }
        }

        /// <remarks/>
        public long HWHID
        {
            get
            {
                return this.hWHIDField;
            }
            set
            {
                this.hWHIDField = value;
            }
        }

        /// <remarks/>
        public long HSCWHID
        {
            get
            {
                return this.hSCWHIDField;
            }
            set
            {
                this.hSCWHIDField = value;
            }
        }

        /// <remarks/>
        public long HEmpID
        {
            get
            {
                return this.hEmpIDField;
            }
            set
            {
                this.hEmpIDField = value;
            }
        }

        /// <remarks/>
        public long HManagerID
        {
            get
            {
                return this.hManagerIDField;
            }
            set
            {
                this.hManagerIDField = value;
            }
        }

        /// <remarks/>
        public long HSecManagerID
        {
            get
            {
                return this.hSecManagerIDField;
            }
            set
            {
                this.hSecManagerIDField = value;
            }
        }

        /// <remarks/>
        public long HKeeperID
        {
            get
            {
                return this.hKeeperIDField;
            }
            set
            {
                this.hKeeperIDField = value;
            }
        }

        /// <remarks/>
        public long HDeptID
        {
            get
            {
                return this.hDeptIDField;
            }
            set
            {
                this.hDeptIDField = value;
            }
        }

        /// <remarks/>
        public string HExplanation
        {
            get
            {
                return this.hExplanationField;
            }
            set
            {
                this.hExplanationField = value;
            }
        }

        /// <remarks/>
        public string HInnerBillNo
        {
            get
            {
                return this.hInnerBillNoField;
            }
            set
            {
                this.hInnerBillNoField = value;
            }
        }

        /// <remarks/>
        public bool HRedBlueFlag
        {
            get
            {
                return this.hRedBlueFlagField;
            }
            set
            {
                this.hRedBlueFlagField = value;
            }
        }

        /// <remarks/>
        public string HStockStyle
        {
            get
            {
                return this.hStockStyleField;
            }
            set
            {
                this.hStockStyleField = value;
            }
        }

        /// <remarks/>
        public long HSTOCKORGID
        {
            get
            {
                return this.hSTOCKORGIDField;
            }
            set
            {
                this.hSTOCKORGIDField = value;
            }
        }

        /// <remarks/>
        public long HOWNERID
        {
            get
            {
                return this.hOWNERIDField;
            }
            set
            {
                this.hOWNERIDField = value;
            }
        }
    }
    /// <remarks/>
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Xml", "4.8.9032.0")]
    [System.SerializableAttribute()]

 WebAPI/Web.config

@@ -33,7 +33,7 @@
        <!--<add key="sUrl" value="http://122.227.133.186:8090/WEBS/WebService1.asmx"/>    -->
        <!--<add key="sUrl" value="http://192.168.80.90:9090/WEBS-WMS/WebService1.asmx"/>     安瑞服务器-->
        <!--<add key="sUrl" value="http://47.96.97.237/WEBS-WMS/WebService1.asmx"/>-->  <!--测试服务器-->
        <add key="surl" value="http://localhost:8082/webs/webservice1.asmx"/>    <!--本地-->
        <!--<add key="surl" value="http://localhost:8082/webs/webservice1.asmx"/>    --><!--本地-->
        <!--<add key="sUrl" value="http://192.168.110.57:81/WEBS/WebService1.asmx"/>-->    <!--陈雯静本地配置-->
        <!--<add key="surl" value="http://localhost/webs-web/webservice1.asmx" />--> <!--翁涛涛本地配置-->
        <!--<add key="sUrl" value="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx"/>九菱-->