parent: 4273864d | 补丁 | 提交 | ignore whitespace
yusijie
2022-12-12 92e7b5a49f82fc6fd08d284bd6b3cfb2015eb832 
Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API
8个文件已修改
216 ■■■■■ 已修改文件
Model/基础资料/基础资料/ClsGy_CustLocation_Model.cs 1 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/BaseSet/Gy_CustomerController.cs 23 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/SCGL/Sc_ICMOReportBillController.cs 100 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/Sc_ProcessMangementController.cs 33 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/基础资料/基础资料/Gy_StockCheckItemBillController.cs 31 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Models/Cls_InventoryAnalysisList.cs 18 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 Model/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/ClsGy_CustLocation_Model.cs


@@ -16,5 +16,6 @@


        public string HStopEmp { get; set; }


        public int HUSEORGID { get; set; }


        public int HCREATEORGID { get; set; }


        public int HENTRYID { get; set; }


    }


}




 WebAPI/Controllers/BaseSet/Gy_CustomerController.cs


@@ -323,16 +323,18 @@


            try


            {


                var model = oMain["model"].ToString();


                var custLocationModel = oMain["model"]["HCustLocationEntry"].ToString();


                //反序列化


                model = "[" + model + "]";


                List<Customer> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Customer>>(model);


                List<Model.ClsGy_CustLocation_Model> custLocationls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_CustLocation_Model>>(custLocationModel);


                string sql = string.Empty;


                oCN.BeginTran();


                sql = $"delete gy_Customer where HItemID = {lsmain[0].HItemID}";


                oCN.RunProc(sql);


                sql = "set identity_insert gy_Customer on";


                oCN.RunProc(sql);


                //主表


                //主表_客户


                oCN.RunProc("Insert into Gy_Customer " +


                    " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                    ",HLevel,HEndFlag,HStopflag,HRemark" +


@@ -356,6 +358,25 @@


                    ", " + lsmain[0].HCusTypeID + ")");


                sql = "set identity_insert gy_Customer off";


                oCN.RunProc(sql);


                //客户_交货地点


                sql = $"delete Gy_CustLocation where HItemID = {lsmain[0].HItemID}";


                oCN.RunProc(sql);


                sql = "set identity_insert Gy_CustLocation on";


                oCN.RunProc(sql);


                foreach (var item in custLocationls)


                {


                    sql = $@"insert into Gy_CustLocation(HItemID,HEntryID,HNumber,HName ,HShortNumber,HParentID ,HLevel 


                                ,HEndFlag,HStopflag,HRemark ,HHelpCode ,HUseFlag


                                 ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp 


                                 ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID)


                  values({item.HItemID},{item.HENTRYID},'{item.HNumber}','{item.HName}','{item.HShortNumber}',{item.HParentID},{item.HLevel}


           ,{Convert.ToString(item.HEndFlag ? 1 : 0)},{Convert.ToString(item.HStopflag ? 1 : 0) },'{item.HRemark}','{item.HHelpCode}','{item.HUseFlag}'


            ,'{item.HMakeTime}','{item.HMakeEmp}','{item.HCheckEmp}','{item.HCheckTime}','{item.HModifyEmp}'


            ,'{item.HModifyTime}','{item.HStopEmp}',null,{item.HUSEORGID},{item.HCREATEORGID})";


                    oCN.RunProc(sql);


                }


                sql = "set identity_insert Gy_CustLocation off";


                oCN.RunProc(sql);


                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;




 WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs


@@ -560,7 +560,7 @@


                oCN.BeginTran();


                sql = $"delete Cg_POInStockBillMain where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                sql = $"delete Cg_POInStockBillMain where HinterID = {mainList[0].HInterID}";


                sql = $"delete Cg_POInStockBillSub where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                //主表


                sql = @"




 WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs


@@ -215,6 +215,7 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }




                //if (HWorkTimes <= 0)


                //{


                //    objJsonResult.code = "0";


