示例#1
0
        private void button1_Click(object sender, EventArgs e)
        {
            var buf_p = SQL_Helper.getInstance().ProcedureParameters("Login_Function");

            buf_p[1].value = tb_login.Text;
            buf_p[2].value = tb_password.Text;
            SQL_Helper.Parameter dt = SQL_Helper.getInstance().SQL_Scalarfunction("[dbo].[Login_Function]", buf_p);

            MainWidow.Access?acs = null;

            if (!(dt.value is  DBNull))
            {
                int val = Convert.ToInt32(dt.value);

                DataTable d = SQL_Helper.getInstance().SQL_ExecuteQuery("SELECT Role FROM users WHERE userID = " + val);

                if (d.Rows.Count > 0)
                {
                    val = (int)d.Rows[0][0];

                    if (val == (int)MainWidow.Access.Admin)
                    {
                        acs = MainWidow.Access.Admin;
                    }
                    else if (val == (int)MainWidow.Access.Accountant)
                    {
                        acs = MainWidow.Access.Accountant;
                    }
                    else if (val == (int)MainWidow.Access.Emploee)
                    {
                        acs = MainWidow.Access.Emploee;
                    }
                    else if (val == (int)MainWidow.Access.Dirrector)
                    {
                        acs = MainWidow.Access.Dirrector;
                    }
                }
            }

            if (acs == null)
            {
                MessageBox.Show("Ошибка! Пользователя с такими данными не существует!");
                return;
            }

            this.Hide();
            MainWidow mw = new MainWidow((MainWidow.Access)acs);

            mw.ShowDialog();
            this.Close();
        }
示例#2
0
        private void GetMessage()
        {
            var p = pc.parameters;

            if (pc.Function_Type == ProcedureControll.FncType.Scalar)
            {
                SQL_Helper.Parameter res = new SQL_Helper.Parameter();
                try
                {
                    res = SQL_Helper.getInstance().SQL_Scalarfunction(pc.ProcedureName, p);
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message);
                }
                Type t = res.type;

                pc_scalar_res       = new SQL_Helper.Parameter();
                pc_scalar_res.value = res;
                pc_scalar_res.type  = t;
            }
            else if (pc.Function_Type == ProcedureControll.FncType.Table)
            {
                DataTable dt = new DataTable();
                try
                {
                    dt = SQL_Helper.getInstance().SQL_Tablefunction(pc.ProcedureName, p);
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message);
                }
                dgv_Data.DataSource = dt;
            }
            else if (pc.Function_Type == ProcedureControll.FncType.StoredProcedure)
            {
                SQL_Helper.getInstance().SQL_StoredProcedure(pc.ProcedureName, p);
            }
            fnc_Type = pc.Function_Type;

            ResetWindow();
        }