public int UpdateScheduleMaster(ScheduleMasterQuery query)
{
try
{
return _secheduleServiceDao.UpdateScheduleMaster(query);
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->UpdateScheduleMaster-->" + ex.Message, ex);
}
}
public List<ScheduleMasterQuery> GetExeScheduleMasterList(ScheduleMasterQuery query)
{
try
{
return _secheduleServiceDao.GetExeScheduleMasterList(query);
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->GetExeScheduleMasterList-->" + ex.Message, ex);
}
}
public List<ScheduleMasterQuery> GetExeScheduleMasterList(ScheduleMasterQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("SELECT `rowid`, `schedule_code`, `schedule_name`, `schedule_api`, `schedule_description`, `schedule_state`, `previous_execute_time`, `next_execute_time`, `schedule_period_id`, `create_user`, `create_time`, `change_user`, `change_time` FROM `schedule_master` WHERE schedule_state = '{0}' AND next_execute_time<='{1}' and next_execute_time > 0 ;", query.schedule_state, Common.CommonFunction.GetPHPTime(DateTime.Now.ToString()));
return _access.getDataTableForObj<ScheduleMasterQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->GetExeScheduleMasterList-->" + ex.Message, ex);
}
}
public ScheduleMasterQuery GetScheduleMaster(ScheduleMasterQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat("SELECT `rowid`, `schedule_code`, `schedule_name`, `schedule_api`, `schedule_description`, `schedule_state`, `previous_execute_time`, `next_execute_time`, `schedule_period_id`, `create_user`, `create_time`, `change_user`, `change_time` FROM `schedule_master` WHERE schedule_code = '{0}';", query.schedule_code);
return _access.getSinggleObj<ScheduleMasterQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->GetScheduleMaster-->" + ex.Message, ex);
}
}
//保存排程_master信息
public HttpResponseBase SaveScheduleMasterInfo()
{
string json = string.Empty;
try
{
ScheduleMasterQuery query = new ScheduleMasterQuery();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["rowid"]))
{
query.rowid = Convert.ToInt32(Request.Params["rowid"]);
}
if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))
{
query.schedule_code = Request.Params["schedule_code"];
}
if (!string.IsNullOrEmpty(Request.Params["schedule_name"]))
{
query.schedule_name = Request.Params["schedule_name"];
}
if (!string.IsNullOrEmpty(Request.Params["schedule_api"]))
{
query.schedule_api = Request.Params["schedule_api"];
}
if (!string.IsNullOrEmpty(Request.Params["schedule_description"]))
{
query.schedule_description = Request.Params["schedule_description"];
}
if (!string.IsNullOrEmpty(Request.Params["schedule_state"]))
{
query.schedule_state = Convert.ToInt32(Request.Params["schedule_state"]);
}
if (!string.IsNullOrEmpty(Request.Params["schedule_period_id"]))
{
query.schedule_period_id = Convert.ToInt32(Request.Params["schedule_period_id"]);
}
query.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.change_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
//判斷該schedule_code是否已存在
if (query.rowid == 0)//新增
{
ScheduleMasterQuery query_chongfu = new ScheduleMasterQuery();
query_chongfu.schedule_code = query.schedule_code;
query_chongfu = _secheduleServiceMgr.GetScheduleMaster(query_chongfu);
if (query_chongfu != null)
{
json = "{success:false,msg:3}";
}
else
{
int _dt = _secheduleServiceMgr.SaveScheduleMasterInfo(query);
if (_dt > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false,msg:2}";
}
}
}
else
{
int _dt = _secheduleServiceMgr.SaveScheduleMasterInfo(query);
if (_dt > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false,msg:2}";
}
}
}
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
//schedule_master 中的狀態啟用
public HttpResponseBase UpdateStats_Schedule_master()
{
string json = string.Empty;
try
{
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
ScheduleMasterQuery query = new ScheduleMasterQuery();
if (!string.IsNullOrEmpty(Request.Params["id"]))
{
query.rowid = Convert.ToInt32(Request.Params["id"]);
}
if (!string.IsNullOrEmpty(Request.Params["active"]))
{
query.schedule_state = Convert.ToInt32(Request.Params["active"]);
}
query.change_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
json = _secheduleServiceMgr.UpdateStats_Schedule_master(query);
}
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetScheduleMasterList()
{
string json = string.Empty;
int totalcount = 0;
try
{
ScheduleMasterQuery query = new ScheduleMasterQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
List<ScheduleMasterQuery> list = _secheduleServiceMgr.GetScheduleMasterList(query);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// timeConverter.DateTimeFormat = "yyyy-MM-dd ";
json = "{success:true,totalCount:" + totalcount + ",data:" + JsonConvert.SerializeObject(list, 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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
} // 獲取 master數據
//可以多行刪除數據_period
public HttpResponseBase SchedulePeriodDelete()
{
string json = string.Empty;
SchedulePeriodQuery period = new SchedulePeriodQuery();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
try
{
string id = Request.Params["id"];
id = id.Substring(0, id.Length - 1).ToString();
string[] ids = id.Split(',');
if (ids.Length>0)
{
period.rowid = int.Parse(ids[0].ToString());
period = _secheduleServiceMgr.GetSchedulePeriod(period);
ScheduleMasterQuery query_master = new ScheduleMasterQuery();
query_master.schedule_code = period.schedule_code;
//刪除
int result = _secheduleServiceMgr.SchedulePeriodDelete(id);
if (result > 0)
{
ScheduleMasterQuery item = _secheduleServiceMgr.GetScheduleMaster(query_master);
//更新ScheduleMaster表的previous_execute_time、next_execute_time、state；
//獲取next_execute_time和schedule_period_id
int schedule_period_id = 0;
int next_execute_time = _secheduleServiceMgr.GetNext_Execute_Time(item.schedule_code, out schedule_period_id);
//if (item.next_execute_time > next_execute_time || (item.next_execute_time == 0 && item.next_execute_time < next_execute_time))
{
item.next_execute_time = next_execute_time;
if (item.next_execute_time == 0)
{
item.schedule_state = 0;
}
item.schedule_period_id = schedule_period_id;
//修改ScheduleMaster
_secheduleServiceMgr.UpdateScheduleMaster(item);
}
}
}
json = "{success:true}";
}
#region 只刪除一行數據時的代碼段
//if (!string.IsNullOrEmpty(Request.Params["id"]))
//{
// query.id = Convert.ToUInt32(Request.Params["id"]);
//}
// int _dt = informationMgr.PersonInfromationDelete(query);
//if (_dt > 0)
//{
// json = "{success:true}";
//}
//else
//{
// json = "{success:false}";
//}
#endregion
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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//可以多行刪除數據_master
public HttpResponseBase ScheduleMasterDelete()
{
string json = string.Empty;
ScheduleMasterQuery query = new ScheduleMasterQuery();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
try
{
string id = Request.Params["id"];
string[] ids = id.Split(',');
for (int i = 0; i < ids.Length - 1; i++)
{
query.rowid = int.Parse(ids[i].ToString());
_secheduleServiceMgr.ScheduleMasterDelete(query.rowid.ToString());
}
json = "{success:true}";
}
#region 只刪除一行數據時的代碼段
//if (!string.IsNullOrEmpty(Request.Params["id"]))
//{
// query.id = Convert.ToUInt32(Request.Params["id"]);
//}
// int _dt = informationMgr.PersonInfromationDelete(query);
//if (_dt > 0)
//{
// json = "{success:true}";
//}
//else
//{
// json = "{success:false}";
//}
#endregion
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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public List<ScheduleMasterQuery> GetScheduleMasterList(ScheduleMasterQuery query) // master
{
try
{
List<ScheduleMasterQuery> store = new List<ScheduleMasterQuery>();
store = _secheduleServiceDao.GetScheduleMasterList(query);
foreach (var item in store)
{
if (item.schedule_state == 0)
{
item.sschedule_state = "停用";
}
if (item.schedule_state == 1)
{
item.sschedule_state = "啟用";
}
if (item.previous_execute_time == 0)
{
item.show_previous_execute_time = string.Empty;
}
else
{
item.show_previous_execute_time = CommonFunction.GetNetTime(item.previous_execute_time).ToString("yyyy-MM-dd HH:mm:ss ");
}
if (item.next_execute_time == 0)
{
item.show_next_execute_time = string.Empty;
}
else
{
item.show_next_execute_time = CommonFunction.GetNetTime(item.next_execute_time).ToString("yyyy-MM-dd HH:mm:ss ");
}
item.show_create_time = CommonFunction.GetNetTime(item.create_time).ToString("yyyy-MM-dd HH:mm:ss ");
item.show_change_time = CommonFunction.GetNetTime(item.change_time).ToString("yyyy-MM-dd HH:mm:ss ");
}
return store;
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->GetScheduleMasterList-->" + ex.Message, ex);
}
}
public int UpdateScheduleMaster(ScheduleMasterQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
sql.AppendFormat(@"UPDATE `schedule_master` SET `schedule_code`='{0}', `schedule_name`='{1}', `schedule_api`='{2}', `schedule_description`='{3}', `schedule_state`='{4}', `previous_execute_time`='{5}', `next_execute_time`='{6}',`schedule_period_id`='{7}', `create_user`='{8}', `create_time`='{9}', `change_user`='{10}', `change_time`='{11}' WHERE `rowid`='{12}';", query.schedule_code, query.schedule_name, query.schedule_api, query.schedule_description, query.schedule_state, query.previous_execute_time, query.next_execute_time, query.schedule_period_id, query.create_user, query.create_time, query.change_user, Common.CommonFunction.GetPHPTime(), query.rowid);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->UpdateScheduleMaster-->" + ex.Message, ex);
}
}
public int ScheduleMasterInfoUpdate(ScheduleMasterQuery query)//更新schedule_master信息
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
sql.AppendFormat("update schedule_master set schedule_code = '{0}', schedule_name = '{1}', schedule_api = '{2}',schedule_description='{3}',schedule_state='{4}',schedule_period_id='{5}',create_user='******',change_user='******',change_time='{8}', previous_execute_time='{9}', next_execute_time='{10}' where rowid='{11}'", query.schedule_code, query.schedule_name, query.schedule_api, query.schedule_description, query.schedule_state, query.schedule_period_id, query.create_user, query.change_user, CommonFunction.GetPHPTime(DateTime.Now.ToString()), query.previous_execute_time, query.next_execute_time, query.rowid);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->ScheduleMasterInfoUpdate-->" + sql.ToString() + ex.Message);
}
}
public int ScheduleMasterInfoInsert(ScheduleMasterQuery query) //插入schedule_master信息
{
StringBuilder sql = new StringBuilder();
query.Replace4MySQL();
try
{
sql.Append("insert into schedule_master ( schedule_code, schedule_name, schedule_api,schedule_description,schedule_state,schedule_period_id,create_user,change_user, create_time, change_time, previous_execute_time,next_execute_time) values ");
sql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", query.schedule_code, query.schedule_name, query.schedule_api, query.schedule_description, query.schedule_state, query.schedule_period_id, query.create_user, query.change_user, CommonFunction.GetPHPTime(DateTime.Now.ToString()), CommonFunction.GetPHPTime(), query.previous_execute_time, query.next_execute_time);
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->ScheduleMasterInfoInsert-->" + sql.ToString() + ex.Message);
}
}
public string UpdateStats_Schedule_master(ScheduleMasterQuery query) // master 狀態更新
{
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat(@"Update schedule_master set schedule_state='{0}',change_user='******',change_time='{2}' WHERE rowid='{3}'", query.schedule_state,query.change_user, CommonFunction.GetPHPTime(), query.rowid);
return strSql.ToString();
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->UpdateStats_Schedule_master-->" + ex.Message + strSql.ToString(), ex);
}
}
/// <summary>
/// 獲取需要執行的排程列表并逐個執行，添加日誌和更新排程；
/// </summary>
/// <returns></returns>
public HttpResponseBase GetExeScheduleServiceList()
{
//獲取需要執行的排程
List<ScheduleMasterQuery> store = new List<ScheduleMasterQuery>();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
try
{
ScheduleMasterQuery query = new ScheduleMasterQuery();
query.schedule_state = 1;
store = _secheduleServiceMgr.GetExeScheduleMasterList(query);
foreach (ScheduleMasterQuery item in store)
{
try
{
//執行排程
bool result = ExeScheduleService(item.schedule_api,item.schedule_code);
//更新SchedulePeriod表的current_nums;ScheduleMaster表的previous_execute_time、next_execute_time、state；
//更新current_nums欄位；
SchedulePeriodQuery query_period = new SchedulePeriodQuery();
query_period.rowid = item.schedule_period_id;
query_period = _secheduleServiceMgr.GetSchedulePeriod(query_period);
if (query_period != null)
{
query_period.current_nums += 1;
_secheduleServiceMgr.UpdateSchedulePeriod(query_period);
}
//更新ScheduleMaster表的previous_execute_time、next_execute_time、state；
item.previous_execute_time = (int)CommonFunction.GetPHPTime();
//獲取next_execute_time和schedule_period_id
int schedule_period_id = 0;
item.next_execute_time = _secheduleServiceMgr.GetNext_Execute_Time(item.schedule_code, out schedule_period_id);
item.schedule_period_id = schedule_period_id;
if (item.next_execute_time == 0)
{
item.schedule_state = 0;
}
_secheduleServiceMgr.UpdateScheduleMaster(item);
}
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);
}
}
}
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);
}
//this.Response.Clear();
//this.Response.Write();
//this.Response.End();
return this.Response;
}
//保存排程_period信息
public HttpResponseBase SaveSchedulePeriodInfo()
{
string json = string.Empty;
try
{
SchedulePeriodQuery query = new SchedulePeriodQuery();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["rowid"]))
{
query.rowid = Convert.ToInt32(Request.Params["rowid"]);
}
if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))
{
query.schedule_code = Request.Params["schedule_code"];
}
if (!string.IsNullOrEmpty(Request.Params["period_type"]))
{
query.period_type = Convert.ToUInt32(Request.Params["period_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["period_nums"]))
{
query.period_nums = Convert.ToUInt32(Request.Params["period_nums"]);
}
if (!string.IsNullOrEmpty(Request.Params["current_nums"]))
{
query.current_nums = Convert.ToUInt32(Request.Params["current_nums"]);
}
if (!string.IsNullOrEmpty(Request.Params["limit_nums"]))
{
query.limit_nums = Convert.ToUInt32(Request.Params["limit_nums"]);
}
if (!string.IsNullOrEmpty(Request.Params["begin_datetime"]))
{
query.begin_datetime = (int)CommonFunction.GetPHPTime(Request.Params["begin_datetime"]);
}
query.create_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
query.change_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int _dt = _secheduleServiceMgr.SaveSchedulePeriodInfo(query);
if (_dt > 0)
{
json = "{success:true}";
//根據schedule_code獲取相應的ScheduleMaster信息
ScheduleMasterQuery query_master = new ScheduleMasterQuery();
query_master.schedule_code = query.schedule_code;
ScheduleMasterQuery item = _secheduleServiceMgr.GetScheduleMaster(query_master);
//更新ScheduleMaster表的previous_execute_time、next_execute_time、state；
//獲取next_execute_time和schedule_period_id
int schedule_period_id = 0;
int next_execute_time = _secheduleServiceMgr.GetNext_Execute_Time(item.schedule_code, out schedule_period_id);
if (item.next_execute_time > next_execute_time || (item.next_execute_time == 0 && item.next_execute_time < next_execute_time))
{
item.next_execute_time = next_execute_time; ;
item.schedule_period_id = schedule_period_id;
_secheduleServiceMgr.UpdateScheduleMaster(item);
}
}
else
{
json = "{success:false}";
}
}
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return Response;
}
public string UpdateStats_Schedule_master(ScheduleMasterQuery query)
{
string json;
string sql = "";
try
{
if (query.schedule_state == 0)
{
query.schedule_state = 1;
}
else
{
query.schedule_state = 0;
}
sql = _secheduleServiceDao.UpdateStats_Schedule_master(query);
if (_dbAccess.execCommand(sql) > 0)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
return json;
}
catch (Exception ex)
{
throw new Exception("SecheduleServiceMgr-->UpdateStats_Schedule_master-->" + ex.Message + sql, ex);
}
}// master 的狀態改變
//立即執行選中的排程
public HttpResponseBase ScheduleMasterRunOnce()
{
string json = string.Empty;
bool result = false;
ScheduleMasterQuery query = new ScheduleMasterQuery();
_secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString);
try
{
string id = Request.Params["id"];
string[] ids = id.Split(',');
for (int i = 0; i < ids.Length - 1; i++)
{
string[] scheduleapis = ids[i].Split('&');
if(scheduleapis.Length==2)
{
if (!string.IsNullOrEmpty(scheduleapis[0].ToString())&&!string.IsNullOrEmpty(scheduleapis[1].ToString()))
{
result = ExeScheduleService(scheduleapis[0].ToString(),scheduleapis[1].ToString());
}
}
}
if (result)
{
json = "{success:true}";
}
else
{
json = "{success:false}";
}
}
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}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}// master 的狀態改變
//schedule_master判断是新增 还是 编辑
public int SaveScheduleMasterInfo(ScheduleMasterQuery query)
{
try
{
if (query.rowid == 0)//新增
{
return _secheduleServiceDao.ScheduleMasterInfoInsert(query);
}
else//編輯
{
return _secheduleServiceDao.ScheduleMasterInfoUpdate(query);
}
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceMgr-->SaveScheduleMasterInfo-->" + ex.Message);
}
}
//添加排程執行日誌
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 List<ScheduleMasterQuery> GetScheduleMasterList(ScheduleMasterQuery query)// 得到 master表中的記錄
{
StringBuilder sql = new StringBuilder();
StringBuilder str = new StringBuilder();
try
{
sql.AppendFormat(" SELECT sm.rowid,sm.schedule_code,sm.schedule_name,sm.schedule_api,sm.schedule_description,sm.schedule_state,sm.previous_execute_time,sm.next_execute_time,sm.schedule_period_id, mu1.user_username as create_username,sm.create_time,mu2.user_username as change_username,sm.change_time FROM schedule_master sm ");
str.Append(" LEFT JOIN manage_user mu1 on mu1.user_id=sm.create_user ");
str.Append(" LEFT JOIN manage_user mu2 on mu2.user_id=sm.change_user ");
sql.Append(str.ToString());
return _access.getDataTableForObj<ScheduleMasterQuery>(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleServiceDao-->GetScheduleMasterList-->" + ex.Message, ex);
}
}