//删除 public override bool DeleteData() { try { if (XtraMessageBox.Show("是否删除选中的数据?", "友情提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { int[] rows = gridView1.GetSelectedRows(); for (int i = 0; i < rows.Length; i++) { AdminsCls val = (AdminsCls)gridView1.GetRow(rows[i]); AdminsDAL.DeleteAdminsById(val.Id); } } QueryAll(); init_cmbbox(); return(true); } catch (System.Exception ex) { return(false); } }
//修改 public static int ModifyAdmins(AdminsCls adc) { using (HullShellContainer hs = new HullShellContainer()) { Admins adm = hs.AdminsSet.Where(a => a.Id == adc.Id).FirstOrDefault(); adm.UserName = adc.UserName; adm.PassWod = adc.PassWord; adm.Role = adc.Role; return(hs.SaveChanges()); } }
//查询 public static AdminsCls QueryAdmin(string _name) { using (HullShellContainer hs = new HullShellContainer()) { Admins adm = hs.AdminsSet.Where(a => a.UserName == _name).FirstOrDefault(); AdminsCls adc = new AdminsCls(); adc.Id = adm.Id; adc.UserName = adm.UserName; adc.PassWord = adm.PassWod; adc.Role = adm.Role; return(adc); } }
//增加 public static int AddAdmin(AdminsCls adc) { using (HullShellContainer hs = new HullShellContainer()) { Admins adm = new Admins { UserName = adc.UserName, PassWod = adc.PassWord, Role = adc.Role }; hs.AddToAdminsSet(adm); return(hs.SaveChanges()); } }
public override bool SelectRecord() { try { int[] rows = gridView1.GetSelectedRows(); adcModify = (AdminsCls)gridView1.GetRow(rows[0]); textEdit1.Text = adcModify.UserName; textEdit2.Text = adcModify.PassWord; textEdit3.Text = adcModify.Role; return(true); } catch (System.Exception ex) { return(false); } }
public override bool RefreshData() { try { string UserName = this.ItemObjectList.EditValue.ToString(); AdminsCls val = AdminsDAL.QueryAdmin(UserName); AdminBindingSource.DataSource = val; gridControl1.DataSource = AdminBindingSource; return(true); } catch (System.Exception ex) { return(false); } //return base.RefreshData(); }
//获得所有的用户 public static List <AdminsCls> GetAllAdminsCls() { using (HullShellContainer hs = new HullShellContainer()) { List <AdminsCls> adcList = new List <AdminsCls>(); List <Admins> val = hs.AdminsSet.Where(a => a.Id >= 0).ToList(); foreach (var item in val) { AdminsCls adc = new AdminsCls { Id = item.Id, UserName = item.UserName, PassWord = item.PassWod, Role = item.Role }; adcList.Add(adc); } return(adcList); } }
//保存 public override bool SaveDataA() { try { if (AddorModify == AddOrModifyEnum.Add) { AdminsCls val = new AdminsCls(); val.UserName = this.textEdit1.Text.ToString(); val.PassWord = this.textEdit2.Text.ToString(); val.Role = this.textEdit3.Text.ToString(); int re = AdminsDAL.AddAdmin(val); AdminBindingSource.DataSource = val; gridControl1.DataSource = AdminBindingSource; // AdminBindingSource.DataSource=; textEdit1.Text = ""; textEdit2.Text = ""; textEdit3.Text = ""; //this.layoutControl1.Enabled = false; this.layoutControlGroup1.Enabled = false; if (re > 0) { MessageBox.Show("新用户添加成功!"); return(true); } else { return(false); } } else if (AddorModify == AddOrModifyEnum.Modify) { adcModify.UserName = textEdit1.Text.ToString(); adcModify.PassWord = textEdit2.Text.ToString(); adcModify.Role = textEdit3.Text.ToString(); int re = AdminsDAL.ModifyAdmins(adcModify); this.layoutControlGroup1.Enabled = false; AdminBindingSource.DataSource = adcModify; gridControl1.DataSource = AdminBindingSource; if (re > 0) { MessageBox.Show("修改成功!"); return(true); } else { return(false); } } else { return(false); } } catch (System.Exception ex) { return(false); } }