| | |
| | | #region è·å éé-æºè½äººäº è·åå¨èåå·¥IDå表 |
| | | public bool getEmployeeIDList_DingDing(long offset, long size, ref List<string> IDList, ref string msg) |
| | | { |
| | | LogService.Write("æ¥ç5-1-1"); |
| | | OapiSmartworkHrmEmployeeQueryonjobResponse response = new OapiSmartworkHrmEmployeeQueryonjobResponse(); |
| | | do |
| | | { |
| | | if (getEmployeeIDList_Page_DingDing(offset, size, ref response, ref msg) == false) |
| | | { |
| | | LogService.Write("æ¥ç5-1-2"); |
| | | return false; |
| | | } |
| | | |
| | | LogService.Write("æ¥ç5-1-3"); |
| | | for (int i = 0; i < response.Result.DataList.Count; i++) |
| | | { |
| | | IDList.Add(response.Result.DataList[i]); |
| | | } |
| | | |
| | | LogService.Write("æ¥ç5-1-4"); |
| | | if (response.Result.NextCursor != 0) |
| | | { |
| | | LogService.Write("æ¥ç5-1-4-1"); |
| | | offset = response.Result.NextCursor; |
| | | } |
| | | else |
| | | { |
| | | LogService.Write("æ¥ç5-1-5"); |
| | | break; |
| | | } |
| | | } while (true); |
| | |
| | | lsmain.Add(oItem); |
| | | }catch(Exception e) |
| | | { |
| | | LogService.Write("æ¥ç1" + e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | string formUuid = "FORM-A01FFB0B63A34F18B7753F695F49190DJEY7"; //ç¾å°è¡¨ |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç1"); |
| | | //è·ååå±å®¡æ ¸è¡¨çå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | lsmain.Add(oItem); |
| | | }catch(Exception e) |
| | | { |
| | | LogService.Write("æ¥ç2"+e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | string formUuid = "FORM-E3DFC12364514330A836DD3056C15668UGG7"; |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç2"); |
| | | //è·åå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("æ¥ç3"+e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | string formUuid = "FORM-K5766HA1CKZB4E1L64Y1KBWCJTQF2HWJ3NDJL4"; |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç3"); |
| | | //è·åå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("æ¥ç4"+e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | string formUuid = "FORM-65AD77453E7F44EA847166C3AB5A1F04IPSS"; |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç4"); |
| | | //è·åå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("æ¥ç5"+e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | { |
| | | long offset = 0; |
| | | long size = 50; |
| | | |
| | | LogService.Write("æ¥ç5"); |
| | | LogService.Write("æ¥ç5.1"); |
| | | //è·åè±ååèåIDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getEmployeeIDList_DingDing(offset, size, ref IDList, ref msg) == false) |
| | | { |
| | | LogService.Write("æ¥ç5-1"+ msg); |
| | | return false; |
| | | } |
| | | |
| | | LogService.Write("æ¥ç5-2"); |
| | | //è·å详ç»ä¿¡æ¯å¹¶éå å°å表lsmainä¸ |
| | | List<DD_HuaMingCe> lsmain = new List<DD_HuaMingCe>(); |
| | | if (getEmployeeDetailList_HuaMingCe__DingDing(IDList, ref lsmain, ref msg) == false) |
| | |
| | | } |
| | | try |
| | | { |
| | | LogService.Write("æ¥ç5-3"); |
| | | oCN.BeginTran(); |
| | | foreach (DD_HuaMingCe oItem in lsmain) |
| | | { |
| | |
| | | |
| | | oCN.RunProc(sql_main); |
| | | } |
| | | LogService.Write("æ¥ç5-4"); |
| | | oCN.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | msg = e.Message; |
| | | LogService.Write("æ¥ç5æ¥é:" + e.Message); |
| | | oCN.RollBack(); |
| | | return false; |
| | | } |
| | |
| | | { |
| | | continue; |
| | | } |
| | | string HStaus = ""; |
| | | |
| | | switch (getInstanceByIdResponse.Body.InstanceStatus) |
| | | { |
| | | case "COMPLETED": |
| | | HStaus = "ç»´ä¿®ç»æ"; |
| | | break; |
| | | case "RUNNING": |
| | | HStaus = "ç»´ä¿®è¿è¡ä¸"; |
| | | break; |
| | | case "TERMINATED": |
| | | HStaus = "ç»´ä¿®ç»æ¢"; |
| | | break; |
| | | } |
| | | |
| | | LogService.Write("ç¶æ:" + HStaus); |
| | | |
| | | if (getInstanceByIdResponse.Body.InstanceStatus != "COMPLETED") |
| | | { |
| | | //模å
·ç¼ç |
| | | if (keys.Contains("selectField_lq3idkvg")) |
| | | { |
| | | string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString(); |
| | | LogService.Write("模å
·:" + HDate_Temp); |
| | | DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock) where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain"); |
| | | string HMouldID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | LogService.Write("æµè¯1:" + ds.Tables[0].Rows[0]["HCloseDate"].ToString()); |
| | | string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString(); |
| | | string HMouldStaus = ds.Tables[0].Rows[0]["HMouldStatus"].ToString(); |
| | | LogService.Write("模å
·:" + HDate_Temp + ",ç¶æ:" + HMouldStaus + ",æ¶é´:" + HUpdateDate); |
| | | HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate)) { |
| | | //ä¿®æ¹æ¨¡å
·çç¶æåæ¶é´ |
| | | oCN.RunProc("update Gy_MouldFileMain set HMouldStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HMouldID); |
| | | } |
| | | } |
| | | } |
| | | |
| | | continue; |
| | | } |
| | | |
| | | //模å
·ç¼ç |
| | | if (keys.Contains("selectField_lq3idkvg")) |
| | | { |
| | | string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString(); |
| | | LogService.Write("模å
·:" + HDate_Temp); |
| | | DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock) where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain"); |
| | | string HMouldID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | LogService.Write("æµè¯2:" + ds.Tables[0].Rows[0]["HCloseDate"].ToString()); |
| | | HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString(); |
| | | |
| | | string HMouldStaus = ds.Tables[0].Rows[0]["HMouldStatus"].ToString(); |
| | | |
| | | LogService.Write("模å
·:" + HDate_Temp+ ",ç¶æ:" + HMouldStaus + ",æ¶é´:" + HUpdateDate); |
| | | if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate)) |
| | | { |
| | | //ä¿®æ¹æ¨¡å
·çç¶æåæ¶é´ |
| | | oCN.RunProc("update Gy_MouldFileMain set HMouldStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HMouldID); |
| | | } |
| | | } |
| | | oItem.HMouldID = long.Parse(HMouldID); |
| | | oItem.HRemark = HDate_Temp; |
| | | //LogService.Write("æµè¯3:" + HMouldID); |
| | | |
| | | //æ¥è¯¢ä¿å
»è®¡å |
| | | ds = oCN.RunProcReturn(@"select a.HInterID,a.HBillNo from Sc_MouldMaintainPlanBillMain a |
| | | inner join Sc_MouldMaintainPlanBillSub b on a.HInterID = b.HInterID |
| | | where a.HMouldID =" + oItem.HMouldID+ " order by a.HMakeDate desc", "Sc_MouldMaintainPlanBillMain"); |
| | | //LogService.Write("æµè¯4:"); |
| | | oItem.HPlanInterID = ""; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | oItem.HPlanInterID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | oItem.HPlanNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | } |
| | | } |
| | | LogService.Write("模å
·ç¼ç :" + oItem.HMouldID); |
| | | |
| | | //å¼åæ¥æ |
| | | if (keys.Contains("dateField_lq0v65sv")) |
| | |
| | | double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq0v65sv"].ToString()); |
| | | oItem.HDate = convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm"); |
| | | } |
| | | LogService.Write("å¼åæ¥æ:" + oItem.HDate); |
| | | |
| | | //模å
·ä¿å
»çº§å« |
| | | if (keys.Contains("selectField_m1ip9j31")) |
| | |
| | | |
| | | oItem.HMaintainLevID = HDate_Temp; |
| | | } |
| | | LogService.Write("模å
·ä¿å
»çº§å«:" + oItem.HMaintainLevID); |
| | | |
| | | //修模å¼å§æ¶é´ |
| | | if (keys.Contains("dateField_lq4gf2ih")) |
| | |
| | | double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ih"].ToString()); |
| | | oItem.HRepairBeginDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm")); |
| | | } |
| | | LogService.Write("修模å¼å§æ¶é´:" + oItem.HRepairBeginDate); |
| | | |
| | | //ä¿®æ¨¡ç»ææ¶é´ |
| | | if (keys.Contains("dateField_lq4gf2ii")) |
| | |
| | | double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ii"].ToString()); |
| | | oItem.HRepairEndDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm")); |
| | | } |
| | | LogService.Write("ä¿®æ¨¡ç»ææ¶é´:" + oItem.HRepairEndDate); |
| | | |
| | | //模å
·åæ®å· |
| | | if (keys.Contains("serialNumberField_lqaak4ts")) |
| | |
| | | string HDate_Temp = response.Body.Result[i].FormData["serialNumberField_lqaak4ts"].ToString(); |
| | | oItem.HBillNo = HDate_Temp; |
| | | } |
| | | LogService.Write("模å
·åæ®å·:" + oItem.HBillNo); |
| | | |
| | | //è¦æ±å®ææ¥æ |
| | | if (keys.Contains("dateField_lq3idkvd")) |
| | |
| | | double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq3idkvd"].ToString()); |
| | | oItem.HRequestComDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm:ss")); |
| | | } |
| | | LogService.Write("è¦æ±å®ææ¥æ:" + oItem.HRequestComDate); |
| | | |
| | | //ç»´ä¿®åçæ¥æ |
| | | if (keys.Contains("dateField_lq4gf2ih")) |
| | |
| | | double HDate_Temp = double.Parse(response.Body.Result[i].FormData["dateField_lq4gf2ih"].ToString()); |
| | | oItem.HRepairAccepDate = DateTime.Parse(convertFromMillisecondsToDateString(HDate_Temp, "yyyy-MM-dd HH:mm:ss")); |
| | | } |
| | | LogService.Write("ç»´ä¿®åçæ¥æ:" + oItem.HRepairAccepDate); |
| | | |
| | | //æè¿ä¿å
»æ¨¡æ° |
| | | if (keys.Contains("numberField_lq3idkvi")) |
| | |
| | | string HDate_Temp = response.Body.Result[i].FormData["numberField_lq3idkvi"].ToString(); |
| | | oItem.HRecentMainModule = double.Parse(HDate_Temp); |
| | | } |
| | | LogService.Write("æè¿ä¿å
»æ¨¡æ°:" + oItem.HRecentMainModule); |
| | | |
| | | //ç´¯è®¡æ¨¡æ° |
| | | if (keys.Contains("numberField_lq3idkvj")) |
| | |
| | | string HDate_Temp = response.Body.Result[i].FormData["numberField_lq3idkvj"].ToString(); |
| | | oItem.HCumulativeModule = double.Parse(HDate_Temp); |
| | | } |
| | | LogService.Write("累计模æ°:" + oItem.HCumulativeModule); |
| | | |
| | | //æ¬æ¬¡çäº§æ¨¡æ° |
| | | if (keys.Contains("textField_lq4vdvgh")) |
| | |
| | | string HDate_Temp = response.Body.Result[i].FormData["textField_lq4vdvgh"].ToString(); |
| | | oItem.HProductionModule = double.Parse(HDate_Temp); |
| | | } |
| | | |
| | | //模å
·ç¼ç |
| | | if (keys.Contains("selectField_lq3idkvg")) |
| | | { |
| | | string HDate_Temp = response.Body.Result[i].FormData["selectField_lq3idkvg"].ToString(); |
| | | DataSet ds = oCN.RunProcReturn("select * from Gy_MouldFileMain with(nolock) where HMouldNo='" + HDate_Temp + "'", "Gy_MouldFileMain"); |
| | | string HMouldID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HMouldID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | } |
| | | oItem.HMouldID = long.Parse(HMouldID); |
| | | oItem.HRemark = HDate_Temp; |
| | | |
| | | |
| | | //æ¥è¯¢ä¿å
»è®¡å |
| | | ds = oCN.RunProcReturn(@"select a.HInterID,a.HBillNo from Sc_MouldMaintainPlanBillMain a |
| | | inner join Sc_MouldMaintainPlanBillSub b on a.HInterID = b.HInterID |
| | | where a.HMouldID =" + oItem.HMouldID + " and a.HMaintainLevID = " + oItem.HMaintainLevID, "Sc_MouldMaintainPlanBillMain"); |
| | | oItem.HPlanInterID = ""; |
| | | if (ds.Tables[0].Rows.Count > 0) { |
| | | oItem.HPlanInterID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | oItem.HPlanNo = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | } |
| | | } |
| | | |
| | | LogService.Write("累计模æ°:" + oItem.HProductionModule); |
| | | |
| | | //ç»´ä¿®é¨é¨ |
| | | if (keys.Contains("selectField_lq3idkva")) |
| | |
| | | } |
| | | oItem.HDeptID = long.Parse(HDeptID); |
| | | } |
| | | LogService.Write("ç»´ä¿®é¨é¨:" + oItem.HDeptID); |
| | | |
| | | //æ°è®¾è®¡å¯¿å½ |
| | | oItem.HNewDesignLife = 30000; |
| | |
| | | } |
| | | oItem.HEmpID = long.Parse(HEmpID); |
| | | } |
| | | LogService.Write("维修人:" + oItem.HEmpID); |
| | | |
| | | //ç»´ä¿®æ¶é´ |
| | | if (keys.Contains("numberField_lq3ixr9j")) |
| | |
| | | oItem.HTimes = long.Parse(HDate_Temp); |
| | | oItem.HPlanTimes = long.Parse(HDate_Temp); |
| | | } |
| | | LogService.Write("ç»´ä¿®æ¶é´:" + oItem.HTimes); |
| | | |
| | | //å表 ç»´ä¿®è¦æ± ç»´ä¿®å¤æ³¨(é®é¢æè¿°) |
| | | if (keys.Contains("tableField_lq3ixr9b")) |
| | |
| | | { |
| | | oItemSub.HRepairExplanation = dic[ij]["textareaField_lq3ixr9e"].ToString(); |
| | | } |
| | | LogService.Write("ç»´ä¿®è¦æ±:" + oItemSub.HRepairExplanation); |
| | | |
| | | //夿³¨ |
| | | if (keys_Sub.Contains("textField_lq3ixr9d")) |
| | | { |
| | | oItemSub.HRemark = dic[ij]["textField_lq3ixr9d"].ToString(); |
| | | } |
| | | LogService.Write("夿³¨:" + oItemSub.HRemark); |
| | | |
| | | oItem.DetailColMouldRepair.Add(oItemSub); |
| | | } |
| | | } |
| | | |
| | | |
| | | string HRemark = ""; |
| | | //å表 ä¿å
»å¤æ³¨(é®é¢æè¿°) |
| | |
| | | oItemSub.HClaim = HDate_Temp[ij]; |
| | | oItemSub.HMaintainResult = HRemark; |
| | | oItem.DetailColMouldMaintain.Add(oItemSub); |
| | | LogService.Write("å
·ä½è¦æ±:" + oItemSub.HClaim); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | int startindex = response.Body.Result[i].Title.IndexOf("zh_CN") + 8; |
| | | oItem.HTitle = startIndex + response.Body.Result[i].Title.Substring(startindex).Replace("\"}", "").Replace("'", ""); |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write("æ¥é:" + e.Message); |
| | | continue; |
| | | } |
| | | } |
| | |
| | | string formUuid = "FORM-30C78F46E77E46A9AA8778214CEFE6B5J0AN"; |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç7"); |
| | | //è·å模å
·ç»´ä¿®ä¿å
»è¡¨çå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | continue; |
| | | } |
| | | |
| | | string HStaus = ""; |
| | | |
| | | switch (getInstanceByIdResponse.Body.InstanceStatus) |
| | | { |
| | | case "COMPLETED": |
| | | HStaus = "ç»´ä¿®ç»æ"; |
| | | break; |
| | | case "RUNNING": |
| | | HStaus = "ç»´ä¿®è¿è¡ä¸"; |
| | | break; |
| | | case "TERMINATED": |
| | | HStaus = "ç»´ä¿®ç»æ¢"; |
| | | break; |
| | | } |
| | | LogService.Write("ç¶æ:" + HStaus); |
| | | if (getInstanceByIdResponse.Body.InstanceStatus != "COMPLETED") |
| | | { |
| | | //设å¤ç¼ç |
| | | if (keys.Contains("textField_lfg9hgys")) |
| | | { |
| | | string HDate_Temp = response.Body.Result[i].FormData["textField_lfg9hgys"].ToString(); |
| | | DataSet ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain with(nolock) where HEquipFileNo='" + HDate_Temp + "'", "Gy_EquipFileBillMain"); |
| | | string HEquipID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HEquipID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | oItem.HEquipID = long.Parse(HEquipID); |
| | | oItem.HRemark2 = HDate_Temp; |
| | | |
| | | string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString()==""?"1900-01-01 00:00:00": ds.Tables[0].Rows[0]["HCloseDate"].ToString(); |
| | | string HMouldStaus = ds.Tables[0].Rows[0]["HStatus"].ToString(); |
| | | LogService.Write("设å¤:" + HDate_Temp + ",ç¶æ:" + HMouldStaus + ",æ¶é´:" + HUpdateDate); |
| | | if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate)) |
| | | { |
| | | //ä¿®æ¹è®¾å¤çç¶æåæ¶é´ |
| | | oCN.RunProc("update Gy_EquipFileBillMain set HStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HEquipID); |
| | | } |
| | | } |
| | | } |
| | | continue; |
| | | } |
| | | |
| | |
| | | { |
| | | string HDate_Temp = response.Body.Result[i].FormData["textField_lfg9hgys"].ToString(); |
| | | DataSet ds = oCN.RunProcReturn("select * from Gy_EquipFileBillMain with(nolock) where HEquipFileNo='" + HDate_Temp + "'", "Gy_EquipFileBillMain"); |
| | | LogService.Write("è®¾å¤æ :" + HDate_Temp); |
| | | string HEquipID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HEquipID = ds.Tables[0].Rows[0]["HInterID"].ToString(); |
| | | oItem.HEquipID = long.Parse(HEquipID); |
| | | oItem.HRemark2 = HDate_Temp; |
| | | string HUpdateDate = ds.Tables[0].Rows[0]["HCloseDate"].ToString() == "" ? "1900-01-01 00:00:00" : ds.Tables[0].Rows[0]["HCloseDate"].ToString(); |
| | | string HMouldStaus = ds.Tables[0].Rows[0]["HStatus"].ToString(); |
| | | LogService.Write("设å¤:" + HDate_Temp + ",ç¶æ:" + HMouldStaus + ",æ¶é´:" + HUpdateDate); |
| | | if (HMouldStaus != HStaus && DateTime.Parse(HUpdateDate) <= DateTime.Parse(oItem.HUpdateDate)) |
| | | { |
| | | //ä¿®æ¹è®¾å¤çç¶æåæ¶é´ |
| | | oCN.RunProc("update Gy_EquipFileBillMain set HStatus='" + HStaus + "',HCloseDate='" + oItem.HUpdateDate + "' WHERE HInterID =" + HEquipID); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | continue; |
| | | } |
| | | } |
| | | LogService.Write("设å¤:" + oItem.HEquipID); |
| | | |
| | | //ç»´ä¿®é¨é¨ |
| | | if (keys.Contains("selectField_kzgkw10a")) |
| | |
| | | } |
| | | |
| | | } |
| | | LogService.Write("ç»´ä¿®é¨é¨:" + oItem.HDeptID); |
| | | |
| | | //维修人 |
| | | if (keys.Contains("employeeField_lthwkdh2")) |
| | |
| | | } |
| | | |
| | | } |
| | | LogService.Write("维修人:" + oItem.HEmpID); |
| | | |
| | | //ç»´ä¿®å
容 |
| | | if (keys.Contains("textField_l2r9bvwk")) |
| | |
| | | |
| | | oItem.HRepairContent = HDate_Temp; |
| | | } |
| | | LogService.Write("ç»´ä¿®å
容:" + oItem.HRepairContent); |
| | | |
| | | //æ¥ä¿®ç±»å« |
| | | if (keys.Contains("multiSelectField_lfg9hgyv")) |
| | |
| | | |
| | | oItem.HRepairCategory = HDate_Temp[0]; |
| | | } |
| | | |
| | | LogService.Write("æ¥ä¿®ç±»å«:" + oItem.HRepairCategory); |
| | | //ç´§æ¥ç¨åº¦ |
| | | if (keys.Contains("radioField_kzgkw10c")) |
| | | { |
| | |
| | | |
| | | oItem.HUrgenLevel = HDate_Temp; |
| | | } |
| | | LogService.Write("ç´§æ¥ç¨åº¦:" + oItem.HUrgenLevel); |
| | | |
| | | //æ¥ä¿®äºº |
| | | if (keys.Contains("employeeField_lkasesrk")) |
| | |
| | | |
| | | oItem.HRepairer = HDate_Temp[0]; |
| | | } |
| | | LogService.Write("æ¥ä¿®äºº:" + oItem.HRepairer); |
| | | |
| | | //æ¯å¦æäº§è½å½±å |
| | | if (keys.Contains("textField_lyjddw0r")) |
| | |
| | | |
| | | oItem.HIsCapacityImpact = HDate_Temp; |
| | | } |
| | | |
| | | LogService.Write("æ¯å¦æäº§è½å½±å:" + oItem.HIsCapacityImpact); |
| | | |
| | | //ç»´ä¿®æ¶é´ |
| | | if (keys.Contains("textField_l2r95oo2")) |
| | | { |
| | |
| | | oItem.HTimes = int.Parse(new string(HDate_Temp.Where(char.IsDigit).ToArray())); |
| | | oItem.HPlanTimes = int.Parse(new string(HDate_Temp.Where(char.IsDigit).ToArray())); |
| | | } |
| | | LogService.Write("ç»´ä¿®æ¶é´:" + oItem.HTimes); |
| | | |
| | | |
| | | //å表 ç»´ä¿®è¦æ± ç»´ä¿®å¤æ³¨(é®é¢æè¿°) |
| | | |
| | |
| | | oItem.HExplanation = HDate_Temp; |
| | | sub.HRepairExplanation = HDate_Temp; |
| | | } |
| | | LogService.Write("ç»´ä¿®è¦æ±:" + oItem.HExplanation); |
| | | |
| | | //夿³¨ |
| | | if (keys.Contains("textField_l2r95oo0")) |
| | |
| | | |
| | | sub.HRemark = HDate_Temp; |
| | | } |
| | | LogService.Write("夿³¨:" + oItem.HRemark); |
| | | |
| | | oItem.DetailColMouldRepair.Add(sub); |
| | | |
| | | int startindex = response.Body.Result[i].Title.IndexOf("zh_CN") + 8; |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | LogService.Write(e.Message); |
| | | LogService.Write("æ¥é:" + e.Message); |
| | | a = ""; |
| | | continue; |
| | | } |
| | |
| | | string formUuid = "FORM-OM566O7177LW0ARJ5IMFF63NTFKA34G9RL2YKN1"; |
| | | int pageNumber = 1; |
| | | int pageSize = 100; |
| | | |
| | | LogService.Write("æ¥ç6"); |
| | | //è·å设å¤ç»´ä¿®ä¿å
»è¡¨çå®ä¾IDå表 |
| | | List<string> IDList = new List<string>(); |
| | | if (getInstanceIDList_YiDa(appType, systemToken, userID, formUuid, pageNumber, pageSize, ref IDList, ref msg) == false) |
| | |
| | | { |
| | | continue; |
| | | } |
| | | string result = getProcessInstanceResponse.Body.Result.Result.ToString(); |
| | | if (result != "agree") |
| | | { |
| | | continue; |
| | | } |
| | | string[] deptNameAndGroupName = getProcessInstanceResponse.Body.Result.OriginatorDeptName.Split('-');//è·åé¨é¨æ¼æ¥å符串æ°ç» |
| | | oItem.HDeptName = deptNameAndGroupName[1]; |
| | | oItem.HGroupName = deptNameAndGroupName[deptNameAndGroupName.Length-1]; |
| | |
| | | } |
| | | oItem.HMangerID = int.Parse(HMangerID); |
| | | //å¤çé¨é¨åçç»åç§°id |
| | | ds = oCN.RunProcReturn("select * from Gy_Department with(nolock) where HName='" + oItem.HDeptName + "'", "Gy_Department"); |
| | | ds = oCN.RunProcReturn("select * from h_v_GroupList with(nolock) where çç»åç§°='" + oItem.HGroupName + "'", "h_v_GroupList"); |
| | | string HDeptID = "0"; |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HDeptID = ds.Tables[0].Rows[0]["HItemID"].ToString(); |
| | | HDeptID = ds.Tables[0].Rows[0]["HDeptID"].ToString(); |
| | | } |
| | | oItem.HDeptID = int.Parse(HDeptID); |
| | | ds = oCN.RunProcReturn("select * from Gy_Group with(nolock) where HName='" + oItem.HGroupName + "'", "Gy_Group"); |
| | |
| | | //循ç¯éåè·åèååç§°idï¼å·¥æ¶ |
| | | for (int i = 0; i < rows.Count; i++) |
| | | { |
| | | if (rows[i].RowValue.Count<10) |
| | | { |
| | | continue; |
| | | } |
| | | string[] nameArray = rows[i].RowValue[4].Value.ToString().Split(',');//è·åæ¯ä¸ªäººç人å |
| | | oItem.HPlanQty += double.Parse(rows[i].RowValue[2].Value.ToString());//è®¡åæ°é |
| | | for (int j = 0; j < int.Parse(rows[i].RowValue[5].Value.ToString()); j++) |
| | | { |
| | | if (nameArray.Length < j + 1)//鲿¢åºç°äººç¦»èäºè®¡æ¶åç³è¯·å®äºå¯¼è´ææ¯äººåä¸è®¡æ¶äººæ°ä¸ä¸è´çé®é¢ |
| | | { |
| | | continue; |
| | | } |
| | | Pay_ErrWorkTimesRequestBillSub pay_ErrWorkTimesRequestBillSub = new Pay_ErrWorkTimesRequestBillSub(); |
| | | ds = oCN.RunProcReturn("select * from Gy_Employee with(nolock) where HName='" + nameArray[j] + "'", "Gy_Employee"); |
| | | string HEmpID = "0"; |
| | |
| | | { |
| | | oCN.BeginTran(); |
| | | //å 餿¶é´èå´å
ç导å
¥åæ® |
| | | DataSet dataSet = oCN.RunProcReturn(@"select HInterID from Pay_ErrWorkTimesRequestBillMain a with(nolock) where a.HRemark like '%éé导å
¥%' and HDate >= '" + startTime + "' and HDate<='" + endTime + "'", "Pay_ErrWorkTimesRequestBillMain"); |
| | | DataSet dataSet = oCN.RunProcReturn(@"select HInterID from Pay_ErrWorkTimesRequestBillMain a with(nolock) where a.HRemark like '%éé导å
¥%' and a.HIsImport = 1 and HDate >= '" + startTime + "' and HDate<='" + endTime + "'", "Pay_ErrWorkTimesRequestBillMain"); |
| | | if(dataSet != null && dataSet.Tables[0].Rows.Count > 0) |
| | | { |
| | | foreach (DataRow row in dataSet.Tables[0].Rows) |
| | |
| | | int HPeriod = int.Parse(oItem.HDate.Split('-')[1]); |
| | | //主表 |
| | | string sql = "insert into Pay_ErrWorkTimesRequestBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HDeptID,HGroupID,HMangerID,HICMOInterID,HICMOBillNo,HExplanation,HSumRequestTimes,HMaterID,HUnitID,HPlanQty,HBatchNo,HRemark,HMaker,HMakeDate) " + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HBillStatus,HInterID,HBillNo,HDate,HInnerBillNo,HDeptID,HGroupID,HMangerID,HICMOInterID,HICMOBillNo,HExplanation,HSumRequestTimes,HMaterID,HUnitID,HPlanQty,HBatchNo,HRemark,HMaker,HMakeDate,HChecker,HCheckDate,HIsImport) " + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | | ",'" + HBillType + |
| | | "','" + " " + |
| | | "'," + 1 + |
| | | "'," + 2 + |
| | | "," + HInterID + |
| | | ",'" + HBillNo + |
| | | "','" + oItem.HDate + |
| | |
| | | "','" + oItem.HRemark + |
| | | "','" + "System" + |
| | | "'," + "GETDATE()" + |
| | | ",'" + "System" + |
| | | "'," + "GETDATE()" + |
| | | "," + "1" + |
| | | ")"; |
| | | //主表 |
| | | LogService.Write(sql); |
| | |
| | | string msg = ""; |
| | | try |
| | | { |
| | | if (getData_ErrWorkTimesRequest(startTime,endTime,ref msg) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + msg; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //if (getData_ErrWorkTimesRequest(startTime,endTime,ref msg) == false) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "Exceptionï¼" + msg; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |