| | |
| | | // timer2 |
| | | // |
| | | this.timer2.Enabled = true; |
| | | this.timer2.Interval = 3600; |
| | | this.timer2.Interval = 300000; |
| | | this.timer2.Tick += new System.EventHandler(this.timer2_Tick); |
| | | // |
| | | // notifyIcon_Icon |
| | |
| | | #endregion |
| | | |
| | | #region erpæ°æ®åºåç§° |
| | | string erpDatabaseName = "AIS20210811135644.."; |
| | | //string erpDatabaseName = "AIS20210811135644.."; //47éè¶äºæ°æ®åºåç§° |
| | | string erpDatabaseName = "AIS20201117213251.."; //ä¸åéè¶äºæ°æ®åºåç§° |
| | | #endregion |
| | | |
| | | #region è·åæå¡å°å |
| | |
| | | Where l.FLOCALEID=2052 |
| | | and unit.FLOCALEID = 2052 |
| | | and a.FFORBIDSTATUS='A' |
| | | and a.FUSEORGID = 1 |
| | | and |
| | | ( |
| | | convert(varchar(100),a.FCREATEDATE,23) >= convert(varchar(100),DATEADD(day,-7,getdate()),23) |
| | | convert(varchar(100),a.FCREATEDATE,23) >= convert(varchar(100),DATEADD(day,-1,getdate()),23) |
| | | or |
| | | convert(varchar(100),a.FMODIFYDATE,23) >= convert(varchar(100),DATEADD(day,-7,getdate()),23) |
| | | convert(varchar(100),a.FMODIFYDATE,23) >= convert(varchar(100),DATEADD(day,-1,getdate()),23) |
| | | )"; |
| | | DataSet ds = oCN.RunProcReturn(sql, "" + erpDatabaseName + @"T_BD_MATERIAL"); |
| | | if (ds != null && ds.Tables.Count > 0) |