昨天还能看呢,我忘记改IIS什么地方了,再登陆就是这个问题。请教高手。我的IIS里面有这些东西:
解决方案 »
- 新手显示问题!
- 复选框问题
- asp.net+ajax 模仿google查询提示的问题
- 怎么样对Girdview控件 新增一行,编辑,删除
- webservice 中函数的返回类型为xmlDocument,为什么客户端调用的时候返回是xmlnode?怎样与datagrid绑定?
- 请教回车响应事件
- 怎么导出数据到EXCEL中,并且在导出的时候能让用户选择保存为一个什么文件!!!急呀
- 讨论:关于服务器计时器的问题
- 初学用户控件,急!最好是vb.net
- 请教ASP.NET高手:外网网关转发http请求到内网以后,为什么ip地址变成了内网地址?
- HttpUtility.HtmlDecode的弊端
- 大家都来看看,谁的算法好
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (CookieHelper_Cai.HaveCookie("WaterFee", "Uname"))
{
Response.Redirect("HomeS.aspx");
}
else
{
}
} protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
string names = "";
string pwd = "", ip = "";
names = this.UnameS.Text.Trim();
pwd = this.Pawd.Text.Trim();
if (!string.IsNullOrEmpty(names) && !string.IsNullOrEmpty(pwd))
{
ip = RequestSafe_Cai.GetIP();
pwd = MD5_Cai.Encrypt(pwd);
if (AdminUserSExecutSqlS.Admin_User_LoginIn(names, pwd, ip))
{
DataTable dt = new DataTable();
dt = AdminUserSExecutSqlS.Admin_User_ShowOneByUname(names);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
CookieHelper_Cai.AddCookie("WaterFee", "Uname", names, 1);
CookieHelper_Cai.AddCookie("WaterFee", "Uid", dt.Rows[0]["ad_ID"].ToString(), 1);
CookieHelper_Cai.AddCookie("WaterFee", "Utruename", System.Web.HttpUtility.UrlEncode(dt.Rows[0]["ad_userTrueName"].ToString()), 1);
Response.Redirect("Default.aspx");
}
else
{
JSscript.AlertAndGoTo("用户名密码正确,但未设定真实姓名,请联系管理员", "Default.aspx");
Response.End();
}
}
else
{
JSscript.AlertAndGoTo("用户名密码正确,但未设定真实姓名,请联系管理员", "Default.aspx");
Response.End();
}
}
else
{
JSscript.AlertAndGoTo("登录失败,可能用户名密码不正确", "Default.aspx");
Response.End();
}
}
else
{
JSscript.AlertAndGoTo("帐号和密码都不能为空", "Default.aspx");
Response.End();
} }
}=================有关的cs片断是:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;/// <summary>
///AdminUserSExecutSqlS 的摘要说明
/// </summary>
public class AdminUserSExecutSqlS
{
public AdminUserSExecutSqlS()
{
//
//TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static bool Admin_User_Add(string uname,string upawd,string utruename)
{
string Sqls = "INSERT INTO [CaiZ_Admin_UserS] ([ad_userName] ,[ad_userPwd] ,[ad_userTrueName],[ad_loginTime]) VALUES ";
Sqls += " (@ad_userName ,@ad_userPwd ,@ad_userTrueName,@ad_loginTime)";
SqlParameter[] ParmS = new SqlParameter[] {
new SqlParameter("@ad_userName",uname),
new SqlParameter("@ad_userPwd",upawd),
new SqlParameter("@ad_userTrueName",utruename),
new SqlParameter("@ad_loginTime",System.DateTime.Now),
};
return SQLHelper.ExecuteSql(Sqls, ParmS) > 0;
}
/// <summary>
/// 用户是否为删除过的用户
/// </summary>
/// <param name="uname"></param>
/// <returns></returns>
public static bool IsDelByUserS(string uname)
{
string Sqls = "select ISNULL((select ad_id from CaiZ_Admin_UserS where ad_userName='" + uname + "'),0)";
return Convert.ToInt32(SQLHelper.GetSingle(Sqls)) > 0;
}
/// <summary>
/// 显示某一个用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static DataTable Admin_User_ShowOneByUname(string uname)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string Sqls = "select ad_ID,[ad_userName] ,[ad_userPwd] ,[ad_userTrueName] ,[ad_loginCount] ,[ad_loginTime] ,[ad_loginIp] ,[ad_stateLock]";
Sqls += " FROM [CaiZ_Admin_UserS] where [ad_stateDel]=0 and [ad_userName]='" + uname + "'";
ds = SQLHelper.Query(Sqls);
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return dt;
} /// <summary>
/// 显示某一个用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static DataTable Admin_User_List()
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string Sqls = "select ad_ID,[ad_userName] ,[ad_userPwd] ,[ad_userTrueName] ,[ad_loginCount] ,[ad_loginTime] ,[ad_loginIp] ,[ad_stateLock]";
Sqls += " FROM [CaiZ_Admin_UserS] where [ad_stateDel]=0 ";
ds = SQLHelper.Query(Sqls);
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return dt;
}
/// <summary>
/// 显示某一个用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static DataTable Admin_User_ShowOneById(int id)
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string Sqls = "select ad_ID,[ad_userName] ,[ad_userPwd] ,[ad_userTrueName] ,[ad_loginCount] ,[ad_loginTime] ,[ad_loginIp] ,[ad_stateLock]";
Sqls += " FROM [CaiZ_Admin_UserS] where [ad_stateDel]=0 and [ad_ID]=" + id + "";
ds = SQLHelper.Query(Sqls);
if (ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return dt;
} /// <summary>
/// 更新用户用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static bool Admin_User_Update(string utruename,int id)
{
string Sqls = "update [CaiZ_Admin_UserS] set [ad_userTrueName]=@ad_userTrueName ";
Sqls += " Where ad_ID=@ad_ID and ad_stateDel=0";
SqlParameter[] ParmS = new SqlParameter[] {
new SqlParameter("@ad_userTrueName",utruename),
new SqlParameter("@ad_ID",id),
};
return SQLHelper.ExecuteSql(Sqls, ParmS) > 0;
}
/// <summary>
/// 密码初始化
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static bool Admin_User_UpdatePwd(string upawd, int id)
{
string Sqls = "update [CaiZ_Admin_UserS] set [ad_userPwd]=@ad_userPwd ";
Sqls += "Where ad_ID=@ad_ID and ad_stateDel=0";
SqlParameter[] ParmS = new SqlParameter[] {
new SqlParameter("@ad_userPwd",upawd),
new SqlParameter("@ad_ID",id),
};
return SQLHelper.ExecuteSql(Sqls, ParmS) > 0;
}
/// <summary>
/// 密码初始化
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static bool Admin_User_Del(int id)
{
string Sqls = "update [CaiZ_Admin_UserS] set [ad_stateDel]=1 ";
Sqls += "Where ad_ID=@ad_ID and ad_stateDel=0";
SqlParameter[] ParmS = new SqlParameter[] {
new SqlParameter("@ad_ID",id),
};
return SQLHelper.ExecuteSql(Sqls, ParmS) > 0;
} /// <summary>
/// 更新用户用户
/// </summary>
/// <param name="uname"></param>
/// <param name="upawd"></param>
/// <param name="utruename"></param>
/// <returns></returns>
public static bool Admin_User_LoginIn(string utruename, string pwd,string ip)
{
string Sqls = "update [CaiZ_Admin_UserS] set ad_loginCount=ad_loginCount+1,ad_loginTime=@ad_loginTime,ad_loginIp=@ad_loginIp";
Sqls += " Where [ad_userName]=@ad_userName and ad_userPwd=@ad_userPwd and ad_stateDel=0";
SqlParameter[] ParmS = new SqlParameter[] {
new SqlParameter("@ad_loginTime",System.DateTime.Now),
new SqlParameter("@ad_loginIp",ip),
new SqlParameter("@ad_userName",utruename),
new SqlParameter("@ad_userPwd",pwd),
};
return SQLHelper.ExecuteSql(Sqls, ParmS) > 0;
}}估计是最后更新用户用户这段代码有问题.请教高手。