智云MES后端API代码
parent: 0a6224c1 | 补丁 | 提交 | ignore whitespace
yxj
2023-12-14 3fcf6df024ad311ee4d2436d0a80c5adf95dd1d4 
工资管理相关模块提交调用方法修改
10个文件已修改
38 ■■■■■ 已修改文件
WebAPI/Controllers/PublicPageMethodController.cs 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_GroupBalBillController.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_OtherBalBillController.cs 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_PayMentBillController.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_ProcPriceRequestBillController.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_SingleBalBillController.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/工资管理/Pay_WorkTimesBillController.cs 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/工资管理/ClsPay_OtherBalBill.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/工资管理/ClsPay_WorkTimesBill.cs 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Web.config 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 WebAPI/Controllers/PublicPageMethodController.cs


@@ -3672,13 +3672,13 @@


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


                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName  from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup");


                    ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName  from Gy_ClassTimePrj where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrj");


                }


                else


                {


                    string sql1 = "Select HItemID,HNumber ,HName  from Gy_ClassTimePrjGroup where HStopflag=0  ";


                    string sql1 = "Select HItemID,HNumber ,HName  from Gy_ClassTimePrj where HStopflag=0  ";


                    string sql = sql1 + sWhere;


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


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


                }




                //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo);




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_GroupBalBillController.cs


@@ -540,9 +540,9 @@


                string HExplanation = mainList[0].HExplanation;


                string HRemark = mainList[0].HRemark;


                string HMaker = mainList[0].HMaker;


                string HMakerDate = mainList[0].HMakerDate;


                DateTime HMakerDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HUpdater = mainList[0].HUpdater;


                string HUpdaterDate = mainList[0].HUpdaterDate;


                DateTime HUpdaterDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HChecker = mainList[0].HChecker;


                string HCheckerDate = mainList[0].HCheckerDate;


                string HCloseMan = mainList[0].HCloseMan;




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_OtherBalBillController.cs


@@ -146,6 +146,7 @@


            string UserName = "";


            string s = "";


            long mouldid;


            DBUtility.ClsPub.CurUserName = msg4;  //操作人


            ListModels oListModels = new ListModels();


            try


            {


@@ -266,7 +267,7 @@


                    //oItemSub.HRepairCheckContent = ""; //验收内容


                    //oItemSub.HManagerID = 0;   //负责人ID


                    //oItemSub.HCloseMan = "";       //行关闭


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


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate("");


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


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


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




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_PayMentBillController.cs


@@ -175,9 +175,9 @@






                string HMaker = mainList[0].HMaker;


                string HMakerDate = mainList[0].HMakerDate;


                DateTime HMakerDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HUpdater = mainList[0].HUpdater;


                string HUpdaterDate = mainList[0].HUpdaterDate;


                DateTime HUpdaterDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HChecker = mainList[0].HChecker;


                string HCheckerDate = mainList[0].HCheckerDate;


                string HCloseMan = mainList[0].HCloseMan;




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_ProcPriceRequestBillController.cs


@@ -173,9 +173,9 @@


                string HRemark = mainList[0].HRemark;




                string HMaker = mainList[0].HMaker;


                string HMakerDate = mainList[0].HMakerDate;


                DateTime HMakerDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HUpdater = mainList[0].HUpdater;


                string HUpdaterDate = mainList[0].HUpdaterDate;


                DateTime HUpdaterDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HChecker = mainList[0].HChecker;


                string HCheckerDate = mainList[0].HCheckerDate;


                string HCloseMan = mainList[0].HCloseMan;




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_SingleBalBillController.cs


@@ -604,9 +604,9 @@


                


                //制单、修改


                string HMaker = mainList[0].HMaker;


                string HMakerDate = mainList[0].HMakerDate;


                DateTime HMakerDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                string HUpdater = mainList[0].HUpdater;


                string HUpdaterDate = mainList[0].HUpdaterDate;


                DateTime HUpdaterDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString());


                




                //if (OperationType == 2)




 WebAPI/Controllers/¹¤×ʹÜÀí/Pay_WorkTimesBillController.cs


