public void OrderSerchExport()
{
List<OrderMasterQuery> stores = new List<OrderMasterQuery>();
OrderMasterQuery query = new OrderMasterQuery();
int id; uint uid; DateTime dtime;
#region 查詢條件
if (int.TryParse(Request.Params["Vip_User_Group"].ToString(), out id))//會員群組
{
query.group_id = id;
}
if (int.TryParse(Request.Params["invoice"].ToString(), out id))//過濾已開發票
{
query.invoice = id;
}
if (uint.TryParse(Request.Params["channel"].ToString(), out uid))//賣場
{
query.Channel = uid;
}
if (int.TryParse(Request.Params["order_pay"].ToString(), out id))//付款狀態
{
query.pay_status = id;
}
if (!string.IsNullOrEmpty(Request.Params["selecttype"]))//查詢種類，訂單編號，訂購姓名
{
query.selecttype = Request.Params["selecttype"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["searchcon"]))//查詢內容
{
query.searchcon = Request.Params["searchcon"].ToString();
}
if (int.TryParse(Request.Params["timeone"].ToString(), out id))//時間類型
{
query.dateType = id;
}
if (DateTime.TryParse(Request.Params["dateOne"].ToString(), out dtime))//開始時間
{
query.datestart = dtime;
}
if (DateTime.TryParse(Request.Params["dateTwo"].ToString(), out dtime))
{
query.dateend = dtime;
}
if (int.TryParse(Request.Params["page_status"].ToString(), out id))//付款單狀態
{
query.orderStatus = Request.Params["page_status"];
}
if (uint.TryParse(Request.Params["order_payment"], out uid))//付款方式，AT
{
query.Order_Payment = uid;
}
#endregion
string json = string.Empty;
DataTable dtHZ = new DataTable();
DataTable dt_payment = new DataTable();
DataTable dt_status = new DataTable();
dt_payment = GetTP("payment");
dt_status = GetTP("order_status");
string newExcelName = string.Empty;
dtHZ.Columns.Add("付款單號", typeof(String));
dtHZ.Columns.Add("訂單人", typeof(String));
dtHZ.Columns.Add("收貨人", typeof(String));
dtHZ.Columns.Add("訂單應收金額", typeof(String));
dtHZ.Columns.Add("付款方式", typeof(String));
dtHZ.Columns.Add("付款單狀態", typeof(String));
dtHZ.Columns.Add("付款單成立日期", typeof(String));
dtHZ.Columns.Add("購物金抵用金額", typeof(String));
dtHZ.Columns.Add("抵用券抵用金額", typeof(String));
dtHZ.Columns.Add("HG抵用金額", typeof(String));
dtHZ.Columns.Add("常溫運費", typeof(String));
dtHZ.Columns.Add("低溫運費", typeof(String));
dtHZ.Columns.Add("付款時間", typeof(String));
dtHZ.Columns.Add("銀行紅利折抵", typeof(String));
dtHZ.Columns.Add("取消金額", typeof(String));
dtHZ.Columns.Add("退貨金額", typeof(String));
dtHZ.Columns.Add("來源群組", typeof(String));
dtHZ.Columns.Add("來源", typeof(String));
dtHZ.Columns.Add("UTM_CODE", typeof(String));
dtHZ.Columns.Add("UTM_NAME", typeof(String));
dtHZ.Columns.Add("訂購人編號", typeof(String));
//dtHZ.Columns.Add("訂購人手機", typeof(String));
dtHZ.Columns.Add("虛擬帳號", typeof(String));
dtHZ.Columns.Add("賣場", typeof(String));
dtHZ.Columns.Add("外站訂單編號", typeof(String));
dtHZ.Columns.Add("管理員備註", typeof(String));
try
{
int totalCount = 0;
_ordermaster = new OrderMasterMgr(mySqlConnectionString);
stores = _ordermaster.Export(query, "", out totalCount);
foreach (var item in stores)
{
DataRow dr = dtHZ.NewRow();
dr[0] = item.Order_Id;
dr[1] = item.Order_Name;
dr[2] = item.Delivery_Name;
dr[3] = item.Order_Amount;
dr[4] = item.Order_Payment;
dr[5] = item.Order_Status;
if (item.Order_Payment > 0)
{//帶出付款方式的參數
DataRow[] drs = dt_payment.Select("ParameterCode = '" + item.Order_Payment.ToString() + "'");
DataTable _newdt = dt_payment.Clone();
foreach (DataRow i in drs)
{
_newdt.Rows.Add(i.ItemArray);
}
dr[4] = _newdt.Rows[0]["ParameterName"].ToString();
}
if (item.Order_Status >= 0)
{//帶出付款方式的參數
DataRow[] drs = dt_status.Select("ParameterCode = '" + item.Order_Status.ToString() + "'");
DataTable _newdt = dt_status.Clone();
foreach (DataRow i in drs)
{
_newdt.Rows.Add(i.ItemArray);
}
dr[5] = _newdt.Rows[0]["remark"].ToString();
}
dr[6] = item.Order_Createdate == 0 ? "" : CommonFunction.GetNetTime(item.Order_Createdate).ToString();
dr[7] = item.Deduct_Bonus;
dr[8] = item.Deduct_Welfare;
dr[9] = item.Deduct_Happygo == 0 ? 0 : Math.Round(item.Deduct_Happygo*item.deduct_happygo_convert);
dr[10] = item.Order_Freight_Normal;
dr[11] = item.Order_Freight_Low;
dr[12] = item.Order_Date_Pay == 0 ? "未付款" : CommonFunction.GetNetTime(item.Order_Date_Pay).ToString();
dr[13] = item.Deduct_Card_Bonus;
dr[14] = item.Money_Cancel;
dr[15] = item.Money_Return;
dr[16] = item.group_name;
dr[17] = item.redirect_name;
dr[18] = item.utm_id;
dr[19] = item.utm_source;
dr[20] = item.User_Id;
//dr[21] = " "+ item.Order_Mobile;
dr[21] = " " + item.hncb_id;
dr[22] = item.channel_name_full;
dr[23] = item.Channel_Order_Id;
dr[24] = item.Note_Admin;
dtHZ.Rows.Add(dr);
}
if (stores.Count > 0)
{
string fileName = "訂單查詢匯出_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
MemoryStream ms = ExcelHelperXhf.ExportDT(dtHZ, "");
Response.AddHeader("Content-Disposition", "attach-ment;filename=" + fileName);
Response.BinaryWrite(ms.ToArray());
}
else
{
Response.Write("匯出數據不存在");
}
}
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 = "false, ";
}
}
public HttpResponseBase OrderMasterChangeStatusFromPayToDel()
{
string json = json = "{success:true,data:''}"; ;
OrderModifyModel orderModifyModel = new OrderModifyModel();
try
{
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
orderModifyModel.order_id = Convert.ToInt32(Request.Params["order_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["deduct_card_bonus"]))
{
orderModifyModel.deduct_card_bonus = Convert.ToInt32(Request.Params["deduct_card_bonus"]);
}
if (!string.IsNullOrEmpty(Request.Params["isBilling_checked"]))
{
orderModifyModel.isBilling_checked = Convert.ToBoolean(Request.Params["isBilling_checked"]);
}
if (!string.IsNullOrEmpty(Request.Params["isHGBonus"]))
{
orderModifyModel.isHGBonus = Convert.ToBoolean(Request.Params["isHGBonus"]);
}
if (!string.IsNullOrEmpty(Request.Params["isCash_record_bonus"]))
{
orderModifyModel.isCash_record_bonus = Convert.ToBoolean(Request.Params["isCash_record_bonus"]);
}
OrderMasterMgr orderMasterMgr = new OrderMasterMgr(connectionString);
orderModifyModel.ip_from = CommonFunction.GetIP4Address(Request.UserHostAddress);
//如果不可以轉單，則返回不可以
if (!orderMasterMgr.ModifyOrderMsaterForDeliver(orderModifyModel))
{
json = "{success:false,data:'此訂單不可轉出貨單'}";
}
else
{
try
{
orderMasterMgr.ModifyOrderMsaterForDeliver(orderModifyModel);
json = "{success:true,data:'恭喜！轉單成功'}";
}
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:'轉單失敗！'}";
}
}
}
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 GetOrderList()
{
List<OrderMasterQuery> stores = new List<OrderMasterQuery>();
string json = string.Empty;
try
{
StringBuilder sb = new StringBuilder();
OrderMasterQuery query = new OrderMasterQuery();
DataTable dt_payment = new DataTable();
DataTable dt_status = new DataTable();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量
string addSerch = string.Empty;//追加一張表的查詢
int id; uint uid; DateTime dtime;
#region 查詢條件
if (int.TryParse(Request.Params["Vip_User_Group"].ToString(), out id))//會員群組
{
query.group_id = id;
}
if (int.TryParse(Request.Params["invoice"].ToString() ,out id ))//過濾已開發票
{
query.invoice=id;
}
if (uint.TryParse(Request.Params["channel"].ToString(),out uid))//賣場
{
query.Channel = uid;
}
if (int.TryParse(Request.Params["order_pay"].ToString(), out id))//付款狀態
{
query.pay_status = id;
}
if (!string.IsNullOrEmpty(Request.Params["selecttype"]))//查詢種類，訂單編號，訂購姓名
{
query.selecttype = Request.Params["selecttype"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["searchcon"]))//查詢內容
{
query.searchcon = Request.Params["searchcon"].ToString();
}
if (int.TryParse(Request.Params["timeone"].ToString(),out id))//時間類型
{
query.dateType = id;
}
if (DateTime.TryParse(Request.Params["dateOne"].ToString(), out dtime))//開始時間
{
query.datestart = dtime;
}
if (DateTime.TryParse(Request.Params["dateTwo"].ToString(), out dtime))
{
query.dateend = dtime;
}
if (int.TryParse(Request.Params["page_status"].ToString(),out id))//付款單狀態
{
query.orderStatus = Request.Params["page_status"];
}
if (uint.TryParse(Request.Params["order_payment"], out uid))//付款方式，AT
{
query.Order_Payment = uid;
}
#endregion
_ordermaster = new OrderMasterMgr(mySqlConnectionString);
int totalCount = 0;
stores = _ordermaster.getOrderSearch(query, sb.ToString(), out totalCount, addSerch);
dt_payment = GetTP("payment");
dt_status = GetTP("order_status");
foreach (var item in stores)
{
if (item.source_trace != 0)
{
item.redirect_name = "【" + item.source_trace + "】" + item.redirect_name;
}
string message = string.Empty;
//獲取時間
item.suser_reg_date = CommonFunction.GetNetTime(item.user_reg_date);
item.ordercreatedate = CommonFunction.GetNetTime(item.Order_Createdate);
if (item.Deduct_Bonus != 0)
{
message = "購物金使用:" + item.Deduct_Bonus;
}
if (item.Deduct_Welfare != 0)
{
message = "抵用劵使用:" + item.Deduct_Welfare;
}
if (item.Deduct_Happygo != 0)
{
message = "HG使用:" + item.Deduct_Happygo + "點/" + Math.Round(Convert.ToDecimal(item.Deduct_Happygo * item.deduct_happygo_convert)) + "元";//deduct_happygo_convert
}
item.order_pay_message = message;
if (item.Order_Payment >0)
{//帶出付款方式的參數
DataRow[] dr = dt_payment.Select("ParameterCode = '" + item.Order_Payment.ToString() + "'");
DataTable _newdt = dt_payment.Clone();
foreach (DataRow i in dr)
{
_newdt.Rows.Add(i.ItemArray);
}
item.payment = _newdt.Rows[0]["ParameterName"].ToString();
}
if (item.Order_Status >=0)
{//帶出付款方式的參數
DataRow[] dr = dt_status.Select("ParameterCode = '" + item.Order_Status.ToString() + "'");
DataTable _newdt = dt_status.Clone();
foreach (DataRow i in dr)
{
_newdt.Rows.Add(i.ItemArray);
}
item.orderStatus = _newdt.Rows[0]["remark"].ToString();
}
switch (item.Export_Flag)
{
case 0:
item.export_flag_str = "-";
break;
case 1:
item.export_flag_str = "待拋轉";
break;
case 2:
item.export_flag_str = "異動";
break;
case 3:
item.export_flag_str = "整筆取消";
break;
default:
item.export_flag_str = "已拋轉";
break;
}
}
#region 注釋 給訂單加上超鏈接/判斷購物金和抵用卷
//for (int i = 0; i < stores.Count; i++)
//{
//string message = string.Empty;
//DataRow[] rows = dt.Select("redirect_id=" + stores[i].Source_Trace);//篩選出訂單下的來源ID和url
//foreach (DataRow row in rows)//篩選出的最多只有一條數據，如果有，加入某個品牌的每日營業額，沒有就為初始值
//{
// if (!string.IsNullOrEmpty(row["redirect_id"].ToString()))
// {
// stores[i].ordercreatedate = CommonFunction.GetNetTime(stores[i].Order_Createdate);
// stores[i].redirect_name = row["redirect_name"].ToString();
// stores[i].redirect_url = row["redirect_url"].ToString();
// }
//}
//stores[i].ordercreatedate = CommonFunction.GetNetTime(stores[i].Order_Createdate);
//if (stores[i].Deduct_Bonus != 0)
//{
// message = "購物金使用:" + stores[i].Deduct_Bonus;
//}
//if (stores[i].Deduct_Welfare != 0)
//{
// message = "抵用卷使用使用:" + stores[i].Deduct_Welfare;
//}
//if (stores[i].Deduct_Happygo != 0)
//{
// message = "HG使用:" + stores[i].Deduct_Happygo + "點/" + Math.Round(Convert.ToDecimal(stores[i].Deduct_Happygo * stores[i].Deduct_Happygo_Convert)) + "元";
//}
//stores[i].order_pay_message = message;
//}
#endregion
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,'msg':'user',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:true,totalCount:0,data:[]}";
}
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;
}