public HttpResponseBase GetQuestionTypeList() { IParametersrcImplMgr parametersrcMgr = new BLL.gigade.Mgr.ParameterMgr(mySqlConnectionString); List<Parametersrc> parametersrclist = new List<Parametersrc>(); string json = string.Empty; try { string type = "problem_category"; parametersrclist = parametersrcMgr.GetElementType(type); json = "{success:true,data:" + JsonConvert.SerializeObject(parametersrclist) + "}";//返回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 GetVendorType() { string vendorType = ""; if (!string.IsNullOrEmpty(Request.Params["VendorType"])) { vendorType = Request.Params["VendorType"]; } List<Parametersrc> list = new List<Parametersrc>(); paraMgr = new ParameterMgr(connectionString); string types = "vendor_type"; list = paraMgr.GetElementType(types); string VendorTypeName = ""; string jsonStr = string.Empty; try { if (!string.IsNullOrEmpty(vendorType)) { string[] vendor_types = vendorType.Split(','); for (int i = 0; i < vendor_types.Length; i++) { for (int j = 0; j < list.Count; j++) { if (list[j].ParameterCode == vendor_types[i].ToString()) { VendorTypeName += list[j].parameterName + ","; } } } VendorTypeName = VendorTypeName.Substring(0, VendorTypeName.Length - 1); } jsonStr = "{success:true,msg:\"" + VendorTypeName + "\"}"; } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
public HttpResponseBase GetVendorTypeStore() { paraMgr = new ParameterMgr(connectionString); List<Parametersrc> store = new List<Parametersrc>(); string json = string.Empty; List<VendorQuery> query = new List<VendorQuery>(); try { string type = "vendor_type"; store = paraMgr.GetElementType(type); for (int i = 0; i < store.Count; i++) { VendorQuery vendor = new VendorQuery(); vendor.vendor_type = store[i].ParameterCode.ToString(); vendor.vendor_type_name = store[i].parameterName.ToString(); query.Add(vendor); } json = "{success:true,data:" + JsonConvert.SerializeObject(query, Formatting.Indented) + "}"; } 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 = "無預覽信息"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
/// <summary> /// 獲取供應商列表數據 /// </summary> /// <returns></returns> public HttpResponseBase GetVendorList() { List<VendorQuery> stores = new List<VendorQuery>(); string json = string.Empty; try { _vendorMgr = new VendorMgr(connectionString); #region 搜索條件 VendorQuery query = new VendorQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 if (!string.IsNullOrEmpty(Request.Params["relation_id"])) { query.vendor_id = Convert.ToUInt32(Request.Params["relation_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["VendorId"])) { query.vendor_id = Convert.ToUInt32(Request.Params["VendorId"].ToString()); } string type = string.Empty; string con = string.Empty; if (!string.IsNullOrEmpty(Request.Params["dateType"])) { type = Request.Params["dateType"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["dateCon"])) { con = Request.Params["dateCon"].ToString(); } int totalCount = 0; if (!string.IsNullOrEmpty(type) && !string.IsNullOrEmpty(con) && type != "0") {//當查詢條件和查詢內容都有值時執行 switch (type) { case "0": break; case "1": query.searchEmail = con.ToLower(); break; case "2": query.searchName = con; break; case "3": query.vendor_name_full = con; break; case "4": query.searchInvoice = con; break; case "5": query.erp_id = con; break; case "6": uint isTranUint = 0; if (uint.TryParse(con, out isTranUint)) { query.vendor_id = Convert.ToUInt32(con); } break; case "7": query.vendor_code = con; break; } if (!string.IsNullOrEmpty(Request.Params["vendortype"]))//供应商类型 { query.vendor_type = Request.Params["vendortype"].ToString(); query.vendor_type = query.vendor_type.TrimEnd(','); } if (!string.IsNullOrEmpty(Request.Params["dateOne"])) { // query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd 00:00:00")); query.create_dateOne = (uint)CommonFunction.GetPHPTime(Request.Params["dateOne"]); } if (!string.IsNullOrEmpty(Request.Params["dateTwo"])) { //query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd 23:59:59")); query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Request.Params["dateTwo"]); } stores = _vendorMgr.Query(query, ref totalCount); } else { //當查詢條件和查詢內容都沒有值時執行 if (!string.IsNullOrEmpty(Request.Params["vendortype"]))//供应商类型 { query.vendor_type = Request.Params["vendortype"].ToString(); query.vendor_type = query.vendor_type.TrimEnd(','); } if (!string.IsNullOrEmpty(Request.Params["dateOne"])) { //query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd 00:00:00")); query.create_dateOne = (uint)CommonFunction.GetPHPTime(Request.Params["dateOne"]); } if (!string.IsNullOrEmpty(Request.Params["dateTwo"])) { //query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd 23:59:59")); query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Request.Params["dateTwo"]); } stores = _vendorMgr.Query(query, ref totalCount); } #endregion #region 供應商類型參數 List<Parametersrc> list = new List<Parametersrc>(); paraMgr = new ParameterMgr(connectionString); string types = "vendor_type"; list = paraMgr.GetElementType(types); #endregion foreach (var item in stores) { item.vendor_name_full = Server.HtmlDecode(Server.HtmlDecode(item.vendor_name_full)); item.vendor_name_simple = Server.HtmlDecode(Server.HtmlDecode(item.vendor_name_simple)); string temp = string.Empty; #region 供應商類型關聯參數表 if (!string.IsNullOrEmpty(item.vendor_type) && item.vendor_type != null) { string[] vendor_types = item.vendor_type.Split(','); for (int i = 0; i < vendor_types.Length; i++) { for (int j = 0; j < list.Count; j++) { if (list[j].ParameterCode == vendor_types[i].ToString()) { item.vendor_type_name += list[j].parameterName + ","; } } } item.vendor_type_name = item.vendor_type_name.Substring(0, item.vendor_type_name.Length - 1); } #endregion if (item.self_send_days == 0) { if (item.stuff_ware_days == 0) { if (item.dispatch_days == 0) { temp = ""; } else { temp = "調度"; } } else { if (item.dispatch_days == 0) { temp = "寄倉"; } else { temp = "寄倉,調度"; } } } else { if (item.stuff_ware_days == 0) { if (item.dispatch_days == 0) { temp = "自出"; } else { temp = "自出,調度"; } } else { if (item.dispatch_days == 0) { temp = "自出,寄倉"; } else { temp = "自出,寄倉,調度"; } } } item.vendor_mode = temp; if (Convert.ToBoolean(Request.Params["isSecret"])) { if (!string.IsNullOrEmpty(item.vendor_name_full)) { item.vendor_name_full = item.vendor_name_full.Substring(0, 1) + "**"; } // if (!string.IsNullOrEmpty(item.vendor_name_simple)) { item.vendor_name_simple = item.vendor_name_simple.Substring(0, 1) + "**"; }//vendor_company_address if (item.vendor_company_address.ToString().Length > 3) { item.vendor_company_address = item.vendor_company_address.Substring(0, 3) + "***"; } else { item.vendor_company_address = item.vendor_company_address + "***"; } if (!string.IsNullOrEmpty(item.contact_email_1)) { item.contact_email_1 = item.contact_email_1.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.contact_email_2)) { item.contact_email_2 = item.contact_email_2.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.contact_email_3)) { item.contact_email_3 = item.contact_email_3.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.contact_email_4)) { item.contact_email_4 = item.contact_email_4.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.contact_email_5)) { item.contact_email_5 = item.contact_email_5.Split('@')[0] + "@***"; } if (item.contact_mobile_1.ToString().Length > 3) { item.contact_mobile_1 = item.contact_mobile_1.Substring(0, 3) + "***"; } else { item.contact_mobile_1 = item.contact_mobile_1 + "***"; } if (item.contact_mobile_2.ToString().Length > 3) { item.contact_mobile_2 = item.contact_mobile_2.Substring(0, 3) + "***"; } else { item.contact_mobile_2 = item.contact_mobile_2 + "***"; } if (item.contact_mobile_3.ToString().Length > 3) { item.contact_mobile_3 = item.contact_mobile_3.Substring(0, 3) + "***"; } else { item.contact_mobile_3 = item.contact_mobile_3 + "***"; } if (item.contact_mobile_4.ToString().Length > 3) { item.contact_mobile_4 = item.contact_mobile_4.Substring(0, 3) + "***"; } else { item.contact_mobile_4 = item.contact_mobile_4 + "***"; } if (item.contact_mobile_5.ToString().Length > 3) { item.contact_mobile_5 = item.contact_mobile_5.Substring(0, 3) + "***"; } else { item.contact_mobile_5 = item.contact_mobile_5 + "***"; } if (item.contact_phone_1_1.ToString().Length > 3) { item.contact_phone_1_1 = item.contact_phone_1_1.Substring(0, 3) + "***"; } else { item.contact_phone_1_1 = item.contact_phone_1_1 + "***"; } if (item.contact_phone_1_2.ToString().Length > 3) { item.contact_phone_1_2 = item.contact_phone_1_2.Substring(0, 3) + "***"; } else { item.contact_phone_1_2 = item.contact_phone_1_2 + "***"; } if (item.contact_phone_1_3.ToString().Length > 3) { item.contact_phone_1_3 = item.contact_phone_1_3.Substring(0, 3) + "***"; } else { item.contact_phone_1_3 = item.contact_phone_1_3 + "***"; } if (item.contact_phone_1_4.ToString().Length > 3) { item.contact_phone_1_4 = item.contact_phone_1_4.Substring(0, 3) + "***"; } else { item.contact_phone_1_4 = item.contact_phone_1_4 + "***"; } if (item.contact_phone_1_5.ToString().Length > 3) { item.contact_phone_1_5 = item.contact_phone_1_5.Substring(0, 3) + "***"; } else { item.contact_phone_1_5 = item.contact_phone_1_5 + "***"; } if (item.contact_phone_2_1.ToString().Length > 3) { item.contact_phone_2_1 = item.contact_phone_2_1.Substring(0, 3) + "***"; } else { item.contact_phone_2_1 = item.contact_phone_2_1 + "***"; } if (item.contact_phone_2_2.ToString().Length > 3) { item.contact_phone_2_2 = item.contact_phone_2_2.Substring(0, 3) + "***"; } else { item.contact_phone_2_2 = item.contact_phone_2_2 + "***"; } if (item.contact_phone_2_3.ToString().Length > 3) { item.contact_phone_2_3 = item.contact_phone_2_3.Substring(0, 3) + "***"; } else { item.contact_phone_2_3 = item.contact_phone_2_3 + "***"; } if (item.contact_phone_2_4.ToString().Length > 3) { item.contact_phone_2_4 = item.contact_phone_2_4.Substring(0, 3) + "***"; } else { item.contact_phone_2_4 = item.contact_phone_2_4 + "***"; } if (item.contact_phone_2_5.ToString().Length > 3) { item.contact_phone_2_5 = item.contact_phone_2_5.Substring(0, 3) + "***"; } else { item.contact_phone_2_5 = item.contact_phone_2_5 + "***"; } if (!string.IsNullOrEmpty(item.contact_name_1)) { item.contact_name_1 = item.contact_name_1.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.contact_name_2)) { item.contact_name_2 = item.contact_name_2.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.contact_name_3)) { item.contact_name_3 = item.contact_name_3.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.contact_name_4)) { item.contact_name_4 = item.contact_name_4.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.contact_name_5)) { item.contact_name_5 = item.contact_name_5.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.manage_name)) { item.manage_name = item.manage_name.Substring(0, 1) + "**"; } if (!string.IsNullOrEmpty(item.manage_email)) { item.manage_email = item.manage_email.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.vendor_email)) { item.vendor_email = item.vendor_email.Split('@')[0] + "@***"; } if (!string.IsNullOrEmpty(item.company_person)) { item.company_person = item.company_person.Substring(0, 1) + "**"; } if (item.company_address.ToString().Length > 3) { item.company_address = item.company_address.Substring(0, 3) + "***"; } else { item.company_address = item.company_address + "***"; } if (item.invoice_address.ToString().Length > 3) { item.invoice_address = item.invoice_address.Substring(0, 3) + "***"; } else { item.invoice_address = item.invoice_address + "***"; } } } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";//返回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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }