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