protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string openid = Request.QueryString["openid"];
string total_fee = Request.QueryString["total_fee"];
order_id = Request.QueryString["order_id"];
string ActualPay = ConfigurationManager.AppSettings["ActualPay"].ToString();
OrderPay = new Entity.Order();
DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
if (orderDS.Tables.Count == 2)
{
if (orderDS.Tables[0].Rows[0]["status"].ToString() != "NotPaid")
{
return;
}
OrderPay.fruittype = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
OrderPay.startdate = orderDS.Tables[0].Rows[0]["startdate"].ToString();
OrderPay.enddate = orderDS.Tables[0].Rows[0]["enddate"].ToString();
OrderPay.days = orderDS.Tables[0].Rows[0]["days"].ToString();
OrderPay.count = orderDS.Tables[0].Rows[0]["count"].ToString();
OrderPay.deliveryaddr = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
OrderPay.user = orderDS.Tables[0].Rows[0]["user"].ToString();
OrderPay.mp = orderDS.Tables[0].Rows[0]["mp"].ToString();
OrderPay.totalprice = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
OrderPay.outtradeno = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
OrderPay.createdate = orderDS.Tables[0].Rows[0]["createdate"].ToString();
OrderPay.unitprice = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
OrderPay.deduction = orderDS.Tables[0].Rows[0]["deduction"].ToString();
OrderPay.actualprice = orderDS.Tables[0].Rows[0]["actualprice"].ToString();
for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
{
if (OrderPay.fruittype.Contains("社区预定"))
//{
// Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
//}
//else
{
Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
+ (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
+ orderDS.Tables[1].Rows[i]["unit"] + ";";
divunit.Visible = false;
divdelivery.Visible = false;
}
}
}
else
{
return;
}
//return;
//检测是否给当前页面传递了相关参数
if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(total_fee) || string.IsNullOrEmpty(order_id))
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面传参出错,请返回重试" + "</span>");
Log.Error(this.GetType().ToString(), "This page have not get params, cannot be inited, exit...");
//submit.Visible = false;
return;
}
//若传递了相关参数，则调统一下单接口，获得后续相关接口的入口参数
JsApiPay jsApiPay = new JsApiPay(this);
jsApiPay.openid = openid;
try
{
if (Convert.ToBoolean(ActualPay))
{
jsApiPay.total_fee = int.Parse(total_fee);
}
else
{
jsApiPay.total_fee = 1;
}
}
catch (Exception ex)
{
Response.Write(ex.Message + ex.StackTrace);
}
//jsApiPay.total_fee = 1;
//JSAPI支付预处理
WxPayData unifiedOrderResult = new WxPayData();
try
{
unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(OrderPay.outtradeno);
wxJsApiParam = jsApiPay.GetJsApiParameters();//获取H5调起JS API参数
Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
//在页面上显示订单信息
//Response.Write("<span style='color:#00CD00;font-size:20px'>订单详情：</span><br/>");
//Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px;margin-left:10px'>" + "初始化失败，无法支付，请返回重试。" + "</span>");
//Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
//Response.Write("wxJsApiParam : " + wxJsApiParam);
divbutton.Visible = false;
}
}
}
public JsonResult UploadByAjax()
{
var allinsertsql = "";
var JsonString = "";
try
{
//取得目前 HTTP 要求的 HttpRequestBase 物件
foreach (string file in Request.Files)
{
var fileContent = Request.Files[file];
if (fileContent != null && fileContent.ContentLength > 0)
{
// 取得的檔案是stream
var stream = fileContent.InputStream;
var fileName = Path.GetFileName(file);
var path = Path.Combine(Request.MapPath("~/SaveFile"), fileName);
using (var fileStream = System.IO.File.Create(path))
{
stream.CopyTo(fileStream);
}
ExcelHelper excel_helper = new ExcelHelper(path);
DataTable dt = excel_helper.ExcelToDataTable("", true);
JsonString = "dt completed";
//List<string> tableList = GetColumnsByDataTable(dt);
foreach (DataRow dr in dt.Rows)
{
string insertSql = @"
insert into t_orders(ImportName,ProductName,Number,Spec,Price,OrderID,OrderDetailID,OrderDate,CustomerName,CellNumber,Province,City,District,Address)
values ("
+ "'" + fileName + "',"
+ "'" + dr[1].ToString() + "',"
+ "'" + dr[2].ToString() + "',"
+ "'" + dr[3].ToString() + "',"
+ "'" + dr[4].ToString() + "',"
+ "'" + dr[5].ToString() + "',"
+ "'" + dr[6].ToString() + "',"
+ "'" + dr[7].ToString() + "',"
+ "'" + dr[8].ToString() + "',"
+ "'" + dr[9].ToString() + "',"
+ "'" + dr[10].ToString() + "',"
+ "'" + dr[11].ToString() + "',"
+ "'" + dr[12].ToString() + "',"
+ "'" + dr[13].ToString() + "');";
allinsertsql += insertSql;
}
allinsertsql = "delete from t_orders where ImportName='" + fileName + "';" + allinsertsql;
JsonString = "allinsertsql completed" + allinsertsql;
MySqlHelp.ExecuteNonQuery(allinsertsql);
string selectsql = @"set @rowno := 0;select @rowno:=@rowno + 1 AS rowno,a.* from (
select CustomerName,CellNumber,
GROUP_CONCAT(CONCAT(ProductName,Spec, CAST(Number AS char),'份',CHAR(10) )) as 'Product',
CONCAT(Province,City,District,Address ) as 'Address'
from t_orders
where ImportName='" + fileName + @"'
GROUP BY CustomerName,CellNumber,Address
) a ,(SELECT @rowno:=0) b;
select ProductName,Spec,SUM(Number) as 'SUM'
from t_orders
where ImportName='" + fileName + @"'
GROUP BY ProductName,Spec
";
JsonString = "selectsql completed" + selectsql;
DataSet sdt = MySqlHelp.ExecuteDataSet(selectsql);
JsonString = DataTableToJsonWithJsonNet(sdt);
}
}
return(Json(JsonString));
}
catch (Exception ex)
{
return(Json(ex.Message + JsonString));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
canRefund = false;
order_id = Request.QueryString["order_id"];
OrderPay = new Entity.Order();
DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
if (orderDS.Tables.Count == 2)
{
OrderPay.openid = orderDS.Tables[0].Rows[0]["openid"].ToString();
OrderPay.fruittype = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
OrderPay.startdate = orderDS.Tables[0].Rows[0]["startdate"].ToString();
OrderPay.enddate = orderDS.Tables[0].Rows[0]["enddate"].ToString();
OrderPay.days = orderDS.Tables[0].Rows[0]["days"].ToString();
OrderPay.count = orderDS.Tables[0].Rows[0]["count"].ToString();
OrderPay.deliveryaddr = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
OrderPay.user = orderDS.Tables[0].Rows[0]["user"].ToString();
OrderPay.mp = orderDS.Tables[0].Rows[0]["mp"].ToString();
OrderPay.totalprice = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
OrderPay.outtradeno = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
OrderPay.createdate = orderDS.Tables[0].Rows[0]["createdate"].ToString();
OrderPay.unitprice = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
OrderPay.deliverystatus = orderDS.Tables[0].Rows[0]["deliverystatus"].ToString();
OrderPay.otheraddr = orderDS.Tables[0].Rows[0]["otheraddr"].ToString();
OrderPay.deduction = orderDS.Tables[0].Rows[0]["deduction"].ToString();
OrderPay.actualprice = orderDS.Tables[0].Rows[0]["actualprice"].ToString();
OrderPay.ExpressNumber = orderDS.Tables[0].Rows[0]["ExpressNumber"].ToString();
switch (orderDS.Tables[0].Rows[0]["status"].ToString())
{
case "NotPaid":
OrderPay.status = "未支付";
break;
case "PaidSuccessed":
OrderPay.status = "已支付";
if (DateTime.Compare(DateTime.Now, Convert.ToDateTime(OrderPay.startdate)) < 0)
{
canRefund = true;
}
break;
case "Completed":
OrderPay.status = "已完成";
break;
case "Canceled":
OrderPay.status = "已取消";
break;
case "Expiry":
OrderPay.status = "已过期";
break;
case "Refunded":
OrderPay.status = "已退款";
break;
default:
break;
}
for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
{
if (OrderPay.fruittype.Contains("社区预定"))
//{
// Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
//}
//else
{
Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
+ (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
+ orderDS.Tables[1].Rows[i]["unit"] + ";";
divunit.Visible = false;
divdelivery.Visible = false;
divdeliverystatus.Visible = true;
}
}
}
}
}
