public static void SaveNewPass(long id, string pass)
{
MainOptr mo = MainOptr.FindById(id);
mo.Password = EncryptDecrypt.MD5(pass);
mo.Save();
}
public static DataTable GetMainOptrDataTable(string type)
{
if (type != "All")
{
var dt = MainOptr.Find(CK.K["IsDeleted"] == 0 && CK.K["MainOptrType"] == type).ToDataTable();
dt.Columns.Remove("Password");
dt.Columns[1].ColumnName = "用户名";
dt.Columns[2].ColumnName = "中文名";
dt.Columns[3].ColumnName = "类型";
dt.Columns[4].ColumnName = "备注";
dt.Columns[5].ColumnName = "保存时间";
return(dt);
}
else
{
var dt = MainOptr.Find(CK.K["IsDeleted"] == 0).ToDataTable();
dt.Columns.Remove("Password");
dt.Columns[1].ColumnName = "用户名";
dt.Columns[2].ColumnName = "中文名";
dt.Columns[3].ColumnName = "类型";
dt.Columns[4].ColumnName = "备注";
dt.Columns[5].ColumnName = "保存时间";
return(dt);
}
}
public static bool CheckLogin(string name, string password)
{
password = XSolo.Common.EncryptDecrypt.MD5(password);
var recordCount = MainOptr.Find(CK.K["Name"] == name && CK.K["Password"] == password).Count;
return(recordCount >= 1);
}
protected override void Saving()
{
//todo 判断如果用户存在，则不允许保存，提示改名
//加密密码text
ctPassword.Text = EncryptDecrypt.MD5(ctPassword.Text);
if (IsAdd)
{
var optr = MainOptr.New;
FrmAddEditBindComboBoxText.BindControlsToObject(optr, tabPage1);
optr.Save();
}
else
{
if (cbSavePassword.Checked)
{
var optr = MainOptr.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(optr, tabPage1);
optr.Save();
}
else
{
var optr = MainOptr.FindById(long.Parse(ItemID));
optr.Name = ctName.Text;
optr.Description = ctDescription.Text;
optr.MainOptrType = ctMainOptrType.Text;
optr.Save();
}
}
}
private void FrmACLUserEdit_Load(object sender, EventArgs e)
{
if (!IsAdd)
{
var optr = MainOptr.FindById(long.Parse(ItemID));
FrmAddEditBind.BindObjectToControls(optr, tabPage1);
}
}
public static DataTable GetMainOptrDataTable()
{
var dt = MainOptr.Find(CK.K["IsDeleted"] == 0).ToDataTable();
dt.Columns[1].ColumnName = "名称";
dt.Columns[2].ColumnName = "密码";
dt.Columns[3].ColumnName = "备注";
dt.Columns[4].ColumnName = "更新日期";
return(dt);
}
public static void DeleteUserModule(long id, long mmId)
{
DbEntry.UsingTransaction(delegate
{
MainOptr mo = MainOptr.FindById(id);
MainModule ma = MainModule.FindById(mmId);
mo.Modules.Remove(ma);
mo.Save();
});
}
public static void DeleteUserModule(long id, string txt)
{
DbEntry.UsingTransaction(delegate
{
MainOptr mo = MainOptr.FindById(id);
MainModule ma = MainModule.FindOne(CK.K["ChineseName"] == txt);
mo.Modules.Remove(ma);
mo.Save();
});
}
public static void InsertUserModule(long id, string txt)
{
DbEntry.UsingTransaction(delegate
{
DeleteUserModule(id, txt);
MainOptr mm = MainOptr.FindById(id);
MainModule ma = MainModule.FindOne(CK.K["ChineseName"] == txt);
mm.Modules.Add(ma);
mm.Save();
});
}
public static bool CheckOldPass(long id, string pass)
{
MainOptr mo = MainOptr.FindById(id);
MessageBox.Show(UserStatics.OptrId + " " + EncryptDecrypt.MD5(pass) + " " + mo.Password);
if (EncryptDecrypt.MD5(pass) == mo.Password)
{
return(true);
}
return(false);
}
//public static List<string> GetUserNameList()
//{
// var strs = new List<string>();
// var myops = new Select("Name").From("SysOptrs").ExecuteTypedList<SysOptr>();
// foreach (SysOptr a in myops)
// {
// strs.Add(a.Name);
// }
// return strs;
//}
public static List <string> GetUserNameList()
{
var strs = new List <string>();
var myops = MainOptr.FindAll();
foreach (MainOptr mainOptr in myops)
{
strs.Add(mainOptr.Name);
}
return(strs);
}
public static void InsertUserModule(long id, long mmId)
{
DbEntry.UsingTransaction(delegate
{
DeleteUserModule(id, mmId);
MainOptr mm = MainOptr.FindById(id);
MainModule ma = MainModule.FindById(mmId);
mm.Modules.Add(ma);
mm.Save();
});
}
protected override void toolStripButtonSave_Click(object sender, EventArgs e)
{
//加密密码text
ctPassword.Text = EncryptDecrypt.MD5(ctPassword.Text);
if (IsAdd)
{
var optr = MainOptr.New;
FrmAddEditBind.BindControlsToObject(optr, tabPage1);
optr.Save();
}
else
{
var optr = MainOptr.FindById(long.Parse(ItemID));
FrmAddEditBind.BindControlsToObject(optr, tabPage1);
optr.Save();
}
}
protected override void Loading()
{
if (IsAdd)
{
cbSavePassword.Visible = false;
}
else
{
var optr = MainOptr.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(optr, tabPage1);
}
if (UserStatics.OptrType != "All")
{
ctMainOptrType.Text = UserStatics.OptrType;
}
}
public static MainOptr GetUser(string name)
{
var mainoptr = MainOptr.FindOne(CK.K["Name"] == name);
return(mainoptr);
}
public static void DelCell(long id)
{
MainOptr.DeleteAll(CK.K["Id"] == id);
}
public static IList <MainModule> GetOptrModules(long id)
{
return(MainOptr.FindById(id).Modules);
}
