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("无通知参数");
}
}