/// <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); }