/// <summary> /// Возвращает ид Роли /// </summary> /// <param name="user_code"></param> /// <returns></returns> private int find_user_role_new(string password) { int rezult = 0; string password_Md5Hash = MainStaticClass.getMd5Hash(password).ToUpper(); try { NpgsqlConnection conn = MainStaticClass.NpgsqlConn(); conn.Open(); string query = "SELECT rights,name,code,inn FROM users where password_m='" + password_Md5Hash.Trim() + "' or password_b='" + password_Md5Hash.Trim() + "'"; NpgsqlCommand command = new NpgsqlCommand(query, conn); NpgsqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { rezult = Convert.ToInt32(reader.GetInt16(0)); if (!not_change_Cash_Operator) { MainStaticClass.Cash_Operator = reader["name"].ToString().Trim(); MainStaticClass.Cash_Operator_Client_Code = reader["code"].ToString(); MainStaticClass.cash_operator_inn = reader["inn"].ToString(); } } conn.Close(); } catch (NpgsqlException ex) { MessageBox.Show(ex.Message); } if (MainStaticClass.Cash_Operator.Trim().ToUpper() == "К9") { //MessageBox.Show(" "+MainStaticClass.CashDeskNumber.ToString()); //MessageBox.Show(" "+MainStaticClass.get_unloading_interval().ToString()); if ((MainStaticClass.CashDeskNumber != 9) || (MainStaticClass.get_unloading_interval() != 0))//Это пользователь для центрального компьютера 9 касса, пользователь не может зайти если стоит период синхронизации отличный от нуля или если номер кассы не 9 { rezult = 0; MainStaticClass.Cash_Operator = ""; MainStaticClass.Cash_Operator_Client_Code = ""; } } return(rezult); }