private void frmThongTinCongTy_Load(object sender, EventArgs e)
{
m_conTyInfo = m_congTyCtrl.LayThongTinCT();
txtTenCT.Text = m_conTyInfo.TenCongTy;
txtDiaChi.Text = m_conTyInfo.DiaChi;
txtSDT.Text = m_conTyInfo.SDT;
txtFax.Text = m_conTyInfo.Fax;
}
public bool LuuThongTinCTLanN(CongTyInfo congTyInfo)
{
SqlCommand cmd = new SqlCommand("UPDATE CONGTY " +
"SET TenCongTy = @TenCongTy, " +
"DiaChi = @DiaChi, " +
"SDT = @SDT, " +
"Fax = @Fax" +
" where ID = @ID");
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = congTyInfo.ID;
cmd.Parameters.Add("TenCongTy", SqlDbType.NVarChar).Value = congTyInfo.TenCongTy;
cmd.Parameters.Add("DiaChi", SqlDbType.NVarChar).Value = congTyInfo.DiaChi;
cmd.Parameters.Add("SDT", SqlDbType.VarChar).Value = congTyInfo.SDT;
cmd.Parameters.Add("Fax", SqlDbType.VarChar).Value = congTyInfo.Fax;
return(m_CongTyData.ExecuteNoneQuery(cmd) > 0);
}
public bool LuuThongTinCTLan1(CongTyInfo congTyInfo)
{
SqlCommand cmd = new SqlCommand("INSERT INTO CONGTY VALUES" +
"(@ID, " +
"@TenCongTy, " +
"@DiaChi, " +
"@SDT, " +
"@Fax)");
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = congTyInfo.ID;
cmd.Parameters.Add("TenCongTy", SqlDbType.NVarChar).Value = congTyInfo.TenCongTy;
cmd.Parameters.Add("DiaChi", SqlDbType.NVarChar).Value = congTyInfo.DiaChi;
cmd.Parameters.Add("SDT", SqlDbType.VarChar).Value = congTyInfo.SDT;
cmd.Parameters.Add("Fax", SqlDbType.VarChar).Value = congTyInfo.Fax;
m_CongTyData.ExecuteNoneQuery(cmd);
return(true);
}
private void btnLuu_Click(object sender, EventArgs e)
{
CongTyInfo congTyInfo = new CongTyInfo();
if (KtraRong() == true)
{
try
{
if (m_congTyCtrl.DemThongTinCT() == 1)
{
congTyInfo.ID = m_congTyCtrl.LayIDThongTinCT();
congTyInfo.TenCongTy = txtTenCT.Text;
congTyInfo.DiaChi = txtDiaChi.Text;
congTyInfo.SDT = txtSDT.Text;
congTyInfo.Fax = txtFax.Text;
m_congTyCtrl.LuuThongTinCT_LanN(congTyInfo);
}
else
{
congTyInfo.ID = "CONGTY";
congTyInfo.TenCongTy = txtTenCT.Text;
congTyInfo.DiaChi = txtDiaChi.Text;
congTyInfo.SDT = txtSDT.Text;
congTyInfo.Fax = txtFax.Text;
m_congTyCtrl.LuuThongTinCT_Lan1(congTyInfo);
}
Utilities.frmMain.lbThongBao.Text = "Lưu thành công.";
}
catch
{
Utilities.frmMain.lbThongBao.Text = "Lỗi.";
}
}
else
{
Utilities.frmMain.lbThongBao.Text = "Nhâp thiếu dữ liệu.";
}
}
public bool LuuThongTinCT_LanN(CongTyInfo congTyInfo)
{
return(m_congTyData.LuuThongTinCTLanN(congTyInfo));
}
