private void ShowInfo(int _id) { BLL.member bll = new BLL.member(); Model.member model = bll.GetModel(_id); ddlTown.SelectedValue = model.town.ToString(); ddlVillage.SelectedValue = model.village.ToString(); txtAddress.Text = model.address; txtNo.Text = model.no; txtNo.ReadOnly = true; txtName.Text = model.name; rblGender.SelectedValue = model.gender.ToString(); txtBirthday.Text = model.birthday.ToString(); ddlEducation.SelectedValue = model.education; txtIdCard.Text = model.id_card; txtAmount.Text = model.amount.ToString(); for (int i = 1; i < model.family.Count + 1; i++) { TextBox txtFamilyName = FindControl("txtFamilyName" + i) as TextBox; DropDownList ddlFamilyGender = FindControl("ddlFamilyGender" + i) as DropDownList; TextBox txtFamilyRel = FindControl("txtFamilyRel" + i) as TextBox; TextBox txtFamilyBir = FindControl("txtFamilyBir" + i) as TextBox; DropDownList ddlFamilyEdu = FindControl("ddlFamilyEdu" + i) as DropDownList; var current = model.family[i - 1]; txtFamilyName.Text = current.name; ddlFamilyGender.SelectedValue = current.gender; txtFamilyRel.Text = current.relationship; txtFamilyBir.Text = current.birthday; ddlFamilyEdu.SelectedValue = current.education; } }
private void ShowInfo(int _id) { BLL.member bll = new BLL.member(); Model.member model = bll.GetModel(_id); txtNo.Text = model.no; txtNo.ReadOnly = true; txtNo.Attributes.Remove("ajaxurl"); txtName.Text = model.name; rblType.SelectedValue = model.type.ToString(); rblGender.SelectedValue = model.gender.ToString(); ddlMemberLevel.SelectedValue = model.level.ToString(); txtTel.Text = model.tel; txtIdCard.Text = model.id_card; ddlTown.SelectedValue = model.town; ddlVillage.SelectedValue = model.village; txtAmount.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.amount), 0).ToString(); txtCanAmount.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.can_amount), 0).ToString(); txtYh.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.yh_amount), 0).ToString(); txtPeigu.Text = Utils.StrToDecimal(Utils.ObjectToStr(model.peigu), 0).ToString(); txtDate.Text = model.date.Value.ToString("yyyy-MM-dd HH:mm:ss"); txtAddTime.Text = model.add_time.Value.ToString("yyyy-MM-dd HH:mm:ss"); txtRemark.Text = model.remark; txtImgUrl.Text = model.img_url; //绑定图片相册 rptAlbumList.DataSource = model.albums; rptAlbumList.DataBind(); rptCwList.DataSource = model.cw_albums; rptCwList.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { //Maticsoft.BLL.weixin wx_bll = new BLL.weixin(); //string result = wx_bll.update_remark(wx_u_mod.openid, wx_bll.get_accesstoken(), name.Text); //Response.Write("<script>alert('" + result + "!');</script>"); Maticsoft.Model.member mem_mod = new Model.member(); mem_mod.openid = wx_u_mod.openid; mem_mod.name = name.Text.Trim(); mem_mod.time = DateTime.Now; mem_mod.peixunban_id = Convert.ToInt16(qishu.SelectedValue); mem_mod.name2 = wx_u_mod.nickname; Maticsoft.BLL.member mem_bll = new BLL.member(); string str = mem_bll.updatedata(mem_mod); if (str == "更新成功" || str == "插入成功") { //Session["name"] = mem_mod.name; //Response.Write("<script>alert('退出系统后重新进入!')</script>"); Response.Write("<script>alert('" + str + "!');window.location='index.aspx'</script>"); } else { //Response.Write("<script>alert('退出系统后重新进入!')</script>"); Response.Write("<script>alert('" + str + "!')/script>"); } }
/// <summary> /// 判断用户是否登陆 /// </summary> /// <returns></returns> public bool IsMemberLogin() { if (Session["Memberlogin"] != null) { return(true); } else { //检查Cookies string membername = Utils.GetCookie("membername", "JinBo"); string memberpwd = Utils.GetCookie("memberpwd", "JinBo"); if (membername != "" && memberpwd != "") { BLL.member bll = new BLL.member(); Model.member model = bll.CheckModle(membername, memberpwd); set = new BLL.member_setting().GetModelByMid(model.id); if (model != null) { Session["Memberlogin"] = model; return(true); } else { return(false); } } else { return(false); } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "") { MessageBox.Show("请填写完整!"); } else { member_id = textBox1.Text.Trim(); password = textBox2.Text.Trim(); if (dealmember.Login(member_id, password)) { model = dealmember.GetOnemember(member_id); MemberHelper.Level = model.Level; MemberHelper.Use = true; MemberHelper.Name = member_id; MessageBox.Show("验证成功!"); this.Close(); } else { MessageBox.Show("验证失败!"); } } }
/// <summary> /// 兑换房间用费 /// </summary> private void GetDuihaun() { string mtid = context.Request.QueryString["mid"]; string Amount = context.Request.QueryString["Amount"]; string syjf = context.Request.QueryString["syjf"]; Model.member modelmem = bllme.GetModel(mtid); Model.memberType modelty = bllmt.GetModel(Convert.ToInt32(modelmem.Mtype)); if (modelty.IsTx) { int jf = Convert.ToInt32(modelty.MachJf); int sum = jf * Convert.ToInt32(Amount); if (sum > Convert.ToInt32(syjf)) { int je = Convert.ToInt32(syjf) / jf; int ld = Convert.ToInt32(syjf) % jf; int sumjf = je * jf; var obj = new { je = je, sumjf = sumjf }; string str = js1.Serialize(obj); Common.AjaxMsgHelper.AjaxMsg1("err", "积分不足", str, ""); } else { Common.AjaxMsgHelper.AjaxMsg("ok", "", "" + sum.ToString() + "", ""); } } else { Common.AjaxMsgHelper.AjaxMsg1("err", "该会员不支持积分兑换!", "", ""); } }
private void button1_Click(object sender, EventArgs e) { string member_id = textBox1.Text.Trim(); string password = this.textBox2.Text.Trim(); string name = textBox3.Text.Trim(); string level = null; if (member_id == "" || name == "" || password == "") { MessageBox.Show("卡号或姓名或密码不能为空!"); textBox1.Focus(); return; } else { Model.member model = new Model.member(); model.Member_id = member_id; model.Name = name; model.Password = password; model.Level = "黄金会员"; if (dealmember.Addmember(model)) { MessageBox.Show("注册成功"); } else { MessageBox.Show("注册失败"); } } }
/// <summary> /// 根据消费金额添加一定的积分 /// </summary> private void AddJf() { int pric = Convert.ToInt32(txt_xfMoney.Value); string cardid = hycard.Value; Model.member modelmem = bllmem.GetModel(cardid); if (modelmem != null) { Model.memberType modelmt = bllmt.GetModel(Convert.ToInt32(modelmem.Mtype)); if (modelmt.IntegraIs) //如果是积分卡 { if (modelmt.IsConsump) //如果是按消费积分 { if (modelmt.XfPrice.ToString() != "" && modelmt.XfConsump.ToString() != "") { int sumzj = 0; int xfPrice = Convert.ToInt32(modelmt.XfPrice); int XfConsump = Convert.ToInt32(modelmt.XfConsump); int ds = pric / xfPrice; for (int i = 0; i < ds; i++) { sumzj += XfConsump; } Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = cardid; modelmr.Price = sumzj; modelmr.Type = 3; modelmr.Remark = "赠送消费积分"; bllmr.Add(modelmr); } } } if (modelmt.IsLive) //如果按入住天数计算 { DateTime date1 = Convert.ToDateTime(fmOc.GetModel(ids).occ_time.ToString()); DateTime date2 = System.DateTime.Now; int cc = date2.Day - date1.Day; if (cc < 0) { cc = (Convert.ToDateTime(date2.ToString("yyyy-MM-dd")) - Convert.ToDateTime(date1.ToString("yyyy-MM-dd"))).Days; } int sumzj = 0; int m = Convert.ToInt32(modelmt.LiveNum); int lp = Convert.ToInt32(modelmt.LiveConsump); int ds = cc / m; for (int i = 0; i < ds; i++) { sumzj += lp; } Model.mRecords modelmr = new Model.mRecords(); modelmr.mmid = cardid; modelmr.Price = sumzj; modelmr.Type = 3; modelmr.Remark = "赠送入住天数积分"; bllmr.Add(modelmr); } } }
protected void confirm_btn_Click(object sender, EventArgs e) { Maticsoft.BLL.member mem_bll = new BLL.member(); Maticsoft.Model.member mem_mod = new Model.member(); mem_mod.openid = openid.Text; mem_mod.name = name.Text; mem_mod.style = "2"; mem_mod.time = DateTime.Now; mem_mod.fenzu_id = Convert.ToInt16(DropDownList1.SelectedValue); }
void Bind(string id) { Model.member model = bllme.GetModel(id); GetSumJf(id.ToString()); CardNo.Value = model.Mid.ToString(); CategoryName.InnerText = GetTypeName(Convert.ToInt32(model.Mtype)); Name.InnerText = model.Name; UsableAmount.InnerText = czyue.ToString(); Amount.Value = Request.QueryString["desp"]; pwd.Value = model.Pwd; }
private void Find() { string mtid = context.Request.QueryString["mid"]; Model.member modelmem = bllme.GetModel(mtid); modelmem.Statid = 0; if (bllme.Update(modelmem)) { context.Response.Write("ok"); } }
/// <summary> /// 获得点击后会员的信息 /// </summary> private void Getinfo() { string account = context.Request.QueryString["memid"]; Model.member modelmem = bllme.GetModel(account); if (modelmem != null) { GetSumJf(account); context.Response.Write("会员类型:" + GetTypeName(Convert.ToInt32(modelmem.Mtype)) + " 剩余积分:" + shengyu + " 剩余金额:" + czyue); } }
protected void Button1_Click(object sender, EventArgs e) { Maticsoft.Model.member mem_mod = new Model.member(); mem_mod.openid = Session["open_id"].ToString(); mem_mod.name = TextBox1.Text.Trim(); mem_mod.time = DateTime.Now; mem_mod.style = "2"; Maticsoft.BLL.member mem_bll = new BLL.member(); string str = mem_bll.updatedata(mem_mod); Response.Write("<script>alert('" + str + ",我们会尽快与您确认信息')</script>"); }
protected void btnSave_Click(object sender, EventArgs e) { Model.member model = bllme.GetModel(accout.Value); if (pwds.Value != model.Pwd) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>alert('密码错误!');</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>parent.document.getElementById('txt_hycard').value='1';parent.document.getElementById('btnAdds').click();</script>"); } }
protected void Page_Load(object sender, EventArgs e) { this.id = Utils.StrToInt(DTRequest.GetQueryString("id"), 0); action = DTRequest.GetQueryString("action"); BLL.member bll = new BLL.member(); Model.member model = bll.GetModel(id); if (!string.IsNullOrEmpty(model.shenfenzheng)) { txtShenFenZheng.Text = model.shenfenzheng; imgShenFenZheng.Src = model.shenfenzheng; } }
void Bind(string id) { Model.member model = bllme.GetModel(id); GetSumJf(id.ToString()); CardNo.Value = model.Mid.ToString(); CategoryName.Value = GetTypeName(Convert.ToInt32(model.Mtype)); MemberName.Value = model.Name; //UsableAmount.Value = czyue.ToString(); //Amount.Value = Request.QueryString["desp"]; zjf.Value = sumjf.ToString(); xyjf.Value = duihua.ToString(); syjf.Value = shengyu.ToString(); }
/// <summary> /// 取得用户信息 /// </summary> public Model.member GetMemberInfo() { if (IsMemberLogin()) { Model.member model = Session["Memberlogin"] as Model.member; set = new BLL.member_setting().GetModelByMid(model.id); if (model != null) { return(model); } } return(null); }
public bool Update(Model.member model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update member set "); strSql.Append("userName=@userName,"); strSql.Append("userPwd=@userPwd,"); strSql.Append("userRole=@userRole,"); strSql.Append("email=@email,"); strSql.Append("phone=@phone,"); strSql.Append("sex=@sex,"); strSql.Append("creoSetup=@creoSetup,"); strSql.Append("creoWorkSpace=@creoWorkSpace,"); strSql.Append("isWork=@isWork"); strSql.Append(" where mem_id=@mem_id"); SqlParameter[] parameters = { new SqlParameter("@userName", SqlDbType.VarChar, 100), new SqlParameter("@userPwd", SqlDbType.VarChar, 100), new SqlParameter("@userRole", SqlDbType.Int, 4), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@phone", SqlDbType.VarChar, 20), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@creoSetup", SqlDbType.VarChar, 200), new SqlParameter("@creoWorkSpace", SqlDbType.VarChar, 200), new SqlParameter("@isWork", SqlDbType.Int, 4), new SqlParameter("@mem_id", SqlDbType.Int, 4) }; parameters[0].Value = model.userName; parameters[1].Value = model.userPwd; parameters[2].Value = model.userRole; parameters[3].Value = model.email; parameters[4].Value = model.phone; parameters[5].Value = model.sex; parameters[6].Value = model.creoSetup; parameters[7].Value = model.creoWorkSpace; parameters[8].Value = model.isWork; parameters[9].Value = model.mem_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void button1_Click(object sender, EventArgs e) { string t_id = textBox1.Text.Trim(); string password = this.textBox2.Text.Trim(); is_member = false; if (t_id == "" || password == "") { MessageBox.Show("用户名或密码不能为空!"); textBox1.Focus(); return; } else { BLL.Dealticketing_seller dealticketing_seller = new BLL.Dealticketing_seller(); if (dealticketing_seller.Login(Convert.ToInt32(t_id), password)) //判断是否为管理员 { SellerHelper.Id = textBox1.Text.Trim(); //用SellerHelper记录id与密码 SellerHelper.Password = textBox2.Text.Trim(); this.Hide(); main f = new main(); f.Show(); } else { BLL.Dealmember dealmember = new BLL.Dealmember(); Model.member model = new Model.member(); if (dealmember.Login(t_id, password)) //判断是否为会员 { is_member = true; model = dealmember.GetOnemember(t_id); MemberHelper.Level = model.Level; MemberHelper.Use = true; MemberHelper.Name = t_id; this.Hide(); film_booking film_b1 = new film_booking(); film_b1.Show(); } else { MessageBox.Show("用户名或密码错误,请重新输入!", "错误"); textBox1.Text = ""; textBox2.Text = ""; textBox1.Focus(); } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.member DataRowToModel(DataRow row) { Model.member model = new Model.member(); if (row != null) { if (row["mem_id"] != null && row["mem_id"].ToString() != "") { model.mem_id = int.Parse(row["mem_id"].ToString()); } if (row["userName"] != null) { model.userName = row["userName"].ToString(); } if (row["userPwd"] != null) { model.userPwd = row["userPwd"].ToString(); } if (row["userRole"] != null && row["userRole"].ToString() != "") { model.userRole = int.Parse(row["userRole"].ToString()); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["phone"] != null) { model.phone = row["phone"].ToString(); } if (row["sex"] != null && row["sex"].ToString() != "") { model.sex = int.Parse(row["sex"].ToString()); } if (row["creoSetup"] != null) { model.creoSetup = row["creoSetup"].ToString(); } if (row["creoWorkSpace"] != null) { model.creoWorkSpace = row["creoWorkSpace"].ToString(); } if (row["isWork"] != null && row["isWork"].ToString() != "") { model.isWork = int.Parse(row["isWork"].ToString()); } } return(model); }
/// <summary> /// 验证密码是否正确 /// </summary> private void VailPwd() { string pwd = context.Request.QueryString["pwd"]; string num = context.Request.QueryString["num"]; Model.member modelmem = bllme.GetModel(num); if (modelmem != null && modelmem.Pwd == pwd) { context.Response.Write("ok"); context.Response.End(); } else { context.Response.Write("err"); context.Response.End(); } }
private void AddButton_Click(object sender, EventArgs e) { string member_id = cardbox.Text.Trim(); string name = namebox.Text.Trim(); string password = this.passwordbox.Text.Trim(); string level = null; if (member_id == "" || name == "" || password == "") { MessageBox.Show("卡号或姓名或密码不能为空!"); cardbox.Focus(); return; } else if (levelcombo.SelectedIndex < 0) { MessageBox.Show("你没有选择身份"); } else { if (levelcombo.SelectedIndex == 0) { level = "黄金会员"; } else { level = "白金会员"; } Model.member model = new Model.member(); model.Member_id = member_id; model.Name = name; model.Password = password; model.Level = level; if (dealmember.Addmember(model)) { MessageBox.Show("添加成功"); Fill(); } else { MessageBox.Show("添加失败"); } } }
public int Add(Model.member model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into member("); strSql.Append("userName,userPwd,userRole,email,phone,sex,creoSetup,creoWorkSpace,isWork)"); strSql.Append(" values ("); strSql.Append("@userName,@userPwd,@userRole,@email,@phone,@sex,@creoSetup,@creoWorkSpace,@isWork)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userName", SqlDbType.VarChar, 100), new SqlParameter("@userPwd", SqlDbType.VarChar, 100), new SqlParameter("@userRole", SqlDbType.Int, 4), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@phone", SqlDbType.VarChar, 20), new SqlParameter("@sex", SqlDbType.Int, 4), new SqlParameter("@creoSetup", SqlDbType.VarChar, 200), new SqlParameter("@creoWorkSpace", SqlDbType.VarChar, 200), new SqlParameter("@isWork", SqlDbType.Int, 4) }; parameters[0].Value = model.userName; parameters[1].Value = model.userPwd; parameters[2].Value = model.userRole; parameters[3].Value = model.email; parameters[4].Value = model.phone; parameters[5].Value = model.sex; parameters[6].Value = model.creoSetup; parameters[7].Value = model.creoWorkSpace; parameters[8].Value = model.isWork; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
//根据卡号获得所有的信息 private void Getvalue() { string mid = context.Request.QueryString["mid"]; Model.member model = bllme.GetModel(mid); if (model != null) { Model.memberType modelty = bllmt.GetModel(Convert.ToInt32(model.Mtype)); GetSumJf(model.Mid.ToString()); var obj = new { states = "ok", name = model.Name, zj = GetZJ(Convert.ToInt32(model.Zjtype)), ZjNumber = model.ZjNumber, typename = GetTypeName(Convert.ToInt32(model.Mtype)), Baithday = model.Baithday == null ? "" : Convert.ToDateTime(model.Baithday).ToString("yyyy-MM-dd"), sales = model.sales, Phone = model.Phone, Likes = model.Likes, Address = model.Address, Ramrek = model.Ramrek, sumjf = sumjf, duihua = duihua, shengyu = shengyu, dongjie = dongjie, czsum = czsum, xfsum = xfsum, czyue = czyue, xfnum = xfnum, xfall = xfall, state = GetState(Convert.ToInt32(model.Statid)), date = model.AddDate == null ? "" : Convert.ToDateTime(model.AddDate).ToString("yyyy-MM-dd"), xq = GetQx(modelty), Mtype = model.Mtype, isok = model.IntegraDj, cardPrice = modelty.typePrice, yxtime = Convert.ToDateTime(model.XqTime).ToString("yyyy-MM-dd"), UpLive = GetTypeName(Convert.ToInt32(modelty.UpLive)), IsDeduction = modelty.IsDeduction, ConsumpSum = modelty.ConsumpSum, umtid = modelty.UpLive }; string str = js1.Serialize(obj); context.Response.Write(str); } else { var obj = new { states = "err" }; string str = js1.Serialize(obj); context.Response.Write(str); context.Response.End(); } }
private void Edit() { ShowFee.Style.Add("display", "none"); CAdd.Style.Add("display", "none"); ShowMd.Style.Add("display", "none"); divfa.InnerText = "编辑会员"; BtnSave.Value = "更新会员"; string id = Request.QueryString["id"]; Model.member modelmen = bll.GetModel(id); CCardNo.InnerText = modelmen.Mid.ToString(); MemberCardNo.Value = modelmen.Mid.ToString(); GetSumJf(modelmen.Mid.ToString()); Name.Value = modelmen.Name; Sex.SelectedValue = modelmen.Sex == true ? "1" : "0"; CardType.SelectedValue = modelmen.Zjtype.ToString(); CardNo.Value = modelmen.ZjNumber; CategoryId.SelectedValue = modelmen.Mtype.ToString(); Phone.Value = modelmen.Phone; BirthDay.Value = modelmen.Baithday.ToString(); Password.Attributes.Add("value", modelmen.Pwd); Love.Value = modelmen.Likes; Address.Value = modelmen.Address; Remark.Value = modelmen.Ramrek; OpenDate.InnerText = Convert.ToDateTime(modelmen.AddDate).ToString("yyyy-MM-dd"); Model.memberType modelty = bllmt.GetModel(Convert.ToInt32(modelmen.Mtype)); ExprieDate.InnerText = Convert.ToDateTime(modelmen.XqTime).ToString("yyyy-MM-dd"); StatusName.InnerText = GetState(Convert.ToInt32(modelmen.Statid)); TotalScore.InnerText = sumjf.ToString(); UsedScore.InnerHtml = duihua.ToString(); UsableScore.InnerHtml = shengyu.ToString(); FrozenScore.InnerHtml = dongjie.ToString(); TotalAmount.InnerHtml = czsum.ToString(); UsedAmount.InnerHtml = xfsum.ToString(); UsableAmount.InnerHtml = czyue.ToString(); ConsumeTimes.InnerHtml = xfnum.ToString(); ConsumeAmount.InnerHtml = xfall.ToString(); }
public Model.member GetMemberByName(string username) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 mem_id,userName,userPwd,userRole,email,phone,sex,creoSetup,creoWorkSpace,isWork from member "); strSql.Append(" where userName=@username"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 100) }; parameters[0].Value = username; Model.member model = new Model.member(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.member GetModel(string Mid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Mid,Name,Sex,Zjtype,ZjNumber,Mtype,sales,Phone,Baithday,Pwd,Likes,Address,Ramrek,Integration,IntegraDh,IntegraDj,Stored,Statid,AddDate,AddUser,XqTime from member "); strSql.Append(" where Mid=@Mid "); SqlParameter[] parameters = { new SqlParameter("@Mid", SqlDbType.NVarChar, 50) }; parameters[0].Value = Mid; Model.member model = new Model.member(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
protected void btnSave_Click(object sender, EventArgs e) { Model.member modelmem = bllme.GetModel(CardNo.Value); string password = modelmem.Pwd; if (Convert.ToInt32(UsableAmount.InnerText) > 0) { if (Convert.ToInt32(Amount.Value) - Convert.ToInt32(UsableAmount.InnerText) > 0) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('余额不足!!');parent.window.location.reload();</script>"); } else { if (password != pwd.Value) { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('密码错误!!');</script>"); } else { //Model.mRecords modelrm = new Model.mRecords(); //modelrm.Type = 2; //modelrm.mmid = CardNo.Value; //modelrm.Price = Convert.ToInt32(Amount.Value); //modelrm.Remark = "交了压金"; //if (bllrm.Add(modelrm) > 0) //{ ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>parent.Window_Close();</script>"); //} } } } else { ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript' defer>alert('余额不足!!');</script>"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.member GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from member "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.member model = new Model.member(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void UpdateButton_Click(object sender, EventArgs e) { string member_id; try { member_id = (String)dataGridView1.CurrentRow.Cells[0].Value; } catch (System.Exception ex) { MessageBox.Show("请选择有效数据行!"); return; } Model.member model = new Model.member(); model = dealmember.GetOnemember(member_id); if (model.Level == "白金会员") { MessageBox.Show("已经是白金会员!"); } else if (model.Level == "黄金会员") { if (MessageBox.Show(" 要升级为白金会员吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes) { return; } model.Level = "白金会员"; if (dealmember.Updatemember_passwd(model)) { MessageBox.Show("升级成功!"); Fill(); } } }