public bool Save(ScheduleRelation sr)
{
try
{
if (Query(sr).Count > 0)
{
if (sr.schedule_id == 0)
{
return Delete(sr.relation_table, sr.relation_id);
}
else
{
return _scheduleRelationDao.Update(sr) > 0;
}
}
else
{
if (sr.schedule_id != 0)
return _scheduleRelationDao.Save(sr) > 0;
else
return true;
}
}
catch (Exception ex)
{
throw new Exception("ScheduleRelationMgr-->Save" + ex.Message,ex);
}
}
public List<ScheduleRelation> Query(ScheduleRelation sr)
{
try
{
return _scheduleRelationDao.Query(sr);
}
catch (Exception ex)
{
throw new Exception("ScheduleRelationMgr-->Query" + ex.Message,ex);
}
}
public int Save(ScheduleRelation sr)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"INSERT INTO schedule_relation(`schedule_id`,`relation_table`,`relation_id`)VALUES({0},'{1}',{2});",sr.schedule_id,sr.relation_table,sr.relation_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleRelationDao-->Save" + ex.Message,ex);
}
}
public List<ScheduleRelation> Query(ScheduleRelation sr)
{
try
{
var scheRel = _access.getDataTableForObj<ScheduleRelation>(string.Format("SELECT rowid,schedule_id,relation_table,relation_id FROM schedule_relation WHERE relation_id={0} AND relation_table='{1}';", sr.relation_id, sr.relation_table));
foreach (var item in scheRel)
{
item.schedule = new ScheduleDao(connectionString).Query(new Model.Query.ScheduleQuery { schedule_id = item.schedule_id }).FirstOrDefault();
}
return scheRel;
}
catch (Exception ex)
{
throw new Exception("ScheduleRelationDao-->Query" + ex.Message, ex);
}
}
public int Update(ScheduleRelation sr)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"set sql_safe_updates=0;update schedule_relation set`schedule_id`={0} where `relation_table`='{1}' AND `relation_id`={2};set sql_safe_updates=1;", sr.schedule_id, sr.relation_table, sr.relation_id); ///add by wwei0216w 2015/3/30 修改原因 代碼執行至該處出現異常 在'{1}'后將','改為'AND'
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("ScheduleRelationDao-->Save" + ex.Message, ex);
}
}
/// <summary>
/// 獲取關係表數據by schedule_id
/// </summary>
/// <param name="sr"></param>
/// <returns></returns>
public ActionResult GetRelationTiers(ScheduleRelation sr)
{
try
{
List<ScheduleRelation> list = new List<ScheduleRelation>();
IScheduleRelationImplMgr _srMgr = new ScheduleRelationMgr(connectionString);
list = _srMgr.Query(sr.schedule_id);
return Content(JsonConvert.SerializeObject(list));
}
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);
return new EmptyResult();
}
}