@@ -255,10 +256,13 @@


                //    objJsonResult.data = null;


                //    return objJsonResult;


                //}


                var num = 0;




                //若MAINDI重复则重新获取


                oCN.BeginTran();


                if ("Add".Equals(eventType))


                {


                    num = 1;


                    if (!AllowbillNo(HBillNo))


                    {


                        oCN.RollBack();


@@ -290,6 +294,7 @@


                }


                else if ("Modify".Equals(eventType))


                {


                    num = 2;


                    oCN.RunProc("UpDate Sc_StationOutBillMain set  " +


                    "HUpDater='" + HMaker + "'" +


                    ",HUpDateDate=getdate()" +


@@ -358,7 +363,7 @@


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ",1");


                oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ","+ num + "");


                oCN.RunProc("exec h_p_Mes_ProcessExchangeChangeStatus  " + HInterID + " ");


                oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode  " + HInterID + " ");


                //判断是否是 æœ«é“工序 


@@ -394,6 +399,7 @@


            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "Exception！" + e.ToString();




 WebAPI/Controllers/SCGL/Sc_ICMOReportBillController.cs


@@ -31,7 +31,7 @@


        /// </summary>


        [Route("Sc_ICMOReportBill/list")]


        [HttpGet]


        public object list(string sWhere,string user)


        public object list(string sWhere, string user)


        {


            try


            {


@@ -52,7 +52,7 @@


                else


                {


                    string sql1 = "select * from h_v_IF_ICMOReportBillList_Edit where 1 = 1 ";


                    string sql = sql1 + sWhere+ " order by hmainid desc ";


                    string sql = sql1 + sWhere + " order by hmainid desc ";


                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOReportBillList_Edit");


                }




@@ -189,10 +189,10 @@


                msg2 = msg2.Replace("\\", "");


                msg2 = msg2.Replace("\n", "");  //\n


                lsmain = oListModels.getObjectByJson_Gy_ICMOReportBillMain(msg2);


                




                foreach (Models.ClsSc_ICMOReportBillMain oItem in lsmain)


                {


                    if (refSav == "Add") 


                    if (refSav == "Add")


                    {


                        //单据号是否重复


                        if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID))


@@ -215,7 +215,7 @@


                            return objJsonResult;


                        }


                        //判断是否可编辑


                        if (BillOld.omodel.HChecker != ""&& BillOld.omodel.HChecker != null)


                        if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null)


                        {


                            objJsonResult.code = "0";


                            objJsonResult.count = 0;


@@ -295,7 +295,7 @@


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);


                    oItemSub.HCloseType = false;   //关闭类型


                    //oItemSub.HRemark = "";         //备注


                    oItemSub.HSourceInterID =0;     // æºå•ä¸»å†…码


                    oItemSub.HSourceInterID = 0;     // æºå•ä¸»å†…码


                    oItemSub.HSourceEntryID = 0;   //源单子内码


                    //oItemSub.HSourceBillNo = "";  //源单单号


                    //oItemSub.HSourceBillType = ""; //源单类型


@@ -348,6 +348,92 @@


        }


        #endregion




        #region ç”Ÿäº§æ±‡æŠ¥å•ä¿å­˜api


        [Route("Sc_ICMOReportBill/Sc_ICMOReportBillSaveApi")]


        [HttpPost]


        public object Sc_ICMOReportBillSaveApi([FromBody] JObject sMainSub)


        {


            try


            {


                var model = sMainSub["model"].ToString();


                var entry = sMainSub["model"]["HENTRY"].ToString();




                model = "[" + model.ToString() + "]";


                List<ClsSc_ICMOReportBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_ICMOReportBillMain>>(model);


                List<ClsSc_ICMOReportBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_ICMOReportBillSub>>(entry);


                string sql = string.Empty;


                oCN.BeginTran();


                sql = $"delete Sc_ICMOReportBillMain where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                sql = $"delete Sc_ICMOReportBillSub where HinterID = {mainList[0].HInterID}";


                oCN.RunProc(sql);


                //主表


                sql = "Insert Into Sc_ICMOReportBillMain   " +


               "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" +


               ",HYear,HPeriod,HRemark,HEmpID,HEmpNumber" +


               ",HGroupID,HDeptID,HDeptNumber" +


               ",HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType" +


               ",HChecker,HCheckDate,HUpDater,HUpDateDate,HDeleteMan,HDeleteDate,HPrintQty,HCheckType" +


               ",HERPInterID,HERPBillType,HPRDORGID" +


               ") " +


               " values('" + mainList[0].HBillType + "','" + mainList[0].HBillSubType + "'," + mainList[0].HInterID.ToString() + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "','" + mainList[0].HMaker + "',getdate()" +


               "," + mainList[0].HYear.ToString() + "," + mainList[0].HPeriod.ToString() + ",'" + mainList[0].HRemark + "','" + mainList[0].HEmpID.ToString() + "','" + mainList[0].HEmpNumber +


               "','" + mainList[0].HGroupID.ToString() + "'," + mainList[0].HDeptID.ToString() + ",'" + mainList[0].HDeptNumber +


               "','" + mainList[0].HMainSourceBillNo.ToString() + "'," + mainList[0].HMainSourceInterID.ToString() + ",'" + mainList[0].HMainSourceEntryID + "','" + mainList[0].HMainSourceBillType + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HUpDater +


               "','" + mainList[0].HUpDateDate + "','" + mainList[0].HDeleteMan + "','" + mainList[0].HDeleteDate + "'," + mainList[0].HPrintQty +


               ",'" + mainList[0].HCheckType + "'," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "'," + mainList[0].HPRDORGID +


               ") ";


                oCN.RunProc(sql);


                //保存主表


                foreach (var oSub in subList)


                {


                    sql = "Insert into Sc_ICMOReportBillSub " +


                      " (HInterID,HEntryID,HMaterID,HMaterNumber" +


                      ",HQty,HUnitID,HUnitNumber,HTimes,HSourceID" +


                      ",HQtyMust,HWorkerID,HWorkerNumber,HBadCount,HWasterQty," +


                      "HCloseMan,HCloseType,HRemark," +


                      "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +


                      ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" +


                      ",HICMOInterID,HICMOBillNo,HBarCode" +


                      ",HOWNERTYPEID,HISENTRUST,HSTOCKINORGID,HOWNERID,HCHECKPRODUCT,HQAIP,HCOSTRATE,HISBACKFLUSH" +


                      ",HREQSRC,HREQBILLNO,HREQBILLID,HREQENTRYSEQ,HREQENTRYID,HMOMAINENTRYID,HSTOCKINQUASELQTY" +


                      ",HPRODUCTTYPE,HPROJECTNO,HICMOENTRYSEQ,HSEQ,HPRODUCEDATE,HEXPIRYDATE,HBASEUNITID,HDEPTID" +


                      ",HGroupID,HDESCRIPTION" +


                      ",HSourceNumber,HQPQty,HICMOEntryID" +


                      ",HWhID,HSPID,HBatChNo,HAuxPropID,HMTONo,HPlanMode,HERPInterID,HERPEntryID" +


                      ") values("


                      + oSub.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() + ",'" + oSub.HMaterNumber + "'" +


                      "," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() + ",'" + oSub.HUnitNumber + "'," + oSub.HTimes.ToString() + "," + oSub.HSourceID.ToString() +


                      "," + oSub.HQtyMust.ToString() + "," + oSub.HWorkerID.ToString() + ",'" + oSub.HWorkerNumber + "'," + oSub.HBadCount.ToString() + "," + oSub.HWasterQty.ToString() +


                      ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +


                      "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +


                      "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +


                      "," + oSub.HICMOInterID.ToString() + ",'" + oSub.HICMOBillNo + "','" + oSub.HBarCode + "','" + oSub.HOWNERTYPEID + "'," +


                      oSub.HISENTRUST + "," + oSub.HSTOCKINORGID + "," + oSub.HOWNERID + "," + oSub.HCHECKPRODUCT + ",'" + oSub.HQAIP + "'," +


                      oSub.HCOSTRATE + "," + oSub.HISBACKFLUSH + ",'" + oSub.HREQSRC + "','" + oSub.HREQBILLNO + "'," + oSub.HREQBILLID + "," +


                      oSub.HREQENTRYSEQ + "," + oSub.HREQENTRYID + "," + oSub.HMOMAINENTRYID + "," + oSub.HSTOCKINQUASELQTY + "," + oSub.HPRODUCTTYPE + ",'" + oSub.HPROJECTNO + "'," + oSub.HICMOENTRYSEQ + "," + oSub.HSEQ + ",'" + oSub.HPRODUCEDATE + "','" + oSub.HEXPIRYDATE + "'," + oSub.HBASEUNITID + "," + oSub.HDEPTID + "," + oSub.HGroupID + ",'" + oSub.HDESCRIPTION + "','" + oSub.HSourceNumber + "'," + oSub.HQPQty + "," + oSub.HICMOEntryID + "," + oSub.HWhID + "," + oSub.HSPID + ",'" + oSub.HBatChNo + "'," + oSub.HAuxPropID + ",'" + oSub.HMTONo + "'," + oSub.HPlanMode + "," + oSub.HERPInterID + "," + oSub.HERPEntryID +


                      ") ";


                    oCN.RunProc(sql);


                }


                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "单据保存成功！";


                objJsonResult.data = null;


                return objJsonResult;




            }


            catch (Exception e)


            {


                oCN.RollBack();


                objJsonResult.code = "0";


                objJsonResult.count = 0;


                objJsonResult.Message = "保存失败！" + e.ToString();


                objJsonResult.data = null;


                return objJsonResult;


            }


        }


        #endregion


        #region ç”Ÿäº§æ±‡æŠ¥å•åˆ é™¤åŠŸèƒ½


        /// <summary>


        /// æ¨¡å…·å¤„理领用单删除功能


