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