public HttpResponseBase CancelReturnPurchaes()
{
string json = string.Empty;
try
{
OrderReturnMasterQuery query = new OrderReturnMasterQuery();
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
query.order_id = Convert.ToUInt32(Request.Params["order_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["return_id"]))
{
query.return_id = Convert.ToUInt32(Request.Params["return_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["return_status"]))
{
query.return_status = Convert.ToUInt32(Request.Params["return_status"]);
}
query.return_ipfrom = CommonFunction.GetIP4Address(Request.UserHostAddress.ToString());
_orderReturnMaster=new OrderReturnMasterMgr (mySqlConnectionString);
json= _orderReturnMaster.CancelReturnPurchaes(query);
}
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 SaveOrderReturnMaster()
{
string json = string.Empty;
try
{
_orderReturnMaster = new OrderReturnMasterMgr(mySqlConnectionString);
OrderReturnMasterQuery query = new OrderReturnMasterQuery();
string return_status = string.Empty;
query.return_id = uint.Parse(Request.Params["return_id"]);
query.order_id = uint.Parse(Request.Params["order_id"]);
if (!string.IsNullOrEmpty(Request.Params["return_note"]))
{
query.return_note = Request.Params["return_note"];
if (!string.IsNullOrEmpty(Request.Params["invoice_deal"]))
{
query.invoice_deal = uint.Parse(Request.Params["invoice_deal"]);
}
if (!string.IsNullOrEmpty(Request.Params["return_deal"]))
{
query.package = uint.Parse(Request.Params["return_deal"]);
}
if (!string.IsNullOrEmpty(Request.Params["return_zip"]))
{
query.return_zip = uint.Parse(Request.Params["return_zip"]);
}
if (!string.IsNullOrEmpty(Request.Params["return_address"]))
{
query.return_address = Request.Params["return_address"];
}
if (!string.IsNullOrEmpty(Request.Params["deliver_code"]))
{
query.deliver_code = Request.Params["deliver_code"];
}
if (!string.IsNullOrEmpty(Request.Params["return_status"]))
{
query.return_status = uint.Parse(Request.Params["return_status"]);
}
if (!string.IsNullOrEmpty(Request.Params["bank_note"]))
{
query.bank_note = Request.Params["bank_note"];
}
query.return_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString()));
query.return_ipfrom = Dns.GetHostByName(Dns.GetHostName()).AddressList.FirstOrDefault().ToString();
if (!string.IsNullOrEmpty(Request.Params["bank_name"]))
{
query.bank_name = Request.Params["bank_name"];
}
if (!string.IsNullOrEmpty(Request.Params["bank_branch"]))
{
query.bank_branch = Request.Params["bank_branch"];
}
if (!string.IsNullOrEmpty(Request.Params["bank_account"]))
{
query.bank_account = Request.Params["bank_account"];
}
if (!string.IsNullOrEmpty(Request.Params["account_name"]))
{
query.account_name = Request.Params["account_name"];
}
query.user_id = (Session["caller"] as Caller).user_id.ToString();
query.user_username = (Session["caller"] as Caller).user_username.ToString();
query.HgReturnUrl = HgReturnUrl;
query.HgMerchandID = HgMerchandID;
query.HgTeminalID = HgTeminalID;
query.HgCategoty = HgCategoty;
query.HgWallet = HgWallet;
if (_orderReturnMaster.Save(query) > 0)
{
json = "{success:'true'}";
}
else
{
json = "{success:'false'}";
}
}
}
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 GetOrderReturnMasterList()
{
string json = string.Empty;
try
{
int totalCount = 0;
OrderReturnMasterQuery query = new OrderReturnMasterQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//
if (!string.IsNullOrEmpty(Request.Params["ven_type"]))
{
query.ven_type = Convert.ToInt32(Request.Params["ven_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["search_content"]))
{
query.content = Request.Params["search_content"];
}
if (!string.IsNullOrEmpty(Request.Params["date_type"]))
{
query.date_type = Convert.ToInt32(Request.Params["date_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["time_start"]))
{
query.time_start = Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy-MM-dd HH:mm:ss"); }
if (!string.IsNullOrEmpty(Request.Params["time_end"]))
{
query.time_end = Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy-MM-dd HH:mm:ss"); }
if (!string.IsNullOrEmpty(Request.Params["return_status"]))
{
query.return_status = Convert.ToUInt32(Request.Params["return_status"]);
}
_orderReturnMaster = new OrderReturnMasterMgr(mySqlConnectionString);
List<OrderReturnMasterQuery> stores = _orderReturnMaster.GetReturnMaster(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, 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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public string GetPayment()
{
_orderMasterMgr = new OrderMasterMgr(mySqlConnectionString);
_orderReturnMaster = new OrderReturnMasterMgr(mySqlConnectionString);
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Params["order_id"]))
{
OrderMaster om = _orderMasterMgr.GetPaymentById(uint.Parse(Request.Params["order_id"]));
//獲取暫存單中atm機 銀行信息 地址信息
if (om.Order_Payment == 2)
{
OrderReturnUserQuery oruQuery = _orderReturnMaster.GetReturnDetailById(om.Order_Id);
json = "{success:true,bank_name:" + oruQuery.bank_name + ",bank_branch:" + oruQuery.bank_branch
+ ",bank_account:" + oruQuery.bank_account + ",account_name:" + oruQuery.account_name + "}";
}
else
{
json = "{success:true,order_id:" + om.Order_Id + ",Order_Payment:" + om.Order_Payment + "}";
}
}
}
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 OrderReturn()
{
List<OrderReturnMasterQuery> stores = new List<OrderReturnMasterQuery>();
OrderReturnMasterQuery query = new OrderReturnMasterQuery();
_orderReturnMaster=new OrderReturnMasterMgr(mySqlConnectionString);
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.Params["detail_id"]))
{
query.detailId = Request.Params["detail_id"].ToString();
}
if (query.detailId.Length > 0)
{
query.detailId = query.detailId.Substring(0, query.detailId.Length - 1);
}
System.Net.IPAddress[] addlist = Dns.GetHostByName(Dns.GetHostName()).AddressList;
query.return_ipfrom = addlist[0].ToString();
json = _orderReturnMaster.OrderReturn(query);// "{success:true}";//返回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:flase}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}