protected void btnSave_Click(object sender, ImageClickEventArgs e) { if (this.txtTitle.Value == "") { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('请输入用户组名称');</script>"); return; } StarTech.DBUtility.AdoHelper ado = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); if (this.id == "") { string sql = "insert into IACenter_Group(groupName) values('" + this.txtTitle.Value.Trim() + "');select @@IDENTITY"; object obj = ado.ExecuteSqlScalar(sql); if (obj != null) { int groupId = Int32.Parse(obj.ToString()); AddUserToGroup(groupId, this.SelectPanel1.Value); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); } } else { string sql = "update IACenter_Group set groupName='" + this.txtTitle.Value.Trim() + "' where uniqueId=" + this.id + ""; if (ado.ExecuteSqlNonQuery(sql) > 0) { AddUserToGroup(Int32.Parse(this.id), this.SelectPanel1.Value); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } }
protected decimal GetMoeny(string out_trade_no) { //return 1; StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); object objMoney = adoHelper.ExecuteSqlScalar(" select top 1 OrderAllMoney from T_Order_Info where OrderId='" + out_trade_no + "'"); if (objMoney != null) { return(decimal.Parse(objMoney.ToString())); } return(0); }
protected void GetMember(string memberID) { string strSQL = "select * from T_Member_Info where memberid='" + memberID + "';"; DataSet ds = adoHelper.ExecuteSqlDataset(strSQL); if (ds != null && ds.Tables.Count > 0) { lbMemberId.Text = ds.Tables[0].Rows[0]["MemberId"].ToString(); lbMemberName.Text = ds.Tables[0].Rows[0]["MemberName"].ToString(); lbTrueName.Text = ds.Tables[0].Rows[0]["TrueName"].ToString(); lbEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString(); lbTel.Text = ds.Tables[0].Rows[0]["Mobile"].ToString(); lbQQ.Text = ds.Tables[0].Rows[0]["QQ"].ToString(); lbSex.Text = ds.Tables[0].Rows[0]["Sex"].ToString(); lbAddress.Text = ds.Tables[0].Rows[0]["AddressCode"].ToString() + " " + ds.Tables[0].Rows[0]["AddressDetail"].ToString() + " " + ds.Tables[0].Rows[0]["PostCode"].ToString(); lbBirthDay.Text = ds.Tables[0].Rows[0]["BirthDay"].ToString().Replace("0:00:00", ""); lbRegisterTime.Text = ds.Tables[0].Rows[0]["RegisterTiem"].ToString(); lbLastLoginTime.Text = ds.Tables[0].Rows[0]["LastLoginTime"].ToString(); lbHeadImg.Text = "<img src='" + ds.Tables[0].Rows[0]["HeadImg"].ToString() + "' width='100px' height='100px'/>"; lbIsUse.Text = ds.Tables[0].Rows[0]["IsUse"].ToString() == "1" ? "<span style='color:Green'>启用</span>" : "<span style='color:Red'>禁用</span>"; //kxm@20160610 lbPersonIDCode.Text = ds.Tables[0].Rows[0]["PersonIDCode"].ToString(); ltPersonIDCodePhoto.Text = ListPics2(memberID); lbSpecialty.Text = ds.Tables[0].Rows[0]["Specialty"].ToString(); lbSkill.Text = ds.Tables[0].Rows[0]["Skill"].ToString(); lbSelfIntroduction.Text = ds.Tables[0].Rows[0]["SelfIntroduction"].ToString(); ltPics.Text = ListPics(memberID); //age try { int age = DateTime.Now.Year - DateTime.Parse(ds.Tables[0].Rows[0]["BirthDay"].ToString()).Year; this.lbAge.Text = age.ToString(); } catch { this.lbAge.Text = "0"; } //money object objMoney = adoHelper.ExecuteSqlScalar("select isnull(account_money,0) from T_Moneybag_AccountInfo where member_id='" + memberID + "'"); this.lbMoney.Text = objMoney == null ? "0.00" : objMoney.ToString(); this.div_money.InnerHtml = ListMoney(memberID); } }
protected void Page_Load(object sender, EventArgs e) { if (Request["orderId"] != null) { this.WIDout_trade_no.Text = Request["orderId"]; this.WIDsubject.Text = "易开工支付"; this.WIDshow_url.Text = "http://120.76.41.179:8001/"; this.WIDbody.Text = "易开工支付"; StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); object objMoney = adoHelper.ExecuteSqlScalar("select OrderAllMoney from T_Order_Info where orderId='" + Request["orderId"] + "'"); if (objMoney != null) { this.WIDtotal_fee.Text = objMoney.ToString(); } else { this.BtnAlipay.Enabled = false; } } }
/// <summary> /// 分享获得佣金 /// </summary> /// <param name="orderId"></param> /// <returns></returns> public static int AddShareMember(string orderId) { StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); DataTable dtOrder = adoHelper.ExecuteSqlDataset("select * from T_Order_Info where isPay=1 and orderId='" + orderId + "'").Tables[0]; if (dtOrder.Rows.Count > 0) { double money = double.Parse(dtOrder.Rows[0]["OrderAllMoney"].ToString()); string orderMemberId = dtOrder.Rows[0]["MemberId"].ToString(); DataTable dtShareMember = adoHelper.ExecuteSqlDataset("select * from V_WXQRCodeShare_Log where newFirendMemberId='" + orderMemberId + "'").Tables[0]; if (money >= 200 && dtShareMember.Rows.Count > 0) { //200奖励50,400奖励100 int CouponValue = 0; if (money < 200) { CouponValue = 1; } else if (money >= 200 && money < 400) { CouponValue = 50; } else if (money >= 400) { CouponValue = 100; } string remarks = "分享给“" + dtShareMember.Rows[0]["newFirendTrueName"].ToString() + "”获得的佣金"; if (adoHelper.ExecuteSqlScalar("select MemberId from T_Member_ShareCash where MemberId='" + dtShareMember.Rows[0]["MemberId"].ToString() + "' and ShareFirendMemberId='" + orderMemberId + "'") == null) { return(AddShareCash(dtShareMember.Rows[0]["MemberId"].ToString(), CouponValue, remarks, orderMemberId, dtShareMember.Rows[0]["newFirendTrueName"].ToString())); } } } return(0); }
protected void Page_Load(object sender, EventArgs e) { SortedDictionary <string, string> sPara = GetRequestPost(); if (sPara.Count > 0)//判断是否有带返回参数 { Notify aliNotify = new Notify(); bool verifyResult = aliNotify.Verify(sPara, Request.Form["notify_id"], Request.Form["sign"]); if (verifyResult)//验证成功 { ///////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中服务器异步通知参数列表 //商户订单号 string out_trade_no = Request.Form["out_trade_no"]; //支付宝交易号 string trade_no = Request.Form["trade_no"]; //交易状态 string trade_status = Request.Form["trade_status"]; string remarks = "【支付宝服务器异步通知】[return_url.aspx]支付宝返回值(out_trade_no=" + Request.Form["out_trade_no"] + ",trade_no=" + Request.Form["trade_no"] + ",trade_status=" + Request.Form["trade_status"] + ")"; StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); if (Request.Form["trade_status"] == "TRADE_FINISHED") { //判断该笔订单是否在商户网站中已经做过处理 //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序 //请务必判断请求时的total_fee、seller_id与通知时获取的total_fee、seller_id为一致的 //如果有做过处理,不执行商户的业务程序 //注意: //退款日期超过可退款期限后(如三个月可退款),支付宝系统发送该交易状态通知 object objMoney = adoHelper.ExecuteSqlScalar(" select top 1 paymoney from T_Order_PayLog where payStatu='paysend' and orderId='" + out_trade_no + "' order by payTime desc"); if (objMoney != null) { adoHelper.ExecuteSqlNonQuery("update T_Order_Info set isPay=1 , payTime=getdate() where isPay=0 and orderId='" + out_trade_no + "'"); PayLog.PayLogWrite(Guid.NewGuid().ToString(), "0", out_trade_no, "pay", "zfb", decimal.Parse(objMoney.ToString()), DateTime.Now, trade_no, remarks, DateTime.Now); } } else if (Request.Form["trade_status"] == "TRADE_SUCCESS") { //判断该笔订单是否在商户网站中已经做过处理 //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序 //请务必判断请求时的total_fee、seller_id与通知时获取的total_fee、seller_id为一致的 //如果有做过处理,不执行商户的业务程序 //注意: //付款完成后,支付宝系统发送该交易状态通知 object objMoney = adoHelper.ExecuteSqlScalar(" select top 1 paymoney from T_Order_PayLog where payStatu='paysend' and orderId='" + out_trade_no + "' order by payTime desc"); if (objMoney != null) { adoHelper.ExecuteSqlNonQuery("update T_Order_Info set isPay=1 , payTime=getdate() where isPay=0 and orderId='" + out_trade_no + "'"); adoHelper.ExecuteSqlNonQuery("update T_Goods_Info set JobStatus='进行中' where goodsId=(select goodsId from T_Order_InfoDetail where orderId='" + out_trade_no + "')"); PayLog.PayLogWrite(Guid.NewGuid().ToString(), "0", out_trade_no, "pay", "zfb", decimal.Parse(objMoney.ToString()), DateTime.Now, trade_no, remarks, DateTime.Now); } } else { PayLog.PayLogWrite(Guid.NewGuid().ToString(), "0", out_trade_no, "other", "zfb", 0, DateTime.Now, trade_no, remarks, DateTime.Now); } //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— Response.Write("success"); //请不要修改或删除 ///////////////////////////////////////////////////////////////////////////////////////////////////////////// } else//验证失败 { Response.Write("fail"); } } else { Response.Write("无通知参数"); } }