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