From 96bca0db0b7298f1e5a8510e3f657c2460276003 Mon Sep 17 00:00:00 2001 From: pzy <2829717936@qq.com> Date: 星期三, 18 九月 2024 10:15:22 +0800 Subject: [PATCH] 导入任务1 --- WebAPI/Controllers/工资管理/Pay_GroupBalBillController.cs | 204 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 204 insertions(+), 0 deletions(-) diff --git "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" index a1c9f76..c5ecf76 100644 --- "a/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" +++ "b/WebAPI/Controllers/\345\267\245\350\265\204\347\256\241\347\220\206/Pay_GroupBalBillController.cs" @@ -590,6 +590,210 @@ } #endregion + #region 宸ヨ祫缁撶畻鍗�(闆嗕綋)妯″潡 浠庡垪琛ㄩ�変腑鎵撳紑鍗曟嵁锛岃繑鍥炲崟鎹俊鎭椂璋冪敤 + /// <summary> + /// 宸ヨ祫缁撶畻鍗�(闆嗕綋)缂栬緫鏃讹紝鏍规嵁鍗曟嵁ID鑾峰彇鍗曟嵁淇℃伅 + /// </summary> + /// <returns></returns> + [Route("Pay_GroupBalBillController/GetPay_GroupBalBill_Json")] + [HttpGet] + public object GetPay_GroupBalBill_Json(Int64 HInterID, string HMaker) + { + try + { + //鍒ゆ柇鏉冮檺 + if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 3, false, HMaker)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎮ㄦ病鏈夎妯″潡缂栬緫鏉冮檺,璇蜂笌绠$悊鍛樿仈绯伙紒"; + objJsonResult.data = null; + return objJsonResult; + } + + //杩斿洖鍒楄〃淇℃伅 + ds = oCn.RunProcReturn("exec h_p_Pay_GroupBalBill_EditInit " + HInterID, "h_p_Pay_GroupBalBill_EditInit"); + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈煡璇㈠埌璇ュ伐璧勭粨绠楀崟(闆嗕綋)锛岃鍒锋柊鏁版嵁鍚庨噸鏂伴�夋嫨锛�"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鎴愬姛锛�"; + objJsonResult.data = new + { + Mainlist = ds.Tables[0], //杩斿洖涓昏〃淇℃伅锛�0锛� + Sublist = ds.Tables[1], //杩斿洖瀛愯〃1淇℃伅锛�1锛� + Emplist = ds.Tables[2], //杩斿洖瀛愯〃2淇℃伅锛�2锛� + }; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "杩斿洖宸ヨ祫缁撶畻鍗�(闆嗕綋)淇℃伅澶辫触锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion + + #region 宸ヨ祫缁撶畻鍗�(闆嗕綋)淇濆瓨 + /// <summary> + /// 宸ヨ祫缁撶畻鍗�(闆嗕綋)淇濆瓨 + /// </summary> + [Route("Pay_GroupBalBillController/GetPay_GroupBalBill_Save_Json")] + [HttpPost] + public object GetPay_GroupBalBill_Save_Json([FromBody] JObject sMainSub) + { + var _value = sMainSub["sMainSub"].ToString(); + string msg1 = _value.ToString(); + string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); + string sMainStr = sArray[0].ToString(); //涓昏〃鏁版嵁 + string sSubStr = sArray[1].ToString(); //瀛愯〃鏁版嵁 + string sSubStr2 = sArray[2].ToString(); //瀛愯〃鏁版嵁2 + string OperationType = sArray[3].ToString(); //鎿嶄綔绫诲瀷锛�1鏂板銆�2缂栬緫锛� + string HMaker = sArray[4].ToString(); //鍒跺崟浜� + try + { + //鍒ゆ柇鏉冮檺 + if (OperationType == "1") + { + BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; + //鍒ゆ柇鏂板鏉冮檺 + if (!DBUtility.ClsPub.Security_Log(ModRightName, 1, false, HMaker)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎮ㄦ病鏈夎妯″潡鏂板鏉冮檺,璇蜂笌绠$悊鍛樿仈绯伙紒"; + objJsonResult.data = null; + return objJsonResult; + } + } + else + { + BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify; + //鍒ゆ柇缂栬緫鏉冮檺 + if (!DBUtility.ClsPub.Security_Log(ModRightNameEdit, 1, false, HMaker)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鎮ㄦ病鏈夎妯″潡缂栬緫鏉冮檺,璇蜂笌绠$悊鍛樿仈绯伙紒"; + objJsonResult.data = null; + return objJsonResult; + } + } + //琛ㄥご璧嬪�� + sMainStr = sMainStr.Replace("\\", ""); + sMainStr = sMainStr.Replace("\n", ""); + sMainStr = "[" + sMainStr.ToString() + "]"; + List<Model.ClsPay_GroupBalBillMain> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPay_GroupBalBillMain>>(sMainStr); + foreach (Model.ClsPay_GroupBalBillMain oItem in lsmain) + { + //鍗曟嵁鍙锋槸鍚﹂噸澶� + if (oBill.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, oItem.HInterID)) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁鍙烽噸澶嶏紒涓嶅厑璁镐繚瀛橈紒"; + objJsonResult.data = null; + return objJsonResult; + } + //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞� + string s = ""; + int sYear = 0; + int sPeriod = 0; + if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod_Pay(oItem.HDate, ref sYear, ref sPeriod, ref s) == false) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = s; + objJsonResult.data = null; + return objJsonResult; + } + + oItem.HYear = sYear; + oItem.HPeriod = sPeriod; + DBUtility.ClsPub.CurUserName = oItem.HMaker; + oBill.omodel = oItem; + } + //琛ㄤ綋璧嬪�� + //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆� + sSubStr = sSubStr.Substring(1, sSubStr.Length - 2); + sSubStr = sSubStr.Replace("\\", ""); + sSubStr = sSubStr.Replace("\n", ""); + sSubStr = "[" + sSubStr.ToString() + "]"; + List<Model.ClsPay_GroupBalBillSub> ls = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPay_GroupBalBillSub>>(sSubStr); + int i = 0; + foreach (Model.ClsPay_GroupBalBillSub oItemSub in ls) + { + i++; + oItemSub.HEntryID = i; + oBill.DetailColl.Add(oItemSub); + } + //琛ㄤ綋璧嬪��2 + //鎸� },{鏉ユ媶鍒嗘暟缁� //鍘绘帀銆愬拰銆� + sSubStr2 = sSubStr2.Substring(1, sSubStr2.Length - 2); + sSubStr2 = sSubStr2.Replace("\\", ""); + sSubStr2 = sSubStr2.Replace("\n", ""); + sSubStr2 = "[" + sSubStr2.ToString() + "]"; + List<Model.ClsPay_GroupBalBillEmp> ls2 = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsPay_GroupBalBillEmp>>(sSubStr2); + int j = 0; + foreach (Model.ClsPay_GroupBalBillEmp oItemSub2 in ls2) + { + j++; + oItemSub2.HEntryID = j; + oBill.DetailEmpColl.Add(oItemSub2); + } + + //淇濆瓨 + bool bResult; + if (OperationType == "1") //鏂板淇濆瓨 + { + bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); + } + else //缂栬緫淇濆瓨 + { + bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); + } + + if (bResult) + { + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = DBUtility.ClsPub.sExeReturnInfo; //鎴愬姛锛� + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + DBUtility.ClsPub.sExeReturnInfo; + objJsonResult.data = null; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.Message; + objJsonResult.data = null; + return objJsonResult; + } + } + + #endregion + -- Gitblit v1.9.1