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;
}
