/// <summary> /// 獲取ScheduleParamer的list /// </summary> /// <param name="query">查詢條件</param> /// <returns></returns> public List<ScheduleParamer> GetScheduleParameterList(ScheduleParamer query, out int totalCount) { StringBuilder sb = new StringBuilder(); StringBuilder sbcount = new StringBuilder(); StringBuilder sbwhere = new StringBuilder(); totalCount = 0; try { sbcount.Append("SELECT count(para_id) "); sb.AppendFormat(@"SELECT para_id,para_value,para_name,para_status,schedule_code"); sbwhere.Append(" FROM schedule_paramer WHERE 1=1 "); sbwhere.AppendFormat("ORDER BY para_id DESC "); DataTable _dt = new DataTable(); _dt = _dbAccess.getDataTable(sbcount.ToString() + sbwhere.ToString()); if (_dt != null) { totalCount = Convert.ToInt32(_dt.Rows[0][0]); } sbwhere.AppendFormat(" LIMIT {0},{1} ", query.Start, query.Limit); return _dbAccess.getDataTableForObj<ScheduleParamer>(sb.ToString() + sbwhere.ToString()); } catch (Exception ex) { throw new Exception("ScheduleParamerDao-->GetScheduleParameterList" + ex.Message + sb.ToString() + sbwhere.ToString(), ex); } }
/// <summary> /// ScheduleParamer表新增 /// </summary> /// <param name="query">新增數據</param> /// <returns></returns> public int InsertScheduleParamer(ScheduleParamer query) { try { return _scheduleDao.InsertScheduleParamer(query); } catch (Exception ex) { throw new Exception("ScheduleParamerMgr-->InsertScheduleParamer" + ex.Message, ex); } }
/// <summary> /// 獲取ScheduleParamer表的list /// </summary> /// <param name="query">查詢條件</param> /// <returns></returns> public List<ScheduleParamer> GetScheduleParameterList(ScheduleParamer query, out int totaoCount) { try { return _scheduleDao.GetScheduleParameterList(query, out totaoCount); } catch (Exception ex) { throw new Exception("ScheduleParamerMgr-->GetScheduleParameterList" + ex.Message, ex); } }
public HttpResponseBase ScheduleParamerAll() { string json = string.Empty; ScheduleParamer sp = new ScheduleParamer(); try { //if (!string.IsNullOrEmpty(Request.Params["schedule_code"]))//判斷id是不是存在.也就是說是否選擇了運送方式.當id不為0時表示選擇了運送方式. //{ // sp.schedule_code = Request.Params["schedule_code"]; //} sp.schedule_code = Request.Params["code"]; _schmerMgr = new ScheduleParamerMgr(mySqlConnectionString); DataTable _dt = _schmerMgr.GetScheduleParamerList(sp.schedule_code); //根據行para_value和行para_name拼接成一個json int lenght = _dt.Rows.Count; json = "{"; for (int i = 1; i <= _dt.Rows.Count; i++) { json = json + "\"" + _dt.Rows[i - 1]["para_name"] + "\":\"" + _dt.Rows[i - 1]["para_value"] + "\""; if (lenght == i) { continue; } else { json = json + ","; } } if (lenght > 0) { json = json + "}"; } else { json = "{\"msg\":\"無數據信息\"}"; } } 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; }
/// <summary> /// ScheduleParamer表新增 /// </summary> /// <param name="query">新增數據</param> /// <returns></returns> public int InsertScheduleParamer(ScheduleParamer query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("INSERT INTO schedule_paramer (para_value,para_name,para_status,schedule_code) VALUES ("); sb.AppendFormat(" '{0}','{1}','{2}','{3}')", query.para_value, query.para_name, query.para_status, query.schedule_code); return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleParamerDao-->InsertScheduleParamer" + ex.Message + sb.ToString(), ex); } }
public HttpResponseBase ScheduleParamerList() { string json = string.Empty; ScheduleParamer sp = new ScheduleParamer(); List<ScheduleParamer> spList = new List<ScheduleParamer>(); int totalCount = 0; try { _schmerMgr = new ScheduleParamerMgr(mySqlConnectionString); sp.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); sp.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); spList = _schmerMgr.GetScheduleParameterList(sp, out totalCount); json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(spList, Formatting.Indented) + "}";//返回json數據 } 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 HttpResponseBase DeleteScheduleParameter() { string json = string.Empty; ScheduleParamer sp = new ScheduleParamer(); try { _schmerMgr = new ScheduleParamerMgr(mySqlConnectionString); string id = string.Empty; if (!string.IsNullOrEmpty(Request.Params["rowID"])) { id = Request.Params["rowID"].ToString(); } string[] ids = id.Split('|'); for (int i = 0; i < ids.Length - 1; i++) { sp.para_id = Convert.ToInt32(ids[i]); if (sp.para_id > 0) { int delresult = _schmerMgr.DelScheduleParamer(sp); if (delresult <= 0) { json = "{success:true,msg:'" + i + 1 + "'}"; break; } } else { json = "{success:false}"; break; } } json = "{success:true,msg:''}";//返回json數據 } 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 JsonResult UpdateActive() { ScheduleParamer sp = new ScheduleParamer(); try { _schmerMgr = new ScheduleParamerMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["id"])) { sp.para_id = Convert.ToInt32(Request.Params["id"]); } if (!string.IsNullOrEmpty(Request.Params["active"])) { sp.para_status = Convert.ToInt32(Request.Params["active"].ToString()); } if (sp.para_id != 0) { int res = _schmerMgr.UpdateActive(sp); if (res > 0) { return Json(new { success = "true" }); } else { return Json(new { success = "false" }); } } else { return Json(new { 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); return Json(new { success = "false" }); } }
public HttpResponseBase ScheduleParamerSave() { string json = string.Empty; ScheduleParamer sp = new ScheduleParamer(); try { _schmerMgr = new ScheduleParamerMgr(mySqlConnectionString); if (!string.IsNullOrEmpty(Request.Params["para_id"])) { sp.para_id = Convert.ToInt32(Request.Params["para_id"]); } if (!string.IsNullOrEmpty(Request.Params["para_value"])) { sp.para_value = Request.Params["para_value"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["para_name"])) { sp.para_name = Request.Params["para_name"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["schedule_code"])) { sp.schedule_code = Request.Params["schedule_code"].ToString(); } sp.para_status = 1; if (sp.para_id != 0) { int res = _schmerMgr.UpdateScheduleParamer(sp); if (res > 0) { json = "{success:true}";//返回json數據 } else { json = "{success:false}";//返回json數據 } } else { int res = _schmerMgr.InsertScheduleParamer(sp); if (res > 0) { json = "{success:true}";//返回json數據 } else { json = "{success:false}";//返回json數據 } } } 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; }
/// <summary> /// ScheduleParamer表更改狀態 /// </summary> /// <param name="query">更改信息</param> /// <returns></returns> public int UpdateActive(ScheduleParamer query) { try { return _scheduleDao.UpdateActive(query); } catch (Exception ex) { throw new Exception("ScheduleParamerMgr-->UpdateActive" + ex.Message, ex); } }
/// <summary> /// ScheduleParamer表編輯 /// </summary> /// <param name="query">編輯信息</param> /// <returns></returns> public int UpdateScheduleParamer(ScheduleParamer query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("UPDATE schedule_paramer SET para_value='{0}',para_name='{1}',schedule_code='{2}'", query.para_value, query.para_name, query.schedule_code); sb.AppendFormat(" WHERE para_id='{0}'", query.para_id); return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleParamerDao-->UpdateScheduleParamer" + ex.Message + sb.ToString(), ex); } }
/// <summary> /// ScheduleParamer表根據para_id刪除數據 /// </summary> /// <param name="query">刪除數據信息</param> /// <returns></returns> public int DelScheduleParamer(ScheduleParamer query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("DELETE FROM schedule_paramer WHERE para_id='{0}'", query.para_id); return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleParamerDao-->DelScheduleParamer" + ex.Message + sb.ToString(), ex); } }
/// <summary> /// ScheduleParamer表更改狀態 /// </summary> /// <param name="query">更改信息</param> /// <returns></returns> public int UpdateActive(ScheduleParamer query) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat("UPDATE schedule_paramer SET para_status='{0}' WHERE 1=1 ", query.para_status); if (query.para_id != 0) { sb.AppendFormat(" and para_id='{0}'", query.para_id); } return _dbAccess.execCommand(sb.ToString()); } catch (Exception ex) { throw new Exception("ScheduleParamerDao-->UpdateActive" + ex.Message + sb.ToString(), ex); } }