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