@@ -147,6 +147,7 @@




            string UserName = "";


            string s = "";


            DBUtility.ClsPub.CurUserName = msg4;  //操作人


            ListModels oListModels = new ListModels();


            try


            {


@@ -244,7 +245,7 @@


                {


                    i++;


                    oItemSub.HEntryID = i;


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


                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate("");


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


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


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




 WebAPI/DLL/¹¤×ʹÜÀí/ClsPay_OtherBalBill.cs


@@ -72,7 +72,7 @@


                      ",HPriceRate,HSubsidyTotal,HDeuctTotal,HSubsidyID,HDeuctID" +


                      ",HPackQty,HPackPrice,HPackMoney,HPackMaterID,HSubsidyQty,HSubsidyMoney" +


                      ") values("


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + (oSub.HEntryCloseDate.ToShortDateString() == "1900/1/1" ? "NULL" : "'" + oSub.HEntryCloseDate.ToShortDateString() + "'") + "," + 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.HMaterID.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HEmpID.ToString() + "," + oSub.HSourceID.ToString()


                      + "," + oSub.HTimes.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HSqty.ToString() +


@@ -136,7 +136,7 @@


                      ",HPriceRate,HSubsidyTotal,HDeuctTotal,HSubsidyID,HDeuctID" +


                      ",HPackQty,HPackPrice,HPackMoney,HPackMaterID,HSubsidyQty,HSubsidyMoney" +


                      ") values("


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + (oSub.HEntryCloseDate.ToShortDateString() == "1900/1/1" ? "NULL" : "'" + oSub.HEntryCloseDate.ToShortDateString() + "'")  + "," + 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.HMaterID.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HEmpID.ToString() + "," + oSub.HSourceID.ToString()


                      + "," + oSub.HTimes.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HSqty.ToString() +




 WebAPI/DLL/¹¤×ʹÜÀí/ClsPay_WorkTimesBill.cs


@@ -69,7 +69,7 @@


                      ",HEarlyQty,HEarlyTimes,HOutForEmpQty,HOutForEmpTimes,HOutForComQty,HOutForComTimes" +


                      ",HAbsentDays,HRestFlag,HSchClassID,HCTPrjID,HWorkTypeID,HPayMoney,HMoney" +


                      ") values("


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + (oSub.HEntryCloseDate.ToShortDateString() == "1900/1/1" ? "NULL" : "'" + oSub.HEntryCloseDate.ToShortDateString() + "'") + "," + 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.HEmpID.ToString() + "," + oSub.HEmpRate.ToString() + "," + oSub.HPMTimes.ToString() + "," + oSub.HAMTimes.ToString() + "," + oSub.HBaseTimes.ToString() + "," + oSub.HBaseDays.ToString() +


                      "," + oSub.HOverTimes.ToString() + "," + oSub.HOverDays.ToString() + "," + oSub.HLeaveTimes.ToString() + "," + oSub.HLeaveDays.ToString() + "," + oSub.HLateQty.ToString() + "," + oSub.HLateTimes.ToString() +


@@ -130,7 +130,7 @@


                      ",HEarlyQty,HEarlyTimes,HOutForEmpQty,HOutForEmpTimes,HOutForComQty,HOutForComTimes" +


                      ",HAbsentDays,HRestFlag,HSchClassID,HCTPrjID,HWorkTypeID,HPayMoney,HMoney" +


                      ") values("


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +


                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'," + (oSub.HEntryCloseDate.ToShortDateString() == "1900/1/1" ? "NULL" : "'" + oSub.HEntryCloseDate.ToShortDateString() + "'") + "," + 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.HEmpID.ToString() + "," + oSub.HEmpRate.ToString() + "," + oSub.HPMTimes.ToString() + "," + oSub.HAMTimes.ToString() + "," + oSub.HBaseTimes.ToString() + "," + oSub.HBaseDays.ToString() +


                      "," + oSub.HOverTimes.ToString() + "," + oSub.HOverDays.ToString() + "," + oSub.HLeaveTimes.ToString() + "," + oSub.HLeaveDays.ToString() + "," + oSub.HLateQty.ToString() + "," + oSub.HLateTimes.ToString() +




 WebAPI/Web.config


@@ -35,7 +35,7 @@


        <!--<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://192.168.56.1:81/web/WebService1.asmx"/>-->    <!--陈雯静本地配置-->


        <add key="sUrl" value="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx"/><!--九菱-->


        <!--<add key="sUrl" value="http://192.168.1.57:8082/WEBS-WMS/WebService1.asmx"/>--> <!--九菱-->




        <add key="webpages:Version" value="3.0.0.0" />


        <add key="webpages:Enabled" value="false" />