private void btnLogin_Click(object sender, EventArgs e)
{
try
{
string strUserName = txtUserName.Text.Trim();
string strPwd = txtPwd.Text.Trim();
if (strUserName == string.Empty)
{
MessageBox.Show("用户名不能为空！");
return;
}
if (strPwd == string.Empty)
{
MessageBox.Show("密码不能为空！");
return;
}
string strEpwd = DES.Encrypt3DES(strPwd);
MyUserEntity myUser = new MyUserEntity();
myUser.userName = strUserName;
myUser.userPwd = strEpwd;
string jsonPar = JsonHelper.ToJson(myUser);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart;
doLogin(realUrl, jsonPar);
}catch (Exception ex)
{
MessageBox.Show("登录失败，" + ex.Message);
}
}
public ReturnResultEntity <object> UpdateUser(MyUserEntity myUserPar)
{
ReturnResultEntity <object> returnResultEntity = new ReturnResultEntity <object>();
bool bSuccess = false;
try
{
string sqlOldPwd = string.Format("SELECT user_pwd from my_user where user_id={0} and is_deleted=0 limit 1",
myUserPar.userId);
object objOldPwd = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteScalar(sqlOldPwd);
if (myUserPar.userPwd != objOldPwd.ToString())
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "旧密码输入错误";
return(returnResultEntity);
}
string sql = string.Format("UPDATE my_user set user_pwd='{1}',u_t='{2}' where user_id={0}", myUserPar.userId, myUserPar.userPwdNew, DateTime.Now);
int rowNum = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteNonQuery(sql);
if (rowNum > 0)
{
bSuccess = true;
}
returnResultEntity.success = bSuccess;
returnResultEntity.data = bSuccess;
return(returnResultEntity);
}
catch (Exception ex)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "修改密码异常," + ex.Message;
return(returnResultEntity);
}
}
public MyUserEntity Delu(MyUserEntity Userentity)
{
string sql = "select * from MyUser where UserAccount=@UserAccount and UserPwd=@UserPwd";
db.PrepareSql(sql);
db.SetParameter("UserAccount", Userentity.UserAccount);
db.SetParameter("UserPwd", Userentity.UserPwd);
DataTable dt = db.ExecQuery();
if (dt.Rows.Count != 1)
{
return null;
}
else
{
MyUserEntity entity = new MyUserEntity();
entity.UserId = int.Parse(dt.Rows[0]["UserId"].ToString());
entity.RoleId = int.Parse(dt.Rows[0]["RoleId"].ToString());
entity.UserAccount = dt.Rows[0]["UserAccount"].ToString();
entity.UserPwd = dt.Rows[0]["UserPwd"].ToString();
entity.UserRealName = dt.Rows[0]["UserRealName"].ToString();
entity.UserPhone = dt.Rows[0]["UserPhone"].ToString();
entity.UserPowerList = dt.Rows[0]["UserPowerList"].ToString();
entity.UserTime = DateTime.Parse(dt.Rows[0]["UserTime"].ToString());
return entity;
}
}
public int Update(MyUserEntity entity)
{
string sql = "Update MyUser set RoleId=@RoleId,UserPwd=@UserPwd,UserRealName=@UserRealName,UserPhone=@UserPhone where UserId=@UserId";
db.PrepareSql(sql);
db.SetParameter("RoleId", entity.RoleId);
db.SetParameter("UserPwd", entity.UserPwd);
db.SetParameter("UserRealName", entity.UserRealName);
db.SetParameter("UserPhone", entity.UserPhone);
db.SetParameter("UserId", entity.UserId);
return db.ExecNonQuery();
}
public int Add(MyUserEntity entity)
{
string sql = @"insert into MyUser(RoleId,UserAccount,UserPwd,UserRealName,UserPhone,UserPowerList,UserTime)
values(@RoleId, @UserAccount,@UserPwd,@UserRealName, @UserPhone, '', GETDATE())";
db.PrepareSql(sql);
db.SetParameter("RoleId", entity.RoleId);
db.SetParameter("UserAccount", entity.UserAccount);
db.SetParameter("UserPwd", entity.UserPwd);
db.SetParameter("UserRealName", entity.UserRealName);
db.SetParameter("UserPhone", entity.UserPhone);
return db.ExecNonQuery();
}
public bool RegisterUser(MyUserEntity myUserEntity)
{
bool bOk = false;
string sql = String.Format("insert into my_user values(null,'{0}','{1}','{2}')", myUserEntity.userName, myUserEntity.userPhone, myUserEntity.userPwd);
int num = MySqlHelper.ExecuteNonQuery(sql);
if (num >= 1)
{
bOk = true;
}
return(bOk);
}
private void User_list()
{
MyUserBLL myUserBLL = new MyUserBLL();
MyUserEntity userEntity = new MyUserEntity();
userEntity.UserAccount = Request["UserAccount"];
userEntity.UserRealName = Request["UserRealName"];
int count = 0;
List <MyUserEntity> list = myUserBLL.list(userEntity, int.Parse(Request["PageInt"]), int.Parse(Request["PageSize"]), out count);
Response.Write(count + "||" + MyJson.ToJsJson(list));
Response.End();
}
public MyUserEntity list(int id)
{
string sql = "select MyUser.*,MyRole.RolePowerList from MyUser left join MyRole on MyUser.RoleId=MyRole.RoleId where UserId=" + id;
db.PrepareSql(sql);
DataTable dt = db.ExecQuery();
if (dt.Rows.Count == 0)
return null;
MyUserEntity entity = new MyUserEntity();
entity.UserId = int.Parse(dt.Rows[0]["UserId"].ToString());
entity.RoleId = int.Parse(dt.Rows[0]["RoleId"].ToString());
entity.UserAccount = dt.Rows[0]["UserAccount"].ToString();
entity.UserPwd = dt.Rows[0]["UserPwd"].ToString();
entity.UserRealName = dt.Rows[0]["UserRealName"].ToString();
entity.UserPhone = dt.Rows[0]["UserPhone"].ToString();
entity.UserPowerList = dt.Rows[0]["UserPowerList"].ToString();
entity.UserTime = DateTime.Parse(dt.Rows[0]["UserTime"].ToString());
entity.Role = new MyRoleEntity();
entity.Role.RolePowerList= dt.Rows[0]["RolePowerList"].ToString();
return entity;
}
public List<MyUserEntity> list()
{
List<MyUserEntity> list = new List<MyUserEntity>();
string sql = "select * from MyUser";
db.PrepareSql(sql);
DataTable dt = db.ExecQuery();
foreach (DataRow item in dt.Rows)
{
MyUserEntity entity = new MyUserEntity();
entity.UserId = int.Parse(item["UserId"].ToString());
entity.RoleId = int.Parse(item["RoleId"].ToString());
entity.UserAccount = item["UserAccount"].ToString();
entity.UserPwd = item["UserPwd"].ToString();
entity.UserRealName = item["UserRealName"].ToString();
entity.UserPhone = item["UserPhone"].ToString();
entity.UserPowerList = item["UserPowerList"].ToString();
entity.UserTime = DateTime.Parse(item["UserTime"].ToString());
list.Add(entity);
}
return list;
}
private void bindata()
{
MyUserEntity myUserEntity = (MyUserEntity)Session["myuser"];
MyUserBLL userBLL = new MyUserBLL();
myUserEntity = userBLL.list(myUserEntity.UserId);
string stry = "";
if (!string.IsNullOrWhiteSpace(myUserEntity.UserPowerList))
{
stry += myUserEntity.UserPowerList;
}
if (!string.IsNullOrWhiteSpace(myUserEntity.UserPowerList) && !string.IsNullOrWhiteSpace(myUserEntity.Role.RolePowerList))
{
stry += ",";
}
if (!string.IsNullOrWhiteSpace(myUserEntity.Role.RolePowerList))
{
stry += myUserEntity.Role.RolePowerList;
}
string[] koo = stry.Split(',');
ViewState["koo"] = koo;
MyPowerBLL myPower = new MyPowerBLL();
List <MyPowerEntity> powerEntity = myPower.list("___");
List <MyPowerEntity> mies = new List <MyPowerEntity>();
for (int i = 0; i < powerEntity.Count; i++)
{
for (int j = 0; j < koo.Length; j++)
{
if (powerEntity[i].PowerId.Equals(koo[j]))
{
mies.Add(powerEntity[i]);
break;
}
}
}
Repeater1.DataSource = mies;
Repeater1.DataBind();
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
string strOldPwd = txtOldPwd.Text.Trim();
string strNewPwd = txtNewPwd.Text.Trim();
string strConfrmNewPwd = txtConfirmNewPwd.Text.Trim();
if (strOldPwd == string.Empty)
{
MessageBox.Show("请输入旧密码");
txtOldPwd.Focus();
return;
}
if (strNewPwd == string.Empty)
{
MessageBox.Show("请输入新密码");
txtNewPwd.Focus();
return;
}
if (strNewPwd != strConfrmNewPwd)
{
MessageBox.Show("两次输入的新密码不一致");
txtConfirmNewPwd.Focus();
return;
}
string strEOldPwd = DES.Encrypt3DES(strOldPwd);
string strENewPwd = DES.Encrypt3DES(strNewPwd);
MyUserEntity myUserEntity = new MyUserEntity();
myUserEntity.userId = UserId;
myUserEntity.userPwd = strEOldPwd;
myUserEntity.userPwdNew = strENewPwd;
string jsonPar = JsonHelper.ToJson(myUserEntity);
string realUrl = ConfigHelper.ConfigHelper.GetApiRootUrl() + urlPart;
doEdit(realUrl, jsonPar);
}
catch (Exception ex)
{
MessageBox.Show("修改密码异常," + ex.Message);
}
}
public List<MyUserEntity> list(MyUserEntity myentity, int Pageint,int Pagesize,out int Count)
{
string sqlwhere = "";
if (myentity != null)
{
if (myentity.UserAccount != null && !myentity.UserAccount.Equals(""))
sqlwhere += " and UserAccount like'%"+ myentity.UserAccount + "%'";
if (myentity.UserRealName != null && !myentity.UserRealName.Equals(""))
sqlwhere += " and UserRealName like'%" + myentity.UserRealName + "%'";
}
string sql = "select count(*) from MyUser where 1=1 "+ sqlwhere;
db.PrepareSql(sql);
Count= int.Parse(db.ExecScalar().ToString());
List<MyUserEntity> list = new List<MyUserEntity>();
sql = @"select *from(
select ROW_NUMBER()over(order by UserId) rowid,MyUser.*,MyRole.RoleName,MyRole.RolePowerList from MyUser left join MyRole on MyUser.RoleId=MyRole.RoleId where 1=1 " + sqlwhere + ") Tamp where rowid between @satr and @end";
db.PrepareSql(sql);
db.SetParameter("satr", (Pageint-1)* Pagesize+1);
db.SetParameter("end", Pageint* Pagesize);
DataTable dt = db.ExecQuery();
foreach (DataRow item in dt.Rows)
{
MyUserEntity entity = new MyUserEntity();
entity.UserId = int.Parse(item["UserId"].ToString());
entity.RoleId = int.Parse(item["RoleId"].ToString());
entity.UserAccount = item["UserAccount"].ToString();
entity.UserPwd = item["UserPwd"].ToString();
entity.UserRealName = item["UserRealName"].ToString();
entity.UserPhone = item["UserPhone"].ToString();
entity.UserPowerList = item["UserPowerList"].ToString();
entity.UserTime = DateTime.Parse(item["UserTime"].ToString());
entity.Role = new MyRoleEntity();
entity.Role.RoleName= item["RoleName"].ToString();
entity.Role.RolePowerList = item["RolePowerList"].ToString();
list.Add(entity);
}
return list;
}
public ReturnResultEntity <MyUserEntity> Login(MyUserEntity myUserPar)
{
ReturnResultEntity <MyUserEntity> returnResultEntity = new ReturnResultEntity <MyUserEntity>();
try
{
if (myUserPar == null)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "参数不能为空";
return(returnResultEntity);
}
MyUserEntity myUserRtn = null;
string sql = string.Format("SELECT * from my_user where user_name='{0}' and user_pwd='{1}' and is_deleted=0",
myUserPar.userName, myUserPar.userPwd);
DataTable dtUser = WebApiForShiTiKu.Helper.MySqlHelper.ExecuteTable(sql);
if (dtUser != null && dtUser.Rows.Count > 0)
{
DataRow dr = dtUser.Rows[0];
myUserRtn = new MyUserEntity();
myUserRtn.userId = dr["user_id"] == DBNull.Value ? 0 : Convert.ToInt32(dr["user_id"].ToString());
myUserRtn.userName = dr["user_name"] == DBNull.Value ? string.Empty : dr["user_name"].ToString();
myUserRtn.userPhone = dr["user_phone"] == DBNull.Value ? string.Empty : dr["user_phone"].ToString();
myUserRtn.userPwd = dr["user_pwd"] == DBNull.Value ? string.Empty : dr["user_pwd"].ToString();
myUserRtn.cT = dr["c_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["c_t"].ToString());
myUserRtn.uT = dr["u_t"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(dr["u_t"].ToString());
myUserRtn.isDeleted = dr["is_deleted"] == DBNull.Value ? 0 : Convert.ToInt32(dr["is_deleted"].ToString());
}
returnResultEntity.success = true;
returnResultEntity.data = myUserRtn;
return(returnResultEntity);
}catch (Exception ex)
{
returnResultEntity.success = false;
returnResultEntity.errorMsg = "登录异常," + ex.Message;
return(returnResultEntity);
}
}
public MyUserEntity Login(MyUserEntity myUserEntity)
{
MyUserEntity myUser = new MyUserEntity();
string sql = String.Format(@"select * from my_user
where is_deleted=0
and user_name='{0}'
and user_pwd='{1}'", myUserEntity.userName, myUserEntity.userPwd);
DataTable dtUser = MySqlHelper.ExecuteTable(sql);
if (dtUser != null && dtUser.Rows.Count > 0)
{
DataRow drUser = dtUser.Rows[0];
myUser.userId = drUser["user_id"] == DBNull.Value ? 0 : Convert.ToInt32(drUser["user_id"].ToString());
myUser.userName = drUser["user_name"] == DBNull.Value ? string.Empty : drUser["user_name"].ToString();
myUser.userPhone = drUser["user_phone"] == DBNull.Value ? string.Empty : drUser["user_phone"].ToString();
myUser.userPwd = drUser["user_pwd"] == DBNull.Value ? string.Empty : drUser["user_pwd"].ToString();
}
else
{
myUser = null;
}
return(myUser);
}
private async void doLogin(string strUrl, string strJsonPar)
{
try
{
var stringContent = new StringContent(strJsonPar, Encoding.UTF8, "application/json");
var response = await client.PostAsync(strUrl, stringContent);
if (response.IsSuccessStatusCode)
{
string strJsonRtn = response.Content.ReadAsStringAsync().Result;
ReturnResultEntity <MyUserEntity> returnResultEntity = JsonHelper.FromJson <ReturnResultEntity <MyUserEntity> >(strJsonRtn);
if (returnResultEntity.success)
{
MyUserEntity myUserEntity = returnResultEntity.data;
if (myUserEntity != null)
{
FrmShiJuanManager frmShiJuanManager = new FrmShiJuanManager();
frmShiJuanManager.UserId = myUserEntity.userId;
frmShiJuanManager.UserName = myUserEntity.userName;
frmShiJuanManager.Show();
this.Hide();
}
}
else
{
MessageBox.Show("用户名或密码不正确");
}
}
else
{
MessageBox.Show("Post登录失败，调用WebApi出错了");
}
}catch (Exception ex)
{
MessageBox.Show("Post登录异常，" + ex.Message);
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
if (!txtValidate.Text.ToLower().Equals(Session["chek"].ToString().ToLower()))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('验证码输入错误！')</script>");
return;
}
MyUserEntity userEntity = new MyUserEntity();
MyUserBLL userBLL = new MyUserBLL();
userEntity.UserAccount = txtAccount.Text;
userEntity.UserPwd = txtPwd.Text;
userEntity = userBLL.Delu(userEntity);
if (userEntity != null)
{
Session["myuser"] = userEntity;
Response.Redirect("inc/Main.aspx");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "js", "<script>alert('用户名或密码错误！')</script>");
return;
}
}
public int Update(MyUserEntity entity)
{
return(dal.Update(entity));
}
public int Add(MyUserEntity entity)
{
return(dal.Add(entity));
}
public MyUserEntity Delu(MyUserEntity Userentity)
{
return(dal.Delu(Userentity));
}
public List <MyUserEntity> list(MyUserEntity myentity, int Pageint, int Pagesize, out int Count)
{
return(dal.list(myentity, Pageint, Pagesize, out Count));
}
