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; } } } } }