public bool LuuCauHinhMayInLanN(CauHinhMayInInfo cauHinhMayInInfo) { SqlCommand cmd = new SqlCommand("UPDATE CAUHINHIN " + "SET TenMayIn = @TenMayIn, " + "SoPhieu = @SoPhieu" + " where ID = @ID"); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = cauHinhMayInInfo.ID; cmd.Parameters.Add("TenMayIn", SqlDbType.VarChar).Value = cauHinhMayInInfo.TenMayIn; cmd.Parameters.Add("SoPhieu", SqlDbType.VarChar).Value = cauHinhMayInInfo.SoPhieu; return(m_CauHinhMayInData.ExecuteNoneQuery(cmd) > 0); }
public bool LuuCauHinhMayInLan1(CauHinhMayInInfo cauHinhMayInInfo) { SqlCommand cmd = new SqlCommand("INSERT INTO CAUHINHIN VALUES" + "(@ID, " + "@TenMayIn, " + "@SoPhieu)"); cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = cauHinhMayInInfo.ID; cmd.Parameters.Add("TenMayIn", SqlDbType.VarChar).Value = cauHinhMayInInfo.TenMayIn; cmd.Parameters.Add("SoPhieu", SqlDbType.VarChar).Value = cauHinhMayInInfo.SoPhieu; m_CauHinhMayInData.ExecuteNoneQuery(cmd); return(true); }
private void btnLuu_Click(object sender, EventArgs e) { CauHinhMayInInfo cauHinhMayInInfo = new CauHinhMayInInfo(); if (KtraRong() == true) { if (KtraSoPhieu() == true) { try { if (m_cauHinhMayInCtrl.DemCauHinhMayIn() == 1) { cauHinhMayInInfo.ID = m_cauHinhMayInCtrl.LayIDCauHinhMayIn(); cauHinhMayInInfo.TenMayIn = cbb_COMPort.Text; cauHinhMayInInfo.SoPhieu = txtSoPhieu.Text; m_cauHinhMayInCtrl.LuuCauHinhMayIn_LanN(cauHinhMayInInfo); } else { cauHinhMayInInfo.ID = "CAUHINH"; cauHinhMayInInfo.TenMayIn = cbb_COMPort.Text; cauHinhMayInInfo.SoPhieu = txtSoPhieu.Text; m_cauHinhMayInCtrl.LuuCauHinhMayIn_Lan1(cauHinhMayInInfo); } lbStatus.Text = "Lưu thành công!"; } catch (Exception ex) { MessageBox.Show(ex.Message); lbStatus.Text = "Lỗi!!!"; } } else { lbStatus.Text = "Số phiếu không được lớn hơn 10!!!"; } } else { lbStatus.Text = "Nhập thiếu dữ liệu!!!"; } }
public bool LuuCauHinhMayIn_LanN(CauHinhMayInInfo cauHinhMayInInfo) { return(m_cauHinhMayInData.LuuCauHinhMayInLanN(cauHinhMayInInfo)); }