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;
}
/// <summary>
/// 將文件內容存儲到數據庫
/// </summary>
/// <param name="all"></param>
/// <param name="pdfFile"></param>
/// <param name="importType"></param>
/// <param name="chkRecord"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public int Import2DB(List<OrdersImport> all, string pdfFile, string importType, string chkRecord, int siteId, ref int totalCount)
{
orderImportMgr = new OrderImportMgr(MySqlConnStr, CurChannel.channel_id);
int successCount = 0;
try
{
List<OrdersImport> chks = orderImportMgr.SplitChkData(chkRecord).FindAll(m => m.chlitpdno != "0");//移除廠商商品編號為0的
if (chks != null && all != null && all.Count > 0)
{
#region 篩選出選中數據資訊
//所有選中商品
var result = from h in chks
join o in all on new { h.dmtshxuid, h.chlitpdno } equals new { o.dmtshxuid, o.chlitpdno } into cs
from c in cs.DefaultIfEmpty()
select c;
#endregion
//所有訂單編號
List<string> master = chks.GroupBy(m => m.dmtshxuid).Select(m => m.Key).ToList();
totalCount = master == null ? 0 : master.Count;
//外站物流業者
channelShippingMgr = new ChannelShippingMgr(MySqlConnStr);
List<ChannelShipping> shippings = channelShippingMgr.QueryByChannelId(new ChannelShipping { channel_id = CurChannel.channel_id });
foreach (var om in master)
{
//單個訂單下所有商品
var product = (from p in result
where p.dmtshxuid == om
select p).ToList();
all.FindAll(m => m.dmtshxuid == om && product.Exists(n => n.chlitpdno == m.chlitpdno)).ForEach(m => m.IsSel = true);
#region 訂單物流業者
ChannelShipping cShipping = null;
if (shippings != null)
{
//查詢該訂單物流業者 取貨方式
cShipping = shippings.Where(m => m.shipco.Trim().ToLower() == product.FirstOrDefault().shipco.Trim().ToLower()).FirstOrDefault();
}
if (shippings == null || cShipping == null)
{
all.FindAll(m => m.dmtshxuid == om && m.IsSel).ForEach(m => m.Msg = Resource.CoreMessage.GetResource("DELIVERY_MAP_NOT_EXISTS"));
continue;
}
#endregion
#region 生成OrderSlave
List<OrderSlave> slaves = orderImportMgr.GetSlave(product, all);
//訂單內商品有問題（商品對照不存在，商品不存在，商品庫存不足）,跳過處理下筆訂單
if (slaves == null || slaves.Count == 0)
{
continue;
}
#endregion
#region OrderMaster
OrderMaster newMaster = new OrderMaster();
#region 其他信息
newMaster.Order_Status = 2;
//newMaster.Order_Id = uint.Parse(orderImportMgr.NextOrderId());
channelMgr = new ChannelMgr(MySqlConnStr);
newMaster.User_Id = Convert.ToUInt32(channelMgr.GetUserIdByChannelId(CurChannel.channel_id));
//備註
if (!string.IsNullOrEmpty(product.FirstOrDefault().xrem))
{
newMaster.Note_Order = "購買備註:" + product.FirstOrDefault().xrem;
}
if (!string.IsNullOrEmpty(product.FirstOrDefault().shipxrem))
{
newMaster.Note_Order = string.IsNullOrEmpty(newMaster.Note_Order) ? "配送備註:" + product.FirstOrDefault().shipxrem : newMaster.Note_Order + ",配送備註:" + product.FirstOrDefault().shipxrem;
}
string name = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_username;
newMaster.Note_Admin = name + " 於" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "建立";
if (!string.IsNullOrEmpty(product.FirstOrDefault().orddat))
{
newMaster.Order_Createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(product.FirstOrDefault().orddat));
}
else
{
newMaster.Order_Createdate = Convert.ToUInt32(CommonFunction.GetPHPTime());
}
newMaster.Order_Date_Pay = Convert.ToUInt32(CommonFunction.GetPHPTime());
newMaster.Import_Time = DateTime.Now;
newMaster.Channel = Convert.ToUInt32(CurChannel.channel_id);
newMaster.Channel_Order_Id = product.FirstOrDefault().dmtshxuid;
if (!string.IsNullOrEmpty(product.FirstOrDefault().agpesadrzip))
{
newMaster.Order_Zip = Convert.ToUInt32(product.FirstOrDefault().agpesadrzip);
}
#endregion
#region 发票状态
if (CurChannel.receipt_to != 2)
{
newMaster.Invoice_Status = 2;
}
#endregion
#region 物流方式
newMaster.Delivery_Store = Convert.ToUInt32(cShipping.shipping_carrior);
newMaster.Retrieve_Mode = Convert.ToUInt32(cShipping.retrieve_mode);
#endregion
#region 運費
var freight = product.Where(m => m.dsr.Contains("物流服務費")).FirstOrDefault();
if (freight != null && !string.IsNullOrEmpty(freight.sumup))
{
if (freight.chlitpdno == "6727_13743")//若廠商商品編號為"6727_13743"是低溫運費
{
newMaster.Order_Freight_Low = uint.Parse(freight.sumup);
}
else//若廠商商品編號為"6727_13742"是常溫運費
{
newMaster.Order_Freight_Normal = uint.Parse(freight.sumup);
}
}
#endregion
#region 訂單價格
product.Where(m => !m.dsr.Contains("物流服務費")).ToList().ForEach(m => newMaster.Order_Product_Subtotal += uint.Parse(string.IsNullOrEmpty(m.sumup) ? "0" : m.sumup));
product.ForEach(m => newMaster.Order_Amount += uint.Parse(string.IsNullOrEmpty(m.sumup) ? "0" : m.sumup));
#endregion
#region 支付方式
//若是外站類型為”合作外站”的，匯入訂單時的 payment = 15
newMaster.Order_Payment = 15;
//switch (product.FirstOrDefault().Payment)
//{
// case "信用卡一次":
// newMaster.Order_Payment = 1;
// break;
// case "7-11貨到付款":
// newMaster.Order_Payment = 15;
// break;
// default:
// newMaster.Order_Payment = 1;
// break;
//}
#endregion
#region 訂購人信息
newMaster.Order_Name = product.FirstOrDefault().ordpesnm;
newMaster.Order_Mobile = product.FirstOrDefault().ordpesnacttel.Replace("'", "");//去掉電話中的單引號
if (string.IsNullOrEmpty(newMaster.Order_Mobile))
{
newMaster.Order_Mobile = product.FirstOrDefault().agpesacttel.Replace("'", "");//去掉電話中的單引號
}
newMaster.Order_Address = product.FirstOrDefault().agpesadr;//order_address與delivery_address相同
#endregion
#region 發貨信息
newMaster.Delivery_Name = product.FirstOrDefault().agpesnm;
newMaster.Delivery_Mobile = product.FirstOrDefault().agpesacttel.Replace("'", "");//去掉電話中的單引號
newMaster.Delivery_Phone = product.FirstOrDefault().agpestel1.Replace("'", "");//去掉電話中的單引號
if (!string.IsNullOrEmpty(product.FirstOrDefault().agpesadrzip))
{
newMaster.Delivery_Zip = uint.Parse(product.FirstOrDefault().agpesadrzip);
}
newMaster.Delivery_Address = product.FirstOrDefault().agpesadr;
#endregion
#endregion
#region ChannelOrder
List<ChannelOrder> cOrder = new List<ChannelOrder>();
ChannelOrder channelOrder;
foreach (var slave in slaves)
{
foreach (var detail in slave.Details)
{
detail.Site_Id = siteId;//add xw 2014/02/03
//ChannelOrder
channelOrder = new ChannelOrder { Channel_Id = CurChannel.channel_id, Order_Id = newMaster.Channel_Order_Id.ToString() };
var p = product.Where(m => m.chlitpdno == detail.Channel_Detail_Id).FirstOrDefault();
if (p != null)
{
//if (importType == "2")
//{
// //channelOrder.Store_Dispatch_File = pdfFile;
//}
channelOrder.Dispatch_Seq = p.shipno;
channelOrder.Channel_Detail_Id = detail.Channel_Detail_Id;
if (!string.IsNullOrEmpty(p.orddat))
{
channelOrder.Createtime = Convert.ToDateTime(p.orddat);
}
channelOrder.Ordertime = channelOrder.Createtime;
if (!string.IsNullOrEmpty(p.prndldat))
{
channelOrder.Latest_Deliver_Date = Convert.ToDateTime(p.prndldat);
}
cOrder.Add(channelOrder);
}
}
}
#endregion
#region 寫入數據庫
if (orderImportMgr.Save2DB(newMaster, slaves, cOrder, all))
{
all.FindAll(m => m.dmtshxuid == om && m.IsSel).ForEach(m => m.Msg = Resource.CoreMessage.GetResource("IMPORT_SUCCESS"));
successCount++;
}
#endregion
}
}
}
catch (Exception ex)
{
throw new Exception("OrderImportPayEasy-->Import2DB-->" + ex.Message, ex);
}
return successCount;
}
public HttpResponseBase GetChannel()/*賣場列表*/
{
_channel = new ChannelMgr(mySqlConnectionString);
List<Channel> stores = new List<Channel>();
string json = string.Empty;
try
{
stores = _channel.QueryList();
//Channel channel = new Channel();
//channel.channel_name_simple = "全部";
//stores.Insert(0, channel);
json = "{success:true,data:" + JsonConvert.SerializeObject(stores) + "}";//返回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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public string Query()
{
ch.Replace4MySQL();
chMgr = new ChannelMgr(connectString);
string json = string.Empty;
string strSel = string.Empty;
int startPage = Convert.ToInt32(Request.Form["start"] ?? "0");
int endPage = Convert.ToInt32(Request.Form["limit"] ?? "20");
try
{
if (!string.IsNullOrEmpty(Request.Form["txtSel"]))
{
if (Request.Form["ddlSel"].ToString() == "full")
{
ch.channel_name_full = Request.Form["txtSel"].Trim();
strSel += " and channel_name_full like '%" + ch.channel_name_full + "%'";
}
else if (Request.Form["ddlSel"].ToString() == "simple")
{
ch.channel_name_simple = Request.Form["txtSel"].Trim();
strSel += " and channel_name_simple like '%" + ch.channel_name_simple + "%'";
}
}
if (!string.IsNullOrEmpty(Request.Form["cobStatus"]))
{
if (Request.Form["cobStatus"].ToString() != "0")
{
ch.channel_status = Int32.Parse(Request.Form["cobStatus"].ToString());
strSel += " and channel_status = '" + ch.channel_status + "'";
}
}
json = chMgr.DataPager(strSel,startPage,endPage);
}
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 SaveChannelOther()
{
chMgr = new ChannelMgr(connectString);
string json = string.Empty;
int num = 0;
try
{
if (!string.IsNullOrEmpty(Request.Form["channel_id"]))
{
ch.channel_id =Int32.Parse(Request.Form["channel_id"]);
}
if (!string.IsNullOrEmpty(Request.Form["deal_method"]))
{
ch.deal_method = Int32.Parse(Request.Form["deal_method"].ToString());
if (Request.Form["deal_method"].ToString() == "2")
{
ch.deal_percent = float.Parse(Request.Form["deal_percent"].ToString());
ch.deal_fee = 0;
}
else if (Request.Form["deal_method"].ToString() == "3")
{
ch.deal_percent = 0;
ch.deal_fee = Int32.Parse(Request.Form["deal_fee"].ToString());
}
else
{
ch.deal_percent = 0;
ch.deal_fee = 0;
}
}
else
{
ch.deal_method = 0;
ch.deal_percent = 0;
ch.deal_fee = 0;
}
if (!string.IsNullOrEmpty(Request.Form["creditcard_1_percent"]))
{
ch.creditcard_1_percent = float.Parse(Request.Form["creditcard_1_percent"].ToString());
}
else
{
ch.creditcard_1_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["creditcard_3_percent"]))
{
ch.creditcard_3_percent = float.Parse(Request.Form["creditcard_3_percent"].ToString());
}
else
{
ch.creditcard_3_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["shopping_car_percent"]))
{
ch.shopping_car_percent = float.Parse(Request.Form["shopping_car_percent"].ToString());
}
else
{
ch.shopping_car_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["commission_percent"]))
{
ch.commission_percent = float.Parse(Request.Form["commission_percent"].ToString());
}
else
{
ch.commission_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["cost_by_percent"]))
{
ch.cost_by_percent = Int32.Parse(Request.Form["cost_by_percent"].ToString());
}
else
{
ch.cost_by_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["cost_low_percent"]))
{
ch.cost_low_percent = float.Parse(Request.Form["cost_low_percent"].ToString());
}
else
{
ch.cost_low_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["cost_normal_percent"]))
{
ch.cost_normal_percent = float.Parse(Request.Form["cost_normal_percent"].ToString());
}
else
{
ch.cost_normal_percent = 0;
}
if (!string.IsNullOrEmpty(Request.Form["invoice_checkout_day"]))
{
ch.invoice_checkout_day = Int32.Parse(Request.Form["invoice_checkout_day"].ToString());
}
else
{
ch.invoice_checkout_day = 0;
}
if (!string.IsNullOrEmpty(Request.Form["invoice_apply_start"]))
{
ch.invoice_apply_start = Int32.Parse(Request.Form["invoice_apply_start"].ToString());
}
else
{
ch.invoice_apply_start = 0;
}
if (!string.IsNullOrEmpty(Request.Form["invoice_apply_end"]))
{
ch.invoice_apply_end = Int32.Parse(Request.Form["invoice_apply_end"].ToString());
}
else
{
ch.invoice_apply_end = 0;
}
if (!string.IsNullOrEmpty(Request.Form["checkout_note"]))
{
ch.checkout_note = Request.Form["checkout_note"].ToString();
}
else
{
ch.checkout_note = "";
}
if (!string.IsNullOrEmpty(Request.Form["receipt_to"]))
{
ch.receipt_to = Int32.Parse(Request.Form["receipt_to"].ToString());
}
else
{
ch.receipt_to = 0;
}
if (!string.IsNullOrEmpty(Request.Form["channel_manager"]))
{
ch.channel_manager = Request.Form["channel_manager"].ToString();
}
else
{
ch.channel_manager = "";
}
if (!string.IsNullOrEmpty(Request.Form["channel_note"]))
{
ch.channel_note = Request.Form["channel_note"].ToString();
}
else
{
ch.channel_note = "";
}
num = chMgr.SaveOther(ch);
if (num > 0)
{
json = "{success:true,msg:\"" + Resources.Channel.SUCCESS + "。\",channelId:" + num.ToString() + "}";
}
else
{
json = "{success:true,msg:\"" + Resources.Channel.FAILED + "\"}";
}
}
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 + "\"}";
}
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 string QueryOther()
{
chMgr = new ChannelMgr(connectString);
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Form["channel_id"]))
{
json = chMgr.QueryOther(Int32.Parse(Request.Form["channel_id"].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;
}
