private void frm_main_Load(object sender, EventArgs e) { if (Directory.Exists(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + @"\G-Sale\database")) { } else { doc.Create(); } // //-------------------------------------THÔNG SỐ ĐẦU CHO COMBOBOX // cbo_quay.SelectedIndex = 0; cbo_giamgia.SelectedIndex = 0; // //---------------------------------------KIỂM TRA ĐĂNG KÍ // DataTable kiemtradangky = new DataTable(); kiemtradangky = SQL.DocBang("sp_Kiemtradangky"); if (kiemtradangky.Rows.Count == 0) { frm_dangky dangky = new frm_dangky(); dangky.ShowDialog(); } else { dangnhap.ShowDialog(); } // //---------------------------------------LOAD THÔNG TIN CỬA HÀNG // SqlCommand cmd = new SqlCommand("sp_Layquantrivien", cnn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter spm_tenquantrivien = new SqlParameter("@tenquantrivien", SqlDbType.NVarChar, 30); spm_tenquantrivien.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_tenquantrivien); SqlParameter spm_tencuahang = new SqlParameter("@tencuahang", SqlDbType.NVarChar, 30); spm_tencuahang.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_tencuahang); SqlParameter spm_logo = new SqlParameter("@logo", SqlDbType.VarBinary, 8000); spm_logo.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_logo); SqlParameter spm_diachi = new SqlParameter("@diachi", SqlDbType.NVarChar, 50); spm_diachi.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_diachi); SqlParameter spm_sdt = new SqlParameter("@sdt", SqlDbType.VarChar, 12); spm_sdt.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_sdt); SqlParameter spm_email = new SqlParameter("@email", SqlDbType.VarChar, 25); spm_email.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_email); SqlParameter spm_website = new SqlParameter("@website", SqlDbType.VarChar, 20); spm_website.Direction = ParameterDirection.Output; cmd.Parameters.Add(spm_website); try { cnn.Open(); cmd.ExecuteNonQuery(); Common.Tencuahang = spm_tencuahang.Value.ToString(); Common.logo = (byte[])spm_logo.Value; Common.diachi = spm_diachi.Value.ToString(); Common.sdt = "0" + spm_sdt.Value.ToString(); lbl_tencuahang.Text = Common.Tencuahang; lbl_diachi.Text = "Địa chỉ: " + Common.diachi; lbl_sodienthoai.Text = "Số điện thoại: " + Common.sdt; ptb_logo.Image = Common.FromImage(Common.logo); } catch (Exception ex) { MessageBox.Show("Không thể load thông tin của quản trị viên" + ex.Message); } finally { if (cnn != null) { cnn.Close(); } } }