/// <summary>
/// 登陆
/// </summary>
/// <param name="name"></param>
/// <param name="password"></param>
/// <returns></returns>
public ShowShop.Model.Member.MemberAccount GetModelByNameAndPassword(string name,string password)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UID,UserType,UserGroup,PassWord,UserId,Signed,Question,Answer,Email,State,RegisterDate,RegisterIP,LastLoginDate,LastLoginIP,LoginTimes,Capital,Coupons,Points,PeriodOfValidity from yxs_memberaccount ");
strSql.Append(" where UserId=@UserId and PassWord=@PassWord ");
SqlParameter[] parameters ={
new SqlParameter("@UserId",name),
new SqlParameter("@PassWord",password)
};
ShowShop.Model.Member.MemberAccount model = null;
using(SqlDataReader reader=ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(),parameters))
{
if(reader.Read())
{
model = new ShowShop.Model.Member.MemberAccount();
model.UID = (int)reader["UID"];
model.UserType = (int)reader["UserType"];
model.UserGroup = Convert.ToInt32(reader["UserGroup"]);
model.PassWord = (string)reader["PassWord"];
model.UserId = (string)reader["UserId"];
model.Signed = reader["Signed"] == null ? string.Empty : Convert.ToString(reader["Signed"]);
model.Question = reader["Question"] == null ? string.Empty : reader["Question"].ToString();
model.Answer = reader["Answer"] == null ? string.Empty : reader["Answer"].ToString();
model.Email = (string)reader["Email"];
model.State = Convert.ToInt32(reader["State"]);
model.RegisterDate = Convert.ToDateTime(reader["RegisterDate"]);
model.RegisterIP = (string)reader["RegisterIP"];
model.LastLoginDate = Convert.ToDateTime(reader["LastLoginDate"]);
model.LastLoginIP = (string)reader["LastLoginIP"];
model.LoginTimes = Convert.ToInt32(reader["LoginTimes"]);
model.Capital = Convert.ToDecimal(reader["Capital"]);
model.Coupons = Convert.ToDecimal(reader["Coupons"]);
model.Points = Convert.ToDecimal(reader["Points"]);
model.PeriodOfValidity = Convert.ToDateTime(reader["PeriodOfValidity"]);
}
}
return model;
}
/// <summary>
/// 查所有 根据条件
/// </summary>
/// <param name="where"></param>
/// <returns></returns>
public List<ShowShop.Model.Member.MemberAccount> GetAll(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select UID,UserType,UserGroup,PassWord,UserId,Signed,Question,Answer,Email,State,RegisterDate,RegisterIP,LastLoginDate,LastLoginIP,LoginTimes,Capital,Coupons,Points,PeriodOfValidity from yxs_memberaccount ");
if (where != null && where != "")
{
strSql.Append("where " + where + " ");
}
List<ShowShop.Model.Member.MemberAccount> accountList = new List<ShowShop.Model.Member.MemberAccount>();
using(SqlDataReader reader=ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while(reader.Read())
{
ShowShop.Model.Member.MemberAccount model= new ShowShop.Model.Member.MemberAccount();
model.UID=(int)reader["UID"];
model.UserType=(int)reader["UserType"];
model.UserGroup=Convert.ToInt32(reader["UserGroup"]);
model.PassWord = (string)reader["PassWord"];
model.UserId=(string)reader["UserId"];
model.Signed=reader["Signed"]==null?string.Empty:Convert.ToString(reader["Signed"]);
model.Question = reader["Question"] == null ?string.Empty : reader["Question"].ToString();
model.Answer = reader["Answer"] == null ? string.Empty : reader["Answer"].ToString();
model.Email=(string)reader["Email"];
model.State=Convert.ToInt32(reader["State"]);
model.RegisterDate=Convert.ToDateTime(reader["RegisterDate"]);
model.RegisterIP=(string)reader["RegisterIP"];
model.LastLoginDate=Convert.ToDateTime(reader["LastLoginDate"]);
model.LastLoginIP=(string)reader["LastLoginIP"];
model.LoginTimes=Convert.ToInt32(reader["LoginTimes"]);
model.Capital=Convert.ToDecimal(reader["Capital"]);
model.Coupons=Convert.ToDecimal(reader["Coupons"]);
model.Points=Convert.ToDecimal(reader["Points"]);
model.PeriodOfValidity=Convert.ToDateTime(reader["PeriodOfValidity"]);
accountList.Add(model);
}
}
return accountList;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public ShowShop.Model.Member.MemberAccount GetModel(string UserId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UID,UserType,UserGroup,UserId,PassWord,Signed,Question,Answer,Email,State,RegisterDate,RegisterIP,LastLoginDate,LastLoginIP,LoginTimes,Capital,Coupons,Points,PeriodOfValidity from yxs_memberaccount ");
strSql.Append(" where UserId=@UserId ");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.VarChar,50)};
parameters[0].Value = UserId;
ShowShop.Model.Member.MemberAccount model = new ShowShop.Model.Member.MemberAccount();
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["UID"].ToString() != "")
{
model.UID = int.Parse(ds.Tables[0].Rows[0]["UID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserType"].ToString() != "")
{
model.UserType = int.Parse(ds.Tables[0].Rows[0]["UserType"].ToString());
}
if (ds.Tables[0].Rows[0]["UserGroup"].ToString() != "")
{
model.UserGroup = int.Parse(ds.Tables[0].Rows[0]["UserGroup"].ToString());
}
model.UserId = ds.Tables[0].Rows[0]["UserId"].ToString();
model.PassWord = ds.Tables[0].Rows[0]["PassWord"].ToString();
model.Signed = ds.Tables[0].Rows[0]["Signed"].ToString();
model.Question = ds.Tables[0].Rows[0]["Question"].ToString();
model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
}
if (ds.Tables[0].Rows[0]["RegisterDate"].ToString() != "")
{
model.RegisterDate = DateTime.Parse(ds.Tables[0].Rows[0]["RegisterDate"].ToString());
}
model.RegisterIP = ds.Tables[0].Rows[0]["RegisterIP"].ToString();
if (ds.Tables[0].Rows[0]["LastLoginDate"].ToString() != "")
{
model.LastLoginDate = DateTime.Parse(ds.Tables[0].Rows[0]["LastLoginDate"].ToString());
}
model.LastLoginIP = ds.Tables[0].Rows[0]["LastLoginIP"].ToString();
if (ds.Tables[0].Rows[0]["LoginTimes"].ToString() != "")
{
model.LoginTimes = int.Parse(ds.Tables[0].Rows[0]["LoginTimes"].ToString());
}
if (ds.Tables[0].Rows[0]["Capital"].ToString() != "")
{
model.Capital = decimal.Parse(ds.Tables[0].Rows[0]["Capital"].ToString());
}
if (ds.Tables[0].Rows[0]["Coupons"].ToString() != "")
{
model.Coupons = decimal.Parse(ds.Tables[0].Rows[0]["Coupons"].ToString());
}
if (ds.Tables[0].Rows[0]["Points"].ToString() != "")
{
model.Points = decimal.Parse(ds.Tables[0].Rows[0]["Points"].ToString());
}
if (ds.Tables[0].Rows[0]["PeriodOfValidity"].ToString() != "")
{
model.PeriodOfValidity = DateTime.Parse(ds.Tables[0].Rows[0]["PeriodOfValidity"].ToString());
}
return model;
}
else
{
return null;
}
}
private void SaveAccount()
{
ShowShop.BLL.Member.MemberAccount bll = new ShowShop.BLL.Member.MemberAccount();
ShowShop.Model.Member.MemberAccount model = new ShowShop.Model.Member.MemberAccount();
model.UserGroup = ChangeHope.Common.StringHelper.StringToInt(this.ddlUserGroup.SelectedValue);
model.UserId = this.txtUserId.Text;
model.UserType = ChangeHope.Common.StringHelper.StringToInt(this.ddlUserType.SelectedValue);
model.State = this.ckbState.Checked ? 1 : 0;
model.Signed = this.txtSigned.Text;
model.Question = this.txtQuestion.Text;
model.PassWord = this.txtPassword.Text;
model.Answer = txtAnswer.Text;
model.Email = txtEmail.Text;
if (ViewState["uid"] != null)
{
model.UID = Convert.ToInt32(ViewState["uid"].ToString());
model.RegisterDate = Convert.ToDateTime(ViewState["RegisterDate"].ToString());
model.RegisterIP = ViewState["RegisterIP"].ToString();
model.LastLoginDate = Convert.ToDateTime(ViewState["LastLoginDate"].ToString());
model.LastLoginIP = ViewState["LastLoginIP"].ToString();
model.LoginTimes = Convert.ToInt32(ViewState["LoginTimes"].ToString());
model.Capital = Convert.ToDecimal(ViewState["Capital"].ToString());
model.Coupons = Convert.ToDecimal(ViewState["Coupons"].ToString());
model.Points = Convert.ToDecimal(ViewState["Points"].ToString());
model.PeriodOfValidity = Convert.ToDateTime(ViewState["PeriodOfValidity"].ToString());
bll.Update(model);
}
else
{
model.RegisterDate = DateTime.Now;
model.RegisterIP = Request.UserHostAddress;
model.LastLoginDate = DateTime.Now;
model.LastLoginIP = Request.UserHostAddress;
model.LoginTimes = 0;
model.Capital = 0;
model.Coupons = 0;
model.Points = 0;
model.PeriodOfValidity = DateTime.Now;
bll.Add(model);
}
}
