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