| | |
| | | } |
| | | string HSendEmp = ds.Tables[0].Rows[0]["æ´¾å人"].ToString();//æ´¾å人 |
| | | string HCopyEmp = ds.Tables[0].Rows[0]["æé人"].ToString();//æé人 |
| | | string HPlanTimes = ds.Tables[0].Rows[0]["è¯ä¼°å·¥æ¶"].ToString();//è¯ä¼°å·¥æ¶ |
| | | string HWorkTaskDate = DateTime.Parse(ds.Tables[0].Rows[0]["æ¥æ"].ToString()).ToString("yyyy-MM-dd");//å·¥ä½ä»»å¡åæ®æ¶é´ |
| | | string HSelfTimes = ds.Tables[0].Rows[0]["èªè¯å·¥æ¶"].ToString();//èªè¯å·¥æ¶ |
| | | string HProjectName = ds.Tables[0].Rows[0]["项ç®åç§°"].ToString();//项ç®åç§° |
| | | string HTaskDescription = ds.Tables[0].Rows[0]["ä»»å¡æè¿°"].ToString(); |
| | | //æå
¥å表sql |
| | | string sql = "insert into PM_WorkTaskReportBillSub" + |
| | | "(HInterID,HBillNo_bak,HEntryID,HRemark,HProjectID,HProNumber,HProjectStageID,HName,HTaskNote,HType,HRelTimes,HReportNote,HAdv,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo,HFinishFlag) " + |
| | |
| | | "'," + DBUtility.ClsPub.BoolToString(HFinishFlag) + |
| | | ")"; |
| | | oCN.RunProc(sql); |
| | | string messageContext = "æ¥æ= " + DateTime.Now + ",æ±æ¥äºº=" + reportMan + ",æ±æ¥å
容=" + HReportNote + ",è¯ä¼°å·¥æ¶=" + HPlanTimes + "å°æ¶,èªè¯å·¥æ¶=" + HSelfTimes + "å°æ¶,èç¨å·¥æ¶=" + HRelTimes + "å°æ¶,ä»»å¡åç§°=" + HName + ",项ç®åç§°=" + HProjectName; ; |
| | | string messageContext = "åæ®æ¥æ= " + HWorkTaskDate + ",æ±æ¥äºº=" + reportMan + ",æ±æ¥å
容=" + HReportNote +",ä»»å¡æè¿° ="+ HTaskDescription +",宿æ è®°="+ (HFinishFlag?"æ¯":"å¦") + ",èªè¯å·¥æ¶=" + HSelfTimes + "å°æ¶,èç¨å·¥æ¶=" + HRelTimes + "å°æ¶,ä»»å¡åç§°=" + HName + ",项ç®åç§°=" + HProjectName; ; |
| | | _ = SendDingDingAsync(HSendEmp, messageContext, HCopyEmp); |
| | | } |
| | | |