protected override void Loading()
{
if (!IsAdd)
{
var dict = MainDict.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(dict, tabPage1);
}
}
//public static DataTable GetAllMainDictTable(string optrType)
//{
// var dt = MainDict.Find(CK.K["OptrType"] == optrType).ToDataTable();
// dt.Columns.Remove("OptrType");
// dt.Columns.Remove("PreName");
// dt.Columns[1].ColumnName = "名称";
// dt.Columns[2].ColumnName = "类型";
// dt.Columns[3].ColumnName = "备注";
// return dt;
//}
public static void DelCell(long id)
{
//保留删除之前的名称然后才删除
var mainDict = MainDict.FindById(id);
mainDict.PreName = mainDict.Name;
mainDict.Save();
MainDict.DeleteAll(CK.K["Id"] == id);
}
public static List <MainDict> GetDict(string optrType, string dictType)
{
MainDict md = MainDict.New;
md.Id = 0;
md.Name = "";
List <MainDict> mainDicts = MainDict.Find(CK.K["OptrType"] == optrType && CK.K["DictType"] == dictType);
mainDicts.Insert(0, md);
return(mainDicts);
}
protected override void Saving()
{
if (IsAdd)
{
var dict = MainDict.New;
FrmAddEditBindComboBoxText.BindControlsToObject(dict, tabPage1);
dict.OptrType = UserStatics.OptrType;
dict.Save();
}
else
{
var dict = MainDict.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(dict, tabPage1);
dict.OptrType = UserStatics.OptrType;
dict.Save();
}
}
//public static DataTable GetUserActions(long optrId, long moduleId)
//{
// //找出该用户在这个模块的操作权限，但不包含"查看"
// SqlStatement ss = new SqlStatement("select * from MainAction where Id in (select [MainAction_Id] from [MainOptrAction] where [MainOptr_Id] = @OptrId and [MainModule_Id] = @ModuleId ) and Status = 0", new DataParameter("@OptrId", optrId), new DataParameter("@ModuleId", moduleId));
// return DbEntry.Context.ExecuteDataset(ss).Tables[0];
//}
public static DataTable GetTable(string optr, string optrType, string dictType)
{
DataTable dt;
if (optr == "root")
{
if (dictType != "请选择")
{
dt = MainDict.Find(CK.K["DictType"] == dictType).ToDataTable();
}
else
{
dt = MainDict.FindAll().ToDataTable();
}
}
else
{
if (dictType != "请选择")
{
dt = MainDict.Find(CK.K["OptrType"] == optrType && CK.K["DictType"] == dictType).ToDataTable();
}
else
{
dt = MainDict.Find(CK.K["OptrType"] == optrType).ToDataTable();
}
}
//dt.Columns.Remove("OptrType");
dt.Columns.Remove("PreName");
dt.Columns[1].ColumnName = "名称";
dt.Columns[2].ColumnName = "类型";
dt.Columns[3].ColumnName = "操作类型";
dt.Columns[4].ColumnName = "备注";
dt.Columns[5].ColumnName = "修改时间";
return(dt);
}