/// <summary>
/// 作者：涂芳 2010-10-19
/// 功能：添加参数
/// </summary>
/// <param name="member"></param>
/// <returns></returns>
public int RegisterUser(KingTop.Modules.Entity.Member member)
{
//RegexOptions options = (RegexOptions.IgnorePatternWhitespace | RegexOptions.Multiline | RegexOptions.IgnoreCase);
int flag = 0;
Regex r = new Regex("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"); //emial
//Regex strName = new Regex("^[a-zA-Z]{1}([a-zA-Z0-9]|[-_]){3,15}$"); //只能输入4-16个以字母开头、可带数字、“_”、“-”的字串
//Regex strPwd = new Regex("^(\\w){6,16}$"); //长度在6-16位
if (r.IsMatch(member.Email))
{
string sql = "proc_K_MemberAdd";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@MemberID", member.MemberID),
new SqlParameter("@UserName", member.UserName),
new SqlParameter("@Password", member.Password),
new SqlParameter("@Email", member.Email)
};
flag = SQLHelper.ExecuteCommand(sql, CommandType.StoredProcedure, para);
}
else
{
flag = 0;
}
return(flag);
}
/// <summary>
/// 作者：涂芳 2010-10-19
/// 功能：添加参数
/// </summary>
/// <param name="member"></param>
/// <returns></returns>
public bool RegisterUser(KingTop.Modules.Entity.Member member)
{
if (dal.RegisterUser(member) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 作者：涂芳 2010-10-20
/// 功能：根据用户名查找ID进行客户端的判断
/// </summary>
/// <param name="usn"></param>
/// <returns>对象</returns>
public KingTop.Modules.Entity.Member GetEmailAndUsnByMID(string usn)
{
KingTop.Modules.Entity.Member member = new KingTop.Modules.Entity.Member();
string sql = "select MemberID,UserName from K_Member where UserName='******'";
DataTable table = SQLHelper.GetDataSet(sql);
foreach (DataRow row in table.Rows)
{
member.MemberID = new Guid(row["MemberID"].ToString()).ToString();
member.UserName = (string)row["UserName"];
}
return(member);
}
public KingTop.Modules.Entity.Member GetPwdByToken(string token)
{
KingTop.Modules.Entity.Member member = new KingTop.Modules.Entity.Member();
string sql = "select PwdVe from K_Member where Token='" + token + "'";
SqlDataReader reader = SQLHelper.GetReader(sql);
if (reader.Read())
{
if (reader["Pwdve"] != DBNull.Value)
{
member.Pwdve = (string)reader["Pwdve"];
}
}
return(member);
}
/// <summary>
/// 根据ID生成实体类
/// </summary>
/// <param name="strMember"></param>
/// <returns></returns>
public KingTop.Modules.Entity.Member GetMember(DataTable dt)
{
KingTop.Modules.Entity.Member member = new KingTop.Modules.Entity.Member();
if (dt.Rows.Count > 0)
{
member.MemberID = dt.Rows[0]["MemberID"].ToString();
member.UserName = dt.Rows[0]["username"].ToString();
member.Password = dt.Rows[0]["password"].ToString();
member.HeadImg = dt.Rows[0]["HeadImg"].ToString();
member.Email = dt.Rows[0]["Email"].ToString();
//member.Gender = KingTop.Common.Utils.ParseInt(dt.Rows[0]["Gender"], 1);
member.Gender = dt.Rows[0]["Gender"].ToString();
return(member);
}
return(null);
}
/// <summary>
/// 增、改K_Member表
/// </summary>
/// <param Name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param Name="paramsModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string tranType, KingTop.Modules.Entity.Member paramsModel)
{
string isOk = "";
try
{
SqlParameter returnValue = new SqlParameter("@ReturnValue", SqlDbType.Int, 4);
returnValue.Direction = ParameterDirection.Output;
string cmdText = "proc_K_MemberSave";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("tranType", tranType),
new SqlParameter("MemberID", paramsModel.MemberID),
new SqlParameter("UserName", paramsModel.UserName),
new SqlParameter("Password", paramsModel.Password),
new SqlParameter("Gender", paramsModel.Gender),
new SqlParameter("GroupID", paramsModel.GroupID),
new SqlParameter("ModleID", paramsModel.ModleID),
new SqlParameter("Email", paramsModel.Email),
new SqlParameter("Funds", paramsModel.Funds),
new SqlParameter("Point", paramsModel.Point),
new SqlParameter("Integral", paramsModel.Integral),
new SqlParameter("StateID", paramsModel.StateID),
new SqlParameter("IsCheck", paramsModel.IsCheck),
new SqlParameter("RegitIP", paramsModel.RegitIP),
new SqlParameter("NodeCode", paramsModel.NodeCode),
new SqlParameter("SiteID", paramsModel.SiteID),
new SqlParameter("token", paramsModel.Token),
returnValue
};
SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, cmdText, paras);
isOk = returnValue.Value.ToString();
}
catch (Exception ex)
{
isOk = ex.Message;
}
return(isOk);
}
/// <summary>
/// 作者：涂芳 2010-10-19
/// 功能：传入参数进行查询比较，返回查询结果
/// </summary>
/// <param name="usn">用户名</param>
/// <param name="pwd">密码</param>
/// <returns>member</returns>
public bool GetUsnAndPwd(KingTop.Modules.Entity.Member member)
{
// KingTop.Model.Member.Member member = null;
bool flag = false;
string sql = "select memberid,username,password,siteID from k_member where UserName=@username and Password=@password";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@username", member.UserName),
new SqlParameter("@password", member.Password)
};
SqlDataReader reader = SQLHelper.GetReader(sql, para);
if (reader.Read())
{
flag = true;
}
else
{
flag = false;
}
return(flag);
}
/// <summary>
/// 作者：涂芳 2010-10-19
/// 功能：传入参数进行查询比较，返回查询结果
/// </summary>
/// <param name="usn">用户名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public bool GetUsnAndPwd(KingTop.Modules.Entity.Member member)
{
return(dal.GetUsnAndPwd(member));
}
/// <summary>
/// 增、改K_Member表
/// </summary>
/// <param name="tranType">操作类型，NEW=增，EDIT=改</param>
/// <param name="MemModel"></param>
/// <returns>返回大于0的数字操作正常，返回非数字表示操作错误，返回的是系统错误说明</returns>
public string Save(string trantype, KingTop.Modules.Entity.Member memModel)
{
return(dal.Save(trantype, memModel));
}
/// <summary>
/// 添加/修改数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (Action == "NEW")
{
if (!IsHaveRightByOperCode("New"))
{
Utils.AlertMessage(this, "你没有添加权限！");
return;
}
}
else
{
if (!IsHaveRightByOperCode("Edit"))
{
Utils.AlertMessage(this, "你没有修改权限！");
return;
}
}
string logTitle = hidLogTitle.Value;
modelMember = new KingTop.Modules.Entity.Member();
string strMessageDetail = "1";
string strMessage = string.Empty;
//初始化相关属性
InitModel();
strMessage = bllMember.Save(Action, modelMember);
int result = Utils.ParseInt(strMessage, 0);
if (Action == "EDIT")
{
if (LogTitle != modelMember.UserName)
{
logTitle += "=>" + modelMember.UserName;
}
//当用户的基本信息更新成功时，再更新其它信息
if (result == 1)
{
// 修改用户信息时，保存用户的详细信息
//strMessageDetail = SaveOrUpdateDetail();
//保存用户自定义字段值
SaveOrUpdateSelf();
}
}
//本来是需要判断都更新成功，才提示成功，但现在只要基本信息更新成功即可
///////if ((strMessage == "1") && (strMessageDetail == "1")) //操作成功
//提示框、消息
string alterTitle = Utils.GetResourcesValue("Common", "TipMessage");
string success = Utils.GetResourcesValue("model", "AddSucess");
string error = Utils.GetResourcesValue("model", "AddError");
string userIsExis = Utils.GetResourcesValue("member", "UserIsExis");
string emailIsExis = Utils.GetResourcesValue("member", "EmailIsExis");
switch (result)
{
case 1: //成功
WriteLog(GetLogValue(logTitle, Action, "Member", true), "", 2);
Utils.AlertMessage(this, success);
break;
case -1: //用户名已存在
WriteLog(GetLogValue(logTitle, Action, "Member", false), userIsExis, 3);
Utils.AlertMessage(this, userIsExis);
break;
case -2: //邮箱已存在
WriteLog(GetLogValue(logTitle, Action, "Member", false), emailIsExis, 3);
Utils.AlertMessage(this, emailIsExis);
break;
case 0: //失败
WriteLog(GetLogValue(logTitle, Action, "Member", false), strMessage, 3);
Utils.AlertMessage(this, error);
break;
}
}
