/// <summary>
/// 添加负责人
/// </summary>
/// <returns></returns>
public string AddfzrAjax()
{
string Meeting = Request["va1"];
string UserName = Request["va2"];
string Password = Request["va3"];
string Start_Date = Request["va4"];
string End_Date = Request["va5"];
string tel = Request["va6"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@Meeting", Meeting),
new SqlParameter("@Bank", UserName),
new SqlParameter("@Password", Passwd.SetPass(Password)),
new SqlParameter("@Start_Date", Start_Date),
new SqlParameter("@End_Date", End_Date),
new SqlParameter("@UserName", tel)
};
MessasgeData mgdata = Datafun.MgfunctionData("bs_NewMeeting_poc", pms, "poc");
if (Convert.ToInt32(mgdata.Mgdata.Rows[0][0].ToString()) > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
/// <summary>
/// 修改密码
/// </summary>
/// <returns></returns>
public string UpdatePassWordAjax()
{
string UserID = LgUser.UserId;
string password = Request["va1"];
string IsSuccess = "1";
SqlParameter[] pms =
{
new SqlParameter("@UserID", UserID),
new SqlParameter("@password", Passwd.SetPass(password))
};
MessasgeInfor mginfor = Datafun.Mgfunctioninfor(@"update tb_login set Password=@password where id=@UserID", pms);
if (mginfor.Mgdatacount > 0)
{
IsSuccess = "0";
}
else
{
IsSuccess = "1";
}
return(IsSuccess);
}
public string LoginActionUser()
{
string username = Request["va1"];
string password = Request["va2"];
string IsSuccess = "0";
string time = DateTime.Now.ToString();
string sql = @"select * from tb_login where UserName=@UserName and Password=@Password and isdel=0 and convert(nvarchar(11),Start_Date,120)<= convert(nvarchar(11),getdate(),120) and convert(nvarchar(11),End_Date,120)>= convert(nvarchar(11),getdate(),120)";
SqlParameter[] pms =
{
new SqlParameter("@UserName", username),
new SqlParameter("@Password", Passwd.SetPass(password))
};
MessasgeData mgdata = Datafun.MgfunctionData(sql, pms);
if (mgdata.Mgdatacount > 0)
{
DataRow dr = mgdata.Mgdata.Rows[0];
LoginUser lguser = new LoginUser
{
UserId = dr["id"].ToString(),
UserName = dr["UserName"].ToString(),
UserPwd = dr["Password"].ToString(),
UserLvl = int.Parse(dr["Lvl"].ToString()),
Bank = dr["Bank"].ToString(),
Tel = dr["Tel"].ToString(),
Meetting = dr["Meeting"].ToString()
};
Session["Lguser"] = lguser;
Response.Cookies["loginname"].Value = Passwd.SetPass(username);
Response.Cookies["loginpwd"].Value = password;
Response.Cookies["loginname"].Expires = DateTime.Now.AddDays(10);
Response.Cookies["loginpwd"].Expires = DateTime.Now.AddDays(10);
mgdata.Mgcontent = "登陆成功";
if (lguser.UserLvl == 0)
{
IsSuccess = "1";
}
else
{
IsSuccess = "2";
}
}
else
{
mgdata.Mgcontent = "用户名密码错误";
IsSuccess = "0";
}
return(IsSuccess);
}