| | |
| | | //è®°å½æ¥å¿ |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥ä½ä»»å¡:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹å·¥ä½ä»»å¡ï¼" + HBillNo + "','LMES-å·¥ä½ä»»å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | }else if (OperationType == 4 && ds.Tables[0].Rows.Count == 0) //䏿¨ |
| | | } |
| | | else if (OperationType == 4 && ds.Tables[0].Rows.Count == 0) //䏿¨ |
| | | { |
| | | string sql = "insert into PM_WorkTaskBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" + |
| | |
| | | //è®°å½æ¥å¿ |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹é¡¹ç®é¶æ®µæ¸
å:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹é¡¹ç®é¶æ®µæ¸
åï¼" + HBillNo + "','LMES-项ç®é¶æ®µæ¸
忍¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | }else if(OperationType == 4 && ds.Tables[0].Rows.Count == 0) //䏿¨ |
| | | } |
| | | else if(OperationType == 4 && ds.Tables[0].Rows.Count == 0) //䏿¨ |
| | | { |
| | | string sql = "insert into PM_WorkTaskReportBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HOrgID,HReportEmpID,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType,HMainSourceBillNo) " + |