public bool updatePhieuDieuChinhTonKho(BKIT.Entities.PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "UPDATE PhieuDieuChinhTonKho SET IDSanpham = @idsanpham, SoluongDC = @SoluongDC, NgayDieuChinh = @NgayDieuChinh, GhiChu = @GhiChu" +
" WHERE ID = @ID";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "IDSanpham", DbType.Int32, objPhieuDieuChinhTonKho.IDSanpham);
db.AddInParameter(dbCommand, "SoluongDC", DbType.Int32, objPhieuDieuChinhTonKho.SoluongDC);
db.AddInParameter(dbCommand, "NgayDieuChinh", DbType.DateTime, objPhieuDieuChinhTonKho.NgayDieuChinh);
db.AddInParameter(dbCommand, "GhiChu", DbType.String, objPhieuDieuChinhTonKho.GhiChu);
db.AddInParameter(dbCommand, "ID", DbType.Int32, objPhieuDieuChinhTonKho.ID);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(cboSanPham.SelectedText))
{
MessageBox.Show("Chọn sản phẩm để điều chỉnh tồn kho.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DataSet ds = new DataAccess().getIDSanPhamByTenSP(cboSanPham.SelectedText);
if (ds == null || ds.Tables[0].Rows.Count < 0 || string.IsNullOrEmpty(ds.Tables[0].Rows[0][0].ToString()))
{
// bi loi...
}
PhieuDieuChinhTonKho obj = new PhieuDieuChinhTonKho();
obj.IDSanpham = Convert.ToInt32(ds.Tables[0].Rows[0]["IDSanPham"]);
obj.SoluongDC = Convert.ToInt32(txtSoLuongDC.Text);
obj.GhiChu = txtGhiChu.Text;
new DataAccess().insertPhieuDieuChinhTonKho(obj);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
loadAllPhieuDieuChinh();
}
public int insertPhieuDieuChinhTonKho(BKIT.Entities.PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "INSERT INTO PhieuDieuChinhTonKho(ID,IDSanpham,SoluongDC,NgayDieuChinh,GhiChu) " + //
"VALUES (@ID,@IDSanpham,@SoluongDC,@NgayDieuChinh,@GhiChu)"; //,
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
int ID = GetNextAVailableID();
objPhieuDieuChinhTonKho.ID = ID;
db.AddInParameter(dbCommand, "ID", DbType.Int32, objPhieuDieuChinhTonKho.ID);
db.AddInParameter(dbCommand, "IDSanpham", DbType.Int32, objPhieuDieuChinhTonKho.IDSanpham);
db.AddInParameter(dbCommand, "SoluongDC", DbType.Int32, objPhieuDieuChinhTonKho.SoluongDC);
db.AddInParameter(dbCommand, "NgayDieuChinh", DbType.DateTime, objPhieuDieuChinhTonKho.NgayDieuChinh);
db.AddInParameter(dbCommand, "GhiChu", DbType.String, objPhieuDieuChinhTonKho.GhiChu);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(ID);
}
catch
{
dbCommand.Connection.Close();
return(-1);
}
}
public bool deletePhieuDieuChinhTonKho(BKIT.Entities.PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "DELETE FROM PhieuDieuChinhTonKho WHERE ID = @ID";
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
try
{
db.AddInParameter(dbCommand, "ID", DbType.Int32, objPhieuDieuChinhTonKho.ID);
db.ExecuteNonQuery(dbCommand);
dbCommand.Connection.Close();
return(true);
}
catch
{
return(false);
}
}
public bool deletePhieuDieuChinhTonKho(PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
return new PhieuDieuChinhTonKhoService().deletePhieuDieuChinhTonKho(objPhieuDieuChinhTonKho);
}
public bool updatePhieuDieuChinhTonKho(PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
return new PhieuDieuChinhTonKhoService().updatePhieuDieuChinhTonKho(objPhieuDieuChinhTonKho);
}
public int insertPhieuDieuChinhTonKho(PhieuDieuChinhTonKho objPhieuDieuChinhTonKho)
{
return new PhieuDieuChinhTonKhoService().insertPhieuDieuChinhTonKho(objPhieuDieuChinhTonKho);
}
