PayrollComputation.cs 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604
  1. using OASystem.API.OAMethodLib.QiYeWeChatAPI;
  2. using OASystem.Domain;
  3. using OASystem.Domain.Entities.PersonnelModule;
  4. using OASystem.Domain.ViewModels.PersonnelModule;
  5. using OASystem.Domain.ViewModels.QiYeWeChat;
  6. using OASystem.Infrastructure.Repositories.Groups;
  7. namespace OASystem.API.OAMethodLib
  8. {
  9. /// <summary>
  10. /// 工资计算
  11. /// </summary>
  12. public static class PayrollComputation
  13. {
  14. private static Result _result = new Result();
  15. private static readonly IQiYeWeChatApiService _qiYeWeChatApiService = AutofacIocManager.Instance.GetService<IQiYeWeChatApiService>();
  16. private static readonly UsersRepository _usersRep = AutofacIocManager.Instance.GetService<UsersRepository>();
  17. private static readonly IMapper _mapper = AutofacIocManager.Instance.GetService<IMapper>();
  18. private static readonly decimal _chengDuMinimumWage = 2100.00M;
  19. /// <summary>
  20. /// 计算工资
  21. /// </summary>
  22. /// <param name="pm_WageSheetDattaSources"></param>
  23. /// <param name="userNames"></param>
  24. /// <param name="thisYearMonth"></param>
  25. /// <param name="startDt"></param>
  26. /// <param name="endDt"></param>
  27. /// <returns></returns>
  28. public static async Task<Result> SalaryCalculatorAsync(
  29. List<Pm_WageSheet> pm_WageSheetDattaSources, List<UserNameView> userNames,int userId, string thisYearMonth, DateTime startDt, DateTime endDt)
  30. {
  31. if (pm_WageSheetDattaSources.Count <= 0)
  32. {
  33. _result.Msg = "计算工资传入数据为空!";
  34. return _result;
  35. }
  36. if (userNames.Count <= 0 )
  37. {
  38. var nameData = await _usersRep.GetUserNameList(1);
  39. userNames = nameData.Data;
  40. }
  41. //获取所有打卡数据
  42. CheckInView checkIn = await _qiYeWeChatApiService.GetCheckin_MonthDataAsync(startDt, endDt); //时间段内所有 打卡数据
  43. if (checkIn.errcode != 0)
  44. {
  45. _result.Msg = checkIn.errmsg;
  46. return _result;
  47. }
  48. List<Data> checkInDatas = checkIn.datas;
  49. List<Sp_Info> sp_Infos = new List<Sp_Info>();
  50. sp_Infos = await _qiYeWeChatApiService.GetApprovalDatasAsync(startDt, endDt); //时间段内所有 审批数据
  51. if (sp_Infos.Count <= 0)
  52. {
  53. string errMsg = startDt + " - " + endDt + "审批数据获取失败!";
  54. return _result;
  55. }
  56. // 筛选 时间段内(请假时间,补卡时间) /审批类型(打卡补卡,请假)/审核通过的数据
  57. List<Sp_Info> sp_leave_InfosData = sp_Infos.Where(it => it.sp_status == 2 && it.spname == "请假" && it.leave.start_time_dt >= startDt && it.leave.start_time_dt <= endDt).ToList(); //请假
  58. List<Sp_Info> sp_reissuecard_InfosData = sp_Infos.Where(it => it.sp_status == 2 && it.spname == "打卡补卡" && it.comm.FillingDt >= startDt && it.comm.FillingDt <= endDt).ToList(); //补卡
  59. foreach (var pm_wsInfo in pm_WageSheetDattaSources)
  60. {
  61. string itemName = userNames.Where(it => it.Id == pm_wsInfo.UserId).FirstOrDefault().CnName;
  62. //补贴 金额
  63. decimal meal_subsidy = 0.00M; // 午餐(午餐10元/天) 补贴 * 计算方式:单日上午请假时长(小时)大于或者等于三小时 没有餐补
  64. //事假 病假 总金额
  65. decimal personalLeaveTotal = 0.00M, // 事假 日薪 *计算方式:日平均工资 = 月工资/当月应出勤天数。
  66. sickLeaveTotal = 0.00M; // 病假 日薪 *计算方式:日平均工资 = 成都市最低工资标准的80%/当月应出勤天数。 短期病假=当月15天内
  67. //扣款金额
  68. decimal beLate_deduction = 0.00M, // 迟到 扣款金额 *计算方式:
  69. // 一个自然月内,不足 10 分钟的迟到/早退,不超过 2 次的部分,不做处罚;3 次及以上,按50元 / 次处罚;
  70. // 超过 10 分钟(含 10 分钟),不足 60 分钟的迟到/早退,按 50 元/次处罚;
  71. // 超过 60 分钟(含 60 分钟),不足 3 小时的迟到/早退,且无请假者,按旷工半日处理;超过3 小时的迟到 / 早退,且无请假者,按旷工一日处理。
  72. early_deduction = 0.00M, // 早退 扣款金额
  73. absenteeism_deduction = 0.00M, // 旷工 扣款金额 *计算方式:旷工扣发当日工资
  74. unprinted_deduction = 0.00M, // 未打卡 扣款金额 *计算方式:
  75. // 试用期员工每月有 2 次 补卡机会,超过 2 次不足 5 次的部分,按 10 元 / 次处罚,5 次及以上的漏卡,按 50 元 / 次处罚;
  76. // 正式员工每月 3 次以内的补卡,按 10 元 / 次处罚,3 次及以上的漏卡,按 50 元 / 次处罚。
  77. sickLeave_deduction = 0.00M,
  78. other_deduction = 0.00M; // 其他 扣款金额
  79. decimal meal_deduction = 0.00M; // 餐补 扣款金额
  80. decimal reissuecard_deduction = 0.00M; // 补卡 扣款金额
  81. //打卡数据
  82. Data? checkInData = checkInDatas.Where(it => it.base_info.name == itemName).FirstOrDefault();
  83. if (checkInData == null) { continue; }
  84. string acctid = checkInData.base_info.acctid; //用户Id
  85. //当月总计数据
  86. Summary_Info? summary_Info = checkInData.summary_info;
  87. if (summary_Info == null) { continue; }
  88. int work_days = summary_Info.work_days; //应出勤天数
  89. int regular_days = summary_Info.regular_days; //正常出勤天数
  90. meal_subsidy = work_days * 10; //应发放餐补
  91. #region 计算日工资 正常日薪 事假日薪 病假日薪
  92. //月 - 应发工资
  93. decimal amountPayable = pm_wsInfo.Basic + pm_wsInfo.Floats + pm_wsInfo.PostAllowance + pm_wsInfo.GarmentWashSubsidies + pm_wsInfo.CommunicationSubsidies +
  94. pm_wsInfo.TrafficSubsidies + pm_wsInfo.InformationSecurityFee + pm_wsInfo.OperationBonus + pm_wsInfo.SpecialAllowance + pm_wsInfo.OtherSubsidies + pm_wsInfo.GroupCost;
  95. // 日薪 = 事假日薪 *计算方式:日平均工资 = 月工资/当月应出勤天数。
  96. decimal dailyWage = amountPayable / work_days;
  97. // 病假日薪 *计算方式:日平均工资 = 成都市最低工资标准的80%/当月应出勤天数。 短期病假=当月15天内
  98. decimal sickLeave_dailywage = _chengDuMinimumWage / work_days;
  99. //病假 一天扣款
  100. sickLeave_deduction = dailyWage - sickLeave_dailywage;
  101. #endregion
  102. int annualLeaveNum = 0, //年假
  103. personalLeaveNum = 0, //事假
  104. sickLeaveNum = 0, //病假
  105. lieuLeaveNum = 0, //调休假
  106. marriageLeaveNum = 0, //婚嫁
  107. maternityLeaveNum = 0, //产假
  108. paternityLeaveNum = 0, //陪产假
  109. funeralLeaveNum = 0, //丧假
  110. reissueCardNum = 0, //补卡 次数
  111. evectionNum = 0, //出差 次数
  112. outIngNum = 0, //外出 次数
  113. outWorkNum = 0, //外勤 次数
  114. otherLeaveNum = 0; //其他
  115. #region 假勤 处理 1-请假;2-补卡;3-出差;4-外出;100-外勤;
  116. List<Sp_Item>? sp_items = checkInData.sp_items.Where(it => it.count != 0).ToList();
  117. if (sp_items != null && sp_items.Count > 0)
  118. {
  119. annualLeaveNum = Fallibilitydispose(sp_items, 1, "年假");
  120. personalLeaveNum = Fallibilitydispose(sp_items, 1, "事假");
  121. sickLeaveNum = Fallibilitydispose(sp_items, 1, "病假");
  122. lieuLeaveNum = Fallibilitydispose(sp_items, 1, "调休假");
  123. marriageLeaveNum = Fallibilitydispose(sp_items, 1, "婚嫁");
  124. maternityLeaveNum = Fallibilitydispose(sp_items, 1, "产假");
  125. paternityLeaveNum = Fallibilitydispose(sp_items, 1, "陪产假");
  126. funeralLeaveNum = Fallibilitydispose(sp_items, 1, "丧假");
  127. otherLeaveNum = Fallibilitydispose(sp_items, 1, "其他");
  128. reissueCardNum = Fallibilitydispose(sp_items, 2, "补卡次数");
  129. evectionNum = Fallibilitydispose(sp_items, 3, "出差");
  130. outIngNum = Fallibilitydispose(sp_items, 4, "外出");
  131. outWorkNum = Fallibilitydispose(sp_items, 3, "外勤");
  132. }
  133. #region 请假类型金额/餐补 处理
  134. List<Sp_Info> sp_leave_item_infosData = sp_leave_InfosData.Where(it => it.spname == "请假" && it.apply_name == itemName).ToList();
  135. List<Ex_Items> ex_Items = new List<Ex_Items>();//假勤 And 打卡备注集合
  136. Ex_Items ex_Items_jq = new Ex_Items() { Type = "假勤" }; //假勤
  137. List<Ex_Item> ex_ItemInfos = new List<Ex_Item>();
  138. foreach (Sp_Info sp_item in sp_leave_item_infosData)
  139. {
  140. Leave? sp_leave = sp_item.leave;
  141. if (sp_leave != null)
  142. {
  143. //请假时长
  144. double leaveLength = (sp_leave.end_time_dt - sp_leave.start_time_dt).TotalHours;
  145. string typeName = string.Empty;
  146. //leave_type 1年假;2事假;3病假;4调休假;5婚假;6产假;7陪产假;8其他
  147. switch (sp_leave.leave_type)
  148. {
  149. case 1: //年假
  150. typeName = "年假";
  151. if (sp_leave.timeunit == 0) //半天
  152. {
  153. meal_deduction += 10;
  154. }
  155. else if (sp_leave.timeunit == 1) //小时
  156. {
  157. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  158. {
  159. meal_deduction += 10;
  160. }
  161. else if (sp_leave.duration > 7.5)
  162. {
  163. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  164. meal_deduction += daysPrice;
  165. }
  166. }
  167. break;
  168. case 2: //事假 需调整
  169. typeName = "事假";
  170. if (sp_leave.timeunit == 0) //半天
  171. {
  172. meal_deduction += 10;
  173. personalLeaveTotal += dailyWage / 2;
  174. }
  175. else if (sp_leave.timeunit == 1) //小时
  176. {
  177. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  178. {
  179. meal_deduction += 10;
  180. }
  181. else if (sp_leave.duration > 7.5)
  182. {
  183. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  184. meal_deduction += daysPrice;
  185. }
  186. }
  187. break;
  188. case 3: //病假 需调整
  189. typeName = "病假";
  190. if (sp_leave.timeunit == 0) //半天
  191. {
  192. meal_deduction += 10;
  193. sickLeaveTotal += sickLeave_deduction / 2;
  194. }
  195. else if (sp_leave.timeunit == 1) //小时
  196. {
  197. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  198. {
  199. meal_deduction += 10;
  200. }
  201. else if (sp_leave.duration > 7.5)
  202. {
  203. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  204. meal_deduction += daysPrice;
  205. }
  206. }
  207. break;
  208. case 4: //调休假
  209. typeName = "调休假";
  210. if (sp_leave.timeunit == 0) //半天
  211. {
  212. meal_deduction += 10;
  213. }
  214. else if (sp_leave.timeunit == 1) //小时
  215. {
  216. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  217. {
  218. meal_deduction += 10;
  219. }
  220. else if (sp_leave.duration > 7.5)
  221. {
  222. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  223. meal_deduction += daysPrice;
  224. }
  225. }
  226. break;
  227. case 5: //婚假
  228. typeName = "婚假";
  229. if (sp_leave.timeunit == 0) //半天
  230. {
  231. meal_deduction += 10;
  232. }
  233. else if (sp_leave.timeunit == 1) //小时
  234. {
  235. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  236. {
  237. meal_deduction += 10;
  238. }
  239. else if (sp_leave.duration > 7.5)
  240. {
  241. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  242. meal_deduction += daysPrice;
  243. }
  244. }
  245. break;
  246. case 6: //产假
  247. typeName = "产假";
  248. if (sp_leave.timeunit == 0) //半天
  249. {
  250. meal_deduction += 10;
  251. }
  252. else if (sp_leave.timeunit == 1) //小时
  253. {
  254. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  255. {
  256. meal_deduction += 10;
  257. }
  258. else if (sp_leave.duration > 7.5)
  259. {
  260. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  261. meal_deduction += daysPrice;
  262. }
  263. }
  264. break;
  265. case 7: //陪产假
  266. typeName = "陪产假";
  267. if (sp_leave.timeunit == 0) //半天
  268. {
  269. meal_deduction += 10;
  270. }
  271. else if (sp_leave.timeunit == 1) //小时
  272. {
  273. if (sp_leave.duration >= 3 && sp_leave.duration <= 7.5) //7.5小时 一天
  274. {
  275. meal_deduction += 10;
  276. }
  277. else if (sp_leave.duration > 7.5)
  278. {
  279. decimal daysPrice = Convert.ToDecimal(sp_leave.duration / 7.5 * 10);
  280. meal_deduction += daysPrice;
  281. }
  282. }
  283. break;
  284. default:
  285. break;
  286. }
  287. Ex_Item ex_Item = new Ex_Item()
  288. {
  289. SubTypeId = sp_leave.leave_type,
  290. SubType = typeName,
  291. Start_time_dt = sp_leave.start_time_dt,
  292. End_time_dt = sp_leave.end_time_dt,
  293. Duration = sp_leave.duration,
  294. Reason = sp_leave.reason,
  295. Apply_time_dt = sp_item.apply_time_dt,
  296. Approval_name = sp_item.approval_name,
  297. };
  298. ex_ItemInfos.Add(ex_Item);
  299. }
  300. }
  301. if (ex_ItemInfos.Count > 0)
  302. {
  303. ex_Items_jq.Ex_ItemInfo = ex_ItemInfos.OrderBy(it => it.SubTypeId).ThenBy(it => it.Start_time_dt).ToList();
  304. ex_Items.Add(ex_Items_jq);
  305. }
  306. #endregion
  307. #endregion
  308. #region 打卡补卡 处理
  309. if (reissueCardNum == 3)
  310. {
  311. reissuecard_deduction += 10;
  312. }
  313. else if (reissueCardNum >= 4)
  314. {
  315. reissuecard_deduction += 50;
  316. }
  317. #endregion
  318. Ex_Items ex_Items_dk = new Ex_Items() { Type = "打卡" }; //打卡
  319. //List<Ex_Item> ex_reissuecard_Items = new List<Ex_Item>();
  320. List<dynamic> ex_reissuecard_Items = new List<dynamic>();
  321. List<Sp_Info> sp_reissuecard_item_InfosData = sp_reissuecard_InfosData.Where(it => it.apply_name == itemName).ToList();
  322. #region 打卡异常处理 统计 1-迟到;2-早退;3-缺卡;4-旷工;5-地点异常;6-设备异常;
  323. int beLateNum = 0, // 1-迟到;
  324. leaveEarlyNum = 0, // 2-早退;
  325. dummyDeckNum = 0, // 3-缺卡;
  326. minerNum = 0, // 4-旷工;
  327. locationAnomalyNum = 0, // 5-地点异常;
  328. unitExNum = 0; // 6-设备异常;
  329. if (summary_Info.except_days > 0)
  330. {
  331. List<Exception_Info>? ex_infos = checkInData.exception_infos;
  332. if (ex_infos != null && ex_infos.Count >= 0)
  333. {
  334. beLateNum = ExceptionStatistics(ex_infos, 1);
  335. leaveEarlyNum = ExceptionStatistics(ex_infos, 2);
  336. dummyDeckNum = ExceptionStatistics(ex_infos, 3);
  337. minerNum = ExceptionStatistics(ex_infos, 4);
  338. locationAnomalyNum = ExceptionStatistics(ex_infos, 5);
  339. unitExNum = ExceptionStatistics(ex_infos, 6);
  340. }
  341. }
  342. foreach (Sp_Info sp_reissuecard_item in sp_reissuecard_item_InfosData)
  343. {
  344. DateTime apply_time_dt = sp_reissuecard_item.apply_time_dt; //申请时间
  345. List<string>? approval_name = sp_reissuecard_item.approval_name; //审核人
  346. Comm sp_comm = sp_reissuecard_item.comm;
  347. if (sp_comm != null)
  348. {
  349. if (sp_comm.applydata != null)
  350. {
  351. List<ApplyInfo> applyInfos = sp_comm.applydata;
  352. if (applyInfos.Count > 0)
  353. {
  354. //Ex_Item ex_reissuecard_Item = new Ex_Item();
  355. dynamic ex_reissuecard_Item = null;
  356. string text = applyInfos.Where(it => it.type == "text").FirstOrDefault().value.ToString(); //异常状态
  357. DateTime? datehour = applyInfos.Where(it => it.type == "datehour").FirstOrDefault().valueDt;//补卡时间
  358. string textarea = applyInfos.Where(it => it.type == "textarea").FirstOrDefault().value.ToString();//补卡事由
  359. if (text.Contains("未打卡"))
  360. {
  361. ex_reissuecard_Item = new
  362. {
  363. SubTypeId = 0,
  364. SubType = "未打卡",
  365. title = text,
  366. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  367. textarea = textarea,
  368. apply_time_dt = apply_time_dt,
  369. approval_name = approval_name
  370. };
  371. }
  372. else if (text.Contains("迟到"))
  373. {
  374. ex_reissuecard_Item = new
  375. {
  376. SubTypeId = 1,
  377. SubType = "迟到",
  378. title = text,
  379. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  380. textarea = textarea,
  381. apply_time_dt = apply_time_dt,
  382. approval_name = approval_name
  383. };
  384. }
  385. else if (text.Contains("早退"))
  386. {
  387. ex_reissuecard_Item = new
  388. {
  389. SubTypeId = 2,
  390. SubType = "早退",
  391. title = text,
  392. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  393. textarea = textarea,
  394. apply_time_dt = apply_time_dt,
  395. approval_name = approval_name
  396. };
  397. }
  398. else if (text.Contains("缺卡"))
  399. {
  400. ex_reissuecard_Item = new
  401. {
  402. SubTypeId = 3,
  403. SubType = "缺卡",
  404. title = text,
  405. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  406. textarea = textarea,
  407. apply_time_dt = apply_time_dt,
  408. approval_name = approval_name
  409. };
  410. }
  411. else if (text.Contains("旷工"))
  412. {
  413. ex_reissuecard_Item = new
  414. {
  415. SubTypeId = 4,
  416. SubType = "旷工",
  417. title = text,
  418. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  419. textarea = textarea,
  420. apply_time_dt = apply_time_dt,
  421. approval_name = approval_name
  422. };
  423. }
  424. else if (text.Contains("地点异常"))
  425. {
  426. ex_reissuecard_Item = new
  427. {
  428. SubTypeId = 5,
  429. SubType = "地点异常",
  430. title = text,
  431. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  432. textarea = textarea,
  433. apply_time_dt = apply_time_dt,
  434. approval_name = approval_name
  435. };
  436. }
  437. else if (text.Contains("设备异常"))
  438. {
  439. ex_reissuecard_Item = new
  440. {
  441. SubTypeId = 6,
  442. SubType = "设备异常",
  443. title = text,
  444. datehour = datehour == null ? "" : Convert.ToDateTime(datehour).ToString("yyyy-MM-dd HH:mm:ss"),
  445. textarea = textarea,
  446. apply_time_dt = apply_time_dt,
  447. approval_name = approval_name
  448. };
  449. }
  450. if (ex_reissuecard_Item != null)
  451. {
  452. ex_reissuecard_Items.Add(ex_reissuecard_Item);
  453. }
  454. }
  455. }
  456. }
  457. }
  458. if (ex_reissuecard_Items.Count > 0)
  459. {
  460. ex_Items_dk.Ex_ItemInfo = ex_reissuecard_Items.OrderBy(it => it.SubTypeId).ThenBy(it => it.datehour).ToList();
  461. ex_Items.Add(ex_Items_dk);
  462. }
  463. #endregion
  464. #region 应发合计 实发合计 扣款合计(假勤扣款,其他扣款,社保扣款,公积金代扣,个税扣款)
  465. decimal mealTotal = meal_subsidy - meal_deduction; //餐补
  466. decimal salaryTotal = amountPayable + mealTotal; //应发合计
  467. //扣款合计 不含个税
  468. decimal eductionTotal = sickLeaveTotal + personalLeaveTotal + beLate_deduction + early_deduction + absenteeism_deduction + unprinted_deduction + other_deduction +
  469. pm_wsInfo.WithholdingInsurance + pm_wsInfo.ReservedFunds;
  470. decimal actualReleaseTotal = salaryTotal - eductionTotal; //实发合计 * 不含个税
  471. #endregion
  472. #region 处理当月工资数据
  473. pm_wsInfo.YearMonth = thisYearMonth;
  474. pm_wsInfo.StartDate = startDt.ToString("yyyy-MM-dd");
  475. pm_wsInfo.EndDate = endDt.ToString("yyyy-MM-dd");
  476. pm_wsInfo.SickLeave = sickLeaveTotal; //病假
  477. pm_wsInfo.SomethingFalse = personalLeaveTotal; //事假
  478. pm_wsInfo.LateTo = beLate_deduction; //迟到
  479. pm_wsInfo.LeaveEarly = early_deduction; //早退
  480. pm_wsInfo.Absenteeism = absenteeism_deduction; //旷工
  481. pm_wsInfo.NotPunch = unprinted_deduction; //未打卡
  482. pm_wsInfo.OtherDeductions = other_deduction; //其他
  483. pm_wsInfo.Ex_ItemsRemark = JsonConvert.SerializeObject(ex_Items); //
  484. pm_wsInfo.Mealsupplement = mealTotal; //餐补
  485. pm_wsInfo.Should = salaryTotal; //应发合计
  486. pm_wsInfo.TotalDeductions = eductionTotal; //扣款合计
  487. pm_wsInfo.TotalRealHair = actualReleaseTotal; //实发合计
  488. pm_wsInfo.AfterTax = actualReleaseTotal - pm_wsInfo.WithholdingTax; //税后工资
  489. pm_wsInfo.LastUpdateUserId = userId;
  490. pm_wsInfo.LastUpdateDt = DateTime.Now;
  491. pm_wsInfo.CreateUserId = userId;
  492. pm_wsInfo.CreateTime = DateTime.Now;
  493. pm_wsInfo.DeleteUserId = null;
  494. pm_wsInfo.DeleteTime = null;
  495. #endregion
  496. }
  497. _result.Code = 0;
  498. _result.Data = pm_WageSheetDattaSources;
  499. return _result;
  500. }
  501. /// <summary>
  502. /// 打卡数据
  503. /// 假勤数据 统计
  504. /// </summary>
  505. /// <param name="datas">数据源</param>
  506. /// <param name="type">
  507. /// 1-请假;2-补卡;3-出差;4-外出;100-外勤;
  508. /// </param>
  509. /// <param name="subTypeName">
  510. /// 年假 事假 病假 调休假 婚嫁 产假 陪产假 丧假 补卡次数 出差 外出数 外勤 其他
  511. /// </param>
  512. /// <returns></returns>
  513. private static int Fallibilitydispose(List<Sp_Item> datas, int type, string? subTypeName)
  514. {
  515. int num = 0;
  516. Sp_Item _Info = datas.Where(it => it.type == type && it.name == subTypeName).FirstOrDefault();
  517. if (_Info != null) { num = _Info.count; }
  518. return num;
  519. }
  520. /// <summary>
  521. /// 打卡数据
  522. /// 异常数据 统计
  523. /// </summary>
  524. /// <returns></returns>
  525. private static int ExceptionStatistics(List<Exception_Info> datas, int type)
  526. {
  527. int num = 0;
  528. Exception_Info _Info = datas.Where(it => it.exception == type).FirstOrDefault();
  529. if (_Info != null) { num = _Info.count; }
  530. return num;
  531. }
  532. }
  533. }