public void Insert(string SUID, long IRoleID, long IParentRoleID, string FpSBranchID)
{
TblRolesForUser item = new TblRolesForUser();
item.SUID = SUID;
item.IRoleID = IRoleID;
item.IParentRoleID = IParentRoleID;
item.FpSBranchID = FpSBranchID;
item.Save(UserName);
}
public static void SaveSysUserMap(long varIRole, string[] itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (string item in itemList)
{
TblRolesForUser varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole);
varTblRolesForUser.SetColumnValue("FP_sBranchID", item);
varTblRolesForUser.Save();
}
}
public void Update(string SUID, long IRoleID, long IParentRoleID, string FpSBranchID)
{
TblRolesForUser item = new TblRolesForUser();
item.MarkOld();
item.IsLoaded = true;
item.SUID = SUID;
item.IRoleID = IRoleID;
item.IParentRoleID = IParentRoleID;
item.FpSBranchID = FpSBranchID;
item.Save(UserName);
}
public static void SaveSysManagementUnitMap(string varPkSuid, SysManagementUnitCollection items)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysUser.Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varPkSuid, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (SysManagementUnit item in items)
{
TblRolesForUser varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varPkSuid);
varTblRolesForUser.SetColumnValue("FP_sBranchID", item.GetPrimaryKeyValue());
varTblRolesForUser.Save();
}
}
public static void SaveSysManagementUnitMap(long varIRole, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [tbl_RolesForUsers] WHERE [tbl_RolesForUsers].[FP_sBranchID] = @FP_sBranchID", SysRole.Schema.Provider.Name);
cmdDel.AddParameter("@FP_sBranchID", varIRole, DbType.String);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
TblRolesForUser varTblRolesForUser = new TblRolesForUser();
varTblRolesForUser.SetColumnValue("FP_sBranchID", varIRole);
varTblRolesForUser.SetColumnValue("FP_sBranchID", l.Value);
varTblRolesForUser.Save();
}
}
}
public bool Destroy(object SUID)
{
return(TblRolesForUser.Destroy(SUID) == 1);
}
public bool Delete(object SUID)
{
return(TblRolesForUser.Delete(SUID) == 1);
}
