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