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