/// <summary>
/// 得到会员信息
/// </summary>
/// <param name="phone"></param>
/// <returns></returns>
public MemberInfoModel GetMember(string phone)
{
string sqltxt = @"SELECT ID ,
TruethName ,
MobileNum,MStatus
FROM dbo.MemberInfo
WHERE MobileNum = @MobileNum";
SqlParameter[] paramter =
{
new SqlParameter("@MobileNum", phone)
};
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
if (dt.Rows.Count > 0)
{
MemberInfoModel model = new MemberInfoModel();
model.ID = int.Parse(dt.Rows[0]["ID"].ToString());
model.TruethName = dt.Rows[0]["TruethName"].ToString();
model.MobileNum = dt.Rows[0]["MobileNum"].ToString();
model.MStatus = dt.Rows[0]["MStatus"].ToString().ParseToInt(1);
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到会员信息
/// </summary>
/// <param name="phone"></param>
/// <returns></returns>
public MemberInfoModel GetMember(int mid)
{
string sqltxt = @"SELECT ID ,
TruethName ,
MobileNum
FROM dbo.MemberInfo
WHERE ID = @Mid";
SqlParameter[] paramter =
{
new SqlParameter("@Mid", mid)
};
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
if (dt.Rows.Count > 0)
{
MemberInfoModel model = new MemberInfoModel();
model.ID = int.Parse(dt.Rows[0]["ID"].ToString());
model.TruethName = dt.Rows[0]["TruethName"].ToString();
model.MobileNum = dt.Rows[0]["MobileNum"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 接受帮助单据信息页面
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public ActionResult AcceptOrderDetail(int orderid)
{
MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
if (logmember == null)
{
return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
}
AcceptOrderViewModel model = new AcceptOrderViewModel();
AcceptHelpOrderModel order = aobll.GetAcceptOrderInfo(orderid, logmember.ID);
if (order == null)
{
return(RedirectToAction("Index", "WebHome", new { area = "NewTemplateArea" }));
}
//本人的信息
model.acceptpeople = logmember;
//匹配列表单据信息和会员信息及推荐人联系方式
List <HelpOrderExtendInfoModel> acceptmodel = aobll.GetHelpextendmodels(orderid);
model.helpOrderInfo = acceptmodel;
model.acceptorder = order;
ViewBag.PageTitle = web.WebName;
return(View(model));
}
/// <summary>
/// 得到该分配利息的会员
/// </summary>
/// <param name="day"></param>
/// <returns></returns>
public static List <MemberInfoModel> GetPaymentInterestMembers(int day)
{
List <MemberInfoModel> members = new List <MemberInfoModel>();
string sqltxt = @"SELECT MemberID ,
b.MobileNum ,
b.TruethName
FROM dbo.MemberExtendInfo A
INNER JOIN dbo.MemberInfo B ON A.MemberID = b.ID
WHERE ( DATEDIFF(DAY, LastHelperTime, GETDATE()) + 1 ) <=@days";
SqlParameter[] paramter =
{
new SqlParameter("@days", day)
};
DataTable dt = helper.Query(sqltxt, paramter).Tables[0];
foreach (DataRow item in dt.Rows)
{
MemberInfoModel model = new MemberInfoModel();
model.ID = item["MemberID"].ToString().ParseToInt(0);
model.TruethName = item["TruethName"].ToString();
model.MobileNum = item["MobileNum"].ToString();
}
return(members);
}
//绑定信息
public void readInfo()
{
MemberInfoModel memberInfoModel = MemberInfoModifyBll.getMemberInfo(Session["Member"].ToString());
DataTable dt = DetialQueryBLL.GetMemberInfoBalanceByNumber(ExpectNum, Session["Member"].ToString());
if (dt.Rows.Count > 0)
{
lblNewPeople.Text = dt.Rows[0]["CurrentNewNetNum"].ToString();
if (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString())) == 0)
{
lblNewYeji.Text = "0.00";
lblTotalYeji.Text = "0.00";
lblCurrentOneMark2.Text = "0.00";
lblTotalOneMark2.Text = "0.00";
}
else
{
lblNewYeji.Text = (double.Parse(dt.Rows[0]["CurrentTotalNetRecord"].ToString())).ToString("0.00");
lblTotalYeji.Text = (double.Parse(dt.Rows[0]["TotalNetRecord"].ToString())).ToString("0.00");
lblCurrentOneMark2.Text = (double.Parse(dt.Rows[0]["CurrentOneMark2"].ToString())).ToString("0.00");
lblTotalOneMark2.Text = (double.Parse(dt.Rows[0]["TotalOneMark2"].ToString())).ToString("0.00");
}
lblTotalPeople.Text = dt.Rows[0]["TotalNetNum"].ToString();
}
}
/// <summary>
/// 为会员分派奖金
/// </summary>
/// <param name="memberphone"></param>
/// <param name="money"></param>
/// <returns></returns>
public string FenPaiMoney(string memberphone, decimal money)
{
string result = "0";
MemberInfoModel member = MemberInfoDAL.GetMember(memberphone);
if (member == null)
{
return("0无此会员");
}
using (TransactionScope scope = new TransactionScope())
{
int rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFunds(member.ID, money, member.TruethName, member.MobileNum);
if (rowcount < 1)
{
return("0操作失败");
}
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = member.ID;
logmodel.MemberName = member.TruethName;
logmodel.MemberPhone = member.MobileNum;
logmodel.OrderCode = "";
logmodel.OrderID = 0;
logmodel.ProduceMoney = money;
logmodel.Remark = "会员:" + member.MobileNum + " 得到系统派发的奖金";
logmodel.Type = 3;
rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0操作失败");
}
scope.Complete();
result = "1";
}
return(result);
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public Tz888.Model.Register.MemberInfoModel GetModel(string strCriteria)
{
DataTable dt = obj.GetList("MemberInfoTab", "*", "LoginName", 1, 1, 0, 1, strCriteria);
Tz888.Model.Register.MemberInfoModel model = new MemberInfoModel();
if (dt.Rows.Count > 0)
{
model.LoginName = dt.Rows[0]["LoginName"].ToString();
model.MemberName = dt.Rows[0]["MemberName"].ToString();
if (dt.Rows[0]["Sex"].ToString() != "")
{
if ((dt.Rows[0]["Sex"].ToString() == "1") || (dt.Rows[0]["Sex"].ToString().ToLower() == "true"))
{
model.Sex = true;
}
else
{
model.Sex = false;
}
}
model.NickName = dt.Rows[0]["NickName"].ToString();
if (dt.Rows[0]["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(dt.Rows[0]["Birthday"].ToString());
}
model.CertificateID = dt.Rows[0]["CertificateID"].ToString();
model.CertificateNumber = dt.Rows[0]["CertificateNumber"].ToString();
model.CountryCode = dt.Rows[0]["CountryCode"].ToString();
model.ProvinceID = dt.Rows[0]["ProvinceID"].ToString();
model.CountyID = dt.Rows[0]["CountyID"].ToString();
model.Address = dt.Rows[0]["Address"].ToString();
model.PostCode = dt.Rows[0]["PostCode"].ToString();
model.Tel = dt.Rows[0]["Tel"].ToString();
model.Mobile = dt.Rows[0]["Mobile"].ToString();
model.FAX = dt.Rows[0]["FAX"].ToString();
model.Email = dt.Rows[0]["Email"].ToString();
if (dt.Rows[0]["IsSecurity"].ToString() != "")
{
if ((dt.Rows[0]["IsSecurity"].ToString() == "1") || (dt.Rows[0]["IsSecurity"].ToString().ToLower() == "true"))
{
model.IsSecurity = true;
}
else
{
model.IsSecurity = false;
}
}
model.ManageTypeID = dt.Rows[0]["ManageTypeID"].ToString();
model.RequirInfo = dt.Rows[0]["RequirInfo"].ToString();
model.RequirInfoDesc = dt.Rows[0]["RequirInfoDesc"].ToString();
model.HeadPortrait = dt.Rows[0]["HeadPortrait"].ToString();
return(model);
}
else
{
return(null);
}
}
public void r107Implementation(MemberInfoModel instance)
{
// This is the placeholder for method implementation.
if (Arguments.SelectedValues.Count() > 0)
{
string value = string.Join(",", ActionArgs.Current.SelectedValues);
/// Result.NavigateUrl = String.Format("~/Pages/StudentPassword.aspx?ClassStudent={0}", value, false);
}
MailMessage message = new MailMessage();
message.From = new MailAddress("*****@*****.**", "Sales, Code OnTime");
// prepare smtp client
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential("*****@*****.**", "kabir31bd@!#");
// compose and send an email message
// use CustomerID to find the recipient's email
string sendTo = "*****@*****.**";
//// message.Sender = "*****@*****.**";
message.To.Add(sendTo);
message.Subject = String.Format("Hello {0} at {1}.", instance.NameOfMember, instance.CellPhone);
message.Body = "Hello there!" + " My new Email Sender";
smtp.Send(message);
Result.ShowAlert("Email has been sent.");
}
/// <summary>
/// 编辑基本信息
/// </summary>
public void editxtBasic()
{
txtEnumber.Visible = false;
txtEname.Visible = true;
txtEnickname.Visible = true;
txtEstore.Visible = true;
txtEIdtype.Visible = true;
txtEsex.Visible = true;
txtEbirthday.Visible = true;
txtEidnumber.Visible = true;
CountryCityPCode1.Visible = true;
txtEaddress.Visible = true;
txtEcode.Visible = true;
txtEmethod.Visible = true;
txtEcurrency.Visible = true;
labenc.Visible = true;
lblEnumber.Visible = true;
lblEname.Visible = false;
lblEnickname.Visible = false;
lblEstore.Visible = false;
lblEIdtype.Visible = false;
lblEsex.Visible = false;
lblEbirthday.Visible = false;
lblEidnumber.Visible = false;
lblEaddress.Visible = false;
lblEcode.Visible = false;
lblEmethod.Visible = false;
lblEcurrency.Visible = false;
//tbephoto.Visible = true;
//默认的会员编号是
MemberInfoModel model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());
MemberOrderModel order = MemberOrderBLL.GetMemberOrder(model.OrderID);
//绑定证件类型
bindidtype();
Translations();
txtEnumber.Text = model.Number;
txtEname.Text = Encryption.Encryption.GetDecipherName(model.Name);
txtEnickname.Text = model.PetName;
txtEstore.Text = model.StoreID;
try
{
txtEIdtype.SelectedValue = model.PaperType.PaperTypeCode.Trim();
}
catch (Exception exe1)
{
txtEIdtype.SelectedValue = "P000";
}
txtEsex.SelectedIndex = model.Sex == 0 ? 1 : 0;
txtEbirthday.Text = model.Birthday.ToString("yyyy-MM-dd");
txtEidnumber.Text = Encryption.Encryption.GetDecipherNumber(model.PaperNumber.ToString().Trim());
CountryCityPCode1.SelectCountry(model.City.Country, model.City.Province, model.City.City, model.City.Xian);
txtEaddress.Text = Encryption.Encryption.GetDecipherAddress(model.Address.ToString().Trim());;
txtEcode.Text = model.PostalCode.ToString();
lblEbankname.Text = Encryption.Encryption.GetDecipherName(model.BankBook);
}
/// <summary>
/// 添加的时，绑定信息
/// </summary>
private void AddBind()
{
//购货店铺，默认为注册店铺
TxtStore.Text = GetStoreId();
//绑定产品树
ProductTree myTree = new ProductTree();
this.menuLabel.Text = myTree.getMemberProductList(GetStoreId());
//绑定会员信息
MemberInfoModel mi = MemberInfoModifyBll.getMemberInfo(GetMember());
lblNumber.Text = mi.Number;
lblName.Text = Encryption.Encryption.GetDecipherName(mi.Name);
this.Txtxm.Text = Encryption.Encryption.GetDecipherName(mi.Name);
this.Txtyb.Text = mi.PostalCode;
this.Email.Text = mi.Email;
this.Txtjtdh.Text = Encryption.Encryption.GetDecipherTele(mi.HomeTele);
this.Txtyddh.Text = Encryption.Encryption.GetDecipherTele(mi.MobileTele);
//this.CountryCity1.SelectCountry(mi.City.Country, mi.City.Province, mi.City.City,mi.City.Xian);
//this.Txtdz.Text = Encryption.Encryption.GetDecipherAddress(mi.Address);
//this.rdPayType.Enabled = true;
//this.rdPayType.AutoPostBack = true;
//this.dzpanel.Visible = false;
}
/// <summary>
/// 查看联系信息
/// </summary>
public void SellblContact()
{
lblEmobile.Visible = true; //移动电话
lblEphone.Visible = true; //家庭电话
lblEfax.Visible = true; //传真电话
lblEOffphone.Visible = true; //办公电话
lblEemail.Visible = true; //Email
this.divBg.Visible = false;
this.divCz.Visible = false;
this.divJt.Visible = false;
this.txtEmobile.Visible = false;
this.txtEemail.Visible = false;
//this.TxtjtdhQh.Visible = false;
//Txtjtdh.Visible = false;//家庭电话
//this.TxtczdhQh.Visible = false;
//Txtczdh.Visible = false;//传真电话
//this.TxtbgdhFj.Visible = false;
//this.TxtbgdhQh.Visible = false;
//Txtbgdh.Visible = false;//办公电话
//this.TxtbgdhFj.Visible = false;
//默认的会员编号是8888888888s
MemberInfoModel model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());
//MemberOrderModel order = MemberOrderBLL.GetMemberOrder(model.OrderID);
lblEmobile.Text = Encryption.Encryption.GetDecipherTele(model.MobileTele);
lblEphone.Text = Encryption.Encryption.GetDecipherTele(model.HomeTele);
lblEfax.Text = Encryption.Encryption.GetDecipherTele(model.FaxTele);
lblEOffphone.Text = Encryption.Encryption.GetDecipherTele(model.OfficeTele);
lblEemail.Text = model.Email;
}
public ActionResult AddacceptReporting(int orderid, string reason, string title, string text)
{
MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
if (logmember == null)
{
return(RedirectToAction("Index", "Login", new { area = "WebFrontArea" }));
}
OrderReportingModel model = new OrderReportingModel();
model.OrderID = orderid;
model.MemberID = logmember.ID;
model.MemberName = logmember.TruethName;
model.MemberPhone = logmember.MobileNum;
model.Title = title;
model.ReportingText = text;
model.ReasonType = reason;
int row = reportbll.AddReportForAcceptDetail(model);
if (row > 0)
{
return(Json("1"));
}
else
{
return(Json("0"));
}
}
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;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Permissions.MemRedirect(Page, Permissions.redirUrl);
if (!IsPostBack)
{
try
{
type = Request.QueryString["type"] == "" ? "" : Request.QueryString["type"];
url = Request.QueryString["url"] == "" ? "" : Request.QueryString["url"];
var Member = Session["Member"];
if (Member != null)
{
MemberInfoModel member = MemInfoEditBLL.getMemberInfo(Member.ToString());
if (member != null)
{
txtzhifubao.Text = member.Zhifubao;
txtName.Text = member.Name;
}
}
else
{
Response.Redirect("../index.aspx");
}
}
catch (Exception ex)
{
Response.Redirect("../index.aspx");
}
}
}
/// <summary>
/// 编辑帐户信息
/// </summary>
public void edilblBank()
{
lblEbankname.Visible = true; //开户名
lblEbank.Visible = false; //开户银行
lblEbanknumber.Visible = false; //银行卡号
lblEbankaddress.Visible = false; //银行地址
CcpEbankaddress.Visible = true;
plEbank.Visible = true; //开户银行
txtEbanknumber.Visible = true; //银行卡号
txtEbankaddress.Visible = true; //银行地址
CountryCityPCode2.Visible = true;
//默认的会员编号是8888888888s
MemberInfoModel model = MemInfoEditBLL.getMemberInfo(ViewState["membernumberE"].ToString());
txtEbank.Text = model.Bankbranchname;
ViewState["bankcode"] = model.BankCode;
txtEbanknumber.Text = Encryption.Encryption.GetDecipherCard(model.BankCard);
CityModel cityM = CommonDataDAL.GetCPCCode(model.BCPCCode);
CountryCityPCode2.SelectCountry(cityM.Country, cityM.Province, cityM.City, cityM.Xian);
txtEbankaddress.Text = Encryption.Encryption.GetDecipherAddress(model.BankAddress);
BindCountry();
}
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>");
}
}
}
/// <summary>
/// 接受帮助列表页面
/// </summary>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult acceptOrderlist(AcceptHelpOrderModel seachmodel, int page = 1)
{
MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
if (logmember == null)
{
return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
}
AcceptOrderListViewModel model = new AcceptOrderListViewModel();
int totalcount = 0;
seachmodel.MemberID = logmember.ID;
seachmodel.PageIndex = page;
seachmodel.PageSize = pagesize;
List <AcceptHelpOrderModel> orderlist = aobll.GetAllAcceptOrderListForPage(seachmodel, out totalcount);
PagedList <AcceptHelpOrderModel> pagelist = null;
if (orderlist != null)
{
pagelist = new PagedList <AcceptHelpOrderModel>(orderlist, page, pagesize, totalcount);
}
model.orderlist = pagelist;
ViewBag.PageTitle = web.WebName;
return(View(model));
}
public void LoadDataAAA()
{
int tp = 0;
if (Request.QueryString["tp"] != null)
{
try
{
tp = Convert.ToInt32(Request.QueryString["tp"]);
}
catch {
tp = 0;
}
}
Session["cpage"] = tp;
string number = Session["member"].ToString();
decimal todayprice = Common.GetnowPrice();
hidprice.Value = todayprice.ToString("0.0000");
mrjg.Text = todayprice.ToString("0.0000");
mcjg.Text = todayprice.ToString("0.0000");
lbltodayprice.Text = todayprice.ToString("0.0000");
MemberInfoModel mb = MemberInfoDAL.getMemberInfo(number);
decimal de = Convert.ToDecimal(DBHelper.ExecuteScalar("select para15 from config where ExpectNum=" + CommonDataBLL.getMaxqishu() + " "));
lblzzlv.Text = (de * 100).ToString("0.00") + "%";
decimal ca = 0;
decimal usdt = 0;
DataTable dt = DBHelper.ExecuteDataTable("select jackpot-out-membership as usdt ,pointAin-pointAout-pointAfz as ca from memberinfo where number='" + number + "'");
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
ca = Convert.ToDecimal(dr["ca"]);
usdt = Convert.ToDecimal(dr["usdt"]);
}
decimal sxfbl = Common.GetSxfWyjblv(0);
decimal wyjbl = Common.GetSxfWyjblv(1);
//decimal wyjjb = blace*wyjbl; //违约金石斛积分数量
//decimal sxfjb =sxfbl*blace ; //手续费石斛积分数量
hidblance.Value = ca.ToString("0.0000"); ///卖出数量余额
sellsz.Text = "0";
// lblmaxsell.Text = (blace / (1 + sxfbl + wyjbl)).ToString("0.00");
mairu = Convert.ToInt32(usdt / todayprice).ToString();
qbye.Text = mairu;
hidusdtblc.Value = usdt.ToString("0.0000");
//MobileTele.Value = mb.MobileTele;
}
public ActionResult EditMember(MemberInfoModel member)
{
if (member != null)
{
bool row = bll.UpdateMemberInfo(member);
}
return(RedirectToActionPermanent("Index", "MemberOpera", new { area = "AdminArea" }));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddMemberInfo(MemberInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberInfo(");
strSql.Append("Area,Address,WeixinNum,AliPayName,AliPayNum,SecurityQuestion,SecurityAnswer,LogPwd,MStatus,AddTime,TruethName,Sex,TelPhone,MobileNum,Email,IdentificationID,Province,City");
strSql.Append(") values (");
strSql.Append("@Area,@Address,@WeixinNum,@AliPayName,@AliPayNum,@SecurityQuestion,@SecurityAnswer,@LogPwd,1,GETDATE(),@TruethName,@Sex,@TelPhone,@MobileNum,@Email,@IdentificationID,@Province,@City");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Area", SqlDbType.NVarChar),
new SqlParameter("@Address", SqlDbType.NVarChar),
new SqlParameter("@WeixinNum", SqlDbType.NVarChar),
new SqlParameter("@AliPayName", SqlDbType.NVarChar),
new SqlParameter("@AliPayNum", SqlDbType.NVarChar),
new SqlParameter("@SecurityQuestion", SqlDbType.NVarChar),
new SqlParameter("@SecurityAnswer", SqlDbType.NVarChar),
new SqlParameter("@LogPwd", SqlDbType.NVarChar),
new SqlParameter("@TruethName", SqlDbType.NVarChar),
new SqlParameter("@Sex", SqlDbType.Int),
new SqlParameter("@TelPhone", SqlDbType.NVarChar),
new SqlParameter("@MobileNum", SqlDbType.NVarChar),
new SqlParameter("@Email", SqlDbType.NVarChar),
new SqlParameter("@IdentificationID", SqlDbType.NVarChar),
new SqlParameter("@Province", SqlDbType.NVarChar),
new SqlParameter("@City", SqlDbType.NVarChar)
};
parameters[0].Value = model.Area;
parameters[1].Value = model.Address;
parameters[2].Value = model.WeixinNum;
parameters[3].Value = model.AliPayName;
parameters[4].Value = model.AliPayNum;
parameters[5].Value = model.SecurityQuestion;
parameters[6].Value = model.SecurityAnswer;
parameters[7].Value = model.LogPwd;
parameters[8].Value = model.TruethName;
parameters[9].Value = model.Sex;
parameters[10].Value = model.TelPhone;
parameters[11].Value = model.MobileNum;
parameters[12].Value = model.Email;
parameters[13].Value = model.IdentificationID;
parameters[14].Value = model.Province;
parameters[15].Value = model.City;
object obj = helper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 调用存储过程
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertMemberInfo(MemberInfoModel model, SqlTransaction tran)
{
//SqlTransaction tran = null;
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Number", model.Number),
new SqlParameter("@Placement", model.Placement),
new SqlParameter("@Recommended", model.Direct),
new SqlParameter("@ExpectNum", model.ExpectNum),
new SqlParameter("@OrderID", model.OrderID),
new SqlParameter("@StoreID", model.StoreID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@PetName", model.PetName),
new SqlParameter("@LoginPass", model.LoginPass),
new SqlParameter("@Advpass", model.AdvPass),
//new SqlParameter("@LevelStr", model.LevelStr),
new SqlParameter("@LevelInt", model.LevelInt),
new SqlParameter("@RegisterDatec", model.RegisterDate),
new SqlParameter("@Birthday", model.Birthday),
new SqlParameter("@Sex", model.Sex),
new SqlParameter("@HomeTele", model.HomeTele),
new SqlParameter("@OfficeTele", model.OfficeTele),
new SqlParameter("@MobileTele", model.MobileTele),
new SqlParameter("@FaxTele", model.FaxTele),
//new SqlParameter("@Country", model.Country),
//new SqlParameter("@Province", model.Province),
//new SqlParameter("@City", model.City),
new SqlParameter("@CPCCode", model.CPCCode),
new SqlParameter("@Address", model.Address),
new SqlParameter("@PostalCode", model.PostalCode),
new SqlParameter("@PaperTypeCode", model.PaperType.PaperTypeCode),
new SqlParameter("@PaperNumber", model.PaperNumber),
new SqlParameter("@BankCode", model.BankCode),
new SqlParameter("@BankAddress", model.BankAddress),
new SqlParameter("@BankCard", model.BankCard),
//new SqlParameter("@BankCountry", model.BankCountry),
//new SqlParameter("@BankProvince", model.BankProvince),
//new SqlParameter("@BankCity", model.BankCity),
new SqlParameter("@BCPCCode", model.BCPCCode),
new SqlParameter("@BankBook", model.BankBook),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@ChangeInfo", model.ChangeInfo),
new SqlParameter("@Photopath", model.PhotoPath),
new SqlParameter("@Email", model.Email),
new SqlParameter("@IsBatch", model.IsBatch),
new SqlParameter("@Language", model.Language),
new SqlParameter("@OperateIP", model.OperateIp),
new SqlParameter("@OperaterNumber", model.OperaterNum),
new SqlParameter("@District", model.District),
new SqlParameter("@Answer", model.Answer),
new SqlParameter("@Question", model.Question),
new SqlParameter("@Err", model.Error),
new SqlParameter("@BankBranchName", model.Bankbranchname),
};
return(DBHelper.ExecuteNonQuery(tran, "UP_MemberInfo_ADD", para, CommandType.StoredProcedure));
}
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);
}
/// <summary>
/// 退出系统
/// </summary>
/// <returns></returns>
public ActionResult exitsystem()
{
MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
if (logmember != null)
{
Session.Remove(AppContent.SESSION_WEB_LOGIN);
}
return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
}
public ActionResult AddMember(MemberInfoModel member)
{
if (member != null)
{
member.MStatus = 1;
member.LogPwd = DESEncrypt.Encrypt("666666", AppContent.SecrectStr);//加密密码
string row = bll.AddMemberInfo(member);
}
return(RedirectToActionPermanent("Index", "MemberOpera", new { area = "AdminArea" }));
}
public void GetDetial(string Number)
{
MemberInfoModel member = MemInfoEditBLL.getMemberInfo(Number);
this.Number.Text = member.Number.ToString();
if (!BLL.CommonClass.CommonDataBLL.GetRole2(Session["Company"].ToString(), true))
{
this.Placement.Text = "";
}
else
{
this.Placement.Text = member.Placement.ToString();
}
if (!BLL.CommonClass.CommonDataBLL.GetRole2(Session["Company"].ToString(), false))
{
this.Recommended.Text = "";
}
else
{
this.Recommended.Text = member.Direct.ToString();
}
//this.Placement.Text = member.Placement.ToString();
//this.Recommended.Text = member.Direct.ToString();
this.Name.Text = Encryption.Encryption.GetDecipherName(member.Name.ToString());
this.PetName.Text = member.PetName.ToString();
this.Birthday.Text = member.Birthday.ToString("yyyy-MM-dd");
if (Convert.ToInt32(member.Sex) == 0)
{
this.Sex.Text = GetTran("000095", "女");
}
else
{
this.Sex.Text = GetTran("000094", "男");
}
this.PostolCode.Text = member.PostalCode.ToString();
this.HomeTele.Text = Encryption.Encryption.GetDecipherTele(member.HomeTele.ToString());
this.OfficeTele.Text = Encryption.Encryption.GetDecipherTele(member.OfficeTele.ToString());
this.FaxTele.Text = Encryption.Encryption.GetDecipherTele(member.FaxTele.ToString());
labEmail.Text = member.Email.ToString();
this.MoblieTele.Text = member.MobileTele.ToString();
//this.Country.Text = member.Country.ToString() + member.Province.ToString() + member.City.ToString() + member.Address.ToString();
this.Country.Text = member.City.Country + member.City.Province + member.City.City + member.City.Xian + Encryption.Encryption.GetDecipherAddress(member.Address);
this.PaperNumber.Text = Encryption.Encryption.GetDecipherNumber(member.PaperNumber.ToString());
this.PaperType.Text = member.PaperType.PaperType.ToString();
this.Bank.Text = member.Bank.BankName.ToString() + member.Bankbranchname.ToString();
// this.BankAddress.Text = member.BankCountry.ToString() + member.BankProvince.ToString()+member.BankCity.ToString()+member.BankAddress.ToString();
this.BankAddress.Text = member.BankCity.Country + member.BankCity.Province + member.BankCity.City + Encryption.Encryption.GetDecipherAddress(member.BankAddress.ToString());
this.BankNum.Text = Encryption.Encryption.GetDecipherCard(member.BankCard.ToString());
this.BankBook.Text = Encryption.Encryption.GetDecipherName(member.BankBook.ToString());
this.ExpectNum.Text = member.ExpectNum.ToString();
this.Remark.Text = member.Remark.ToString();
}
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>");
}
}
}
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;
}
}
}
}
public ActionResult updatepwd(string pwd)
{
if (string.IsNullOrWhiteSpace(pwd))
{
return(Json("0"));
}
MemberInfoModel logmember = Session[AppContent.SESSION_WEB_LOGIN] as MemberInfoModel;
string newpwd = DESEncrypt.Encrypt(pwd, AppContent.SecrectStr);
int row = bll.UpdateUserPwd(logmember.ID, newpwd);
return(Json(row));
}
public ActionResult Index(string bl = "")
{
string name = SysAdminConfigBLL.GetConfigValue(23);
if (name == "NewTemplateArea")
{
return(RedirectToAction("Index", "Login", new { area = "NewTemplateArea" }));
}
MemberInfoModel model = new MemberInfoModel();
ViewBag.PageTitle = web.WebName;
return(View(model));
}
/// <summary>
/// 修改时绑定信息
/// </summary>
private void EditBind()
{
//this.rdPayType.Enabled = false;
//this.dzpanel.Visible = false;
string OrderId = GetOrderId();
//绑定产品树
ProductTree myTree = new ProductTree();
myTree.Orderid = OrderId;
this.menuLabel.Text = myTree.getEditMenu10(GetStoreId(), GetOrderId());
//绑定产品信息
UptTree(OrderId);
//绑定会员信息
MemberInfoModel mi = MemberInfoModifyBll.getMemberInfo(GetMember());
lblNumber.Text = mi.Number;
lblName.Text = Encryption.Encryption.GetDecipherName(mi.Name);
//绑定订单信息
MemberOrderModel mo = MemberOrderAgainBLL.GetMemberOrderByOrderId(OrderId);
this.Txtxm.Text = Encryption.Encryption.GetDecipherName(mo.Consignee);
this.Txtyb.Text = mo.ConZipCode;
this.Email.Text = mo.ConPost;
this.Txtjtdh.Text = Encryption.Encryption.GetDecipherTele(mo.ConTelPhone);
this.Txtyddh.Text = Encryption.Encryption.GetDecipherTele(mo.ConMobilPhone);
this.CountryCity1.SelectCountry(mo.ConCity.Country, mo.ConCity.Province, mo.ConCity.City, mo.ConCity.Xian);
this.Txtdz.Text = Encryption.Encryption.GetDecipherAddress(mo.ConAddress);
this.ddth.SelectedValue = mo.SendType.ToString();
//this.rdPayType.SelectedValue = mo.DefrayType.ToString();
this.Txtbz.Text = mo.Remark;
//if (mo.DefrayState.ToString() == "1")
//{
// this.rdPayType.Enabled = false;
//}
//if (this.rdPayType.SelectedValue == "2")
//{
// this.dzpanel.Visible = true;
// this.lblNumber.Text = mo.ElectronicaccountId;
//}
this.DropCurrency.SelectedValue = mo.PayCurrency.ToString();
DDLSendType.SelectedValue = mo.SendWay.ToString();
GetBindAddress();
string addess = mo.ConCity.Country + " " + mo.ConCity.Province + " " + mo.ConCity.City + " " + mo.ConCity.Xian + " " + mo.ConAddress;
this.rbtAddress.SelectedValue = addess;
}