public HttpResponseBase GetDesignRequestList() { string json = string.Empty; int totalCount = 0; DesignRequestQuery query = new DesignRequestQuery(); List<DesignRequestQuery> store = new List<DesignRequestQuery>(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 if (!string.IsNullOrEmpty(Request.Params["dr_requester"])) { query.dr_requester_id_name = Request.Params["dr_requester"].ToString().Trim(); } if (!string.IsNullOrEmpty(Request.Params["dr_type"])) { query.dr_type = Convert.ToInt32(Request.Params["dr_type"]); } if (!string.IsNullOrEmpty(Request.Params["assign_to"])) { query.dr_assign_to = Convert.ToInt32(Request.Params["assign_to"]); } if (!string.IsNullOrEmpty(Request.Params["status"])) { query.dr_status = Convert.ToInt32(Request.Params["status"]); } if (!string.IsNullOrEmpty(Request.Params["start_time"])) { query.start_time = Convert.ToDateTime(Request.Params["start_time"]).ToString("yyyy-MM-dd HH:mm:ss"); } if (!string.IsNullOrEmpty(Request.Params["search_date"])) { query.date_type = Convert.ToInt32(Request.Params["search_date"]); } if (!string.IsNullOrEmpty(Request.Params["end_time"])) { query.end_time = Convert.ToDateTime(Request.Params["end_time"]).ToString("yyyy-MM-dd HH:mm:ss"); } query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; store = _DesignRequestMgr.GetList(query,out totalCount); foreach (var item in store) { if (item.dr_expected < DateTime.Now.Date) { item.Isgq = 1; } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase TakeJob() { string json = string.Empty; DesignRequestQuery query = new DesignRequestQuery(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["dr_id"])) { query.dr_ids = Request.Params["dr_id"].ToString(); } query.dr_ids = query.dr_ids.Substring(0, query.dr_ids.Length - 1); query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.dr_assign_to = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.Istake = 1;//認領工作是全部設計人員都可認領 json = _DesignRequestMgr.UpdStatus(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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase DesigneeSave() { string json = string.Empty; DesignRequestQuery query = new DesignRequestQuery(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { //獲取id if (!string.IsNullOrEmpty(Request.Params["dr_id"])) { query.dr_id = Convert.ToUInt32(Request.Params["dr_id"]); } //獲取狀態 if (!string.IsNullOrEmpty(Request.Params["dr_status"])) { query.dr_status = Convert.ToInt32(Request.Params["dr_status"]) + 1; } //獲取派工人員 if (!string.IsNullOrEmpty(Request.Params["dr_assign_to"])) { query.dr_assign_to = Convert.ToInt32(Request.Params["dr_assign_to"]); } query.login_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; json = _DesignRequestMgr.UpdStatus(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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetProductName() { string json = string.Empty; int id = 0; DataTable dt = new DataTable(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["id"])) { id = Convert.ToInt32(Request.Params["id"]); } dt = _DesignRequestMgr.GetPorductNameByProductId(id); if (dt != null && dt.Rows.Count > 0) { json = "{success:true,msg:'" + dt.Rows[0]["product_name"] + "'}"; } else { json = "{success:true,msg:0}"; } } 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 GetDesign() { string json = string.Empty; ManageUserQuery q = new ManageUserQuery(); DataTable store = new DataTable(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { store = _DesignRequestMgr.GetDesign(q); json = "{success:true,data:" + JsonConvert.SerializeObject(store) + "}"; } 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 HttpResponseBase DesignRequestEdit() { string json = string.Empty; DesignRequestQuery query = new DesignRequestQuery(); _DesignRequestMgr = new DesignRequestMgr(mySqlConnectionString); try { if (!string.IsNullOrEmpty(Request.Params["dr_id"])) { query.dr_id = Convert.ToUInt32(Request.Params["dr_id"]); } if (!string.IsNullOrEmpty(Request.Params["dr_content_text"])) { query.dr_content_text = Request.Params["dr_content_text"].ToString().Replace("\\", "\\\\"); } if (!string.IsNullOrEmpty(Request.Params["dr_description"])) { query.dr_description = Request.Params["dr_description"].Replace("\\", "\\\\"); } if (!string.IsNullOrEmpty(Request.Params["dr_document_path"])) { query.dr_document_path = Request.Params["dr_document_path"]; } if (!string.IsNullOrEmpty(Request.Params["dr_resource_path"])) { query.dr_resource_path = Request.Params["dr_resource_path"]; } if (!string.IsNullOrEmpty(Request.Params["product_id"])) { query.product_id = Convert.ToUInt32(Request.Params["product_id"]); } if (!string.IsNullOrEmpty(Request.Params["dr_type"])) { int num = 0; if (int.TryParse(Request.Params["dr_type"], out num)) { query.dr_type = num; } else { query.dr_type_tostring = Request.Params["dr_type"].ToString(); } } query.dr_created = DateTime.Now; query.dr_status = 1; query.dr_requester_id = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; json = _DesignRequestMgr.DesignRequestEdit(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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }