protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SrCom srCom = new SrCom();
string account=Request.Form[this.TextBoxAccount.UniqueID].Trim();
string pwd = srCom.HashPassword( Request.Form[this.TextBoxPwd.UniqueID].Trim());
string connStr=ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString;
OleDbConnection conn = new OleDbConnection(connStr);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from admins_tb where adminAccount=@account";
cmd.Parameters.AddWithValue("@account",account);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
//帐号正确
string dbpwd = dr["adminPwd"].ToString();
if (dbpwd == pwd)
{
//密码正确
Response.Cookies["SyglAdmin"]["account"] = dr["adminAccount"].ToString();
Response.Cookies["SyglAdmin"]["adminID"] = dr["adminID"].ToString();
Response.Cookies["SyglAdmin"].Expires = DateTime.Now.AddHours(3);
Response.Redirect("./Admin/");
}
else
{
//密码错误
this.LabelLoginTip.Text = "密码错误! ";//" + pwd;
this.LabelLoginTip.Visible = true;
}
}
else
{
//帐号错误
this.LabelLoginTip.Text = "帐号不存在! ";
this.LabelLoginTip.Visible = true;
}
dr.Close();
dr = null;
conn.Close();
}
else
{
//初始化
if (Request.QueryString["f"] == "unlogin")
{
this.LabelLoginTip.Visible = true;
this.LabelLoginTip.Text = "您未登录或登录超时，请重新登陆！";
}
}
}
public void ProcessRequest(HttpContext context)
{
int status = 0;
string msg = "未知错误！";
if (context.Request.Cookies["SyglAdmin"] == null)
{
msg = "您未登录或登录超时！";
}
else
{
if (context.Request["imgids"] == "" || context.Request["imgids"] == null)
{
msg = "您没有提交数据！";
}
else
{
string imgids = context.Request["imgids"];
OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString);
try
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
//删除数据记录
cmd.CommandText = "delete from imgs_tb where imgID in ( " + imgids + ") ";
int effects = cmd.ExecuteNonQuery();
//删除图片文件
string imgFile = context.Request["imgFile"];
SrCom srCom = new SrCom();
srCom.DeleteFile(imgFile);
status = 1;
msg = "成功删除" + effects + "条记录";
conn.Close();
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
conn.Close();
}
}
}
JsonData jd = new JsonData();
jd["status"] = status;
jd["msg"] = msg;
string echoData = jd.ToJson();
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write(echoData);
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
int status = 0;
string msg = "未知错误";
string account = Request.Form["account"];
string pwd = Request.Form["pwd"];
SrCom srCom = new SrCom();
//加密
pwd = srCom.HashPassword(pwd);
LNSql lnSql = new LNSql();
lnSql.conn.Open();
lnSql.cmd.CommandText = "select * from admins_tb where adminAccount=@account";
lnSql.cmd.Parameters.AddWithValue("@account",account);
lnSql.dr = lnSql.cmd.ExecuteReader();
if (lnSql.dr.Read())
{
if (pwd == lnSql.dr["adminPwd"].ToString())
{
//登录成功,设置登录sesseion
Session["adminID"] = lnSql.dr["adminID"].ToString();
Session["adminName"] = lnSql.dr["adminName"].ToString();
Session["adminClass"] = lnSql.dr["adminClass"].ToString();
status = 1;
msg = "登录成功";
}
else
{
msg = "密码错误！"; //+ pwd;
}
}
else
{
msg = "账号不存在！";
}
lnSql.conn.Close();
JsonData data = new JsonData();
data["status"] =status;
data["msg"] = msg;
string json = data.ToJson();
Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
Response.Write(json);
Response.End();
}
}
public void ProcessRequest(HttpContext context)
{
//登录状态码
int status = 0;
//登录状态提示信息
string msg = "未知错误";
//接收数据
string account = context.Request.Form["account"];
string pwd = context.Request.Form["pwd"];
if (account == null || account == "")
{
msg = "未填写帐号！";
}
else
{
if (pwd == null || pwd == "")
{
msg = "未填写密码！";
}
else
{
//数据验证通过，查询帐号
DjOledb djOledb = new DjOledb();
djOledb.conn.Open();
djOledb.cmd.CommandText = "select * from admin_tb where adminAccount= @account";
djOledb.cmd.Parameters.AddWithValue("@account",account);
djOledb.dr = djOledb.cmd.ExecuteReader();
if (djOledb.dr.Read())
{
//帐号存在
//加密密码
SrCom srCom = new SrCom();
pwd = srCom.HashPassword(pwd);
//匹配密码
if (pwd == djOledb.dr["adminPwd"].ToString())
{
//匹配
status = 1;
msg = "登录成功！";
//设置session
context.Session["djAdminAccount"] = account;
context.Session["djAdminName"] = djOledb.dr["adminName"].ToString();
context.Session["djAdminType"] = djOledb.dr["adminType"].ToString();
}
else
{
//不匹配
msg = "密码错误！<br />"+pwd;
}
}
else
{
//帐号不存在
msg = "帐号不存在！";
}
djOledb.conn.Close();
}
}
//返回登录结果json数据
JsonData reData = new JsonData();
reData["status"] = status;
reData["msg"] = msg;
context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
context.Response.Write(reData.ToJson());
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["SyglAdmin"] == null)
{
Response.Redirect("/admLogin.aspx?f=unlogin");
}
else
{
Request.Cookies["SyglAdmin"].Expires = DateTime.Now.AddHours(1);
}
if (IsPostBack)
{
int status = 0;
string msg = "未知错误";
OleDbConnection conn = new OleDbConnection();
try
{
//接收数据
string file = Request["img_file"];
//转移缓存数据
SrCom srCom = new SrCom();
file = srCom.MoveFile(file, "/Sourse/Files/image/marquee/");
string link = Request["imgLink"];
conn.ConnectionString = (ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
//保存数据
if (Request["imgID"] == "" || Request["imgID"] == null)
{
//新添加数据
cmd.CommandText = "insert into imgs_tb (imgFile,imgLink) values (@file,@link)";
cmd.Parameters.AddWithValue("@file", file);
cmd.Parameters.AddWithValue("@link", link);
}
else
{
//修改数据
int imgID = Convert.ToInt32(Request["imgID"]);
cmd.CommandText = "update imgs_tb set imgFile=@file,imgLink=@link where imgID=@imgID";
cmd.Parameters.AddWithValue("@file", file);
cmd.Parameters.AddWithValue("@link", link);
cmd.Parameters.AddWithValue("@imgID", imgID);
}
cmd.ExecuteNonQuery();
status = 1;
msg = "保存成功！";
}
catch (Exception ex)
{
conn.Close();
msg = ex.Message;
}
finally
{
conn.Close();
JsonData jd = new JsonData();
jd["status"] = status;
jd["msg"] = msg;
string echoStr = jd.ToJson();
Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
Response.Write(echoStr);
Response.End();
}
}
else
{
//初始化页面
if (Request["imgID"] == "" || Request["imgID"] == null)
{
//初始化添加页面
this.show_img_file.Visible = false;
this.img_file.Visible = false;
}
else
{
//初始化修改页面
OleDbConnection conn = new OleDbConnection();
int imgID = Convert.ToInt32(Request["imgID"]);
conn.ConnectionString = (ConfigurationManager.ConnectionStrings["SyglConnStr"].ConnectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from imgs_tb where imgID=@imgID";
cmd.Parameters.AddWithValue("@imgID",imgID);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
this.show_img_file.ImageUrl = dr["imgFile"].ToString();
this.show_img_file.Width = 280;
this.img_file.Value = dr["imgFile"].ToString();
this.imgLink.Text = dr["imgLink"].ToString();
this.imgID.Value = imgID.ToString();
}
conn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
int status = 0;
string msg = "未定义错误";
SrCom srCom = new SrCom();
LNSql lnSql = new LNSql();
lnSql.conn.Open();
//保存提交数据
try
{
int resetPwd = Convert.ToInt32(Request.Params["resetPwd"]);
string adminName = Request.Params["adminName"];
string adminAccount = Request.Params["adminAccount"];
string adminCpPwd = srCom.HashPassword(Request.Params["adminCpPwd"]);
string adminPWD = srCom.HashPassword(Request.Params["adminPWD"]);
if (Request.Params["adminID"] == "" || Request.Params["adminID"] == null)
{
//添加用户，全部初始化密码
lnSql.cmd.CommandText = "insert into admins_tb (adminName,adminAccount,adminPWD) values(@adminName,@adminAccount,@adminPWD)";
lnSql.cmd.Parameters.AddWithValue("@adminName", adminName);
lnSql.cmd.Parameters.AddWithValue("@adminAccount", adminAccount);
lnSql.cmd.Parameters.AddWithValue("@adminPWD", adminPWD);
lnSql.cmd.ExecuteNonQuery();
}
else
{
int adminID = Convert.ToInt32(Request.Params["adminID"]);
//修改用户
if (resetPwd == 1)
{
lnSql.cmd.CommandText = "update admins_tb set adminName=@adminName,adminAccount=@adminAccount,adminPWD=@adminPWD where adminID=@adminID";
lnSql.cmd.Parameters.AddWithValue("@adminName", adminName);
lnSql.cmd.Parameters.AddWithValue("@adminAccount", adminAccount);
lnSql.cmd.Parameters.AddWithValue("@adminPWD", adminPWD);
lnSql.cmd.Parameters.AddWithValue("@adminID", adminID);
}
else
{
lnSql.cmd.CommandText = "update admins_tb set adminName=@adminName,adminAccount=@adminAccount where adminID=@adminID";
lnSql.cmd.Parameters.AddWithValue("@adminName", adminName);
lnSql.cmd.Parameters.AddWithValue("@adminAccount", adminAccount);
lnSql.cmd.Parameters.AddWithValue("@adminID", adminID);
}
lnSql.cmd.ExecuteNonQuery();
}
status = 1;
msg = "保存成功！";
}
catch (Exception ex)
{
msg = ex.Message;
}
finally
{
lnSql.conn.Close();
JsonData jsonData = new JsonData();
jsonData["status"] = status;
jsonData["msg"] = msg;
string echoString = jsonData.ToJson();
Response.AddHeader("Content-Type", "text/html; charset=UTF-8");
Response.Write(echoString);
Response.End();
}
}
else
{
//初始化页面
if (Request.Params["did"] == null || Request.Params["did"] == "")
{
//初始化增加页面
this.adminCpPwd.TextMode = TextBoxMode.Password;
this.adminPWD.TextMode = TextBoxMode.Password;
this.adminPWD.Text = "12345";
this.adminCpPwd.Text ="12345";
}
else
{
//初始化修改页面
int adminID = Convert.ToInt32(Request.Params["did"]);
LNSql lnSql = new LNSql();
lnSql.conn.Open();
lnSql.cmd.CommandText = "select * from admins_tb where adminID="+adminID;
lnSql.dr = lnSql.cmd.ExecuteReader();
if (lnSql.dr.Read())
{
this.adminID.Value = adminID.ToString();
this.adminName.Text = lnSql.dr["adminName"].ToString();
this.adminAccount.Text = lnSql.dr["adminAccount"].ToString();
}
this.adminCpPwd.TextMode = TextBoxMode.Password;
this.adminPWD.TextMode = TextBoxMode.Password;
}
}
}
