public static void CapNhatPhatSinh(CT_BC_VTPT chiTiet)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("CAPNHATPHATSINH");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MACTBCT", chiTiet.MaCTBC);
cmd.Parameters.AddWithValue("@SL", chiTiet.PhatSinh);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
}
public static void ThemBC(BC_TONVTPT baoCao)
{
BC_TONVTPT_DAO.ThemBaoCao(baoCao);
DataTable dt = VTPT_BUS.ListPhuTung(); //Lấy danh sách VTPT
foreach (DataRow row in dt.Rows)
{
CT_BC_VTPT chiTiet = new CT_BC_VTPT();
chiTiet.MaCTBC = CT_BC_VTPT_BUS.AutoMaCTBCT(); //Sinh mã bc VTPT
chiTiet.MaBCT = baoCao.MaBCT;
chiTiet.MaVTPT = row.ItemArray[0].ToString();
chiTiet.TonDau = int.Parse(VTPT_BUS.LaySoLuongPhuTung(chiTiet.MaVTPT)); //Lấy số lượng tồn của VTPT
chiTiet.TonCuoi = chiTiet.TonDau;
chiTiet.PhatSinh = 0;
CT_BC_VTPT_BUS.themChiTietBaoCao(chiTiet);
}
}
public static void themChiTietBCT(CT_BC_VTPT chitiet)
{
DataAccessHelper db = new DataAccessHelper();
SqlCommand cmd = db.Command("THEMCT_BCT");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MACTBC", chitiet.MaCTBC);
cmd.Parameters.AddWithValue("@MABC", chitiet.MaBCT);
cmd.Parameters.AddWithValue("@MAPT", chitiet.MaVTPT);
cmd.Parameters.AddWithValue("@TONDAU", chitiet.TonDau);
cmd.Parameters.AddWithValue("@PHATSINH", chitiet.PhatSinh);
cmd.Parameters.AddWithValue("@TONCUOI", chitiet.TonCuoi);
SqlDataAdapter da = new SqlDataAdapter(cmd);
db.dt = new DataTable();
da.Fill(db.dt);
}
private void btnThem_Click(object sender, EventArgs e)
{
//PHIEUSUACHUA psc = new PHIEUSUACHUA(...);
//PHIEUSUACHUA_BUS.ThemPhieuSuaChua(psc);
DateTime today = DateTime.Now;
string maBCT = BC_TONVTPT_BUS.GetMaBCT(today.Month, today.Year);
string maCTBCT = CT_BC_VTPT_BUS.getMaCTBCT(maBCT, cboPhuTung.Text);
CT_BC_VTPT chitiet = new CT_BC_VTPT();
chitiet.MaBCT = maBCT;
chitiet.MaCTBC = maCTBCT;
chitiet.MaVTPT = cboPhuTung.Text;
chitiet.TonCuoi = int.Parse(txtSL.Text);
chitiet.PhatSinh = 0;
chitiet.TonDau = 0;
CT_BC_VTPT_BUS.capNhatTonCuoi(chitiet);
}
private void btnThemSL_Click(object sender, EventArgs e)
{
int soluong = int.Parse(txtSoLuong.Text);
frmNhapVTPT form = new frmNhapVTPT(txtSoLuong);
form.ShowDialog();
if (btnThayDoi.Enabled)
{
DTO.VTPT phuTung = new DTO.VTPT();
phuTung.MaVTPT = txtMaVTPT.Text;
phuTung.TenVTPT = txtTenVTPT.Text;
phuTung.SoLuongTon = int.Parse(txtSoLuong.Text);
//cap nhat phat sinh
DateTime today = DateTime.Now;
string maBCT = BC_TONVTPT_BUS.GetMaBCT(today.Month, today.Year);
if (maBCT == "")
{
BC_TONVTPT baocao = new BC_TONVTPT();
baocao.MaBCT = BC_TONVTPT_BUS.AutoMABCT();
maBCT = baocao.MaBCT;
baocao.Thang = today.Month;
baocao.Nam = today.Year;
BC_TONVTPT_BUS.ThemBC(baocao);
}
string maCTBCT = CT_BC_VTPT_BUS.getMaCTBCT(maBCT, phuTung.MaVTPT);
CT_BC_VTPT chitiet = new CT_BC_VTPT();
chitiet.MaBCT = maBCT;
chitiet.MaCTBC = maCTBCT;
chitiet.MaVTPT = phuTung.MaVTPT;
chitiet.TonCuoi = 0;
chitiet.PhatSinh = int.Parse(txtSoLuong.Text) - soluong;
chitiet.TonDau = 0;
CT_BC_VTPT_BUS.capNhatPhatSinh(chitiet);
//PHUTUNG_BUS.ThayDoiSoLuongPhuTung(phuTung);
}
}
public static void capNhatPhatSinh(CT_BC_VTPT chitiet)
{
CT_BC_VTPT_DAO.CapNhatPhatSinh(chitiet);
}
public static void capNhatTonCuoi(CT_BC_VTPT chitiet)
{
CT_BC_VTPT_DAO.CapNhatTonCuoi(chitiet);
}
public static void themChiTietBaoCao(CT_BC_VTPT chitiet)
{
CT_BC_VTPT_DAO.themChiTietBCT(chitiet);
}
