public string Update(ScheduleItem si) { try { return _scheduleItemDao.Update(si); } catch (Exception ex) { throw new Exception("ScheduleItemMgr-->Update"+ ex.Message,ex);; } }
public List<ScheduleItemCustom> Query(ScheduleItem si) { try { return _scheduleItemDao.Query(si); } catch (Exception ex) { throw new Exception("ScheduleItemMgr-->Query"+ ex.Message,ex);; } }
public string Save(ScheduleItem si) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("INSERT INTO schedule_item(`schedule_id`,`type`,`key1`,`key2`,`key3`,`value1`,`value2`,`value3`,`item_name`)VALUES({0},{1},{2},{3},{4},'{5}','{6}','{7}','{8}');", si.schedule_Id, si.type, si.key1, si.key2, si.key3, si.value1, si.value2, si.value3,si.item_name); return sb.ToString(); } catch (Exception ex) { throw new Exception("ScheduleItemDao-->Save" + ex.Message,ex); } }
public string Update(ScheduleItem si) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@"UPDATE schedule_item SET `item_name` = '{0}',`schedule_id` = {1},`type` = {2},`key1` = {3},`value1` = '{4}' WHERE id = {5};",si.item_name,si.schedule_Id,si.type,si.key1,si.value1,si.id); return sb.ToString(); } catch (Exception ex) { throw new Exception("ScheduleItemDao-->Update" + ex.Message, ex); } }
public List<ScheduleItemCustom> QueryByCondition(ScheduleItem si) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@"SELECT s.schedule_id,s.schedule_name,s.desc,si.id,si.item_name,si.schedule_id,si.type,si.key1,si.value1 FROM schedule_item si LEFT JOIN schedule s ON s.schedule_id = si.schedule_id WHERE si.type = {0}", si.type); return _access.getDataTableForObj<ScheduleItemCustom>(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleItemDao-->Update" + ex.Message, ex); } }
public List<ScheduleItemCustom> Query(ScheduleItem si) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(@"SELECT si.id,si.item_name,si.schedule_id,s.schedule_name,si.`type`,si.`key1`,si.value1,v.vendor_name_full AS valueStr FROM schedule_item si INNER JOIN schedule s ON s.schedule_id =si.schedule_id INNER JOIN vendor v ON v.vendor_id = si.value1 WHERE si.schedule_id = {0}", si.schedule_Id); return _access.getDataTableForObj<ScheduleItemCustom>(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleItemDao-->Query" + ex.Message, ex); } }