protected void LinkButton3_Click(object sender, EventArgs e) { if (txtCode.Text.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('会员编号不能为空!');", true); return; } lgk.Model.tb_user model_user = userBLL.GetModel(" UserCode='" + txtCode.Text.Trim() + "'"); if (model_user == null) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('会员不存在!');", true); return; } if (model_user.AgentsID != agentBLL.GetIDByIDUser(getLoginID())) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('所属报单中心不正确!');", true); return; } if (txtMoney.Value.Trim() == "") { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('消费金额不能为空!');", true); return; } decimal money = 0; try { money = Convert.ToDecimal(txtMoney.Value.Trim()); } catch { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('消费金额格式不正确!');", true); return; } if (money <= 0) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('消费金额要大于零!');", true); return; } if (money > model_user.StockAccount) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('重复消费账户余额不足!');", true); return; } lgk.Model.tb_mix model = new lgk.Model.tb_mix(); model.UserID = model_user.UserID; model.Amount = money; model.AddTime = DateTime.Now; model.Source = "报单中心消费"; if (mixBLL.Add(model) > 0) { AllCore acore = new AllCore();//1收入2支出 acore.add_userRecord(new lgk.BLL.tb_user().GetModel(model.UserID).UserCode, DateTime.Now, money, 2); ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功!');window.location.href='agent_xf.aspx';", true); } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('错误!');", true); } }
protected void LinkButton3_Click(object sender, EventArgs e) { if (txtCode.Text.Trim() == "") { MessageBox.MyShow(this, "会员编号不能为空!"); return; } lgk.Model.tb_user model_user = userBLL.GetModel(" UserCode='" + txtCode.Text.Trim() + "'"); if (model_user == null) { MessageBox.MyShow(this, "会员不存在!"); return; } if (txtMoney.Value.Trim() == "") { MessageBox.MyShow(this, "消费金额不能为空!"); return; } decimal money = 0; try { money = Convert.ToDecimal(txtMoney.Value.Trim()); } catch { MessageBox.MyShow(this, "消费金额格式不正确!"); return; } if (money <= 0) { MessageBox.MyShow(this, "消费金额要大于零!"); return; } if (money > model_user.StockAccount) { MessageBox.MyShow(this, "重复消费账户余额不足!"); return; } lgk.Model.tb_mix model = new lgk.Model.tb_mix(); model.UserID = model_user.UserID; model.Amount = money; model.AddTime = DateTime.Now; model.Source = "后台消费"; if (mixBLL.Add(model) > 0) { AllCore acore = new AllCore();//1收入2支出 acore.add_userRecord(new lgk.BLL.tb_user().GetModel(model.UserID).UserCode, DateTime.Now, money, 2); MessageBox.MyShow(this, "操作成功!"); } else { MessageBox.MyShow(this, "错误!"); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(lgk.Model.tb_mix model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_mix("); strSql.Append("UserID,BonusID,Amount,AddTime,Source,FromUserID,Mix001,Mix002,Mix003,Mix004,Mix005,Mix006,Mix007)"); strSql.Append(" values ("); strSql.Append("@UserID,@BonusID,@Amount,@AddTime,@Source,@FromUserID,@Mix001,@Mix002,@Mix003,@Mix004,@Mix005,@Mix006,@Mix007)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@BonusID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Decimal, 9), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@Source", SqlDbType.VarChar, 50), new SqlParameter("@FromUserID", SqlDbType.Int, 4), new SqlParameter("@Mix001", SqlDbType.Int, 4), new SqlParameter("@Mix002", SqlDbType.Int, 4), new SqlParameter("@Mix003", SqlDbType.VarChar, 50), new SqlParameter("@Mix004", SqlDbType.VarChar, 50), new SqlParameter("@Mix005", SqlDbType.Decimal, 9), new SqlParameter("@Mix006", SqlDbType.Decimal, 9), new SqlParameter("@Mix007", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.BonusID; parameters[2].Value = model.Amount; parameters[3].Value = model.AddTime; parameters[4].Value = model.Source; parameters[5].Value = model.FromUserID; parameters[6].Value = model.Mix001; parameters[7].Value = model.Mix002; parameters[8].Value = model.Mix003; parameters[9].Value = model.Mix004; parameters[10].Value = model.Mix005; parameters[11].Value = model.Mix006; parameters[12].Value = model.Mix007; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
protected void btnSearch_Click(object sender, EventArgs e) { lgk.Model.tb_user umodel = userBLL.GetModel(getIntRequest("userid")); if (this.txtMoney.Value == "") { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额不能为空!');", true); return; } if (Convert.ToDecimal(this.txtMoney.Value.Trim()) < 0) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额需大于零!');", true); return; } if (Convert.ToDecimal(this.txtMoney.Value.Trim()) > umodel.BonusAccount) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额不能大于会员重消账户余额!');", true); return; } lgk.Model.tb_mix model = new lgk.Model.tb_mix(); model.UserID = umodel.UserID; model.Amount = umodel.BonusAccount; model.AddTime = DateTime.Now; model.Mix005 = umodel.BonusAccount - Convert.ToDecimal(txtMoney.Value.Trim()); model.Mix006 = Convert.ToDecimal(txtMoney.Value.Trim()); //加入流水账表 lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal(); jmodel.UserID = getIntRequest("userid"); jmodel.JournalDate = DateTime.Now; jmodel.JournalType = 1; jmodel.InAmount = 0; jmodel.OutAmount = umodel.BonusAccount - Convert.ToDecimal(txtMoney.Value.Trim()); jmodel.BalanceAmount = Convert.ToDecimal(txtMoney.Value.Trim()); jmodel.Remark = "B网消费"; umodel.BonusAccount = Convert.ToDecimal(txtMoney.Value.Trim()); if (userBLL.Update(umodel) && mixBLL.Add(model) > 0 && journalBLL.Add(jmodel) > 0) { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功!');window.location.href='chongxiaoList.aspx'", true); } else { ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败!');", true); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(lgk.Model.tb_mix model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_mix set "); strSql.Append("UserID=@UserID,"); strSql.Append("BonusID=@BonusID,"); strSql.Append("Amount=@Amount,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("Source=@Source,"); strSql.Append("FromUserID=@FromUserID,"); strSql.Append("Mix001=@Mix001,"); strSql.Append("Mix002=@Mix002,"); strSql.Append("Mix003=@Mix003,"); strSql.Append("Mix004=@Mix004,"); strSql.Append("Mix005=@Mix005,"); strSql.Append("Mix006=@Mix006,"); strSql.Append("Mix007=@Mix007"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.BigInt, 8), new SqlParameter("@BonusID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Decimal, 9), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@Source", SqlDbType.VarChar, 50), new SqlParameter("@FromUserID", SqlDbType.Int, 4), new SqlParameter("@Mix001", SqlDbType.Int, 4), new SqlParameter("@Mix002", SqlDbType.Int, 4), new SqlParameter("@Mix003", SqlDbType.VarChar, 50), new SqlParameter("@Mix004", SqlDbType.VarChar, 50), new SqlParameter("@Mix005", SqlDbType.Decimal, 9), new SqlParameter("@Mix006", SqlDbType.Decimal, 9), new SqlParameter("@Mix007", SqlDbType.DateTime), new SqlParameter("@ID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.UserID; parameters[1].Value = model.BonusID; parameters[2].Value = model.Amount; parameters[3].Value = model.AddTime; parameters[4].Value = model.Source; parameters[5].Value = model.FromUserID; parameters[6].Value = model.Mix001; parameters[7].Value = model.Mix002; parameters[8].Value = model.Mix003; parameters[9].Value = model.Mix004; parameters[10].Value = model.Mix005; parameters[11].Value = model.Mix006; parameters[12].Value = model.Mix007; parameters[13].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public lgk.Model.tb_mix GetModel(long ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,UserID,BonusID,Amount,AddTime,Source,FromUserID,Mix001,Mix002,Mix003,Mix004,Mix005,Mix006,Mix007 from tb_mix "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.BigInt) }; parameters[0].Value = ID; lgk.Model.tb_mix model = new lgk.Model.tb_mix(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); 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]["BonusID"] != null && ds.Tables[0].Rows[0]["BonusID"].ToString() != "") { model.BonusID = int.Parse(ds.Tables[0].Rows[0]["BonusID"].ToString()); } if (ds.Tables[0].Rows[0]["Amount"] != null && ds.Tables[0].Rows[0]["Amount"].ToString() != "") { model.Amount = decimal.Parse(ds.Tables[0].Rows[0]["Amount"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"] != null && ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } if (ds.Tables[0].Rows[0]["Source"] != null && ds.Tables[0].Rows[0]["Source"].ToString() != "") { model.Source = ds.Tables[0].Rows[0]["Source"].ToString(); } if (ds.Tables[0].Rows[0]["FromUserID"] != null && ds.Tables[0].Rows[0]["FromUserID"].ToString() != "") { model.FromUserID = int.Parse(ds.Tables[0].Rows[0]["FromUserID"].ToString()); } if (ds.Tables[0].Rows[0]["Mix001"] != null && ds.Tables[0].Rows[0]["Mix001"].ToString() != "") { model.Mix001 = int.Parse(ds.Tables[0].Rows[0]["Mix001"].ToString()); } if (ds.Tables[0].Rows[0]["Mix002"] != null && ds.Tables[0].Rows[0]["Mix002"].ToString() != "") { model.Mix002 = int.Parse(ds.Tables[0].Rows[0]["Mix002"].ToString()); } if (ds.Tables[0].Rows[0]["Mix003"] != null && ds.Tables[0].Rows[0]["Mix003"].ToString() != "") { model.Mix003 = ds.Tables[0].Rows[0]["Mix003"].ToString(); } if (ds.Tables[0].Rows[0]["Mix004"] != null && ds.Tables[0].Rows[0]["Mix004"].ToString() != "") { model.Mix004 = ds.Tables[0].Rows[0]["Mix004"].ToString(); } if (ds.Tables[0].Rows[0]["Mix005"] != null && ds.Tables[0].Rows[0]["Mix005"].ToString() != "") { model.Mix005 = decimal.Parse(ds.Tables[0].Rows[0]["Mix005"].ToString()); } if (ds.Tables[0].Rows[0]["Mix006"] != null && ds.Tables[0].Rows[0]["Mix006"].ToString() != "") { model.Mix006 = decimal.Parse(ds.Tables[0].Rows[0]["Mix006"].ToString()); } if (ds.Tables[0].Rows[0]["Mix007"] != null && ds.Tables[0].Rows[0]["Mix007"].ToString() != "") { model.Mix007 = DateTime.Parse(ds.Tables[0].Rows[0]["Mix007"].ToString()); } return(model); } else { return(null); } }