public Viwer(int id)
{
InitializeComponent();
db = Model.DatabaseConfigure.getConfigure();
this.ForeColor = Color.Black;
this.user = db.admins.Find(id);
label_username.Text = this.user.name;
label_role.Text = RoleManagement.CurrentRole.rolename[this.user.role];
checkBox_enabled.Checked = this.user.enabled;
checkColor();
init = true;
}
public int hh(Model.admin ad)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into admin(_admin_name,_password) values(@name,@pwd)");
SqlParameter[] par = { new SqlParameter("@name", SqlDbType.VarChar, 50),
new SqlParameter("@pwd", SqlDbType.VarChar, 50) };
par[0].Value = ad.name;
par[1].Value = ad.pwd;
int result = Common.DbHelperSQL.ExecuteSql(sql.ToString(), par);
return(result);
}
private void materialButton_addnew_Click(object sender, EventArgs e)
{
if (betterTextBox_username.Text.Trim() == "")
{
CustomControls.Alert.show("Add User", "Please Enter Username", 3000);
return;
}
if (betterTextBox_password.Text.Trim() == "" || betterTextBox_retypepassword.Text.Trim() == "")
{
CustomControls.Alert.show("Add User", "Password Cannot be blank", 3000);
return;
}
if (betterTextBox_password.Text.Trim() != betterTextBox_retypepassword.Text.Trim())
{
CustomControls.Alert.show("Add User", "Please Rematch the password", 3000);
return;
}
if (comboBox_roles.SelectedIndex < 0)
{
CustomControls.Alert.show("Add User", "Please Select The Role", 3000);
return;
}
var password = CustomControls.Encrypt.EncryptString(betterTextBox_password.Text.Trim(), "need12345");
var user = new Model.admin()
{
name = betterTextBox_username.Text.Trim(),
password = password,
role = comboBox_roles.SelectedIndex,
updated_at = DateTime.Now,
created_at = DateTime.Now,
enabled = true
};
db.admins.Add(user);
db.SaveChanges();
add?.Invoke(user.id);
betterTextBox_username.Clear();
betterTextBox_password.Clear();
betterTextBox_retypepassword.Clear();
comboBox_roles.SelectedIndex = -1;
flowLayoutPanel.Controls.Add(new Viwer(user.id));
}
/// <summary>
/// 根据用户名查询相关信息
/// </summary>
/// <param name="Ma">实体层admin类的对象</param>
/// <returns>DataSet数据集合</returns>
public DataSet QueryUserInfoByName(Model.admin Ma)
{
return(DALad.QueryUserInfoByName(Ma.username));
}
/// <summary>
/// 修改管理员密码,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="Cid">管理员用户Cid</param>
/// <param name="del_ad">实体层类的对象</param>
/// <returns>true,false</returns>
public bool UpdateAdminPassword(Model.admin del_ad)
{
string strSQL = "update admin set password='******' where cid=" + del_ad.cid;
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 修改管理员用户权限,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="Cid">管理员用户Cid</param>
/// <param name="del_ad">实体层类的对象</param>
/// <returns>true,false</returns>
public bool UpdateAdminAleave(Model.admin del_ad)
{
string strSQL = "update admin set aleave='" + del_ad.aleave + "' where cid=" + del_ad.cid;
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 添加管理员用户,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="del_ad">实体层类的对象</param>
/// <returns>true,false</returns>
public bool AddUser(Model.admin del_ad)
{
string strSQL = "insert into admin (username,password,email,aleave) values ('" + del_ad.username + "','" + del_ad.password + "','" + del_ad.useremail + "','" + del_ad.aleave + "')";
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 删除用户信息,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="del_ad">实体层类的对象</param>
/// <returns>true,false</returns>
public bool DeleteAdmin(Model.admin ma)
{
string strSQL = "delete from admin where cid=" + ma.cid;
return(db.ExecuteNonQuery(false, strSQL));
}
public int insert(Model.admin ad)
{
DAL.dalhhh dalhh = new DAL.dalhhh();
return(dalhh.hh(ad));
}
/// <summary>
/// 根据ID修改相关信息
/// </summary>
/// <param name="ma">实体层admin类的对象</param>
/// <returns>true,false</returns>
public bool UpdateUserInfo(Model.admin ma)
{
string strSQL = "update admin set username='******',password='******',email='" + ma.useremail + "',aleave='" + ma.aleave + "' where cid=" + ma.cid;
return(db.ExecuteNonQuery(false, strSQL));
}
/// <summary>
/// 根据用户名修改用户数据
/// </summary>
/// <param name="Ma">实体层admin类的对象</param>
/// <returns>bool值</returns>
public bool UpdateUserInfoByName(Model.admin Ma)
{
return(DALad.UpdateUserInfoByName(Ma.username, Ma.password, Ma.useremail));
}
/// <summary>
/// 根据ID修改相关信息
/// </summary>
/// <param name="ma">实体层admin类的对象</param>
/// <returns>true,false</returns>
public bool UpdateUserInfo(Model.admin ma)
{
return(DALad.UpdateUserInfo(ma));
}
/// <summary>
/// 删除用户信息,语句执行成功返回true,否则返回false
/// </summary>
/// <returns>true,fasle</returns>
public bool DeleteAdmin(Model.admin ma)
{
return(DALad.DeleteAdmin(ma));
}
/// <summary>
/// 添加用户,语句执行成功返回true,否则返回false
/// </summary>
/// <param name="M_ad">实体层admin类的对象</param>
/// <returns>true,false</returns>
public bool AddUser(Model.admin M_ad)
{
return(DALad.AddUser(M_ad));
}
/// <summary>
/// 返回记录总数,用户登陆的方法
/// </summary>
/// <param name="Ma">实体层admin类的对象</param>
/// <returns>记录行数</returns>
public int ReRowCount(Model.admin Ma)
{
return(DALad.ReRowCount(Ma.username, Ma.password));
}
/// <summary>
/// 用户用户登陆的方法
/// </summary>
/// <param name="Ma">实体层admin类的对象</param>
/// <returns>数据集合</returns>
public DataSet UserLogin(Model.admin Ma)
{
return(DALad.UserLogin(Ma.username, Ma.password));
}
/// <summary>
/// 检测用户名是否存在
/// </summary>
/// <param name="Ma">实体层admin类的对象</param>
/// <returns>整型数据</returns>
public int CheckUser(Model.admin Ma)
{
return(DALad.CheckUser(Ma.username));
}
