public bool AddCategory(string strName, bool blInUse, string strDescription) { bool bResult = false; System.DateTime time = System.DateTime.Now; HybridDictionary hTable = new HybridDictionary(); hTable.Add("PMS_CTG_NAME", strName); hTable.Add("USE_IDT", blInUse); hTable.Add("CRT_DATE", time); hTable.Add("UPD_DATE", time); hTable.Add("DES", strDescription); try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName); bResult = pl.Insert(hTable) > 0?true:false; return(bResult); } catch (Exception ex) { throw ex; } }
public bool UpdateByName(string strName, bool blInUse, string strDescription) { bool bResult = false; string strCommand = "UpdateByName"; System.DateTime time = System.DateTime.Now; HybridDictionary hTable = new HybridDictionary(); hTable.Add("PMS_CTG_NAME", strName); hTable.Add("USE_IDT", blInUse); hTable.Add("UPD_DATE", time); hTable.Add("DES", strDescription); try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName); bResult = pl.ExecuteNonQuery(CommandType.Text, strCommand, hTable) > 0?true:false; return(bResult); } catch (Exception ex) { throw ex; } }
/// <summary> /// 获取操作实体表 /// </summary> /// <param name="strEntityName">实体名称</param> /// <returns>操作实体表</returns> public static ISingleTable GetEntityTbl(string strEntityName) { Manager manager = GetInstance(); ISingleTable entityTbl = manager.Entities[strEntityName] as ISingleTable; return(entityTbl); }
public void Initialize(ISingleTable Table, string Name) { this.Table = Table; if (this.Name == null) { this.Name = Name; } }
public lyf_UserRolePermission() { // //TODO: 在此处添加构造函数逻辑 // _manager = (Manager)(Managers.Members["NewUtilityOra"]); _entity = (ISingleTable)(_manager.Entities["USER_ROLE_PMS_VIEW"]); _entityPMS = (ISingleTable)(_manager.Entities["PERMISSION_VIEW"]); }
/// <summary> /// 读取所有权限类别 /// </summary> /// <returns></returns> public DataTable GetAllCategory() { try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName); return(pl.GetDataTable()); } catch (Exception e) { throw e; } }
public DataTable GetAllName() { string strCommand = "GetAllCategory"; try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName); return(pl.ExecuteDataTable(CommandType.Text, strCommand)); } catch (Exception e) { throw e; } }
public DataTable GetAcitivePermissions() { try { string strCommand = "GetAllActive"; ISingleTable pl = UserManager.GetEntityTbl(strEntityName); return(pl.ExecuteDataTable2(CommandType.Text, strCommand)); } catch (Exception e) { throw e; } }
public DataTable GetByCategory(string strCategory) { try { string strCommand = "GetByCategory"; HybridDictionary hTable = new HybridDictionary(); hTable.Add("PMS_CTG_NAME", strCategory); ISingleTable pl = UserManager.GetEntityTbl(strEntityName); return(pl.ExecuteDataTable2(CommandType.Text, strCommand, hTable)); } catch (Exception e) { throw e; } }
public void UpdateAll(DataTable dtMerger) { try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName);; DataSet ds = new DataSet(); ds.Tables.Add(pl.GetDataTable()); ds.Tables[0].TableName = "PermissionCategory"; dtMerger.TableName = "PermissionCategory"; // ds.EnforceConstraints =false; ds.Merge(dtMerger, false, MissingSchemaAction.Ignore); pl.UpdateDataTable(ds.Tables[0]); // return ds.Tables[0]; } catch (Exception ex) { throw ex; } }
public void UpdateAll(DataTable dtMerger) { try { ISingleTable pl = CoreDataManager.GetEntityTbl(strEntityName);; DataSet ds = new DataSet(); ds.Tables.Add(pl.GetDataTable()); ds.Tables[0].TableName = "Users"; dtMerger.TableName = "Users"; ds.Merge(dtMerger, false, MissingSchemaAction.Ignore); pl.UpdateDataTable(ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public bool ChangePWD(string strUser, string strPWD) { bool bResult = false; string strCommand = "ChangePWD"; HybridDictionary hTable = new HybridDictionary(); hTable.Add("USER_ID", strUser); hTable.Add("PWD", strPWD); try { ISingleTable pl = UserManager.GetEntityTbl(strEntityName); bResult = Convert.ToInt32(pl.ExecuteScalar(CommandType.Text, strCommand, hTable)) > 0?true:false; return(bResult); } catch (Exception ex) { throw ex; } }
public Join(ISingleTable OtherTable, IColumn FirstColumn, IColumn SecondColumn) { this.OtherTable = OtherTable; this.FirstColumn = FirstColumn; this.SecondColumn = SecondColumn; }
public JoinedTables(ISingleTable FirstTable, IJoin Join) { this.joins = new List <IJoin>(); joins.Add(Join); this.FirstTable = FirstTable; }