//添加排程執行日誌
private void ScheduleAddLog(string schedule_code)
{
ScheduleLogQuery query_log = new ScheduleLogQuery();
query_log.schedule_code = schedule_code;
try
{
//如果通過瀏覽器登陸；
query_log.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
}
catch (Exception)
{
//根據schedule_code獲取相應period的change_user
ScheduleMasterQuery query_master = new ScheduleMasterQuery();
query_master.schedule_code = schedule_code;
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
ScheduleMasterQuery master = _secheduleServiceMgr.GetScheduleMaster(query_master);
if (master.schedule_period_id != 0)
{
SchedulePeriodQuery query_period = new SchedulePeriodQuery();
query_period.rowid = master.schedule_period_id;
query_period = _secheduleServiceMgr.GetSchedulePeriod(query_period);
query_log.create_user = query_period.change_user;
}
}
query_log.ipfrom = BLL.gigade.Common.CommonFunction.GetIP4Address(Request.UserHostAddress.ToString());
_secheduleServiceMgr.AddScheduleLog(query_log);
}
public HttpResponseBase GetScheduleLogList()// 獲取Log數據
{
string json = string.Empty;
int totalcount = 0;
ScheduleLogQuery query = new ScheduleLogQuery();
try
{
List<ScheduleLogQuery> Store = new List<ScheduleLogQuery>();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))
{
query.schedule_code = Request.Params["schedule_code"];
}
if (!string.IsNullOrEmpty(Request.Params["start_time"]))//開始時間
{
query.start_time = (int)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
if (!string.IsNullOrEmpty(Request.Params["end_time"]))//結束時間
{
query.end_time = (int)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd HH:mm:ss"));
}
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
Store = _secheduleServiceMgr.GetScheduleLogList(query, out totalcount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// json = "{success:true,data:" + JsonConvert.SerializeObject(Store, Formatting.Indented, timeConverter) + "}";//返回json數據
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(Store, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<ScheduleLogQuery> GetScheduleLogList(ScheduleLogQuery query, out int totalCount)// Log
{
try
{
List<ScheduleLogQuery> store = new List<ScheduleLogQuery>();
store = _secheduleServiceDao.GetScheduleLogList(query, out totalCount);
foreach (var item in store)
{
item.show_create_time = CommonFunction.GetNetTime(item.create_time).ToString("yyyy-MM-dd HH:mm:ss ");
}
return store;
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->GetScheduleLogList-->" + ex.Message, ex);
}
}
public int AddScheduleLog(ScheduleLogQuery query)
{
try
{
return _secheduleServiceDao.AddScheduleLog(query);
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->AddScheduleLog-->" + ex.Message, ex);
}
}
public List<ScheduleLogQuery> GetScheduleLogList(ScheduleLogQuery query, out int totalCount)// 得到 period表中的記錄
{
StringBuilder sql = new StringBuilder();
StringBuilder sqlCondi = new StringBuilder();
StringBuilder sqlCount = new StringBuilder();
totalCount = 0;
try
{
sqlCount.AppendFormat("SELECT count(sl.rowid) as totalCount from schedule_log sl ");
sql.AppendFormat("select sl.rowid,sl.schedule_code,schedule_master.schedule_name,mu1.user_username as create_username,sl.create_time,sl.ipfrom ");
sql.Append(" from schedule_log sl left join schedule_master on schedule_master.schedule_code=sl.schedule_code LEFT JOIN manage_user mu1 on mu1.user_id=sl.create_user ");
sqlCondi.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(query.schedule_code))
{
sqlCondi.AppendFormat(" and sl.schedule_code='{0}' ", query.schedule_code);
}
if (query.start_time != 0)
{
sqlCondi.AppendFormat(" and sl.create_time >= '{0}' ", query.start_time);
}
if (query.end_time != 0)
{
sqlCondi.AppendFormat(" and sl.create_time <= '{0}' ", query.end_time);
}
if (query.IsPage)
{
//StringBuilder strpage = new StringBuilder();
//StringBuilder strcontpage = new StringBuilder();
//strpage.AppendFormat(" SELECT count(rowid) as totalCount FROM schedule_log ");
DataTable _dt = _access.getDataTable(sqlCount.ToString()+ sqlCondi.ToString());
if (_dt.Rows.Count > 0)
{
totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"]);
sqlCondi.AppendFormat(" order by sl.rowid desc limit {0},{1} ", query.Start, query.Limit);
}
}
return _access.getDataTableForObj<ScheduleLogQuery>(sql.ToString() + sqlCondi.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->GetScheduleLogList-->" + ex.Message, ex);
}
}
public int AddScheduleLog(ScheduleLogQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"INSERT INTO `schedule_log` ( `schedule_code`, `create_user`, `create_time`, `ipfrom`) VALUES ('{0}', '{1}', '{2}', '{3}');", query.schedule_code, query.create_user, Common.CommonFunction.GetPHPTime(), query.ipfrom);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->AddScheduleLog-->" + ex.Message, ex);
}
}
