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();
}
}
}
