protected void btnLogin_Click(object sender, EventArgs e)
{
var name = txtName.Value;
var pwd = txtPwd.Value;
if (!string.IsNullOrEmpty(name) && !string.IsNullOrEmpty(pwd))
{
//Common.LogHelper.Info(name + ":" + pwd);
//读取用户帐号
JC.Model.users my = busers.GetList().Where(c => ((c.email == name || c.username == name) && c.pwd.ToUpper() == DESEncrypt.MD5Encrypt(pwd).ToUpper())).FirstOrDefault();
if (my != null)
{
if (my.isadmin == 1)
{
if (ckRember.Checked == true)
{
CookieHelper.Set("JCRemberMe", my.username ?? my.email);
}
else
{
CookieHelper.Del("JCRemberMe");
}
Session[userKey] = my;
CookieHelper.Set(userKey, my.id + "|" + my.username + '|' + my.email + '|' + my.avator + '|' + my.isadmin);
//更新登录次数
my.logtime += 1;
busers.Update(my);
var lg = new Model.logs();
UserLog("登录", lg);
UserLogRemove();
Response.Redirect("/manager/index");
}
else
{
lblMsg.InnerText = "网站管理员才可以登录后台！";
}
}
else
{
lblMsg.InnerText = "登录密码错误！";
}
}
else
{
lblMsg.InnerText = "邮箱和密码必须填写！";
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JC.Model.users GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,username,nickname,email,pwd,avator,postdate,modifydate,isadmin,logtime,ext1,ext2,ext3,ext4,ext5,ext6,ext7,ext8,ext9,ext10 from users ");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@id", DbType.Int32, 4)
};
parameters[0].Value = id;
JC.Model.users model = new JC.Model.users();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JC.Model.users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into users(");
strSql.Append("username,nickname,email,pwd,avator,postdate,modifydate,isadmin,logtime,ext1,ext2,ext3,ext4,ext5,ext6,ext7,ext8,ext9,ext10)");
strSql.Append(" values (");
strSql.Append("@username,@nickname,@email,@pwd,@avator,@postdate,@modifydate,@isadmin,@logtime,@ext1,@ext2,@ext3,@ext4,@ext5,@ext6,@ext7,@ext8,@ext9,@ext10)");
strSql.Append(";select LAST_INSERT_ROWID()");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@username", DbType.String),
new SQLiteParameter("@nickname", DbType.String),
new SQLiteParameter("@email", DbType.String),
new SQLiteParameter("@pwd", DbType.String),
new SQLiteParameter("@avator", DbType.String),
new SQLiteParameter("@postdate", DbType.DateTime),
new SQLiteParameter("@modifydate", DbType.DateTime),
new SQLiteParameter("@isadmin", DbType.Int32, 8),
new SQLiteParameter("@logtime", DbType.Int32, 8),
new SQLiteParameter("@ext1", DbType.String),
new SQLiteParameter("@ext2", DbType.String),
new SQLiteParameter("@ext3", DbType.String),
new SQLiteParameter("@ext4", DbType.String),
new SQLiteParameter("@ext5", DbType.String),
new SQLiteParameter("@ext6", DbType.String),
new SQLiteParameter("@ext7", DbType.String),
new SQLiteParameter("@ext8", DbType.String),
new SQLiteParameter("@ext9", DbType.String),
new SQLiteParameter("@ext10", DbType.String)
};
parameters[0].Value = model.username;
parameters[1].Value = model.nickname;
parameters[2].Value = model.email;
parameters[3].Value = model.pwd;
parameters[4].Value = model.avator;
parameters[5].Value = model.postdate;
parameters[6].Value = model.modifydate;
parameters[7].Value = model.isadmin;
parameters[8].Value = model.logtime;
parameters[9].Value = model.ext1;
parameters[10].Value = model.ext2;
parameters[11].Value = model.ext3;
parameters[12].Value = model.ext4;
parameters[13].Value = model.ext5;
parameters[14].Value = model.ext6;
parameters[15].Value = model.ext7;
parameters[16].Value = model.ext8;
parameters[17].Value = model.ext9;
parameters[18].Value = model.ext10;
object obj = DbHelperSQLite.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JC.Model.users DataRowToModel(DataRow row)
{
JC.Model.users model = new JC.Model.users();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["username"] != null)
{
model.username = row["username"].ToString();
}
if (row["nickname"] != null)
{
model.nickname = row["nickname"].ToString();
}
if (row["email"] != null)
{
model.email = row["email"].ToString();
}
if (row["pwd"] != null)
{
model.pwd = row["pwd"].ToString();
}
if (row["avator"] != null)
{
model.avator = row["avator"].ToString();
}
if (row["postdate"] != null && row["postdate"].ToString() != "")
{
model.postdate = DateTime.Parse(row["postdate"].ToString());
}
if (row["modifydate"] != null && row["modifydate"].ToString() != "")
{
model.modifydate = DateTime.Parse(row["modifydate"].ToString());
}
if (row["isadmin"] != null && row["isadmin"].ToString() != "")
{
model.isadmin = int.Parse(row["isadmin"].ToString());
}
if (row["logtime"] != null && row["logtime"].ToString() != "")
{
model.logtime = int.Parse(row["logtime"].ToString());
}
if (row["ext1"] != null)
{
model.ext1 = row["ext1"].ToString();
}
if (row["ext2"] != null)
{
model.ext2 = row["ext2"].ToString();
}
if (row["ext3"] != null)
{
model.ext3 = row["ext3"].ToString();
}
if (row["ext4"] != null)
{
model.ext4 = row["ext4"].ToString();
}
if (row["ext5"] != null)
{
model.ext5 = row["ext5"].ToString();
}
if (row["ext6"] != null)
{
model.ext6 = row["ext6"].ToString();
}
if (row["ext7"] != null)
{
model.ext7 = row["ext7"].ToString();
}
if (row["ext8"] != null)
{
model.ext8 = row["ext8"].ToString();
}
if (row["ext9"] != null)
{
model.ext9 = row["ext9"].ToString();
}
if (row["ext10"] != null)
{
model.ext10 = row["ext10"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JC.Model.users model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update users set ");
strSql.Append("username=@username,");
strSql.Append("nickname=@nickname,");
strSql.Append("email=@email,");
strSql.Append("pwd=@pwd,");
strSql.Append("avator=@avator,");
strSql.Append("postdate=@postdate,");
strSql.Append("modifydate=@modifydate,");
strSql.Append("isadmin=@isadmin,");
strSql.Append("logtime=@logtime,");
strSql.Append("ext1=@ext1,");
strSql.Append("ext2=@ext2,");
strSql.Append("ext3=@ext3,");
strSql.Append("ext4=@ext4,");
strSql.Append("ext5=@ext5,");
strSql.Append("ext6=@ext6,");
strSql.Append("ext7=@ext7,");
strSql.Append("ext8=@ext8,");
strSql.Append("ext9=@ext9,");
strSql.Append("ext10=@ext10");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@username", DbType.String),
new SQLiteParameter("@nickname", DbType.String),
new SQLiteParameter("@email", DbType.String),
new SQLiteParameter("@pwd", DbType.String),
new SQLiteParameter("@avator", DbType.String),
new SQLiteParameter("@postdate", DbType.DateTime),
new SQLiteParameter("@modifydate", DbType.DateTime),
new SQLiteParameter("@isadmin", DbType.Int32, 8),
new SQLiteParameter("@logtime", DbType.Int32, 8),
new SQLiteParameter("@ext1", DbType.String),
new SQLiteParameter("@ext2", DbType.String),
new SQLiteParameter("@ext3", DbType.String),
new SQLiteParameter("@ext4", DbType.String),
new SQLiteParameter("@ext5", DbType.String),
new SQLiteParameter("@ext6", DbType.String),
new SQLiteParameter("@ext7", DbType.String),
new SQLiteParameter("@ext8", DbType.String),
new SQLiteParameter("@ext9", DbType.String),
new SQLiteParameter("@ext10", DbType.String),
new SQLiteParameter("@id", DbType.Int32, 8)
};
parameters[0].Value = model.username;
parameters[1].Value = model.nickname;
parameters[2].Value = model.email;
parameters[3].Value = model.pwd;
parameters[4].Value = model.avator;
parameters[5].Value = model.postdate;
parameters[6].Value = model.modifydate;
parameters[7].Value = model.isadmin;
parameters[8].Value = model.logtime;
parameters[9].Value = model.ext1;
parameters[10].Value = model.ext2;
parameters[11].Value = model.ext3;
parameters[12].Value = model.ext4;
parameters[13].Value = model.ext5;
parameters[14].Value = model.ext6;
parameters[15].Value = model.ext7;
parameters[16].Value = model.ext8;
parameters[17].Value = model.ext9;
parameters[18].Value = model.ext10;
parameters[19].Value = model.id;
int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
