| | |
| | | private string AppKey = "dingiokapm2dvjrhzl2g"; //å·²å建çä¼ä¸å
é¨åºç¨çAppKeyã |
| | | private string AppSecret = "dPUD7tN3BGVYAC4lDzhpcBH7O4FWFDdjLJWa6cVRBQj5U7GJ4Gwr7Vohnv0oPBOr"; //å·²å建çä¼ä¸å
é¨åºç¨çAppSecretã |
| | | private long AgentID = 3188176952; //åºç¨çAgentId |
| | | private string accessToken = ""; //è°ç¨è¯¥æ¥å£ç访é®åè¯ã |
| | | public string accessToken = ""; //è°ç¨è¯¥æ¥å£ç访é®åè¯ã |
| | | private string ProcessInstanceId = ""; //审æ¹å®ä¾IDã |
| | | #endregion |
| | | |
| | |
| | | |
| | | //TaskId = "12", //ä»»å¡IDã |
| | | //CreateFromTimeGMT = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"), //å建æ¶é´èµ·å§å¼ã |
| | | //CreateToTimeGMT = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd hh:mm:ss"), //å建æ¶é´ç»æ¢å¼ã |
| | | //CreateToTimeGMT = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd HH:mm:ss"), //å建æ¶é´ç»æ¢å¼ã |
| | | ModifiedFromTimeGMT = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd"), //ä¿®æ¹æ¶é´èµ·å§å¼ã |
| | | ModifiedToTimeGMT = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), //ä¿®æ¹æ¶é´ç»æ¢å¼ã |
| | | ModifiedToTimeGMT = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), //ä¿®æ¹æ¶é´ç»æ¢å¼ã |
| | | |
| | | PageSize = pageSize, //å页大å°ã |
| | | PageNumber = pageNumber, //å页页ç |
| | |
| | | |
| | | if (getInstanceByIdResponse.Body.InstanceStatus != "COMPLETED") |
| | | { |
| | | //continue; |
| | | continue; |
| | | } |
| | | |
| | | //å¼åæ¥æ |
| | |
| | | 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 HNumber='" + HDate_Temp + "'", "Gy_MouldFileMain"); |
| | | 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) |
| | | { |
| | |
| | | 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(); |
| | |
| | | string sql_main = "Insert Into Sc_MouldMaintainBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HUpDateDate" + |
| | | ",HPlanNo,HPlanInterID,HMouldID,HBeginDate" + |
| | | ",HMouldID,HBeginDate" + |
| | | ",HEndDate" + |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleInterID,HMaintainLevID,HLastResult" + |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleInterID,HLastResult" + |
| | | ",HRequestComDate,HRecentMainModule,HCumulativeModule,HProductionModule" + |
| | | ",HPlanInterID,HPlanNo,HMaintainLevID)" + |
| | | "values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + oItem.HBillNo + "','"+ oItem.HDate + "','" + oItem.HOriginator + "','" + oItem.HMakeDate + "'" + |
| | | ",'" + DateTime.Now.Year + "','" + DateTime.Now.Month + "','"+ oItem.HRemark + "','" + oItem.HUpdateDate + "'" + |
| | | ",'','0','" + oItem.HMouldID + "','" + oItem.HRepairBeginDate + "'" + |
| | | ",'" + oItem.HMouldID + "','" + oItem.HRepairBeginDate + "'" + |
| | | ",'" + oItem.HRepairEndDate + "'" + |
| | | ",'" + oItem.HInstanceID + "','',"+ HMouldMaintainRuleInterID + ",0,'OK'" + |
| | | ",'" + oItem.HInstanceID + "','',"+ HMouldMaintainRuleInterID + ",'OK'" + |
| | | ",'"+ oItem.HRequestComDate + "'," + oItem.HRecentMainModule + "," + oItem.HCumulativeModule + "," + oItem.HProductionModule + "" + |
| | | "," + oItem.HPlanInterID + "," + oItem.HPlanNo + "," + oItem.HMaintainLevID + ")"; |
| | | "," + (oItem.HPlanInterID == "" ? "0" : oItem.HPlanInterID) + ",'" + oItem.HPlanNo + "'," + oItem.HMaintainLevID + ")"; |
| | | LogService.Write(sql_main); |
| | | oCN.RunProc(sql_main); |
| | | int i = 1; |
| | |
| | | continue; |
| | | } |
| | | |
| | | if (oItem.HInstanceID != "9b6e108c-b7bf-45e4-910d-5629ac30d4aa") { |
| | | continue; |
| | | } |
| | | //if (oItem.HInstanceID != "9b6e108c-b7bf-45e4-910d-5629ac30d4aa") { |
| | | // continue; |
| | | //} |
| | | |
| | | //设å¤ç¼ç |
| | | if (keys.Contains("textField_lfg9hgys")) |