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