/// <summary>
/// 显示数据
/// </summary>
private void ShowData()
{
lgk.Model.tb_recharge rechargeInfo = rechargeBLL.GetModel(iRechargeID);
if (rechargeInfo != null)
{
p2_Order.Value = rechargeInfo.RechargeDate.ToString("yyyyMMddHHmmss");
p3_Amt.Value = rechargeInfo.RechargeableMoney.ToString();
//ltRechargeableDate.Text = rechargeInfo.RechargeDate.ToString();
pa_MP.Value = LoginUser.UserCode;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_recharge model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_recharge(");
strSql.Append("UserID,RechargeableMoney,RechargeStyle,Flag,RechargeDate,YuAmount,RechargeType,AgentID,Recharge001,Recharge002,Recharge003,Recharge004,Recharge005,Recharge006)");
strSql.Append(" values (");
strSql.Append("@UserID,@RechargeableMoney,@RechargeStyle,@Flag,@RechargeDate,@YuAmount,@RechargeType,@AgentID,@Recharge001,@Recharge002,@Recharge003,@Recharge004,@Recharge005,@Recharge006)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@RechargeableMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RechargeStyle", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@RechargeDate", SqlDbType.DateTime),
new SqlParameter("@YuAmount", SqlDbType.Decimal, 9),
new SqlParameter("@RechargeType", SqlDbType.Int, 4),
new SqlParameter("@AgentID", SqlDbType.Int, 4),
new SqlParameter("@Recharge001", SqlDbType.Int, 4),
new SqlParameter("@Recharge002", SqlDbType.Int, 4),
new SqlParameter("@Recharge003", SqlDbType.VarChar, 50),
new SqlParameter("@Recharge004", SqlDbType.VarChar, 50),
new SqlParameter("@Recharge005", SqlDbType.Decimal, 9),
new SqlParameter("@Recharge006", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.RechargeableMoney;
parameters[2].Value = model.RechargeStyle;
parameters[3].Value = model.Flag;
parameters[4].Value = model.RechargeDate;
parameters[5].Value = model.YuAmount;
parameters[6].Value = model.RechargeType;
parameters[7].Value = model.AgentID;
parameters[8].Value = model.Recharge001;
parameters[9].Value = model.Recharge002;
parameters[10].Value = model.Recharge003;
parameters[11].Value = model.Recharge004;
parameters[12].Value = model.Recharge005;
parameters[13].Value = model.Recharge006;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
public long Recharge(string trade_no, decimal PayAmount, long userid)
{
lgk.Model.tb_recharge recharge = new lgk.Model.tb_recharge();
recharge.UserID = userid;
recharge.RechargeableMoney = Convert.ToDecimal(PayAmount);
recharge.RechargeStyle = 1; // 1:"增加" : 2:"减少"
recharge.RechargeType = 1; //1: "电子币" : 2:"金币"
recharge.Recharge001 = 2; //1：后台；2：支付宝
recharge.Flag = 0; // 充值状态
recharge.RechargeDate = DateTime.Now;
recharge.Recharge003 = trade_no; //订单编号
long id = new lgk.BLL.tb_recharge().Add(recharge);
return(id);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
lgk.Model.tb_recharge rechargeInfo = rechargeBLL.GetModel(iRechargeID);
if (rechargeInfo != null)
{
////////////////////////////////////////////支付宝请求参数////////////////////////////////////////////
//Response.Write("<script type='text/javascript'>alert('fasfaf');</script>");
//支付类型
string payment_type = "1";
//必填，不能修改
//服务器异步通知页面路径
string notify_url = HttpContext.Current.Request.Url.Host + "/user/finance/notify_url.aspx";
//需http://格式的完整路径，不能加?id=123这类自定义参数
//页面跳转同步通知页面路径
string return_url = HttpContext.Current.Request.Url.Host + "/user/finance/return_url.aspx";
//需http://格式的完整路径，不能加?id=123这类自定义参数，不能写成http://localhost/
//防钓鱼时间戳
string anti_phishing_key = "";
//若要使用请调用类文件submit中的query_timestamp函数
//客户端的IP地址
string exter_invoke_ip = "";
//非局域网的外网IP地址，如：221.0.0.1
////////////////////////////////////////////////////////////////////////////////////////////////
//把请求参数打包成数组
SortedDictionary <string, string> sParaTemp = new SortedDictionary <string, string>();
sParaTemp.Add("partner", Config.Partner);
sParaTemp.Add("_input_charset", Config.Input_charset.ToLower());
sParaTemp.Add("service", "create_direct_pay_by_user");
sParaTemp.Add("RemitMoney", rechargeInfo.RechargeableMoney.ToString());
sParaTemp.Add("out_trade_no", "会员充值");
sParaTemp.Add("payment_type", payment_type);
sParaTemp.Add("notify_url", notify_url);
sParaTemp.Add("return_url", return_url);
sParaTemp.Add("anti_phishing_key", anti_phishing_key);
sParaTemp.Add("exter_invoke_ip", exter_invoke_ip);
//建立请求
string sHtmlText = Submit.BuildRequest(sParaTemp, "get", "确认");
Response.Write(sHtmlText);
}
}
protected void lbtnSubmit_Click(object sender, EventArgs e)
{
#region 充值金额验证
if (this.txtMoney.Text == "")
{
MessageBox.MyShow(this, "充值金额不能为空!");
return;
}
else if (Convert.ToDouble(this.txtMoney.Text.Trim()) <= 0)
{
MessageBox.MyShow(this, "金额需大于零!");
return;
}
#endregion
lgk.Model.tb_recharge rechargeInfo = new lgk.Model.tb_recharge();
lgk.Model.tb_systemMoney userInfo = systemBll.GetModel(1);
#region 充值实体
rechargeInfo.RechargeStyle = Convert.ToInt32(dropRechargeStyle.SelectedValue);
rechargeInfo.RechargeableMoney = Convert.ToDecimal(this.txtMoney.Text.Trim());
rechargeInfo.RechargeDate = DateTime.Now;
#endregion
#region 加入流水账表
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = 3;
jmodel.UserID = Convert.ToInt32("system");
if (rechargeInfo.RechargeStyle == 1)
{
rechargeInfo.RechargeType = 2;
rechargeInfo.YuAmount = Convert.ToDecimal(userInfo.Money001) + Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.InAmount = Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.OutAmount = 0;
jmodel.BalanceAmount = Convert.ToDecimal(userInfo.Money001) + Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.Remark = "后台充值慈善(增加)";
}
if (rechargeInfo.RechargeStyle == 0)
{
if (Convert.ToDecimal(this.txtMoney.Text) > userInfo.Money001)
{
MessageBox.MyShow(this, "慈善余额不足!");
return;
}
rechargeInfo.RechargeType = 2;
rechargeInfo.YuAmount = Convert.ToDecimal(userInfo.Money001) - Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.InAmount = 0;
jmodel.OutAmount = Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.BalanceAmount = Convert.ToDecimal(userInfo.Money001) - Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.Remark = "后台充值慈善(扣除)";
}
#endregion
if (rechargeBLL.Add(rechargeInfo) > 0 && journalBLL.Add(jmodel) > 0)
{
if (rechargeInfo.RechargeStyle == 1)
{
UpdateSystemAccount("Money001", Convert.ToDecimal(rechargeInfo.RechargeableMoney), 0);//公司账户减少
}
else
{
UpdateSystemAccount("Money001", Convert.ToDecimal(rechargeInfo.RechargeableMoney), 1);//公司账户增加
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');window.location.href='Addcishan.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('充值失败!');", true);
}
}
protected void btnSub_Click(object sender, EventArgs e)
{
lgk.Model.tb_recharge Model = new lgk.Model.tb_recharge();
lgk.Model.tb_user user = new lgk.Model.tb_user();
user = userBLL.GetModel(" usercode='" + SafeHelper.GetSafeSqlandHtml(this.txtUserCode.Text.Trim()) + "' ");
string usercode = txtUserCode.Text.Trim();
if (string.IsNullOrEmpty(usercode))
{
MessageBox.MyShow(this, "请填写要充值的会员账号!");
return;
}
if (user == null)
{
MessageBox.MyShow(this, "该会员账号不存在!");
return;
}
//if (user.IsOpend == 0)
//{
// MessageBox.MyShow(this, "会员未开通!");
// return;
//}
Model.UserID = user.UserID;
if (Convert.ToInt32(dropMoneyType.SelectedValue) == 0)
{
MessageBox.MyShow(this, "请选择账户类型!");
return;
}
Model.RechargeType = Convert.ToInt32(dropMoneyType.SelectedValue);
if (Convert.ToInt32(dropRechargeStyle.SelectedValue) == 0)
{
MessageBox.MyShow(this, "请选择充值类型!");
return;
}
Model.RechargeStyle = Convert.ToInt32(dropRechargeStyle.SelectedValue);
string tMoney = this.txtMoney.Text.Trim();
if (string.IsNullOrEmpty(tMoney))
{
MessageBox.MyShow(this, "充值金额不能为空!");
return;
}
else if (Convert.ToDecimal(tMoney) <= 0)
{
MessageBox.MyShow(this, "金额需大于零!");
return;
}
decimal reMoney = Convert.ToDecimal(tMoney);
//加入流水账表
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = Convert.ToInt32(user.UserID);
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = Model.RechargeType;
jmodel.Remark = "后台充值" + AccountTypeHelper.GetName((int)Model.RechargeType) + "(增加)";
if (Model.RechargeStyle == 1)
{
jmodel.OutAmount = 0;
jmodel.JournalType = Model.RechargeType;
jmodel.InAmount = reMoney;
if (Model.RechargeType == 1)//注册分
{
Model.YuAmount = user.Emoney + reMoney;
jmodel.BalanceAmount = user.Emoney + reMoney;
}
if (Model.RechargeType == 2)//奖励分
{
Model.YuAmount = user.BonusAccount + reMoney;
jmodel.BalanceAmount = user.BonusAccount + reMoney;
}
if (Model.RechargeType == 3)//复利分
{
Model.YuAmount = user.StockMoney + reMoney;
jmodel.BalanceAmount = user.StockMoney + reMoney;
}
if (Model.RechargeType == 4)//激活分
{
Model.YuAmount = user.StockAccount + reMoney;
jmodel.BalanceAmount = user.StockAccount + reMoney;
}
if (Model.RechargeType == 5)//购物分
{
Model.YuAmount = user.GLmoney + reMoney;
jmodel.BalanceAmount = user.GLmoney + reMoney;
}
}
if (Model.RechargeStyle == 2)
{
jmodel.InAmount = 0;
jmodel.JournalType = Model.RechargeType;
jmodel.OutAmount = reMoney;
jmodel.Remark = "后台充值" + AccountTypeHelper.GetName((int)Model.RechargeType) + "(扣除)";
if (Model.RechargeType == 1)
{
if (reMoney > user.Emoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.Emoney - reMoney;
jmodel.BalanceAmount = user.Emoney - reMoney;
}
if (Model.RechargeType == 2)
{
if (reMoney > user.BonusAccount)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.BonusAccount - reMoney;
jmodel.BalanceAmount = user.BonusAccount - reMoney;
}
if (Model.RechargeType == 3)
{
if (reMoney > user.StockAccount)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.StockMoney - reMoney;
jmodel.BalanceAmount = user.StockMoney - reMoney;
}
if (Model.RechargeType == 4)
{
if (reMoney > user.StockMoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.StockAccount - reMoney;
jmodel.BalanceAmount = user.StockAccount - reMoney;
}
if (Model.RechargeType == 5)
{
if (reMoney > user.GLmoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.GLmoney - reMoney;
jmodel.BalanceAmount = user.GLmoney - reMoney;
}
}
Model.RechargeableMoney = reMoney;
Model.RechargeDate = DateTime.Now;
Model.Flag = 1;
if (rechargeBLL.Add(Model) > 0 && journalBLL.Add(jmodel) > 0)
{
string fieldName = "";
if (Model.RechargeType == 1)
{
fieldName = "Emoney";
}
else if (Model.RechargeType == 2)
{
fieldName = "BonusAccount";
}
else if (Model.RechargeType == 3)
{
fieldName = "StockMoney";
}
else if (Model.RechargeType == 4)
{
fieldName = "StockAccount";
}
else if (Model.RechargeType == 5)
{
fieldName = "GLmoney";
}
if (Model.RechargeStyle == 1)
{
UpdateAccount(fieldName, Convert.ToInt32(Model.UserID), reMoney, 1);
UpdateSystemAccount("MoneyAccount", reMoney, 1);//公司账户增加
}
else
{
UpdateAccount(fieldName, Convert.ToInt32(Model.UserID), reMoney, 0);
UpdateSystemAccount("MoneyAccount", reMoney, 0);//公司账户减少
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');window.location.href='AddMoney.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('充值失败!');", true);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_recharge model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_recharge set ");
strSql.Append("UserID=@UserID,");
strSql.Append("RechargeableMoney=@RechargeableMoney,");
strSql.Append("RechargeStyle=@RechargeStyle,");
strSql.Append("Flag=@Flag,");
strSql.Append("RechargeDate=@RechargeDate,");
strSql.Append("YuAmount=@YuAmount,");
strSql.Append("RechargeType=@RechargeType,");
strSql.Append("AgentID=@AgentID,");
strSql.Append("Recharge001=@Recharge001,");
strSql.Append("Recharge002=@Recharge002,");
strSql.Append("Recharge003=@Recharge003,");
strSql.Append("Recharge004=@Recharge004,");
strSql.Append("Recharge005=@Recharge005,");
strSql.Append("Recharge006=@Recharge006");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@RechargeableMoney", SqlDbType.Decimal, 9),
new SqlParameter("@RechargeStyle", SqlDbType.Int, 4),
new SqlParameter("@Flag", SqlDbType.Int, 4),
new SqlParameter("@RechargeDate", SqlDbType.DateTime),
new SqlParameter("@YuAmount", SqlDbType.Decimal, 9),
new SqlParameter("@RechargeType", SqlDbType.Int, 4),
new SqlParameter("@AgentID", SqlDbType.Int, 4),
new SqlParameter("@Recharge001", SqlDbType.Int, 4),
new SqlParameter("@Recharge002", SqlDbType.Int, 4),
new SqlParameter("@Recharge003", SqlDbType.VarChar, 50),
new SqlParameter("@Recharge004", SqlDbType.VarChar, 50),
new SqlParameter("@Recharge005", SqlDbType.Decimal, 9),
new SqlParameter("@Recharge006", SqlDbType.Decimal, 9),
new SqlParameter("@ID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.RechargeableMoney;
parameters[2].Value = model.RechargeStyle;
parameters[3].Value = model.Flag;
parameters[4].Value = model.RechargeDate;
parameters[5].Value = model.YuAmount;
parameters[6].Value = model.RechargeType;
parameters[7].Value = model.AgentID;
parameters[8].Value = model.Recharge001;
parameters[9].Value = model.Recharge002;
parameters[10].Value = model.Recharge003;
parameters[11].Value = model.Recharge004;
parameters[12].Value = model.Recharge005;
parameters[13].Value = model.Recharge006;
parameters[14].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_recharge GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserID,RechargeableMoney,RechargeStyle,Flag,RechargeDate,YuAmount,RechargeType,AgentID,Recharge001,Recharge002,Recharge003,Recharge004,Recharge005,Recharge006 from tb_recharge ");
if (strWhere.Trim() == "")
{
strSql.Append(" where " + strWhere);
}
lgk.Model.tb_recharge model = new lgk.Model.tb_recharge();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["RechargeableMoney"] != null && ds.Tables[0].Rows[0]["RechargeableMoney"].ToString() != "")
{
model.RechargeableMoney = decimal.Parse(ds.Tables[0].Rows[0]["RechargeableMoney"].ToString());
}
if (ds.Tables[0].Rows[0]["RechargeStyle"] != null && ds.Tables[0].Rows[0]["RechargeStyle"].ToString() != "")
{
model.RechargeStyle = int.Parse(ds.Tables[0].Rows[0]["RechargeStyle"].ToString());
}
if (ds.Tables[0].Rows[0]["Flag"] != null && ds.Tables[0].Rows[0]["Flag"].ToString() != "")
{
model.Flag = int.Parse(ds.Tables[0].Rows[0]["Flag"].ToString());
}
if (ds.Tables[0].Rows[0]["RechargeDate"] != null && ds.Tables[0].Rows[0]["RechargeDate"].ToString() != "")
{
model.RechargeDate = DateTime.Parse(ds.Tables[0].Rows[0]["RechargeDate"].ToString());
}
if (ds.Tables[0].Rows[0]["YuAmount"] != null && ds.Tables[0].Rows[0]["YuAmount"].ToString() != "")
{
model.YuAmount = decimal.Parse(ds.Tables[0].Rows[0]["YuAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["RechargeType"] != null && ds.Tables[0].Rows[0]["RechargeType"].ToString() != "")
{
model.RechargeType = int.Parse(ds.Tables[0].Rows[0]["RechargeType"].ToString());
}
if (ds.Tables[0].Rows[0]["AgentID"] != null && ds.Tables[0].Rows[0]["AgentID"].ToString() != "")
{
model.AgentID = int.Parse(ds.Tables[0].Rows[0]["AgentID"].ToString());
}
if (ds.Tables[0].Rows[0]["Recharge001"] != null && ds.Tables[0].Rows[0]["Recharge001"].ToString() != "")
{
model.Recharge001 = int.Parse(ds.Tables[0].Rows[0]["Recharge001"].ToString());
}
if (ds.Tables[0].Rows[0]["Recharge002"] != null && ds.Tables[0].Rows[0]["Recharge002"].ToString() != "")
{
model.Recharge002 = int.Parse(ds.Tables[0].Rows[0]["Recharge002"].ToString());
}
if (ds.Tables[0].Rows[0]["Recharge003"] != null && ds.Tables[0].Rows[0]["Recharge003"].ToString() != "")
{
model.Recharge003 = ds.Tables[0].Rows[0]["Recharge003"].ToString();
}
if (ds.Tables[0].Rows[0]["Recharge004"] != null && ds.Tables[0].Rows[0]["Recharge004"].ToString() != "")
{
model.Recharge004 = ds.Tables[0].Rows[0]["Recharge004"].ToString();
}
if (ds.Tables[0].Rows[0]["Recharge005"] != null && ds.Tables[0].Rows[0]["Recharge005"].ToString() != "")
{
model.Recharge005 = decimal.Parse(ds.Tables[0].Rows[0]["Recharge005"].ToString());
}
if (ds.Tables[0].Rows[0]["Recharge006"] != null && ds.Tables[0].Rows[0]["Recharge006"].ToString() != "")
{
model.Recharge006 = decimal.Parse(ds.Tables[0].Rows[0]["Recharge006"].ToString());
}
return(model);
}
else
{
return(null);
}
}
