public static IOrderImport InitOrderImport(int ChannelId) { IOrderImport orderImport = null; ChannelMgr channelMgr = new ChannelMgr(GetMySqlConnStr()); Channel channel=channelMgr.QueryC(" and channel_id='" + ChannelId + "'").FirstOrDefault(); if (channel != null) { switch (channel.model_in) { case "1": orderImport = new OrderImportZero(); break; case "2": orderImport = new OrderImportGigade(); break; case "3": orderImport = new OrderImportPayEasy(); //當類型類PayEasy訂單的時候實例化該類型 break; } if (orderImport != null) { orderImport.MySqlConnStr = GetMySqlConnStr(); orderImport.CurChannel = channel; } } return orderImport; }
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; }