public void AddRelation(Role right, User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[2]; parameters[0] = new System.Data.SqlClient.SqlParameter("@rightId", System.Data.SqlDbType.BigInt); parameters[0].set_Value((int) right.Id); parameters[1] = new System.Data.SqlClient.SqlParameter("@userId", System.Data.SqlDbType.BigInt); parameters[1].set_Value((long) user.Id); DALSql.ExecuteNonQuery("insert sn.UserRights ( UserId, RightId ) values ( @userId, @rightId )", parameters); }
public AdminUserChangePasswordForm(User user) : this() { this.bsUser.set_DataSource(this.m_User = user); this.set_Text("Изменение пароля пользователя"); this.btnOk.set_Text("Изменить"); this.tbLogin.set_ReadOnly(true); this.tbName.set_ReadOnly(true); }
public void AddRelation(OldRole roleChild, User user) { if (roleChild.TypeRole == "Роль приложения") { DALSql.ExecuteNonQuery(string.Concat((string[]) new string[] { "insert sn.UserRights ( UserId, RightId ) values ( ", ((long) user.Id).ToString(), ", ", ((long) roleChild.Id).ToString(), ")" }), null); } else { DALSql.ExecuteNonQuery(string.Concat((string[]) new string[] { "exec sys.sp_addrolemember [", roleChild.Name, "],[", user.Login, "]" }), null); } }
public BindingListView<Role> FindIncludeRightsBy(User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@userId", System.Data.SqlDbType.BigInt) }; parameters[0].set_Value((long) user.Id); string sql = this.SelectQuery + "\tinner join sn.UserRights ur on ur.RightId = t.id\r\n\tinner join sn.Users u on ur.UserId = u.id\r\nwhere u.id = @userId and t.TypeId not in (select id from sn.RightTypes where [name] like 'Роль%')"; BindingListView<Role> view = new BindingListView<Role>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { Role owid = new Role(); this.Load(row, owid); view.Add(owid); } return view; }
public BindingListView<Role> FindExcludeRightsBy(User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@userId", System.Data.SqlDbType.BigInt) }; parameters[0].set_Value((long) user.Id); string sql = "select r.id, r.name, r.TypeId\r\n\tinto #t\r\n\tfrom sn.Rights r\r\n\t\tinner join sn.UserRights ur on ur.RightId = r.id\r\n\t\tinner join sn.Users u on ur.UserId = u.id\r\n\twhere u.id = @userId\r\n\tunion \r\n\tselect rr.id, rr.name, rr.TypeId\r\n\t\tfrom sn.UserRights ur\r\n\t\tinner join sn.Users u on ur.UserId = u.id\r\n\t\tinner join sn.Rights r on ur.RightId = r.id\r\n\t\tinner join sn.RightGroups rg on r.id = rg.GroupId\r\n\t\tinner join sn.Rights rr on rg.RightId = rr.id\r\n\twhere r.TypeId = 2 and u.id = @userId\r\n\tunion \r\n\tselect rrr.id, rrr.name, rrr.TypeId\r\n\tfrom sn.UserRights ur\r\n\t\tinner join sn.Users u on ur.UserId = u.id\r\n\t\tinner join sn.Rights r on ur.RightId = r.id\r\n\t\tinner join sn.RightGroups rg on r.id = rg.GroupId\r\n\t\tinner join sn.Rights rr on rg.RightId = rr.id\r\n\t\tinner join sn.RightGroups rrg on rr.id = rrg.GroupId\r\n\t\tinner join sn.Rights rrr on rrg.RightId = rrr.id\r\n\twhere r.TypeId = 2 and rr.TypeId = 2 and u.id = @userId\r\n" + this.SelectQuery + "\r\n\twhere t.id not in (select tt.id from #t tt) and t.TypeId not in (select id from sn.RightTypes where [name] like 'Роль%')"; BindingListView<Role> view = new BindingListView<Role>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { Role owid = new Role(); this.Load(row, owid); view.Add(owid); } return view; }
public void DeleteRelation(Role right, User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[2]; parameters[0] = new System.Data.SqlClient.SqlParameter("@rightId", System.Data.SqlDbType.BigInt); parameters[0].set_Value((int) right.Id); parameters[1] = new System.Data.SqlClient.SqlParameter("@userId", System.Data.SqlDbType.BigInt); parameters[1].set_Value((long) user.Id); DALSql.ExecuteNonQuery("delete sn.UserRights where UserId = @userId and RightId = @rightId", parameters); }
public static ObjectList<UserAddress> FindByUser(User user) { return Mappers.UserAddressMapper.FindByUserId(user.Id); }
public BindingListView<OldRole> FindIncludeRoleRightsBy(User user, OldRole r) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[2]; parameters[0] = new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar); parameters[0].set_Value(user.Login); parameters[1] = new System.Data.SqlClient.SqlParameter("@role", System.Data.SqlDbType.VarChar); parameters[1].set_Value((long) r.Id); string sql = this.SelectQuery + " inner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n inner join sn.RolesView rv on rv.id = rm.member_principal_id\r\n inner join sys.database_role_members rm2 on rv.id = rm2.role_principal_id /*and rv.typeRole in ('РОЛЬ')*/ and rv.id = @role\r\n inner join sys.database_principals pr on rm2.member_principal_id = pr.principal_id and pr.type = 'S' and pr.name = @name\r\n "; BindingListView<OldRole> view = new BindingListView<OldRole>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { OldRole owid = new OldRole(); this.Load(row, owid); view.Add(owid); } return view; }
public System.Data.DataTable MakeObjLogReport(System.DateTime dateb, System.DateTime datee, User user, TableWithIdentity table) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[4]; parameters[0] = new System.Data.SqlClient.SqlParameter("@dateb", System.Data.SqlDbType.DateTime); parameters[0].set_Value(dateb); parameters[1] = new System.Data.SqlClient.SqlParameter("@datee", System.Data.SqlDbType.DateTime); parameters[1].set_Value(datee); parameters[2] = new System.Data.SqlClient.SqlParameter("@userId", System.Data.SqlDbType.BigInt); parameters[2].set_Value(user.Equals(User.Null) ? ((object) System.DBNull.Value) : ((object) ((long) user.Id))); parameters[3] = new System.Data.SqlClient.SqlParameter("@tableId", System.Data.SqlDbType.BigInt); parameters[3].set_Value(table.Equals(TableWithIdentity.Null) ? ((object) System.DBNull.Value) : ((object) ((long) table.Id))); return DALSql.ExecuteDataTable("\r\n\t\t\t\t\t\t\tset @datee=dateadd(ms,-1,dateadd(day,1,@datee))\r\n\t\t\t\t\t\t\tselect stamp, [objId], tableName, userName, operation \r\n\t\t\t\t\t\t\tfrom sn.rpt$ObjLogOper(@dateb, @datee, @userId, @tableId) ", parameters); }
public System.Data.DataSet GetJnReportByJn(long areaId, User user, System.DateTime fromDate, System.DateTime toDate, int paymentTypeId, string terminal) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[6]; parameters[0] = new System.Data.SqlClient.SqlParameter("@fromDate", System.Data.SqlDbType.DateTime); parameters[0].set_Value((fromDate == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) fromDate)); parameters[1] = new System.Data.SqlClient.SqlParameter("@toDate", System.Data.SqlDbType.DateTime); parameters[1].set_Value((toDate == Constants.NullDate) ? ((object) System.DBNull.Value) : ((object) toDate)); parameters[2] = new System.Data.SqlClient.SqlParameter("@user", System.Data.SqlDbType.VarChar); parameters[2].set_Value((user == User.Null) ? ((object) System.DBNull.Value) : ((object) user.Name)); parameters[3] = new System.Data.SqlClient.SqlParameter("@paymentAgentTypeId", System.Data.SqlDbType.VarChar); parameters[3].set_Value((paymentTypeId == FasetItem.Null.Id) ? ((object) System.DBNull.Value) : ((object) ((int) paymentTypeId))); parameters[4] = new System.Data.SqlClient.SqlParameter("@terminal", System.Data.SqlDbType.VarChar); parameters[4].set_Value((terminal == "") ? ((object) System.DBNull.Value) : ((object) terminal)); parameters[5] = new System.Data.SqlClient.SqlParameter("@areaId", System.Data.SqlDbType.BigInt); parameters[5].set_Value((areaId == 0L) ? ((object) System.DBNull.Value) : ((object) ((long) areaId))); return DALSql.ExecuteDataSet("exec [rep].[Отчет по оплате]\t\t@fromDate,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t@toDate,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t@user,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t@paymentAgentTypeId, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t@terminal, \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t@areaId", parameters); }
public AdminUserOrganizationsForm(User user) : this() { this.m_User = user; this.set_Font(Manager.WindowFont); }
public AdminUserAddChangeForm(User user) : this() { this.bsUser.set_DataSource(this.m_User = user); }
private bool bwPOSOperation_BeforeStart() { if (this.IsBusy) { System.Windows.Forms.MessageBox.Show("Фискальный регистратор занят. " + System.Environment.get_NewLine() + "Дождитесь выполнения операции."); return false; } try { if (this.m_Operator == null) { this.m_Operator = User.GetCurrentUser(); } if (this.m_OperatorOrg == null) { this.m_OperatorOrg = this.m_Operator.GetOrg(); } if (this.m_OperatorOrgParent == null) { this.m_OperatorOrgParent = Organization.FindById(this.m_OperatorOrg.ParentId); } this.m_Terminal = Settings.Default.CashierTerminal; IskraPOS.IsBusy = true; } catch (System.Exception exception) { throw new System.ApplicationException("Ошибка, проверьте настройки пользователя, организаций пункта приема и платежного агента.", exception); } return true; }
public static void Reload() { if (_currentUser != null) { _currentUser = GetCurrentUser(); } }
public BindingListView<Role> FindIncludeRolesBy(User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar) }; parameters[0].set_Value(user.Login); string sql = this.RoleSelectQuery + " \t\tinner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n where pr.type='S' and t.typeRole in ('РОЛЬ') and pr.[name] = @name"; BindingListView<Role> view = new BindingListView<Role>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { Role owid = new Role(); this.Load(row, owid); view.Add(owid); } return view; }
public AdminUserRolesForm(User user) : this() { this.m_User = user; this.set_Font(Manager.WindowFont); }
public static ObjectList<LocalAddress> GetByUserId(User user) { return Mappers.LocalAddressMapper.GetByUserId(user.Id); }
public BindingListView<OldRole> FindExcludeRightsBy(User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar) }; parameters[0].set_Value(user.Login); string sql = this.SelectQuery + " where\t/*t.typeRole in ('РОЛЬ','ПРАВО') \r\n and*/ not t.id in (\tselect\tt.id\r\n\t from\tsn.RolesView t\r\n inner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n inner join sys.database_role_members rm2 on pr.principal_id = rm2.role_principal_id\r\n\t\t inner join sys.database_principals pr2 on rm2.member_principal_id = pr2.principal_id\r\n inner join sys.database_role_members rm3 on pr2.principal_id = rm3.role_principal_id\r\n\t\t inner join sys.database_principals pr3 on rm3.member_principal_id = pr3.principal_id\r\n inner join sys.database_role_members rm4 on pr3.principal_id = rm4.role_principal_id\r\n\t \t inner join sys.database_principals pr4 on rm4.member_principal_id = pr4.principal_id\r\n where pr4.type='S' \r\n /*and t.typeRole in ('РОЛЬ','ПРАВО') */\r\n and pr4.[name] = @name \r\n union\r\n select\tt.id\r\n\t from\tsn.RolesView t\r\n inner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n inner join sys.database_role_members rm2 on pr.principal_id = rm2.role_principal_id\r\n\t\t inner join sys.database_principals pr2 on rm2.member_principal_id = pr2.principal_id\r\n inner join sys.database_role_members rm3 on pr2.principal_id = rm3.role_principal_id\r\n\t\t inner join sys.database_principals pr3 on rm3.member_principal_id = pr3.principal_id\r\n where pr3.type='S' \r\n /*and t.typeRole in ('РОЛЬ','ПРАВО') */\r\n and pr3.[name] = @name\r\n union \r\n select\tt.id\r\n\t from\tsn.RolesView t\r\n inner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n inner join sys.database_role_members rm2 on pr.principal_id = rm2.role_principal_id\r\n\t\t inner join sys.database_principals pr2 on rm2.member_principal_id = pr2.principal_id\r\n where pr2.type='S' \r\n /*and t.typeRole in ('РОЛЬ','ПРАВО') */\r\n and pr2.[name] = @name\r\n union\r\n select\tt.id\r\n\t from\tsn.RolesView t\r\n inner join sys.database_role_members rm on t.id = rm.role_principal_id\r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n where pr.type='S' \r\n /*and t.typeRole in ('РОЛЬ','ПРАВО') */\r\n and pr.[name] = @name) "; BindingListView<OldRole> view = new BindingListView<OldRole>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { OldRole owid = new OldRole(); this.Load(row, owid); view.Add(owid); } return view; }
private void bsUsers_CurrentChanged(object sender, System.EventArgs e) { this.m_User = (this.bsUsers.get_Current() as User) ?? User.Null; }
public BindingListView<OldRole> FindIncludeRolesBy(User user) { System.Data.SqlClient.SqlParameter[] parameters = new System.Data.SqlClient.SqlParameter[] { new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar) }; parameters[0].set_Value(user.Login); string sql = this.SelectQuery + " \r\n inner join sys.database_role_members rm on t.id = rm.role_principal_id \r\n\t\t inner join sys.database_principals pr on rm.member_principal_id = pr.principal_id\r\n where pr.type='S' /*and t.typeRole in ('РОЛЬ')*/ and pr.[name] = @name\r\n union\r\n " + this.SelectQueryAR + "\r\n inner join sn.UserRights ur on tar.id = ur.RightId\r\n inner join sn.Users u on ur.UserId = u.id and u.login = @name\r\n\t where tar.TypeId = 4"; BindingListView<OldRole> view = new BindingListView<OldRole>(); foreach (System.Data.DataRow row in DALSql.ExecuteDataTable(sql, parameters).Rows) { OldRole owid = new OldRole(); this.Load(row, owid); view.Add(owid); } return view; }
private void tsbAdd_Click(object sender, System.EventArgs e) { User user = new User(); AdminUserAddChangeForm form = new AdminUserAddChangeForm(user); if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) { this.bsUsers.Add(user); this.bsUsers.set_Sort(this.bsUsers.get_Sort()); this.bsUsers.set_Sort(this.bsUsers.get_Sort()); this.bsUsers.set_Position(this.bsUsers.IndexOf(user)); } }
public void DeleteRelation(OldRole roleChild, User user) { if (roleChild.TypeRole == "Роль приложения") { DALSql.ExecuteNonQuery("delete sn.UserRights where RightId = " + ((long) roleChild.Id).ToString() + " and UserId = " + ((long) user.Id).ToString(), null); } else { DALSql.ExecuteNonQuery(string.Concat((string[]) new string[] { "exec sys.sp_droprolemember [", roleChild.Name, "],[", user.Login, "]" }), null); } }
public static void DeleteByUserAndAddress(LocalAddress localAddress, User user) { Mappers.UserAddressMapper.DeleteByUserAndAddress(localAddress.Id, user.Id); }