@@ -355,7 +441,7 @@


        /// <returns></returns>


        [Route("Sc_ICMOReportBill/DeltetICMOReportBill")]


        [HttpGet]


        public object DeltetMouldLifeChangeBill(string HInterID,string user)


        public object DeltetMouldLifeChangeBill(string HInterID, string user)


        {


            //编辑权限


            if (!DBUtility.ClsPub.Security_Log_second("Sc_ICMOReportBill_Drop", 1, false, user))




 WebAPI/Controllers/Sc_ProcessMangementController.cs


@@ -167,16 +167,26 @@


                //根据工序汇报单主ID获取工序汇报入库单的数据


                DataSet ds = oCN.RunProcReturn("select * from h_v_MES_StationOutBillList_LastProc where HInterID=" + InterID, "h_v_MES_StationOutBillList_LastProc");


                DataRow dr = ds.Tables[0].Rows[0];


                


                //保存


                oCN.BeginTran();


                //生产汇报单主表


                oCN.RunProc("Insert Into Sc_ICMOReportBillMain   " +


                DataSet DsTable = oCN.RunProcReturn($"select * from Sc_ICMOReportBillMain where HBillNo='{HBillNo}'"  , "Sc_ICMOReportBillMain");


                if (DsTable.Tables[0].Rows.Count > 0)


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


                    objJsonResult.Message = "已入库,请不要重复入库";


                    objJsonResult.data = null;


                    return objJsonResult;


                }


                    //生产汇报单主表


                    oCN.RunProc("Insert Into Sc_ICMOReportBillMain   " +


                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate,HBillStatus,HChecker,HCheckDate" +


                ",HYear,HPeriod,HRemark,HEmpID,HEmpNumber" +


                ",HGroupID,HDeptID,HDeptNumber" +


                ",HMainSourceBillNo,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType" +


                ") " +


                " values('3711','3711'," + HInterID.ToString() + ",'" + HBillNo + "',getdate(),'" + user + "',getdate(),2,'" + user + "',getdate()" +


                " values('3711','3711'," + HInterID.ToString() + ",'" + BillNo + "',getdate(),'" + user + "',getdate(),2,'" + user + "',getdate()" +


                ",DATENAME(YEAR,GETDATE()),0,'','" + dr["HEmpID"].ToString() + "','" + dr["操作员代码"].ToString() +


                "','" + dr["HGroupID"].ToString() + "',0,''" +


                ",'" + BillNo.ToString() + "'," + InterID.ToString() + ", 0,'3791'" +


@@ -220,7 +230,7 @@


                model.Add("FPrdOrgId", new JObject() { ["Fnumber"] = dr1["FPrdOrgNUMBER"].ToString() }); //生产组织1


                model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //单据日期1


                model.Add("FHZYMESFLAG", "是");//  æ˜¯å¦ä¸ºMES同步


                model.Add("FBillNo", HBillNo);


                model.Add("FBillNo", BillNo);


                


                JArray Fentity = new JArray();




@@ -260,19 +270,6 @@


                    FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //包装标识


                    FentityModel.Add("FLot", new JObject() { ["FNumber"] = dr1["FBATCHNO"].ToString() }); //批号


                    FentityModel.Add("F_bsv_Text", dr1["工序流转卡号"].ToString()); //流转卡号


                    //批号


                    //FFLOWID FFLOWLINEID FRULEID FSTABLENAME


                    //f6e6eec3 - 5267 - 4f02 - 8593 - b633da508a72    3   PRD_MO2MORPT T_PRD_MOENTRY


                    //业务流程图：FEntity_Link_FFlowId


                    //推进路线：FEntity_Link_FFlowLineId


                    //转换规则：FEntity_Link_FRuleId


                    //源单表内码：FEntity_Link_FSTableId


                    //源单表：FEntity_Link_FSTableName


                    //源单内码：FEntity_Link_FSBillId


                    //源单分录内码：FEntity_Link_FSId


                    //原始携带量：FEntity_Link_FBaseQuaQtyOld


                    //修改携带量：FEntity_Link_FBaseQuaQty




                    JArray Fentity2 = new JArray();


                    JObject FentityModel2 = new JObject();


                    FentityModel2.Add("FEntity_Link_FFlowId", "f6e6eec3-5267-4f02-8593-b633da508a72");


@@ -439,7 +436,7 @@


                model.Add("FOwnerId0", new JObject() { ["FNumber"] = dr1["HPrdOrgNumber"].ToString() }); //


                model.Add("FIsEntrust", "false");//  


                model.Add("FCurrId", new JObject() { ["FNumber"] = "PRE001" }); //


                model.Add("FBillNo", HBillNo);


                model.Add("FBillNo", BillNo);




                JArray Fentity = new JArray();






 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs


@@ -298,11 +298,11 @@


            try


            {


                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


                //oCn.BeginTran();


              


                //oCN.RunProc("exec h_p_StockItemSubDel " + sID);


                oCn.BeginTran();




                //oCn.Commit();


                oCN.RunProc("exec h_p_StockItemSubDel " + sID);




                oCn.Commit();




                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -385,22 +385,13 @@


            {


                ds = MouldStockBillMainTemp(sWhere);




                //if (ds.Tables[0].Rows.Count != 0 || ds != null)


                //{


              


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "Sucess！";


                objJsonResult.data = ds.Tables[0];


                return objJsonResult;


                //}


                //else


                //{


                //objJsonResult.code = "0";


                //objJsonResult.count = 0;


                //objJsonResult.Message = "无数据";


                //objJsonResult.data = null;


                //return objJsonResult;


                //}


             


            }


            catch (Exception ex)


            {


@@ -481,7 +472,7 @@


                string userID = sArray[2].ToString();//userID


                string sName = sArray[3].ToString();//盘点方案


                //查询盘点方案创建日期


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem");


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName+"'", "Gy_StockCheckItem");


                string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString();




                //转化格式


@@ -570,7 +561,7 @@


                string userID = sArray[2].ToString();//userID


                string sName = sArray[3].ToString();//盘点方案


                //查询盘点方案创建日期


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem");


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem");


                string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString();




                //转化格式


@@ -660,7 +651,7 @@


                string userID = sArray[2].ToString();//userID


                string sName = sArray[3].ToString();//盘点方案


                //查询盘点方案创建日期


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem");


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName+"'", "Gy_StockCheckItem");


                string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString();






@@ -773,7 +764,7 @@


                string userID = sArray[2].ToString();//userID


                string sName = sArray[3].ToString();//盘点方案


                //查询盘点方案创建日期


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem");


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem");


                string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString();




                //转化格式


@@ -861,7 +852,7 @@


                string userID = sArray[2].ToString();//userID


                string sName = sArray[3].ToString();//盘点方案


                //查询盘点方案创建日期


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName=" + sName, "Gy_StockCheckItem");


                DataSet dd = oCn.RunProcReturn("select * from Gy_StockCheckItem where HName='" + sName + "'", "Gy_StockCheckItem");


                string HDate = dd.Tables[0].Rows[0]["HMakeTime"].ToString();




                //转化格式




 WebAPI/Models/Cls_InventoryAnalysisList.cs


@@ -7,14 +7,14 @@


{


    public class Cls_InventoryAnalysisList


    {


        public long HItemID;


        public string HBarCode;


        public string HMouldNo;


        public string HStockCheck;


        public string HRealPotType;


        public string HRealPot;


        public string HBookPotType;


        public string HBookPot;


        public string HMakeDate;


        public long HItemID { get; set; }


        public string HBarCode{ get; set; }


        public string HMouldNo{ get; set; }


        public string HStockCheck{ get; set; }


        public string HRealPotType{ get; set; }


        public string HRealPot{ get; set; }


        public string HBookPotType{ get; set; }


        public string HBookPot{ get; set; }


        public string HMakeDate{ get; set; }


    }


}