public string QueryBig() { IZipImplMgr zMgr = new ZipMgr(connectionString); string json = string.Empty; try { json = zMgr.QueryBig(Request.Form["topValue"] ?? ""); } 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 = "[]"; } return json; }
//獲取地址 public HttpResponseBase GetZip() { string json = string.Empty; DataTable store = new DataTable(); zMgr = new ZipMgr(mySqlConnectionString); try { store = zMgr.GetZip(); 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 GetData() { uint orderId =0; if(uint.TryParse(Request.Params["order_id"],out orderId)) { orderId = orderId; } OrderMasterQuery omQuery=new OrderMasterQuery (); OrderShowMasterQuery query = new OrderShowMasterQuery(); string json = string.Empty; OrderShowMasterQuery store = new OrderShowMasterQuery(); _orderMasterMgr = new OrderMasterMgr(mySqlConnectionString); zMgr = new ZipMgr(mySqlConnectionString); try { store = _orderMasterMgr.GetData(orderId); uint user_id =(uint)(Session["caller"] as Caller).user_id; if (_orderMasterMgr.VerifySession(user_id) > 0) { store.is_manage_user = true; } else { store.is_manage_user = false; } if (!string.IsNullOrEmpty(Request.Params["isSecret"])) { if (Request.Params["isSecret"] == "false") { store.isSecret = false; } else { store.isSecret = true; } } omQuery.Order_Id=orderId; store.is_send_product = _orderMasterMgr.IsSendProduct(omQuery);//true可以變更 false不可變更。 store.is_vendor_deliver = _orderMasterMgr.IsVendorDeliver(orderId); store.OrderDatePay = CommonFunction.GetNetTime(store.order_date_pay); if (!string.IsNullOrEmpty(store.money_collect_date.ToString()) && store.money_collect_date != 0) { store.MoneyCollectDate = CommonFunction.GetNetTime(store.money_collect_date); } store.NoteOrderModifyTime = CommonFunction.GetNetTime(store.note_order_modify_time); store.OrderCreateDate = CommonFunction.GetNetTime(store.order_createdate); store.OrderDateClose = CommonFunction.GetNetTime(store.order_date_close); double value = Convert.ToDouble(store.deduct_happygo * store.deduct_happygo_convert); store.Hg_Nt = Math.Round(value).ToString(); //地址直接讀取 store.order_address = zMgr.Getaddress(int.Parse(store.order_zip.ToString())) + store.order_address; store.delivery_address = zMgr.Getaddress(int.Parse(store.delivery_zip.ToString())) + store.delivery_address; if (store.isSecret) { #region 添加資安的字段 if (store.order_name.Length > 1) { store.order_name = store.order_name.ToString().Substring(0, 1) + "**"; } else { store.order_name = store.order_name.ToString() + "**"; } //if (store.order_mobile.Length > 1) //{ // store.order_mobile = store.order_mobile.ToString().Substring(0, 1) + "****"; //} //else //{ // store.order_mobile = store.order_mobile.ToString() + "**"; //} if (!string.IsNullOrEmpty(store.order_mobile)) { if (!CommonFunction.isMobile(store.order_mobile)) { if (store.order_mobile.ToString().Length == 48) { store.order_mobile = EncryptComputer.EncryptDecryptTextByApi(store.order_mobile, false); if (!CommonFunction.isMobile(store.order_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.order_mobile, "訂購人行動電話解密后不滿足正則表達式"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } else { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.order_mobile, "訂購人行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } if (store.order_mobile.ToString().Length > 3) { store.order_mobile = store.order_mobile.Substring(0, 3) + "***"; } else { store.order_mobile = store.order_mobile + "***"; } } if (store.order_address.Length > 3) { store.order_address = store.order_address.ToString().Substring(0, 3) + "****"; } else { store.order_address = store.order_address.ToString() + "**"; } if (store.delivery_name.Length > 1) { store.delivery_name = store.delivery_name.ToString().Substring(0, 1) + "**"; } else { store.delivery_name = store.delivery_name.ToString() + "**"; } //if (store.delivery_mobile.Length > 1) //{ // store.delivery_mobile = store.delivery_mobile.ToString().Substring(0, 1) + "****"; //} //else //{ // store.delivery_mobile = store.delivery_mobile.ToString() + "**"; //} if (!string.IsNullOrEmpty(store.delivery_mobile)) { if (!CommonFunction.isMobile(store.delivery_mobile)) { if (store.delivery_mobile.ToString().Length == 48) { store.delivery_mobile = EncryptComputer.EncryptDecryptTextByApi(store.delivery_mobile, false); if (!CommonFunction.isMobile(store.delivery_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.delivery_mobile, "收貨人行動電話解密后不滿足正則表達式"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } else { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},訂單編號:{1},行動電話:{2},Message:{3}", "order_master", store.order_id, store.delivery_mobile, "收貨人行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } if (store.delivery_mobile.ToString().Length > 3) { store.delivery_mobile = store.delivery_mobile.Substring(0, 3) + "***"; } else { store.delivery_mobile = store.delivery_mobile + "***"; } } if (store.delivery_address.Length > 3) { store.delivery_address = store.delivery_address.ToString().Substring(0, 3) + "****"; } else { store.delivery_address = store.delivery_address.ToString() + "**"; } #endregion } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,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,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public string QueryCityZip() { zMgr = new ZipMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["zipcode"])) { json = "{success:true,data:" + JsonConvert.SerializeObject(zMgr.QueryCityAndZip(Request.Params["zipcode"])) + "}";//返回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 = "[]"; } return json; }
public string QueryZip() { zMgr = new ZipMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["topValue"])) { json = zMgr.QuerySmall(Request.Form["topValue"].ToString(), Request.Form["topText"].ToString()); } } 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 = "[]"; } return json; }
/*****************chaojie1124j********************/ public HttpResponseBase GetZip() { Zip zip = new Zip(); List<Zip> zipList = new List<Zip>(); int resultzip = 0; if (!string.IsNullOrEmpty(Request.Params["big_code"])) { zip.bigcode = Request.Params["big_code"]; resultzip = 1; } if (!string.IsNullOrEmpty(Request.Params["c_midcode"])) { zip.middlecode = Request.Params["c_midcode"]; resultzip = 1; } if (!string.IsNullOrEmpty(Request.Params["c_zipcode"])) { zip.zipcode = Request.Params["c_zipcode"]; resultzip = 1; } string jsonStr = string.Empty; try { zMgr = new ZipMgr(connectionString); zipList = zMgr.GetZipList(zip); if (zipList.Count > 0 && resultzip > 0) { jsonStr = "{success:true,msg:\"" + zipList[0].big + " " + zipList[0].middle + " " + zipList[0].zipcode + "/" + zipList[0].small.Trim() + "\"}"; } else { jsonStr = "{success:true,msg:\"" + 100 + "\"}"; } } 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 ExportVipListCsv() { string json = string.Empty; UserVipListQuery query = new UserVipListQuery(); List<UserVipListQuery> stores = new List<UserVipListQuery>(); try { if (!string.IsNullOrEmpty(Request.Params["dateOne"])) { query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["dateTwo"])) { query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd HH:mm:ss")); } if (!string.IsNullOrEmpty(Request.Params["user_id"])) { query.user_id = uint.Parse(Request.Params["user_id"]); } int totalCount = 0; query.IsPage = false; zMgr = new ZipMgr(mySqlConnectionString); usersMgr = new UsersMgr(mySqlConnectionString); stores = usersMgr.ExportVipListCsv(query, ref totalCount); DataTable _vipdt = usersMgr.IsVipUserId(0); DataTable newDt = new DataTable(); newDt.Columns.Add("user_id", typeof(string)); newDt.Columns.Add("user_status", typeof(string)); newDt.Columns.Add("user_name", typeof(string)); newDt.Columns.Add("user_gender", typeof(string)); newDt.Columns.Add("VIP", typeof(string)); // newDt.Columns.Add("user_email", typeof(string)); newDt.Columns.Add("age", typeof(string)); newDt.Columns.Add("user_birthday_month", typeof(string)); // newDt.Columns.Add("user_address", typeof(string)); newDt.Columns.Add("user_reg_date", typeof(string));//需要轉 newDt.Columns.Add("order_createdate", typeof(string));//需要轉 newDt.Columns.Add("last_time", typeof(string));//需要轉 newDt.Columns.Add("sum_amount", typeof(string)); newDt.Columns.Add("cou", typeof(string)); newDt.Columns.Add("aver_amount", typeof(string));//計算得出 newDt.Columns.Add("sum_bonus", typeof(string)); newDt.Columns.Add("normal_product", typeof(string)); newDt.Columns.Add("freight_normal", typeof(string)); newDt.Columns.Add("low_product", typeof(string)); newDt.Columns.Add("freight_low", typeof(string)); newDt.Columns.Add("ct", typeof(string)); newDt.Columns.Add("HG", typeof(string)); newDt.Columns.Add("ht", typeof(string)); newDt.Columns.Add("ml_code", typeof(string)); //newDt.Columns.Add("order_product_subtotal", typeof(string)); for (int i = 0; i < stores.Count; i++) { DataRow newRow = newDt.NewRow(); newRow["user_id"] = stores[i].user_id; //newRow["user_status"] = stores[i].user_status; switch (stores[i].user_status) { case 0: newRow["user_status"] = "未啟用"; break; case 1: newRow["user_status"] = "已啟用"; break; case 2: newRow["user_status"] = "停用"; break; case 5: newRow["user_status"] = "簡易會員"; break; } newRow["user_name"] = stores[i].user_name; newRow["user_gender"] = stores[i].user_gender == 0 ? "小姐" : "先生"; newRow["VIP"] = "N"; for (int j = 0; j < _vipdt.Rows.Count; j++) { if (_vipdt.Rows[j]["user_id"] != null) { if (stores[i].user_id.ToString() == _vipdt.Rows[j]["user_id"].ToString()) { newRow["VIP"] = "Y"; break; } } } //newRow["user_email"] = stores[i].user_email; newRow["age"] = DateTime.Now.Year - stores[i].user_birthday_year; newRow["user_birthday_month"] = stores[i].user_birthday_month; //if (zMgr.QueryCityAndZip(stores[i].user_zip.ToString()) != null) //{ // newRow["user_address"] = zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).middle + " " + zMgr.QueryCityAndZip(stores[i].user_zip.ToString()).small; //} //else //{ // newRow["user_address"] = ""; //} newRow["user_reg_date"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].user_reg_date)); newRow["order_createdate"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].order_createdate)); newRow["last_time"] = newRow["order_createdate"]; //if (stores[i].last_time == Convert.ToUInt32(CommonFunction.GetPHPTime("1970-1-1 8:00"))) //{ // newRow["last_time"] = ""; //} //else //{ // newRow["last_time"] = CommonFunction.DateTimeToString(CommonFunction.GetNetTime(stores[i].last_time)); //} newRow["sum_amount"] = stores[i].sum_amount; newRow["cou"] = stores[i].cou; decimal s = stores[i].sum_amount / stores[i].cou; int sint = Convert.ToInt32(s); newRow["aver_amount"] = s > sint ? sint + 1 : sint; newRow["sum_bonus"] = stores[i].sum_bonus; newRow["normal_product"] = stores[i].normal_product; newRow["freight_normal"] = stores[i].freight_normal; newRow["low_product"] = stores[i].low_product; newRow["freight_low"] = stores[i].freight_low; newRow["ct"] = stores[i].ct; newRow["HG"] = stores[i].ct; newRow["ht"] = stores[i].ht; newRow["ml_code"] = stores[i].ml_code; //newRow["order_product_subtotal"] = stores[i].order_product_subtotal; newDt.Rows.Add(newRow); } // string[] columnName = { "編號", "會員狀態", "姓名", "性別", "VIP", "電子郵件", "年齡", "生日月份", "居住區", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵" }; string[] columnName = { "會員編號", "會員狀態", "姓名", "性別", "VIP", "年齡", "生日月份", "註冊時間", "最近歸檔日", "最近購買日", "購買金額", "購買次數", "客單價", "購物金使用", "常溫商品總額", "常溫商品運費", "低溫商品總額", "低溫商品運費", "中信折抵", "HG折抵", "台新折抵", "會員等級" };//, "近期累積金額" }; string fileName = "Vip_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv"; string newFileName = Server.MapPath(excelPath) + fileName; json = "{success:'true',filename:'" + fileName + "'}"; CsvHelper.ExportDataTableToCsv(newDt, newFileName, columnName, true); } 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 SaveChannel() { zMgr = new ZipMgr(connectString); chMgr = new ChannelMgr(connectString); uMgr = new UsersMgr(connectString); string json = string.Empty; bool result = false; string channel_id = Request.Form["channel_id"] ?? string.Empty; try { if (!string.IsNullOrEmpty(Request.Form["channel_status"])) { ch.channel_status = Int32.Parse(Request.Form["channel_status"].ToString()); } if (!string.IsNullOrEmpty(Request.Form["channel_type"])) { ch.channel_type = Int32.Parse(Request.Form["channel_type"].ToString()); } if (!string.IsNullOrEmpty(Request.Form["channel_name_full"])) { ch.channel_name_full = Request.Form["channel_name_full"].ToString(); u.user_name = Request.Form["channel_name_full"].ToString(); List<Channel> channel = chMgr.QueryC(" and channel_name_full='" + Request.Form["channel_name_full"] + "'"); if (channel != null && channel.Count > 0 && channel.Where(m => m.channel_id == int.Parse(string.IsNullOrEmpty(channel_id) ? "0" : channel_id)).Count() == 0) { json = "{success:true,msg:\""+Resources.Channel.CHANNEL_HAS_EXIST+"。\",channelId:\"" + channel_id + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } if (!string.IsNullOrEmpty(Request.Form["channel_name_simple"])) { ch.channel_name_simple = Request.Form["channel_name_simple"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["channel_invoice"])) { ch.channel_invoice = Request.Form["channel_invoice"].ToString(); u.user_password = Request.Form["channel_invoice"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["channel_email"])) { ch.channel_email = Request.Form["channel_email"].ToString(); } else { ch.channel_email = ""; } if (!string.IsNullOrEmpty(Request.Form["company_cphonenum"])) { ch.company_phone = Request.Form["company_cphone"].ToString() +Request.Form["company_cphonenum"].ToString(); } else { ch.company_phone = ""; } if (!string.IsNullOrEmpty(Request.Form["company_cfaxnum"])) { ch.company_fax = Request.Form["company_cfax"].ToString() +Request.Form["company_cfaxnum"].ToString(); } else { ch.company_fax = ""; } if (!string.IsNullOrEmpty(Request.Form["company_zip"])) { ch.company_zip = Int32.Parse(Request.Form["company_zip"].ToString()); } else { ch.company_zip = 0; } if (!string.IsNullOrEmpty(Request.Form["company_address"])) { ch.company_address = Request.Form["company_address"].ToString(); } else { ch.company_address = ""; } if (!string.IsNullOrEmpty(Request.Form["invoice_title"])) { ch.invoice_title = Request.Form["invoice_title"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["invoice_zip"])) { ch.invoice_zip = Int32.Parse(Request.Form["invoice_zip"].ToString()); } if (!string.IsNullOrEmpty(Request.Form["invoice_address"])) { ch.invoice_address = Request.Form["invoice_address"].ToString(); } if (!string.IsNullOrEmpty(Request.Form["contract_createdate"])) { ch.contract_createdate = DateTime.Parse(Request.Form["contract_createdate"].ToString()); } else { ch.contract_createdate = DateTime.MinValue; } if (!string.IsNullOrEmpty(Request.Form["contract_start"])) { ch.contract_start = DateTime.Parse(Request.Form["contract_start"].ToString()); } else { ch.contract_start = DateTime.MinValue; } if (!string.IsNullOrEmpty(Request.Form["contract_end"])) { ch.contract_end = DateTime.Parse(Request.Form["contract_end"].ToString()); } else { ch.contract_end = DateTime.MinValue; } if (!string.IsNullOrEmpty(Request.Form["annaul_fee"])) { ch.annaul_fee = Decimal.Parse(Request.Form["annaul_fee"].ToString()); } else { ch.annaul_fee = 0; } if (!string.IsNullOrEmpty(Request.Form["renew_fee"])) { ch.renew_fee = Decimal.Parse(Request.Form["renew_fee"].ToString()); } else { ch.renew_fee = 0; } if (!string.IsNullOrEmpty(Request.Form["model_in"])) { ch.model_in = Request.Form["model_in"].ToString(); } else { ch.model_in = "1"; } if (!string.IsNullOrEmpty(Request.Form["notify_sms"])) { ch.notify_sms = Int32.Parse(Request.Form["notify_sms"].ToString()); } else { ch.notify_sms = 0; } //add by xiangwang0413w 2014/06/26 增加 ERP客戶代號 if (!string.IsNullOrEmpty(Request.Form["erp_id"])) { ch.erp_id = Request.Form["erp_id"]; } DataTable dtUsers = uMgr.Query(Request.Form["manager_Email"].ToString()); if (dtUsers.Rows.Count > 0)//會員信箱已存在 { DataTable dtUserId = chMgr.QueryUser(dtUsers.Rows[0]["user_id"].ToString()); if (string.IsNullOrEmpty(channel_id))//新增 { if (dtUserId.Rows.Count > 0)//是否被外站使用 { json = "{success:true,msg:\""+Resources.Channel.MAIL_WAS_USED+"。\",channelId:\"" + channel_id + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } else { ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString()); channel_id = chMgr.Save(ch).ToString(); result = Int32.Parse(channel_id) > 0; } } else { //修改 if (dtUserId.Rows.Count > 0) { if (dtUserId.Rows[0]["channel_id"].ToString() != channel_id) { json = "{success:true,msg:\"" + Resources.Channel.MAIL_WAS_USED + "。\",channelId:\"" + channel_id + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } else { ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString()); } } else { ch.user_id = Int32.Parse(dtUsers.Rows[0]["user_id"].ToString()); } ch.channel_id = Int32.Parse(channel_id); result = chMgr.Edit(ch) > 0; } } else { //會員信箱不存在 u.user_email = Request.Form["manager_Email"].ToString(); u.user_name = Request.Form["channel_name_full"].ToString(); BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt(); u.user_password = hash.SHA256Encrypt(Request.Form["invoice_title"].ToString()); u.user_mobile = "0227833183"; u.user_phone = "0227833183"; u.user_zip = 115; u.user_address = Resources.Channel.USER_ADDRESS; u.user_status = 1; u.user_reg_date = (int)BLL.gigade.Common.CommonFunction.GetPHPTime(); u.user_updatedate = (int)BLL.gigade.Common.CommonFunction.GetPHPTime(); u.user_birthday_year = 1900; u.user_birthday_month = 01; u.user_birthday_day = 01; if (uMgr.SelSaveID(u) > 0) { ch.user_id = Convert.ToInt32(u.user_id); } if (string.IsNullOrEmpty(channel_id)) { channel_id=chMgr.Save(ch).ToString(); /** *如果外站類型是gigade,則將參數表中type=deliver_store(即所有物流方式)全部插入channel_shipping表中 ***/ if (ch.channel_type == 2) { paraMgr = new ParameterMgr(connectString); chsMgr = new ChannelShippingMgr(connectString); List<Parametersrc> Deliver_result = paraMgr.QueryUsed(new Parametersrc { ParameterType = "deliver_store", Used = 1 }); foreach (Parametersrc item in Deliver_result) { chs.channel_id = int.Parse(channel_id); chs.shipping_carrior = int.Parse(item.ParameterCode); chs.shipco = item.parameterName; chsMgr.Save(chs); } } /* end by zhongyu0304w at 2013/10/10 */ result = Int32.Parse(channel_id) > 0; } else { ch.channel_id = int.Parse(channel_id); result = chMgr.Edit(ch) > 0; } } if (result) { json = "{success:true,msg:\""+Resources.Channel.SUCCESS+"。\",channelId:\"" + channel_id + "\"}"; } else { json = "{success:true,msg:\""+Resources.Channel.FAILED+"\",channelId:\"" + channel_id + "\"}"; } } 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:true,msg:\"" + Resources.Channel.FAILED + "\",channelId:\"" + channel_id + "\"}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase Import() { List<OrdersImport> all = (List<OrdersImport>)Session["import"] ?? null; int successCount = 0; int totalCount = 0; string json = string.Empty; try { if (all != null) { if (!string.IsNullOrEmpty(Request.Form["Orders"]) && !string.IsNullOrEmpty(Request.Form["Files"]) && !string.IsNullOrEmpty(Request.Form["ImportType"]) && !string.IsNullOrEmpty(Request.Form["Channel"])) { string orders = Request.Form["Orders"]; int channel = Convert.ToInt32(Request.Form["Channel"]); string improtType = Request.Form["ImportType"]; int site_id = int.Parse(Request.Form["site"]);//add xw string files = Request.Form["Files"]; Resource.CoreMessage = new CoreResource("OrderImport"); orderImport = OrderImportFactory.InitOrderImport(channel); if (orderImport != null) { string[] names = files.Split('|'); string execlFile = files.LastIndexOf("|") != -1 ? Server.MapPath(excelPath) + names[0] : Server.MapPath(excelPath) + files; string pdfFile = files.LastIndexOf("|") != -1 && names.Length == 3 ? names[2] : ""; //修改 Excel 表裏面的地址 add by zhuoqin0830w 2015/04/17 for (int i = 0; i < all.Count; i++) { zMgr = new ZipMgr(connectionString); if (!string.IsNullOrEmpty(all[i].agpesadrzip)) { string small = zMgr.QueryCityAndZip(all[i].agpesadrzip).small; int index = all[i].agpesadr.IndexOf(small); if (index != -1) { string newAddress = all[i].agpesadr.Substring(index + small.Length); all[i].agpesadr = newAddress; } } } successCount = orderImport.Import2DB(all, pdfFile, improtType, orders, site_id, ref totalCount); if (successCount > 0) { ImportOrdersLog log = new ImportOrdersLog { Channel_Id = channel, TCount = totalCount, Success_Count = successCount }; log.File_Name = names[1]; log.Import_Date = DateTime.Now; log.Exec_Name = (Session["caller"] as Caller).user_username; importOrdersLogMgr = new ImportOrdersLogMgr(connectionString); importOrdersLogMgr.Save(log); } } } all.FindAll(m => m.IsSel).ForEach(m => m.IsSel = false); Session["import"] = all; } } 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 = "{Total:" + totalCount + ",SucccessCount:" + successCount + ",Orders:" + JsonConvert.SerializeObject(all) + "}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetUserInfo() { string json = "{success:false}"; try { int type = 0; int related_id = 0; string urlType = string.Empty; int totalCount = 0; int info_id = 0; string info_type = string.Empty; if (!string.IsNullOrEmpty(Request.Params["relatedID"])) { related_id = Convert.ToInt32(Request.Params["relatedID"].ToString());//表主鍵欄位 } if (!string.IsNullOrEmpty(Request.Params["type"])) { type = Convert.ToInt32(Request.Params["type"].ToString());//secret_type,表某一模塊 } if (!string.IsNullOrEmpty(Request.Params["urlType"]))//url地址 { urlType = Request.Params["urlType"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["info_id"])) { info_id = Convert.ToInt32(Request.Params["info_id"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["info_type"])) { info_type = Request.Params["info_type"].ToString(); } switch (info_type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case "users": UsersMgr _usermgr = new UsersMgr(mySqlConnectionString); Users u = new Users(); Users uModel = _usermgr.GetUser(new Users { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); if (uModel != null) { if (!string.IsNullOrEmpty(uModel.user_mobile)) { if (!CommonFunction.isMobile(uModel.user_mobile)) { if (uModel.user_mobile.ToString().Length == 48) { uModel.user_mobile = EncryptComputer.EncryptDecryptTextByApi(uModel.user_mobile, false); if (!CommonFunction.isMobile(uModel.user_mobile)) { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話解密后不滿足正則表達式"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } else { //異常記錄 Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("表名:{0},編號:{1},行動電話:{2},Message:{3}", "users", uModel.user_id, uModel.user_mobile, "行動電話錯誤"); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } } } } json = "{success:true,\"user_id\":\"" + uModel.user_id + "\",\"user_name\":\"" + uModel.user_name + "\",\"user_email\":\"" + uModel.user_email + "\",\"user_mobile\":\"" + uModel.user_mobile + "\",\"user_adress\":\"" + uModel.user_address + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; case "trial_share": TrialRecordMgr _recordMgr = new TrialRecordMgr(mySqlConnectionString); TrialShare tModel = _recordMgr.GetTrialShare(new TrialShare { share_id = related_id, user_id = info_id }); json = "{success:true,\"user_id\":\"" + tModel.user_id + "\",\"user_name\":\"" + tModel.user_name + "\"}"; break; case "manager_user": ManageUserMgr _muMgr = new ManageUserMgr(mySqlConnectionString); ManageUser muModel = _muMgr.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + muModel.user_id + "\",\"user_name\":\"" + muModel.user_username + "\",\"user_email\":\"" + muModel.user_email + "\"}"; break; case "vip_user": VipUserMgr vipusersMgr = new VipUserMgr(mySqlConnectionString); VipUser model = vipusersMgr.GetSingleByID(related_id); json = "{success:true,\"v_id\":\"" + model.v_id + "\",\"user_id\":\"" + model.user_id + "\",\"user_email\":\"" + model.user_email + "\"}"; break; case "edm_group_email": EdmGroupEmailMgr edmgroupmailMgr = new EdmGroupEmailMgr(mySqlConnectionString); EdmGroupEmailQuery egemodel = edmgroupmailMgr.GetModel(new EdmGroupEmail { email_id = Convert.ToUInt32(related_id), group_id = Convert.ToUInt32(info_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + egemodel.email_id + "\",\"user_name\":\"" + egemodel.email_name + "\",\"user_email\":\"" + egemodel.email_address + "\"}"; break; case "edm_test": EdmTestMgr edmtestMgr = new EdmTestMgr(mySqlConnectionString); EdmTestQuery etmodel = edmtestMgr.GetModel(new EdmTestQuery { email_id = Convert.ToUInt32(related_id) }).FirstOrDefault(); json = "{success:true,\"user_id\":\"" + etmodel.email_id + "\",\"user_name\":\"" + etmodel.test_username + "\",\"user_email\":\"" + etmodel.email_address + "\"}"; break; case "order_master": OrderMasterMgr omMgr = new OrderMasterMgr(mySqlConnectionString); zMgr = new ZipMgr(mySqlConnectionString); DataTable dt = omMgr.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt.Rows[0][0] + "\",\"order_name\":\"" + dt.Rows[0][1] + "\",\"order_phone\":\"" + dt.Rows[0][2] + "\",\"order_mobile\":\"" + dt.Rows[0][3] + "\",\"order_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][9].ToString())) + dt.Rows[0][4] + "\",\"delivery_name\":\"" + dt.Rows[0][5] + "\",\"delivery_phone\":\"" + dt.Rows[0][6] + "\",\"delivery_mobile\":\"" + dt.Rows[0][7] + "\",\"delivery_address\":\"" + zMgr.Getaddress(int.Parse(dt.Rows[0][10].ToString())) + dt.Rows[0][8] + "\"}"; break; case "order_master1": OrderMasterMgr omMgr1 = new OrderMasterMgr(mySqlConnectionString); DataTable dt1 = omMgr1.GetOrderidAndName(related_id); json = "{success:true,\"order_id\":\"" + dt1.Rows[0][0] + "\",\"order_name\":\"" + dt1.Rows[0][1] + "\"}"; break; case "order_payment_hitrust": TabShowMgr OphMgr = new TabShowMgr(mySqlConnectionString); DataTable store = new DataTable(); store = OphMgr.GetOderHitrustDT(related_id); json = "{success:true,\"id\":\"" + store.Rows[0]["id"] + "\",\"pan\":\"" + store.Rows[0]["pan"] + "\",\"bankname\":\"" + store.Rows[0]["bankname"] + "\"}"; break; case "order_payment_nccc": TabShowMgr OpnMgr = new TabShowMgr(mySqlConnectionString); DataTable Opn = new DataTable(); store = OpnMgr.GetNCCC(related_id); json = "{success:true,\"nccc_id\":\"" + Opn.Rows[0]["nccc_id"] + "\",\"nccc_pan\":\"" + Opn.Rows[0]["pan"] + "\",\"nccc_bankname\":\"" + Opn.Rows[0]["bankname"] + "\"}"; break; //case "send_mail": // SendMailMgr sendmailMgr = new SendMailMgr(mySqlConnectionString); // SendMail sendModel = sendmailMgr.GetModel(new SendMail { id = related_id }); // json = "{success:true,\"sender_address\":\"" + sendModel.sender_address + "\",\"sender_name\":\"" + sendModel.sender_name + "\",\"send_type\":\"" + sendModel.send_type // + "\",\"recipient\":\"" + sendModel.recipient + "\",\"recipient_name\":\"" + sendModel.recipient_name // + "\"}"; // break; } switch (type)//1.會員查詢頁面2.訂單內容3.簡訊查詢4.聯絡客服列表 { case 1: if (urlType == "/Member/RecommendMember")//推薦會員中推薦者的信息 { UserRecommendMgr _userrecommendMgr = new UserRecommendMgr(mySqlConnectionString); DataTable _urdtno = _userrecommendMgr.getUserInfo(related_id); if (_urdtno.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"ur_name\":\"" + _urdtno.Rows[0]["name"] + "\",\"ur_mail\":\"" + _urdtno.Rows[0]["mail"] + "\",\"no_ur_name\":\"" + _urdtno.Rows[0]["user_name"] + "\"}"; } } else if (urlType == "/Member/UserLoginLog")//會員登入記錄 { UserLoginLogMgr _userloginlog = new UserLoginLogMgr(mySqlConnectionString); DataTable _dtull = _userloginlog.GetUserInfo(related_id); if (_dtull.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtull.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtull.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtull.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtull.Rows[0]["user_address"] + "\"}"; } } else { UsersListMgr _userMgr = new UsersListMgr(mySqlConnectionString); BLL.gigade.Model.Custom.Users _user = _userMgr.getModel(related_id); if (_user != null) { json = "{success:true,\"user_id\":\"" + _user.user_id + "\",\"user_name\":\"" + _user.user_name + "\",\"user_email\":\"" + _user.user_email + "\",\"user_adress\":\"" + _user.user_address + "\"}"; } } break; case 2: OrderQuestionMgr _IOrderQuesMgr = new OrderQuestionMgr(mySqlConnectionString); DataTable _dtques = _IOrderQuesMgr.GetUserInfo(related_id); if (_dtques.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtques.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtques.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtques.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\",\"order_id\":\"" + _dtques.Rows[0]["order_id"] + "\"}"; } break; case 3: SmsMgr _ISmsMgr = new SmsMgr(mySqlConnectionString); SmsQuery SmsStore = _ISmsMgr.GetSmsList(new SmsQuery { id = related_id }, out totalCount).FirstOrDefault(); if (SmsStore != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + "" + "\",\"user_mobile\":\"" + SmsStore.mobile + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 4: ContactUsQuestionMgr _ctactMgr = new ContactUsQuestionMgr(mySqlConnectionString); DataTable _dt = _ctactMgr.GetUserInfo(related_id); if (_dt.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dt.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dt.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dt.Rows[0]["user_email"] + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 7://供應商詳情 VendorQuery _dtven = null; if (urlType == "/Vendor/VendorBrandList") { VendorBrandSetMgr _IvendorBrandSet = new VendorBrandSetMgr(mySqlConnectionString); VendorBrandSetQuery query = _IvendorBrandSet.GetModelById(related_id); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + "" + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else if (urlType == "/Vendor/VendorLoginList") { VendorLoginListMgr _Ivendorloginlist = new VendorLoginListMgr(mySqlConnectionString); VendorLoginQuery query = _Ivendorloginlist.Query(new VendorLoginQuery { login_id = Convert.ToUInt32(related_id), IsPage = false }, out totalCount).FirstOrDefault(); VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = query.vendor_id, IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + "" + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } else { VendorMgr _vendorMgr = new VendorMgr(mySqlConnectionString); _dtven = _vendorMgr.Query(new VendorQuery { vendor_id = Convert.ToUInt32(related_id), IsPage = false }, ref totalCount).FirstOrDefault(); if (_dtven != null) { json = "{success:true,\"user_id\":\"" + _dtven.vendor_code + "\",\"user_name\":\"" + _dtven.vendor_name_full + "\",\"user_email\":\"" + _dtven.vendor_email + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + _dtven.vendor_company_address + "\",\"simple_name\":\"" + _dtven.vendor_name_simple + "\"}"; } } break; case 9: MailUserMgr _IMailUserMgr = new MailUserMgr(mySqlConnectionString); DataTable _dtmu = _IMailUserMgr.GetUserInfo(related_id); if (_dtmu.Rows.Count > 0) { json = "{success:true,\"user_id\":\"" + _dtmu.Rows[0]["user_id"] + "\",\"user_name\":\"" + _dtmu.Rows[0]["user_name"] + "\",\"user_email\":\"" + _dtmu.Rows[0]["user_email"] + "\",\"user_adress\":\"" + _dtmu.Rows[0]["user_address"] + "\"}"; } break; case 10: PaperAnswerMgr _paperAnswerMgr = new PaperAnswerMgr(mySqlConnectionString); PaperAnswer store = _paperAnswerMgr.GetPaperAnswerList(new PaperAnswer { answerID = related_id, IsPage = false }, out totalCount).FirstOrDefault(); if (store != null) { json = "{success:true,\"user_id\":\"" + store.userid + "\",\"user_name\":\"" + "" + "\",\"user_email\":\"" + store.userMail + "\",\"user_phone\":\"" + "" + "\",\"user_adress\":\"" + "" + "\"}"; } break; case 14://會員等級歷程 UserLevelLogMgr _userLevelLog = new UserLevelLogMgr(mySqlConnectionString); // UserLevelLogQuery store UserLevelLogQuery levelStore = _userLevelLog.GetUserLevelLogList(new UserLevelLogQuery { user_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (levelStore != null) { json = "{success:true,\"user_id\":\"" + levelStore.user_id + "\",\"user_name\":\"" + levelStore.user_name + "\",\"user_email\":\"" + levelStore.user_email + "\"}"; } break; case 18://企業會員管理 _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); VipUserGroupQuery vipStore = _vipUserGroup.GetVipUserGList(new VipUserGroupQuery { group_id = Convert.ToUInt32(related_id), IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); if (vipStore != null) { json = "{success:true,\"group_committe_chairman\":\"" + vipStore.group_committe_chairman + "\",\"group_committe_phone\":\"" + vipStore.group_committe_phone + "\",\"group_committe_mail\":\"" + vipStore.group_committe_mail + "\"}"; } break; case 19://商品點擊查詢 _IBrowseDataMgr = new BrowseDataMgr(mySqlConnectionString); DataTable _dtBrowse = _IBrowseDataMgr.GetBrowseDataList(new BrowseDataQuery { id = related_id, IsPage = false, isSecret = false }, out totalCount); string user_name = (_dtBrowse.Rows[0]["user_name"].ToString()); string user_id = (_dtBrowse.Rows[0]["user_id"].ToString()); json = "{success:true,\"user_name\":\"" + user_name + "\",\"user_id\":\"" + user_id + "\"}"; break; case 22://聯合信用卡銀行卡號 _tabshow = new TabShowMgr(mySqlConnectionString); // OrderPaymentNcccQuery OPNQuery = new OrderPaymentNcccQuery(); OrderPaymentNcccQuery OPNQuery = _tabshow.GetNCCC(new OrderPaymentNcccQuery { nccc_id = (uint)related_id, IsPage = false, isSecret = false }, out totalCount).FirstOrDefault(); json = "{success:true,\"nccc_id\":\"" + OPNQuery.nccc_id + "\",\"nccc_pan\":\"" + OPNQuery.pan + "\",\"nccc_bankname\":\"" + OPNQuery.bankname + "\"}"; break; case 23://退貨 _orderReturnStatus = new OrderReturnStatusMgr(mySqlConnectionString); OrderMaster om = _orderReturnStatus.GetOrderInfo(Convert.ToUInt32(related_id)); json = "{success:true,\"orc_name\":\"" + om.Delivery_Name + "\",\"orc_mobile\":\"" + om.Delivery_Mobile + "\",\"orc_address\":\"" + om.Delivery_Address + "\"}"; break; } } 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 Model.Custom.TableChangeLogCustom GetVendorChangeDetail(TableChangeLogQuery query) { try { DataTable _dt = _tclDao.GetVendorChangeDetail(query); Model.Custom.TableChangeLogCustom _model = new Model.Custom.TableChangeLogCustom(); if (_dt.Rows.Count > 0) { Dao.ParametersrcDao _pDao = new Dao.ParametersrcDao(connStr); List<Model.Parametersrc> _pModel = _pDao.Query(new Model.Parametersrc { ParameterType = "ColumnChange", ParameterCode = "vendor" }); List<Model.Parametersrc> _slist = _pDao.QueryParametersrcByTypes("vendor_type"); if (_pModel.Count > 0) { _model.vendor_id = Convert.ToInt32(_dt.Rows[0]["vendor_id"].ToString()); _model.vendor_name_full = _dt.Rows[0]["vendor_name_full"].ToString(); List<Model.TableChangeLog> _list = new List<Model.TableChangeLog>(); foreach (DataRow dr in _dt.Rows) { Model.TableChangeLog _log = new Model.TableChangeLog(); _log.change_field = dr["change_field"].ToString(); if (_log.change_field == "vendor_status") { string[] status_str = { "", "啟用", "停用", "失格" }; _log.old_value = status_str[Convert.ToInt32(dr["old_value"].ToString())].ToString(); _log.new_value = status_str[Convert.ToInt32(dr["new_value"].ToString())].ToString(); } else if (_log.change_field == "product_manage") { ManageUserMgr mu = new ManageUserMgr(connStr); List<ManageUser> o_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["old_value"].ToString()) }); List<ManageUser> n_mlist = mu.GetManageUser(new ManageUser { user_id = Convert.ToUInt32(dr["new_value"].ToString()) }); if (o_mlist.Count > 0) { _log.old_value = o_mlist[0].user_username; } if (n_mlist.Count > 0) { _log.new_value = n_mlist[0].user_username; } } else if (_log.change_field.IndexOf("contact_type") > -1) { string[] type_str = { "", "負責人", "業務窗口", "圖/文窗口", "出貨負責窗口", "帳務連絡窗口", "客服窗口", "刪除" }; _log.old_value = type_str[Convert.ToInt32(dr["old_value"].ToString())].ToString(); if (dr["new_value"].ToString() != "") { _log.new_value = type_str[Convert.ToInt32(dr["new_value"].ToString())].ToString(); } else { _log.new_value = type_str[0].ToString(); } } else if (_log.change_field == "vendor_type")//供應商類型 { if (_slist.Count > 0) { var a_o = dr["old_value"].ToString().Split(','); var a_n = dr["new_value"].ToString().Split(','); string l_o = ""; string l_n = ""; for (int i = 0; i < a_o.Length; i++) { if (!string.IsNullOrEmpty(a_o[i].ToString())) { l_o = l_o + _slist.Find(m => m.ParameterCode == a_o[i].ToString()).parameterName + ","; } } for (int i = 0; i < a_n.Length; i++) { if (!string.IsNullOrEmpty(a_n[i].ToString())) { l_n = l_n + _slist.Find(m => m.ParameterCode == a_n[i].ToString()).parameterName + ","; } } _log.old_value = l_o.TrimEnd(','); _log.new_value = l_n.TrimEnd(','); } } else if (_log.change_field == "company_address" || _log.change_field == "invoice_address")//公司地址或發票地址 { string o_zip = dr["old_value"].ToString().Split('&')[0]; string o_adress = dr["old_value"].ToString().Substring(dr["old_value"].ToString().IndexOf('&') + 1); string n_zip = dr["new_value"].ToString().Split('&')[0]; string n_adress = dr["new_value"].ToString().Substring(dr["new_value"].ToString().IndexOf('&') + 1); ZipMgr zip = new ZipMgr(connStr); _log.old_value = zip.Getaddress(Convert.ToInt32(o_zip)) + o_adress; _log.new_value = zip.Getaddress(Convert.ToInt32(n_zip)) + n_adress; } else { _log.old_value = dr["old_value"].ToString(); _log.new_value = dr["new_value"].ToString(); } if (!string.IsNullOrEmpty(dr["field_ch_name"].ToString())) { _log.field_ch_name = dr["field_ch_name"].ToString(); } else { _log.field_ch_name = _pModel.Find(m => m.parameterName == _log.change_field).remark; } _list.Add(_log); } _model.tclModel = _list; } } return _model; } catch (Exception ex) { throw new Exception("TableChangeLogMgr-->GetVendorChangeDetail-->" + ex.Message, ex); } }