//------------
private void ValidNickName(string name, string isreverse)
{
MemberInfoBLL memberBll = new MemberInfoBLL();
int result = memberBll.ValidNikeName(name);
//检查昵称是否可注册
if (isreverse.Length <= 0)
{
if (result > 0)
{ //不可用
Response.Write("1");
}
else
{ //可用
Response.Write("0");
}
}//检查昵称是否存在
else
{
if (result > 0)
{ //存在
Response.Write("0");
}
else
{ //不存在
Response.Write("1");
}
}
}
public string checkUsername(string userName)
{
string temp = string.Empty;
temp = new MemberInfoBLL().CheckUserName(userName).ToString();
return(temp);
}
private void btnOk_Click(object sender, EventArgs e)
{
if (IsCheck())
{
MemberInfoBLL bll = new MemberInfoBLL();
MemberInfo mem = new MemberInfo();
mem.MemberAddress = "上海";//默认没有文本框
mem.MemberBirthday = Convert.ToDateTime(txtBirs.Text);
mem.MemberDiscount = Convert.ToDecimal(txtMemDiscount.Text);
mem.MemberEndServerTime = dtEndServerTime.Value;
mem.MemberGender = CheckGender(); //性别
mem.MemberMobilePhone = txtMemPhone.Text; //电话
mem.MemberMoney = Convert.ToDecimal(txtmemMoney.Text); //钱
mem.MemberName = txtMemName.Text;
mem.MemberNum = txtMemNum.Text;
mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue);//等级
//判断
if (this.TP == 1)//新增
{
mem.DelFlag = 0;
mem.MemberIntegral = Convert.ToDecimal(txtMemIntegral.Text);
mem.SubTime = System.DateTime.Now;
}
else if (this.TP == 2)//修改
{
mem.MemberId = Convert.ToInt32(labId.Text);
}
string msg = bll.SaveMemmberInfo(mem, this.TP) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
this.Close();
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (CheckEmpty())
{
MemberInfo member = new MemberInfo();
member.MemAddress = txtAddress.Text;
member.MemBirthday = dtpBirthday.Value;
member.MemDiscount = Convert.ToInt32(txtDiscount.Text);
member.MemEndTime = dtpEndTime.Value;
member.MemGender = rdoMan.Checked ? "男" : "女";
member.MemIntegral = Convert.ToInt32(txtIntger.Text);
member.MemMobilePhone = txtPhone.Text;
member.MemMoney = Convert.ToDouble(txtMoney.Text);
member.MemName = txtName.Text;
member.MemNum = txtNum.Text;
member.MemType = Convert.ToInt32(cmbType.SelectedIndex);
member.SubTime = dtpSubTime.Value;
if (Temp == 1)
{
member.DelFlag = 0;
member.MemIntegral = 0;
//添加
}
else if (Temp == 2)
{
//修改
member.MemberId = Convert.ToInt32(labId.Text);
}
MemberInfoBLL bll = new MemberInfoBLL();
string msg = bll.AddOrUpdateMemberInfo(member, Temp) ? "操作成功" : "操作失败";
msgAddOrModify.MsgDivShow(msg, 1, Bind);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
MemberInfoModel _mod = new MemberInfoModel();
MemberInfoBLL bll = new MemberInfoBLL();
_mod = bll.GetModel(userid);
if (_mod != null)
{
_mod.shFlag = Convert.ToInt32(this.rdlshFlag.SelectedValue);
_mod.shPerson = this.txtshPerson.Text;
_mod.shTime = Convert.ToDateTime(this.txtshTime.Value);
_mod.unPassReason = this.txtunPassReason.Text;
_mod.memberStatus = this.rdlmemberStatus.SelectedValue;
_mod.memberCompanyType = GetHyType();
if ((bll.Update(_mod)) > 0)
{
string BackUrl = "MemberList.aspx?PageIndex=" + PageIndex;
/*日志归档*/
string sql = @"select memberName as title from T_Member_Info u where memberId=" + userid + "";
PubFunction.InsertLog("业务管理", "会员管理", "会员列表", "修改", sql, userid.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('操作成功!');layer_close();</script>");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SearchCodeInfo search = new SearchCodeInfo();
string ticket = search.GetAuthorizationTicket("xingzhen", "xz20100722");
JgdmInfo info = search.GetJgdmDetail(ticket, txtjgdm.Text.Trim().Replace("-", "").Replace("－", ""));
if (info.State == "000001")
{
MemberInfoModel model = new MemberInfoModel();
if (checkUsername(KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20)) == "0")
{
model.memberName = KillSqlIn.Form_ReplaceByString(this.txtname.Text, 20);
model.password = KillSqlIn.Form_ReplaceByString(this.txtpw.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密
model.memberLevel = "20";
model.memberType = type;
model.memberCompanyType = "";
model.areaName = "";
model.memberCompanyName = info.jgmc;
model.memberCompanyCode = txtjgdm.Text;
model.memberTrueName = "";
model.sex = "";
model.tel = "";
model.fax = "";
model.mobile = "";
model.address = "";
model.post = "";
model.email = "";
model.regTime = System.DateTime.Now;
model.shFlag = 1;
model.shTime = DateTime.Now;
model.shPerson = "SYS";
model.unPassReason = "";
model.memberStatus = "ZC";//正常：ZC 禁用：JY
model.buyMoneyAccount = 0;
model.buyMoneyAccountUsed = 0;
model.freeMoenyAccount = 0;
model.freeMoenyAccountUsed = 0;
int i = new MemberInfoBLL().Add(model);
if (i > 0)
{
Session["MemberId"] = i.ToString();
Response.Write("<script>alert('注册成功！');layer_close();</script>");
}
else
{
Response.Write("<script>alert('注册失败！');</script>");
}
}
else
{
Response.Write("<script>alert('该用户名已存在！');layer_close();</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('组织机构代码错误！');</script>");
return;
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearch.Text))
{
LoadMemberInfoByDelFlag(0);
return;
}
var temp = 0;
if (char.IsDigit(txtSearch.Text[0]))
{
temp = 2;
}
else
{
temp = 1;
}
var bll = new MemberInfoBLL();
dgvMemmber.AutoGenerateColumns = false;
dgvMemmber.DataSource = bll.GetMemberInfoBySerach(txtSearch.Text, temp);
dgvMemmber.SelectedRows[0].Selected = false;
}
private void btnOk_Click(object sender, EventArgs e)
{
if (CheckTextBoxEmpty())
{
var mem = new MemberInfo();
//MemAddress不要
mem.MemBirthday = Convert.ToDateTime(txtBirs.Text);
mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text);
mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text);
mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text);
mem.MemName = txtMemName.Text;
mem.MemNum = txtMemNum.Text;
mem.MemMobilePhone = txtMemPhone.Text;
mem.MemEndServerTime = Convert.ToDateTime(dtEndServerTime.Value);
mem.MemGender = CheckGender();
mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue);
//判断新增还是修改
if (this._tp == 1)//新增
{
mem.DelFlag = 0;
mem.SubTime = System.DateTime.Now;
}
else if (this._tp == 2)//修改
{
mem.MemberId = Convert.ToInt32(lblId.Text);
}
var bll = new MemberInfoBLL();
var msg = bll.SaveMemberInfo(mem, this._tp) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
this.Close();
}
}
public int insertData(string loginName, byte[] passWord2, string email, string nikeName, string tel, string addr, string infoid, string sitekey)
{
int flag = 0;
LoginInfoModel model = new LoginInfoModel();
model.LoginName = loginName;
model.Password = passWord2;
model.NickName = nikeName;
model.RoleName = "0";//会员
model.ManageTypeID = "2002";
model.MemberGradeID = "1001";
model.IsCheckUp = false;
model.Email = email;
model.Tel = tel;
model.CompanyName = addr;
model.PropertyID = Int32.Parse("0");
//--------会员信息
MemberInfoModel memberModel = new MemberInfoModel();
memberModel.LoginName = loginName;
memberModel.ManageTypeID = "2002";
memberModel.NickName = nikeName;
memberModel.Email = email;
memberModel.Tel = tel;
memberModel.Mobile = "";
memberModel.Birthday = DateTime.Now;
LoginInfoBLL loginfo = new LoginInfoBLL();
MemberInfoBLL member = new MemberInfoBLL();
try
{
try
{
loginfo.LogInfoAdd(model); //向注册表写数据
loc.AdLogin_Add2(model.LoginName.Trim(), infoid, sitekey); //向AdLoginInfoTab表写数据
}
catch (System.Data.SqlClient.SqlException ex)
{
throw (new Exception(ex.Message));
}
int i = member.MemberMessage_Insert(memberModel); //会员信息
if (i > 0)
{
//BBS_Reg.Reg(nikeName, "123456", email); //论坛会员注册
flag = 1;
}
}
catch (Exception exp)
{
flag = -1;
Tz888.Common.MessageBox.ShowBack("数据提交时出错，注册失败。");
}
return(flag);
}
private void LoadCmbMemBer()
{
List <MemberInfo> members = new MemberInfoBLL().GetAllMemberInfoByDelFlag(0);
members.Insert(0, new MemberInfo {
MemName = "请选择", MemberId = -1
});
cmbMember.DataSource = members;
cmbMember.DisplayMember = "MemName";
cmbMember.ValueMember = "MemberId";
}
private void AddXHMember()
{
if (checkUsername(this.txtMemberName.Text.Trim()) == "1")
{
Response.Write("<script>alert('该协会会员已存在！');</script>");
}
else
{
try
{
MemberInfoModel model = new MemberInfoModel();
model.memberName = KillSqlIn.Form_ReplaceByString(this.txtMemberName.Text, 20);
model.password = KillSqlIn.Form_ReplaceByString(this.txtPwd.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密
model.memberLevel = "0";
model.memberType = type;
// model.memberCompanyType = this.ddlMemberType.SelectedValue;
model.memberCompanyType = GetHyType();
model.areaName = "";
model.memberCompanyName = txtXHName.Text;
model.memberCompanyCode = "";
model.memberTrueName = txtTrueName.Text;
model.sex = "";
model.tel = txtTel.Text;
model.fax = "";
model.mobile = "";
model.address = this.txtAddress.Text;
model.post = "";
model.email = "";
model.regTime = System.DateTime.Now;
model.shFlag = 1;
model.shTime = DateTime.Now;
model.shPerson = " ";
model.unPassReason = "";
model.memberStatus = "ZC";//正常：ZC 禁用：JY
model.buyMoneyAccount = 0;
model.buyMoneyAccountUsed = 0;
model.freeMoenyAccount = 0;
model.freeMoenyAccountUsed = 0;
int i = new MemberInfoBLL().Add(model);
if (i > 0)
{
Response.Write("<script>alert('添加成功！');layer_close();</script>");
}
else
{
Response.Write("<script>alert('添加失败！');</script>");
}
}
catch (Exception ee)
{
Response.Write("<script>alert('出错了, 原因：'" + ee.Message + "'');</script>");
}
}
}
/// <summary>
/// 查询所有的会员信息
/// </summary>
/// <param name="v"></param>
private void LoadMemberInfoByDelFlag(int v)
{
MemberInfoBLL bll = new MemberInfoBLL();
dgvMemmber.AutoGenerateColumns = false;//禁止自动生成列
dgvMemmber.DataSource = bll.GetAllMemberInfoByDelFlag(v);
if (dgvMemmber.Rows.Count > 0)
{
dgvMemmber.SelectedRows[0].Selected = false;
}
}
private void LoadAllMemberInfoByDelFlag(int p)
{
var bll = new MemberInfoBLL();
var list = bll.GetAllMemberInfoByDelFlag(0);
list.Insert(0, new MemberInfo {
MemberId = -1, MemName = "请选择"
});
cmbMemmber.DataSource = list;
cmbMemmber.DisplayMember = "MemName";
cmbMemmber.ValueMember = "MemberId";
}
protected void Page_Load(object sender, EventArgs e)
{
//AjaxPro.Utility.RegisterTypeForAjax(typeof(AddXHMember));
type = Request.QueryString["type"] == null ? "" : Request.QueryString["type"].ToString();
id = Request.QueryString["id"] == null ? 0 : Convert.ToInt32(Request.QueryString["id"].ToString());
rd = Request.QueryString["rd"] == null ? 0 : Convert.ToInt32(Request.QueryString["rd"].ToString());
if (!IsPostBack)
{
loadMemberType();
if (rd == 1)
{
this.btnSubmit.Visible = false;
this.Button2.Visible = false;
}
if (type == "XH")
{
this.panel_xh.Visible = true;
if (id != 0)
{
MemberInfoBLL mBll = new MemberInfoBLL();
MemberInfoModel mModel = mBll.GetModel(id);
this.txtAddress.Text = mModel.address;
this.txtXHName.Text = mModel.memberCompanyName;
this.txtMemberName.Text = mModel.memberName;
// this.ddlMemberType.SelectedValue = mModel.memberCompanyType;
SelectType(mModel.memberCompanyType);
this.txtPwd.Text = mModel.password;
this.txtTel.Text = mModel.tel;
this.txtTrueName.Text = mModel.memberTrueName;
this.txtMemberName.ReadOnly = true;
}
}
else if (type == "HZSIS")
{
this.panel_xz.Visible = true;
if (id != 0)
{
MemberInfoBLL mBll = new MemberInfoBLL();
MemberInfoModel mModel = mBll.GetModel(id);
this.txtXZMember.Text = mModel.memberName;
this.txtXZName.Text = mModel.memberCompanyName;
this.txtXZPwd.Text = mModel.password;
this.txtXZTel.Text = mModel.tel;
this.txtXZTrueName.Text = mModel.memberTrueName;
this.txtXZType.Text = mModel.memberCompanyType;
this.txtXZMember.ReadOnly = true;
}
}
}
}
private void bindhy()
{
if (memberid != "")
{
MemberInfoModel mod = new MemberInfoBLL().GetModel(int.Parse(memberid));
if (mod != null)
{
lithym.Text = mod.memberName;
litgsmc.Text = mod.memberCompanyName;
lityx.Text = mod.levelServiceStartTime.ToString("yyyy-MM-dd") + "到" + mod.levelServiceEndTime.ToString("yyyy-MM-dd");
}
}
}
//删除会员
private void btnDelete_Click(object sender, EventArgs e)
{
if (dgvMemmber.SelectedRows.Count <= 0)
{
MessageBox.Show("请选中要删除的数据");
return;
}
int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value.ToString());
MemberInfoBLL bll = new MemberInfoBLL();
string msg = bll.SoftDeleteMemberInfoByNumberId(id) ? "操作成功" : "操作失败";
LoadMemberInfoByDelFlag(0);//刷新
MessageBox.Show(msg);
}
//////////////////////////////////////////////////////////////////////////
// 检查EMAIL是否可注册
private void ValidEmail(string email)
{
MemberInfoBLL memberBll = new MemberInfoBLL();
int result = memberBll.ValidEmail(email);
if (result > 0)
{ //不可用
Response.Write("1");
}
else
{ //可用
Response.Write("0");
}
}
/// <summary>
/// 检查用户名是否可用
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
private void ValidateName(string name)
{
MemberInfoBLL memberBll = new MemberInfoBLL();
int result = memberBll.ValideNameUseable(name);
if (result > 0)
{ //不可用
Response.Write("1");
}
else
{ //可用
Response.Write("0");
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateMember_Click(object sender, EventArgs e)
{
if (dgvMemmber.SelectedRows.Count <= 0)
{
MessageBox.Show("请选择数据");
return;
}
//选中，根据id去数据库查询该行数据的所有信息
MemberInfoBLL bll = new MemberInfoBLL();
int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value);
fea.obj = bll.GetMemmberInfoMemmberId(id);
LoadFrmChangeMember(2);
}
private void Update_AddXZMember()
{
try
{
MemberInfoModel model = new MemberInfoModel();
model.memberId = id;
model.memberName = KillSqlIn.Form_ReplaceByString(this.txtXZMember.Text, 20);
model.password = KillSqlIn.Form_ReplaceByString(this.txtXZPwd.Text, 20);//ValidateUtil.MD5Encrypt(this.txtTwoPwd.Value);不用MD5加密
model.memberLevel = "0";
model.memberType = type;
model.memberCompanyType = this.txtXZType.Text;//部门名称
model.areaName = "";
model.memberCompanyName = this.txtXZName.Text;
model.memberCompanyCode = "";
model.memberTrueName = txtXZTrueName.Text;
model.sex = "";
model.tel = txtXZTel.Text;
model.fax = "";
model.mobile = "";
model.address = "";
model.post = "";
model.email = "";
model.regTime = System.DateTime.Now;
model.shFlag = 1;
model.shTime = DateTime.Now;
model.shPerson = " ";
model.unPassReason = "";
model.memberStatus = "ZC";//正常：ZC 禁用：JY
model.buyMoneyAccount = 0;
model.buyMoneyAccountUsed = 0;
model.freeMoenyAccount = 0;
model.freeMoenyAccountUsed = 0;
int i = new MemberInfoBLL().Update(model);
if (i > 0)
{
Response.Write("<script>alert('修改成功！');layer_close();</script>");
}
else
{
Response.Write("<script>alert('修改失败！');</script>");
}
}
catch (Exception ee)
{
Response.Write("<script>alert('出错了, 原因：'" + ee.Message + "'');</script>");
}
}
private void FrmGuestPay_Load(object sender, EventArgs e)
{
MemberInfoBLL membll = new MemberInfoBLL();
List <MemberInfo> list = membll.GetAllMemberInfoByDelFlag(0);
list.Insert(0, new MemberInfo()
{
MemName = "请选择", MemberId = -1
});
cmbMember.DataSource = list;
cmbMember.DisplayMember = "MemName";
cmbMember.ValueMember = "MemberId";
//显示 该订单所有的菜
LoadAddProByOrder(Convert.ToInt32(labOrderId.Text));
}
private void ValidNickName(string name)
{
MemberInfoBLL memberBll = new MemberInfoBLL();
int result = memberBll.ValidNikeName(name);
//检查昵称是否可注册
if (result > 0)
{ //不可用
Response.Write("1");
}
else
{ //可用
Response.Write("0");
}
}
/// <summary>
/// 获得领导详细信息
/// </summary>
protected void GetMemberCZRecordInfo()
{
model = bll.GetModel(_mid);
if (model != null)
{
int id = Convert.ToInt32(model.memberId);
string strname = new MemberInfoBLL().GetModel(id).memberName;
this.txtName.Text = strname;
this.txtMemberId.Value = model.memberId.ToString();
this.txtMoney.Text = model.money.ToString();
this.ddlMoneyType.SelectedValue = model.moneyType;
this.txtRemarks.Text = model.remarks;
this.txtReleaseDate.Value = Convert.ToDateTime(model.addTime).ToString("yyyy-MM-dd");//发布日期
this.txtAddPerson.Text = model.addPerson;
this.ltlshFlag.Text = model.shFlag == 0 ? "未审核" : "审核";
this.ltlshPerson.Text = model.shPerson == "" ? " " : model.shPerson;
this.ltlshTime.Text = model.shTime.ToString() == "" ? " " : Convert.ToDateTime(model.shTime).ToString("yyyy-MM-dd");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataSet ds = new MemberInfoBLL().GetList("memberName='" + this.txtMemberId.Value + "'");
int id = 0;
if (ds.Tables[0].Rows.Count > 0)
{
id = Convert.ToInt32(ds.Tables[0].Rows[0]["memberId"].ToString());
}
model.memberId = id;// Convert.ToInt32(KillSqlIn.Form_ReplaceByString(this.txtMemberId.Value, 10));
model.money = Convert.ToDecimal(KillSqlIn.Form_ReplaceByString(this.txtMoney.Text, 10));
model.moneyType = KillSqlIn.Form_ReplaceByString(this.ddlMoneyType.SelectedValue, 20);
model.remarks = KillSqlIn.Form_ReplaceByString(this.txtRemarks.Text, 200);
model.addPerson = KillSqlIn.Form_ReplaceByString(this.txtAddPerson.Text, 20);
model.addTime = Convert.ToDateTime(this.txtReleaseDate.Value.Trim());
model.shFlag = 0;
string BackUrl = "MemberCZRecordList.aspx?PageIndex=" + PageIndex + "";
if (_mid != "")
{
model.sysnumber = _mid;
bll.Update(model);
/*日志归档*/
string sql = @"select l.memberId as title from T_Member_AccountRecord l where sysnumber='" + this._mid + "'";
PubFunction.InsertLog("业务管理", "会员列表", "会员充值列表", "修改", sql, _mid);
JSUtility.AlertAndRedirect("修改成功!", BackUrl);
}
else
{
int i = bll.Add(model);
/*日志归档*/
string sql = @"select l.memberId as title from T_Member_AccountRecord l where sysnumber='" + i.ToString() + "'";
PubFunction.InsertLog("业务管理", "会员列表", "会员充值列表", "添加", sql, i.ToString());
JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString());
}
}
private void btnOk_Click(object sender, EventArgs e)
{
MemberInfoBLL memberbll = new MemberInfoBLL();
if (NewCheckEmpty())
{
MemberInfo member = new MemberInfo();
member.MemAddress = txtAddress.Text;
member.MemBirthday = txtBirstday.Value; //生日
member.MemDiscount = float.Parse(txtDiscount.Text); //折扣
member.MemEndTime = txtEndTime.Value; //结束时间
member.MemGender = CheckGender(); //性别
member.MemIntegral = Convert.ToInt32(txtIntegral.Text); //积分
member.MemMobilePhone = txtPhone.Text; //电话
member.MemMoney = float.Parse(txtMoney.Text); //金额
member.MemName = txtName.Text; //会员的名字
member.MemNum = txtNum.Text; //编号
member.MemType = Convert.ToInt32(cmbType.SelectedValue); //会员的类型
string msg = null;
if (status == HandleStatus.Insert)
{
member.SubTime = System.DateTime.Now;
member.DelFlag = 0;
msg = memberbll.AddOrUpdateMemberInfo(member, status) ? "办理成功" : "办理失败";
}
if (status == HandleStatus.Update)
{
member.MemberId = oldMember.MemberId;
member.SubTime = oldMember.SubTime;
member.DelFlag = oldMember.DelFlag;
msg = memberbll.AddOrUpdateMemberInfo(member, status) ? "修改成功" : "修改失败";
}
md.MsgDivShow(msg, 1, Bind);
}
}
private void btnAccounts_Click(object sender, EventArgs e)
{
//更新餐桌状态
DeskInfoBLL dbll = new DeskInfoBLL();
bool dkResult = dbll.UpdateDeskInfoStateByDeskId(Convert.ToInt32(labdkId.Text), 0);
//订单状态改变
OrderInfoBLL ordlbll = new OrderInfoBLL();
OrderInfo order = new OrderInfo();
order.EndTime = System.DateTime.Now;
order.OrderMoney = Convert.ToDouble(lblMoney.Text);
order.OrderState = 2;
order.OrderId = Convert.ToInt32(labOrderId.Text);
if (cmbMember.SelectedIndex != 0)//是会员
{
MemberInfo mem = (MemberInfo)cmbMember.SelectedItem;
order.OrderMemberId = mem.MemberId;
order.DisCount = mem.MemDiscount;//状态
//根据会员的id更新会员的金额
double money = Convert.ToDouble(labyuMoney.Text) - Convert.ToDouble(lblMoney.Text);
MemberInfoBLL membll = new MemberInfoBLL();
membll.UpdateMoneyByMemId(mem.MemberId, money);
}
bool ordResult = ordlbll.UpdateOrderInfo(order);
//改变订单对应订单和菜单的中间表中的菜的状态
R_Order_ProductBLL ropbll = new R_Order_ProductBLL();
bool ropResult = ropbll.UpdateR_Order_ProductByOrderId(Convert.ToInt32(labOrderId.Text));
if (dkResult && ordResult && ropResult)
{
md.MsgDivShow("结账成功", 1, Bind);
}
else
{
md.MsgDivShow("结账失败了", 1);
}
}
private void Bind()
{
MemberInfoBLL memberBll = new MemberInfoBLL();
MemberInfoModel model = memberBll.GetModel(userid);
if (model != null)
{
litUserName.Text = model.memberName;
this.litPassword.Text = model.password;
this.litbuyMoneyAccount.Text = model.buyMoneyAccount.ToString();
this.litfreeMoenyAccount.Text = model.freeMoenyAccount.ToString();
litMemberType.Text = GetMemType(model.memberType);
litAreaName.Text = model.areaName;
//本地 会员原始数据企业类型为类型值，需要对应获取类型名称
litmemberCompanyType.Text = GetHy(model.memberCompanyType);
//外网 会员数据类型企业类型为中文名称，不需要处理
// litmemberCompanyType.Text = model.memberCompanyType;
SelectType(model.memberCompanyType);
litmemberCompanyName.Text = model.memberCompanyName;
litmemberCompanyCode.Text = model.memberCompanyCode;
litmemberTrueName.Text = model.memberTrueName;
litSex.Text = model.sex;
litaddress.Text = model.address;
litPhone.Text = model.tel;
litMobile.Text = model.mobile;
litFax.Text = model.fax;
litPost.Text = model.post;
litEmail.Text = model.email;
litRegDate.Text = Convert.ToDateTime(model.regTime).ToString("yyyy-MM-dd");
rdlshFlag.SelectedValue = model.shFlag.ToString();
rdlmemberStatus.SelectedValue = model.memberStatus;
txtshTime.Value = model.shTime.ToString() != "2011-01-01 00:00:00.000" ? Convert.ToDateTime(model.shTime).ToString("yyyy-MM-dd") : System.DateTime.Now.ToString("yyyy-MM-dd");
txtshPerson.Text = model.shPerson;
txtunPassReason.Text = model.unPassReason;
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string loginName;
string passWord;
string companyname; //单位名称
string country; //国家
int province = 0; //省
int city = 0; //市
int xian = 0; //县
int sid; //机构类别
int serviesgig = 0; //服务大类
string serviesmall; //服务小类
int scale = 0; //企业规模
int capital = 0; //注册资金
string createdate; //企业创建时间
string count; // 营业额
string directions; //主营业务说明
string website; //网址
string linkman; //联系人
string linktel; //联系电话
string fex; //传真号码
string email; //电子邮件
loginName = this.usrname.Value;
passWord = Request.Form["repwd"];
companyname = Request.Form["company"];
country = this.ZoneSelectControl1.CountryID.ToString();
if (this.ZoneSelectControl1.CityID.ToString() != "")
{
city = int.Parse(this.ZoneSelectControl1.CityID.ToString());
}
if (this.ZoneSelectControl1.CountyID.ToString() != "")
{
xian = int.Parse(this.ZoneSelectControl1.CountyID.ToString());
}
if (this.ZoneSelectControl1.ProvinceID.ToString() != "")
{
province = int.Parse(this.ZoneSelectControl1.ProvinceID.ToString());
}
sid = Convert.ToInt32(structid.SelectedItem.Value);
if (ServiesControl.ServicesBID.ToString() != "")
{
string[] Test = ServiesControl.ServicesBID.Split(',');
string TestValue = Test[0].Trim();
serviesgig = Convert.ToInt32(TestValue);
}
if (Request.Form["scale"].ToString() != "")
{
scale = int.Parse(Request.Form["scale"].ToString());
}
serviesmall = ServiesControl.ServicesMID.ToString();
if (Request.Form["capital"].ToString() != "")
{
capital = int.Parse(Request.Form["capital"].ToString());
}
createdate = Request.Form["createdate"];
count = Request.Form["count"];
directions = Request.Form["directions"];
website = Request.Form["website"];
linkman = Request.Form["linkman"];
linktel = Request.Form["linktel"];
fex = Request.Form["fex"];
email = Request.Form["email"];
#region 验证提交的验证码并清空验证码
///--------------------------------------------------
///--验证提交的验证码并清空验证码
///--------------------------------------------------
string vercode = Request.Form["vercode"];
string strRndNum = "";
//SESSION丢失
if (Session["valationNo"] == null)
{
Response.Write("<script>alert('操作超时！请刷新页面！');</script>");
return;
}
else
{
if (vercode.Trim() == "")
{
Response.Write("<script>alert('验证码不能为空，请重新提交！');</script>");
return;
}
else
{
strRndNum = Session["valationNo"].ToString();
if (vercode.Trim() != "" && vercode.ToLower().Trim() == strRndNum.ToLower())
{
Session["valationNo"] = "";
}
else
{
Response.Write("<script>alert('验证码错误，请重新提交！');</script>");
return;
}
}
}
#endregion
//注册信息
SHA1 sha1 = SHA1.Create();
byte[] passWord2 = sha1.ComputeHash(Encoding.Unicode.GetBytes(passWord.Trim()));
LoginInfoModel model = new LoginInfoModel();
if (Request.Cookies["adv_cpa"] != null)
{
HttpCookie logCook = Request.Cookies["adv_cpa"];
model.adsiteID = logCook.Value.ToString();
model.autoReg = 2;
}
model.LoginName = loginName;
model.Password = passWord2;
model.RoleName = "0";//会员
model.ManageTypeID = "2007";
model.MemberGradeID = "1001";
model.IsCheckUp = false;
model.Email = email;
model.Tel = linktel;
model.CompanyName = companyname;
model.NickName = " ";
model.PWDAnswere = "";
model.PWDQuestion = "";
model.RequirInfo = "";
//--------会员信息
MemberInfoModel memberModel = new MemberInfoModel();
memberModel.LoginName = loginName;
memberModel.Email = email;
memberModel.ManageTypeID = "2007";
//memberModel.RequirInfo = requirInfo;
memberModel.Tel = linktel;
memberModel.Mobile = linktel;
memberModel.Birthday = DateTime.Now;
// -------------专业服务机构
Tz888.Model.Register.SS_Agency_Services service = new SS_Agency_Services();
service.LoginName = loginName;
service.OrganName = companyname;
service.OrganType = sid;
service.CountryCode = country;
service.ProvinceID = province;
service.CityID = city;
service.Area = xian;
service.ServiceBigtype = serviesgig;
service.ServiceSmalltype = serviesmall;
service.BusinessCount = scale;
service.BusinessView = directions;
service.Bankroll = capital;
service.FoundDate = createdate;
service.Turnover = count;
service.www = website;
service.LinkName = linkman;
service.Tel = linktel;
service.FAX = fex;
service.Email = email;
service.Regdate = DateTime.Now;
LoginInfoBLL loginfo = new LoginInfoBLL();
Tz888.BLL.Register.SS_Agency_ServicesBLL smode = new SS_Agency_ServicesBLL();
MemberInfoBLL member = new MemberInfoBLL();
try
{
//机构服务表
try
{ smode.AgencyAdd(service); }
catch (System.Data.SqlClient.SqlException ex)
{
throw (new Exception(ex.Message));
}
//向注册表写数据
try
{ loginfo.LogInfoAdd(model); }
catch (System.Data.SqlClient.SqlException ex)
{
throw (new Exception(ex.Message));
}
// 会员信息
int i = member.MemberMessage_Insert(memberModel);
string encryEmail = Server.UrlEncode(DEncrypt.Encrypt(email));
string encryLogname = Server.UrlEncode(DEncrypt.Encrypt(loginName));
string act = Server.UrlEncode(DEncrypt.Encrypt("register"));
string strPass = Server.UrlEncode(DEncrypt.Encrypt(passWord));
string ValidUrl = "ValidSuccessGov.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act + "&PassWord="******"数据提交时出错，注册失败。");
}
finally
{
string encryEmail = Server.UrlEncode(DEncrypt.Encrypt(email));
string encryLogname = Server.UrlEncode(DEncrypt.Encrypt(loginName));
string act = Server.UrlEncode(DEncrypt.Encrypt("register"));
string strPass = Server.UrlEncode(DEncrypt.Encrypt(passWord));
string ValidUrl = "ValidSuccessGov.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act + "&PassWord=" + strPass;
Response.Redirect(ValidUrl, true);
}
}
// protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
private void Click()
{
string loginName;
string passWord;
string nikeName;
string email;
string phone;
string zone;
string country;
string mobile;
string company;
string propertyid;
string invite; //邀请人
//string intent;//意向
//string question;
//string answer;
loginName = this.usrname.Value;
passWord = Request.Form["repwd"];
nikeName = Request.Form["nikename"];
email = Request.Form["email"];
phone = Request.Form["phone"];
zone = Request.Form["zone"];
country = Request.Form["country"];
mobile = Request.Form["mobile"];
company = Request.Form["company"];
propertyid = Request.Form["propertyid"];
invite = Request.Form["invite"];
//intent = Request.Form["intent"];
//question = Request.Form["question"];
//answer = Request.Form["answer"];
phone = country + "-" + zone + "-" + phone;
#region 验证提交的验证码并清空验证码
///--------------------------------------------------
///--验证提交的验证码并清空验证码
///--------------------------------------------------
string vercode = Request.Form["vercode"];
string strRndNum = "";
//SESSION丢失
if (Session["valationNo"] == null)
{
Response.Write("<script>alert('操作超时！请刷新页面！');</script>");
return;
}
else
{
if (vercode.Trim() == "")
{
Response.Write("<script>alert('验证码不能为空，请重新提交！');</script>");
return;
}
else
{
strRndNum = Session["valationNo"].ToString();
if (vercode.Trim() != "" && vercode.ToLower().Trim() == strRndNum.ToLower())
{
Session["valationNo"] = "";
}
else
{
Response.Write("<script>alert('验证码错误，请重新提交！');</script>");
return;
}
}
}
#endregion
//注册信息
SHA1 sha1 = SHA1.Create();
byte[] passWord2 = sha1.ComputeHash(Encoding.Unicode.GetBytes(passWord.Trim()));
LoginInfoModel model = new LoginInfoModel();
if (Request.Cookies["adv_cpa"] != null)
{
HttpCookie logCook = Request.Cookies["adv_cpa"];
model.adsiteID = logCook.Value.ToString().Trim();
model.autoReg = 2;
}
model.LoginName = loginName;
model.Password = passWord2;
model.NickName = nikeName;
//model.PWDAnswere = answer;
//model.PWDQuestion = question;
model.RoleName = "0";//会员
model.ManageTypeID = "2002";
model.MemberGradeID = "1001";
model.IsCheckUp = false;
model.Email = email;
model.Tel = phone;
model.CompanyName = company;
model.PropertyID = Int32.Parse(propertyid);
//model.RequirInfo = intent;
//--------会员信息
MemberInfoModel memberModel = new MemberInfoModel();
memberModel.LoginName = loginName;
memberModel.ManageTypeID = "2002";
memberModel.NickName = nikeName;
memberModel.Email = email;
memberModel.Tel = phone;
//memberModel.RequirInfo = intent;
memberModel.Mobile = mobile;
memberModel.Birthday = DateTime.Now;
LoginInfoBLL loginfo = new LoginInfoBLL();
MemberInfoBLL member = new MemberInfoBLL();
try
{
//向注册表写数据
try
{ loginfo.LogInfoAdd(model); }
catch (System.Data.SqlClient.SqlException ex)
{
throw (new Exception(ex.Message));
}
//会员信息
int i = member.MemberMessage_Insert(memberModel);
//论坛会员注册
if (i > 0)
{
BBS_Reg.Reg(nikeName, passWord, email);
}
//邀请注册
//if (invite.Trim().Length > 0)
//{
// loginfo.InviterRegiste(Request.UserHostAddress, email, invite);
//}
//添加邀请人
//if (loginName.Trim() != "" && invite.Trim() != "")
//{
// AdSystem.Introducer ad = new AdSystem.Introducer();
// ad.AddIntroducer(loginName, invite);
//}
string encryEmail = Server.UrlEncode(DEncrypt.Encrypt(email));
string encryLogname = Server.UrlEncode(DEncrypt.Encrypt(loginName));
string act = Server.UrlEncode(DEncrypt.Encrypt("register"));
string strPass = Server.UrlEncode(DEncrypt.Encrypt(passWord));
string ValidUrl = "RegisterSuccessInvestor.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act + "&PassWord="******"register"));
string strPass = Server.UrlEncode(DEncrypt.Encrypt(passWord));
string ValidUrl = "RegisterSuccessInvestor.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act + "&PassWord=" + strPass;
Response.Redirect(ValidUrl, true);
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string loginName; //帐号
string passWord; //密码
string contactname; //真实姓名
string groupName; //单位名称
string countrycode; //国家
int province = 0; //省
int city = 0; //城市
int area = 0; //县
string contacttitle; //职务
int sid = 0; //人才类别
int ServiesBig = 0; //服务大类
string ServiesSmall; //服务小类
string Resume; //个人简历
string Specialty; //个人特长
string BefCase; //成功案例
string phone; //固定电话
string zone; //固定电话城市区号
string country; //固定电话国家编号
string fax; //传真
string mobile; //手机
string address; //地址
string txtAds1; //相片地址
string email;
string tel;
loginName = this.usrname.Value;
passWord = Request.Form["repwd"];
contactname = Request.Form["contactname"];
groupName = Request.Form["comname"];
countrycode = this.ZoneSelectControl1.CountryID;
if (this.ZoneSelectControl1.ProvinceID.ToString() != "")
{
province = int.Parse(this.ZoneSelectControl1.ProvinceID.ToString());
}
if (this.ZoneSelectControl1.CityID.ToString() != "")
{
city = int.Parse(this.ZoneSelectControl1.CityID.ToString());
}
if (this.ZoneSelectControl1.CountyID.ToString() != "")
{
area = int.Parse(this.ZoneSelectControl1.CountyID.ToString());
}
contacttitle = Request.Form["contacttitle"];
sid = Convert.ToInt32(structid.SelectedItem.Value);
if (ServiesControl._ServicesBID.ToString() != "")
{
string [] str = ServiesControl._ServicesBID.Split(',');
ServiesBig = int.Parse(str[0].ToString());
}
ServiesSmall = ServiesControl._ServicesMID.ToString();
Resume = Request.Form["Resume"];
Specialty = Request.Form["Specialty"];
BefCase = Request.Form["BefCase"];
tel = Request.Form["phone"];
zone = Request.Form["zone"];
country = Request.Form["country"];
fax = this.fax.Value;
mobile = Request.Form["mobile"];
address = Request.Form["address"];
txtAds1 = Request.Form["txtAds1"];
email = Request.Form["email"];
phone = country + "-" + zone + "-" + tel;
#region 验证提交的验证码并清空验证码
///--------------------------------------------------
///--验证提交的验证码并清空验证码
///--------------------------------------------------
string vercode = Request.Form["vercode"];
string strRndNum = "";
//SESSION丢失
if (Session["valationNo"] == null)
{
Response.Write("<script>alert('操作超时！请刷新页面！');</script>");
return;
}
else
{
if (vercode.Trim() == "")
{
Response.Write("<script>alert('验证码不能为空，请重新提交！');</script>");
return;
}
else
{
strRndNum = Session["valationNo"].ToString();
if (vercode.Trim() != "" && vercode.ToLower().Trim() == strRndNum.ToLower())
{
Session["valationNo"] = "";
}
else
{
Response.Write("<script>alert('验证码错误，请重新提交！');</script>");
return;
}
}
}
#endregion
//注册信息
SHA1 sha1 = SHA1.Create();
byte[] passWord2 = sha1.ComputeHash(Encoding.Unicode.GetBytes(passWord.Trim()));
LoginInfoModel model = new LoginInfoModel();
model.LoginName = loginName;
model.Password = passWord2;
model.RoleName = "0";//会员
model.ManageTypeID = "2006";
model.MemberGradeID = "1001";
model.IsCheckUp = false;
model.Email = email;
model.Tel = phone;
//--------会员信息
MemberInfoModel memberModel = new MemberInfoModel();
memberModel.LoginName = loginName;
memberModel.ManageTypeID = "2006";
memberModel.Email = email;
memberModel.Tel = phone;
memberModel.Mobile = mobile;
memberModel.CountryCode = country;
memberModel.CountyID = city.ToString();
memberModel.ProvinceID = province.ToString();
memberModel.Address = address;
memberModel.Birthday = DateTime.Now;
Tz888.Model.Register.SS_ProfessionalServices fesModel = new Tz888.Model.Register.SS_ProfessionalServices();
fesModel.LoginName = loginName;
fesModel.NnitName = groupName;
fesModel.CountryCode = countrycode;
fesModel.CityID = city;
fesModel.ProvinceID = province;
fesModel.AreaID = area;
fesModel.Job = contacttitle;
fesModel.TalentType = sid;
fesModel.ServiceBigtype = ServiesBig;
fesModel.ServiceSmalltype = ServiesSmall;
fesModel.Resume = Resume;
fesModel.Specialty = Specialty;
fesModel.BefCase = BefCase;
fesModel.Tel = phone;
fesModel.Mobile = mobile;
fesModel.FAX = fax;
fesModel.Email = email;
fesModel.Address = address;
if (txtAds1 != null && txtAds1 != "")
{
fesModel.Pic = txtAds1;
}
else
{
fesModel.Pic = "Img/photo.jpg";
}
fesModel.RegDate = DateTime.Now;
fesModel.RealName = contactname;
LoginInfoBLL loginfo = new LoginInfoBLL();
Tz888.BLL.Register.SS_ProfessionalServices pro = new Tz888.BLL.Register.SS_ProfessionalServices();
MemberInfoBLL member = new MemberInfoBLL();
//向注册表写数据
try
{ loginfo.LogInfoAdd(model);
// 注册
pro.ProfessionalAdd(fesModel);
try
{
int i = member.MemberMessage_Insert(memberModel);
}
catch (System.Data.SqlClient.SqlException exp)
{
throw (new Exception(exp.Message));
}
// 会员信息
string encryEmail = Server.UrlEncode(DEncrypt.Encrypt(email));
string encryLogname = Server.UrlEncode(DEncrypt.Encrypt(loginName));
string act = Server.UrlEncode(DEncrypt.Encrypt("register"));
string ValidUrl = "ValidSuccessEnter.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act;
Response.Redirect(ValidUrl, true); }
catch (Exception ex)
{
Response.Write(ex.Message);
Tz888.Common.MessageBox.ShowBack("数据提交时出错,注册失败。");
}
finally
{
string encryEmail = Server.UrlEncode(DEncrypt.Encrypt(email));
string encryLogname = Server.UrlEncode(DEncrypt.Encrypt(loginName));
string act = Server.UrlEncode(DEncrypt.Encrypt("register"));
string ValidUrl = "ValidSuccessGov.aspx?email=" + encryEmail + "&logname=" + encryLogname + "&act=" + act;
Response.Redirect(ValidUrl, true);
}
}
