protected void save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("PollCode");
model.YuE = 0M;
model.IssueTime = DateTime.Now;
string retUrl = Utils.GetFormValue("rurl");
bool result = bll.Add(model);
if (result)
{
if (!string.IsNullOrEmpty(retUrl))
{
Response.Redirect(retUrl);
}
EyouSoft.Common.Page.HuiyuanPage.Logout();
Response.Redirect("/AppPage/weixin/Login.aspx");
}
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.User();
model.UserName = Utils.GetFormValue(userName.UniqueID);
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserPwd = Utils.GetFormValue(userPwd.UniqueID);
model.ContactName = Utils.GetFormValue(ContactName.UniqueID);
model.Remark = Utils.GetFormValue(remark.UniqueID);
model.IssueTime = DateTime.Now;
model.CommissonScale = Utils.GetDecimal(Utils.GetFormValue(fydecimal.UniqueID));
model.PromotionCode = Utils.GetFormValue(userPromotionCode.UniqueID);
model.YuE = Utils.GetDecimal(Utils.GetFormValue(zhYuE.UniqueID));
model.IsZZ = Utils.GetFormValue(chk_zf.UniqueID) == "1" ? true : false;
model.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption"));
model.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice"));
model.CityId = Utils.GetInt(Utils.GetFormValue("MyCity"));
model.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea"));
model.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet"));
if (model.CommissonScale == 0 && string.IsNullOrEmpty(model.PromotionCode))
{
model.IsAgent = false;
}
else
{
model.IsAgent = true;
}
#region 提交保存
bool result = false;
string msg = "";
Response.Clear();
Eyousoft_yhq.BLL.Member BLL = new Eyousoft_yhq.BLL.Member();
//if (doType == "add")
//{
// result = BLL.Add(model);
// msg = result ? "添加成功！" : "添加失败！";
// Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
//}
//else
//{
model.UserID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
//}
Response.End();
#endregion
}
protected void save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("PollCode");
model.YuE = 0M;
model.IssueTime = DateTime.Now;
bool result = bll.Add(model);
if (result)
{
EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd);
Response.Redirect("/AppPage/Default.aspx");
}
}
protected void save()
{
Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User();
model.ContactName = Utils.GetFormValue(contactName.UniqueID);
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); ;
model.UserPwd = Utils.GetFormValue(userPwd.UniqueID);
model.UserID = userinfo.UserID;
model.Remark = userinfo.Remark;
bool result = new Eyousoft_yhq.BLL.Member().Update(model);
if (result)
{
Utils.ShowMsg("修改成功！");
}
else
{
Utils.ShowMsg("修改失败！");
}
}
protected void save()
{
Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User();
model.ContactName = Utils.GetFormValue(contactName.UniqueID);
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));;
model.UserPwd = Utils.GetFormValue(userPwd.UniqueID);
model.UserID = userinfo.UserID;
model.Remark = userinfo.Remark;
bool result = new Eyousoft_yhq.BLL.Member().Update(model);
if (result)
{
Utils.ShowMsg("修改成功！");
}
else
{
Utils.ShowMsg("修改失败！");
}
}
/// <summary>
/// 添加用户
/// </summary>
protected string save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue("userSex"));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("userPollCode");
model.IsAgent = false;
model.IssueTime = DateTime.Now;
//string ViaCode = Utils.GetFormValue("userViaCode");
model.YuE = 0M;
string msg = string.Empty;
List <string[]> list = new List <string[]>();
//list = Session[model.UserName] as List<string[]>;
//if (list != null)
//{
// for (int i = 0; i < list.Count; i++)
// {
// if (ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0)
// {
// msg = list[i][1];
// }
// }
//}
//if (string.IsNullOrEmpty(msg))
//{
// return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码！");
//}
bool result = bll.Add(model);
Session.Remove(model.UserName);
if (result)
{
Session.Remove(model.UserName);
EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd);
}
return(UtilsCommons.AjaxReturnJson("1", string.Format("注册{0}", result ? "成功，正在跳转页面，请稍后 !" : "失败！请稍后再试")));
}
/// <summary>
/// 添加用户
/// </summary>
protected string save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue("userSex"));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("userPollCode");
model.IsAgent = false;
model.IssueTime = DateTime.Now;
//string ViaCode = Utils.GetFormValue("userViaCode");
model.YuE = 0M;
string msg = string.Empty;
List<string[]> list = new List<string[]>();
//list = Session[model.UserName] as List<string[]>;
//if (list != null)
//{
// for (int i = 0; i < list.Count; i++)
// {
// if (ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0)
// {
// msg = list[i][1];
// }
// }
//}
//if (string.IsNullOrEmpty(msg))
//{
// return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码！");
//}
bool result = bll.Add(model);
Session.Remove(model.UserName);
if (result)
{
Session.Remove(model.UserName);
EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd);
}
return UtilsCommons.AjaxReturnJson("1", string.Format("注册{0}", result ? "成功，正在跳转页面，请稍后 !" : "失败！请稍后再试"));
}
protected void save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("PollCode");
model.YuE = 0M;
model.IssueTime = DateTime.Now;
bool result = bll.Add(model);
if (result)
{
EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd);
Response.Redirect("/AppPage/Default.aspx");
}
}
protected void save()
{
var model = new Eyousoft_yhq.Model.User();
Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member();
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserName = Utils.GetFormValue("userName");
model.UserPwd = Utils.GetFormValue("userPwd");
model.ContactName = Utils.GetFormValue("contactName");
model.PollCode = Utils.GetFormValue("PollCode");
model.YuE = 0M;
model.IssueTime = DateTime.Now;
string retUrl = Utils.GetFormValue("rurl");
bool result = bll.Add(model);
if (result)
{
if (!string.IsNullOrEmpty(retUrl)) Response.Redirect(retUrl);
EyouSoft.Common.Page.HuiyuanPage.Logout();
Response.Redirect("/AppPage/weixin/Login.aspx");
}
}
protected string UpdateUserInfo()
{
string Phone = Utils.GetFormValue(txtPhone.UniqueID);
string Name = Utils.GetFormValue(txtName.UniqueID);
string Pwd = Utils.GetFormValue(txtPassOld.UniqueID);
string NewPwd = Utils.GetFormValue(txtPassNew.UniqueID);
string SurePwd = Utils.GetFormValue(txtPassSure.UniqueID);
string sex = Utils.GetFormValue(dl_sex.UniqueID);
Eyousoft_yhq.Model.User UserInfo = new Eyousoft_yhq.Model.User();
UserInfo = Mem.GetModel(HuiYuanInfo.UserID);
UserInfo.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice"));
UserInfo.CityId = Utils.GetInt(Utils.GetFormValue("MyCity"));
UserInfo.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea"));
UserInfo.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet"));
UserInfo.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption"));
#region 验证码
string ViaCode = Utils.GetFormValue("userViaCode");
List <string[]> list = new List <string[]>();
list = Session[Phone] as List <string[]>;
string msg = string.Empty;
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
if (!string.IsNullOrEmpty(ViaCode) && ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0)
{
msg = list[i][1];
UserInfo.valiUser = true;
}
}
}
if (!string.IsNullOrEmpty(ViaCode) && !UserInfo.valiUser)
{
return(UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码！"));
}
#endregion
if (!string.IsNullOrEmpty(Pwd))
{
if (Pwd != UserInfo.UserPwd)
{
return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "原始密码不正确"));
}
else if (NewPwd != SurePwd)
{
return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "两次密码输入不一致"));
}
}
if (!string.IsNullOrEmpty(SurePwd) && !string.IsNullOrEmpty(Pwd))
{
UserInfo.UserPwd = SurePwd;
}
if (!string.IsNullOrEmpty(sex))
{
UserInfo.ContactSex = (sexType)Utils.GetInt(sex);
}
if (!string.IsNullOrEmpty(Name))
{
UserInfo.ContactName = Name;
}
if (Mem.Update(UserInfo))
{
return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "修改成功"));
}
else
{
return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "修改失败,查看原始密码是否正确"));
}
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns></returns>
public Eyousoft_yhq.Model.User GetModelByName(string UserName)
{
Eyousoft_yhq.Model.User model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT [UserID],[UserName],[UserPwd],[ContactName],[ContactSex],[Remark],[IssueTime],[CommissonScale],[PollCode],[PromotionCode],[IsAgent],[valiUser],[YuE],[IsZZ],MemberOption,ProviceId,CityId,AreaId,StreetId ");
strSql.Append(" FROM tbl_Member ");
strSql.Append(" where UserName=@UserName ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "UserName", System.Data.DbType.AnsiStringFixedLength, UserName);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.User();
model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID"));
model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName"));
model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale"));
model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode"));
model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode"));
model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent")));
model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser")));
model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE"));
model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ")));
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption"));
model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId"));
model.CityId = dr.GetInt32(dr.GetOrdinal("CityId"));
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId"));
}
}
return model;
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="UserID">用户编号</param>
/// <returns></returns>
public Eyousoft_yhq.Model.User GetModel(string UserID)
{
Eyousoft_yhq.Model.User model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * ");
strSql.Append(" FROM tbl_Member ");
strSql.Append(" where UserID=@UserID ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
this._db.AddInParameter(cmd, "UserID", System.Data.DbType.AnsiStringFixedLength, UserID);
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
model = new Eyousoft_yhq.Model.User();
model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID"));
model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName"));
model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale"));
model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode"));
model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode"));
model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent")));
model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser")));
model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE"));
model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ")));
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.WeiXinHao = dr["WeiXinHao"].ToString();
model.GongSiName = dr["GongSiName"].ToString();
model.ZhiWei = dr["ZhiWei"].ToString();
model.ShouJi = dr["ShouJi"].ToString();
model.TuXiangFilepath = dr["TuXiangFilepath"].ToString();
model.QQ = dr["QQ"].ToString();
model.YouXiang = dr["YouXiang"].ToString();
model.DiZhi = dr["DiZhi"].ToString();
model.IsLvYouGuWen = dr["IsLvYouGuWen"].ToString() == "1";
model.LvYouGuWenRenZhengTime = dr.GetDateTime(dr.GetOrdinal("LvYouGuWenRenZhengTime"));
model.ZanJiShu = dr.GetInt32(dr.GetOrdinal("ZanJiShu"));
model.GuanZhuJiShu = dr.GetInt32(dr.GetOrdinal("GuanZhuJiShu"));
model.LiuYanJiShu = dr.GetInt32(dr.GetOrdinal("LiuYanJiShu"));
model.MingPianId = dr["MingPianId"].ToString();
model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption"));
model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId"));
model.CityId = dr.GetInt32(dr.GetOrdinal("CityId"));
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId"));
}
}
return model;
}
public IList<Eyousoft_yhq.Model.User> GetList(Eyousoft_yhq.Model.MSearchUser serModel)
{
IList<Eyousoft_yhq.Model.User> list = new List<Eyousoft_yhq.Model.User>();
StringBuilder query = new StringBuilder();
query.Append("select UserID,UserName,UserPwd,ContactName,ContactSex,Remark,IssueTime,CommissonScale,PollCode,PromotionCode,IsAgent,valiUser,YuE,MemberOption,ProviceId,CityId,AreaId,StreetId from tbl_Member where 1=1");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.UserName))
{
query.AppendFormat(" and UserName like '%{0}%' ", serModel.UserName);
}
if (!string.IsNullOrEmpty(serModel.ContactName))
{
query.AppendFormat(" and ContactName like '%{0}%' ", serModel.ContactName);
}
}
query.Append(" order by UserID DESC ");
DbCommand cmd = this._db.GetSqlStringCommand(query.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
while (dr.Read())
{
Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User();
model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID"));
model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName"));
model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale"));
model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode"));
model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode"));
model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent")));
model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser")));
model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE"));
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption"));
model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId"));
model.CityId = dr.GetInt32(dr.GetOrdinal("CityId"));
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId"));
list.Add(model);
}
}
return list;
}
public IList<Eyousoft_yhq.Model.User> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchUser serModel, int isadmin)
{
IList<Eyousoft_yhq.Model.User> list = new List<Eyousoft_yhq.Model.User>();
string tableName = "tbl_Member";
string fileds = " *,(SELECT COUNT(1) FROM tbl_Order WHERE MemberID=tbl_Member.UserID and PayState='2' ) AS OrderCount ";
string orderByString = "IssueTime desc";
StringBuilder query = new StringBuilder();
query.AppendFormat(" 1=1 ", isadmin);
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.UserName))
{
query.AppendFormat(" and UserName like '%{0}%' ", serModel.UserName);
}
if (!string.IsNullOrEmpty(serModel.ContactName))
{
query.AppendFormat(" and ContactName like '%{0}%' ", serModel.ContactName);
}
if (!string.IsNullOrEmpty(serModel.PromotionCode))
{
query.AppendFormat(" and PollCode = '{0}' ", serModel.PromotionCode);
}
if (serModel.IsLvYouGuWen.HasValue)
{
query.AppendFormat(" AND IsLvYouGuWen='{0}' ", serModel.IsLvYouGuWen.Value ? "1" : "0");
if (serModel.IsLvYouGuWen.Value)
{
orderByString = "LvYouGuWenRenZhengTime DESC";
}
}
if (serModel.MemberOption.HasValue)
{
query.AppendFormat(" AND MemberOption='{0}' ", (int)serModel.MemberOption);
}
if (serModel.ProviceId != 0)
{
query.AppendFormat(" AND ProviceId='{0}' ", serModel.ProviceId);
}
if (serModel.CityId != 0)
{
query.AppendFormat(" AND CityId='{0}' ", serModel.CityId);
}
if (serModel.AreaId != 0)
{
query.AppendFormat(" AND AreaId='{0}' ", serModel.AreaId);
}
if (serModel.StreetId != 0)
{
query.AppendFormat(" AND StreetId='{0}' ", serModel.StreetId);
}
}
using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null))
{
while (dr.Read())
{
Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User();
model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID"));
model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName"));
model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd"));
model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex"));
model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark"));
model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale"));
model.OrderCount = dr.GetInt32(dr.GetOrdinal("OrderCount"));
model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode"));
model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode"));
model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent")));
model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser")));
model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE"));
model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ")));
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
model.WeiXinHao = dr["WeiXinHao"].ToString();
model.GongSiName = dr["GongSiName"].ToString();
model.ZhiWei = dr["ZhiWei"].ToString();
model.ShouJi = dr["ShouJi"].ToString();
model.TuXiangFilepath = dr["TuXiangFilepath"].ToString();
model.QQ = dr["QQ"].ToString();
model.YouXiang = dr["YouXiang"].ToString();
model.DiZhi = dr["DiZhi"].ToString();
model.IsLvYouGuWen = dr["IsLvYouGuWen"].ToString() == "1";
model.LvYouGuWenRenZhengTime = dr.GetDateTime(dr.GetOrdinal("LvYouGuWenRenZhengTime"));
model.ZanJiShu = dr.GetInt32(dr.GetOrdinal("ZanJiShu"));
model.GuanZhuJiShu = dr.GetInt32(dr.GetOrdinal("GuanZhuJiShu"));
model.LiuYanJiShu = dr.GetInt32(dr.GetOrdinal("LiuYanJiShu"));
model.MingPianId = dr["MingPianId"].ToString();
model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption"));
model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId"));
model.CityId = dr.GetInt32(dr.GetOrdinal("CityId"));
model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId"));
model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId"));
list.Add(model);
}
}
return list;
}
protected void pageSave(string doType)
{
string id = Utils.GetQueryStringValue("id");
var model = new Eyousoft_yhq.Model.User();
model.UserName = Utils.GetFormValue(userName.UniqueID);
model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));
model.UserPwd = Utils.GetFormValue(userPwd.UniqueID);
model.ContactName = Utils.GetFormValue(ContactName.UniqueID);
model.Remark = Utils.GetFormValue(remark.UniqueID);
model.IssueTime = DateTime.Now;
model.CommissonScale = Utils.GetDecimal(Utils.GetFormValue(fydecimal.UniqueID));
model.PromotionCode = Utils.GetFormValue(userPromotionCode.UniqueID);
model.YuE = Utils.GetDecimal(Utils.GetFormValue(zhYuE.UniqueID));
model.IsZZ = Utils.GetFormValue(chk_zf.UniqueID) == "1" ? true : false;
model.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption"));
model.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice"));
model.CityId = Utils.GetInt(Utils.GetFormValue("MyCity"));
model.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea"));
model.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet"));
if (model.CommissonScale == 0 && string.IsNullOrEmpty(model.PromotionCode))
{
model.IsAgent = false;
}
else
{
model.IsAgent = true;
}
#region 提交保存
bool result = false;
string msg = "";
Response.Clear();
Eyousoft_yhq.BLL.Member BLL = new Eyousoft_yhq.BLL.Member();
//if (doType == "add")
//{
// result = BLL.Add(model);
// msg = result ? "添加成功！" : "添加失败！";
// Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
//}
//else
//{
model.UserID = id;
result = BLL.Update(model);
msg = result ? "修改成功！" : "修改失败！";
Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg));
//}
Response.End();
#endregion
}
protected string UpdateUserInfo()
{
string Phone = Utils.GetFormValue(txtPhone.UniqueID);
string Name = Utils.GetFormValue(txtName.UniqueID);
string Pwd = Utils.GetFormValue(txtPassOld.UniqueID);
string NewPwd = Utils.GetFormValue(txtPassNew.UniqueID);
string SurePwd = Utils.GetFormValue(txtPassSure.UniqueID);
string sex = Utils.GetFormValue(dl_sex.UniqueID);
Eyousoft_yhq.Model.User UserInfo = new Eyousoft_yhq.Model.User();
UserInfo = Mem.GetModel(HuiYuanInfo.UserID);
UserInfo.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice"));
UserInfo.CityId = Utils.GetInt(Utils.GetFormValue("MyCity"));
UserInfo.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea"));
UserInfo.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet"));
UserInfo.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption"));
#region 验证码
string ViaCode = Utils.GetFormValue("userViaCode");
List<string[]> list = new List<string[]>();
list = Session[Phone] as List<string[]>;
string msg = string.Empty;
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
if (!string.IsNullOrEmpty(ViaCode) && ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0)
{
msg = list[i][1];
UserInfo.valiUser = true;
}
}
}
if (!string.IsNullOrEmpty(ViaCode) && !UserInfo.valiUser)
{
return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码！");
}
#endregion
if (!string.IsNullOrEmpty(Pwd))
{
if (Pwd != UserInfo.UserPwd)
{
return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "原始密码不正确");
}
else if (NewPwd != SurePwd)
return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "两次密码输入不一致");
}
if (!string.IsNullOrEmpty(SurePwd) && !string.IsNullOrEmpty(Pwd))
{
UserInfo.UserPwd = SurePwd;
}
if (!string.IsNullOrEmpty(sex))
{
UserInfo.ContactSex = (sexType)Utils.GetInt(sex);
}
if (!string.IsNullOrEmpty(Name))
{
UserInfo.ContactName = Name;
}
if (Mem.Update(UserInfo))
{
return EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "修改成功");
}
else
{
return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "修改失败,查看原始密码是否正确");
}
}
