public DTOChiTietPhieuDatNCC(DataRow dong) { PhieuDat = new DTOPhieuDatVatLieuCC(dong); dtoVatLieu = new DTOVatLieu(dong); SoLuong = (int)dong["SoLuong"]; ThanhTien = (decimal)dong["Thanhtien"]; }
public DTOPhieuNVL_SX(DataRow dongDL) { MaPNVLSX = dongDL["MaPNVLSX"].ToString(); dtoPhieuDat = new DTOPhieuDatVatLieuCC(dongDL); ngaylap = dongDL["Ngaylap"].ToString(); NgayGiao = dongDL["Ngaygiao"].ToString(); NguoiGiao = dongDL["NguoiGiao"].ToString(); MaNV = (int)dongDL["MaNV"]; }
protected void btnLuu_Click(object sender, EventArgs e) { DTOCongNoVatLieu dtovl = new DTOCongNoVatLieu(); dtovl.MaPDVLCC = int.Parse(lbMPD.Text); dtovl.MaNCC = int.Parse(lbNCC.Text); dtovl.MaNV = int.Parse(TextBox1.Text); dtovl.NgayTraNo = Convert.ToDateTime(lbNTT.Text); dtovl.Sotien = int.Parse(TextBox2.Text); DAO_Entity dao = new DAO_Entity(); dao.ThemCongNoNCC(dtovl); DTOPhieuDatVatLieuCC dtopd = new DTOPhieuDatVatLieuCC(); dtopd.MaPDVLCC = lbMPD.Text; int tong = int.Parse(lbTong.Text); int no = int.Parse(TextBox2.Text); dtopd.CongNoNCC = tong - no; dao.CapNhatCongNoNCC(dtopd); Response.Redirect("~/QLBoPhan_VatLieu/QLCongNoNCC/DanhSachCongNo.aspx"); }
// DAOPhieuNhapVatLieu_NCC //Tao danh sach san pham public List<DTOPhieuDatVatLieuCC> LayDSPhieuDatVatLieu_NCC() { List<DTOPhieuDatVatLieuCC> dssp = new List<DTOPhieuDatVatLieuCC>(); string lenh = "select * from PDVL_CC pd, Nhacungcap ncc where pd.mancc = ncc.mancc and pd.TrangThai = 1"; ketnoi.TaoKetNoi(); DataTable bang = new DataTable(); try { ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); foreach (DataRow dongDL in bang.Rows) { DTOPhieuDatVatLieuCC dtosp = new DTOPhieuDatVatLieuCC(dongDL); dssp.Add(dtosp); } } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return dssp; }
public bool CapNhatCongNoNCC(DTOPhieuDatVatLieuCC dtoPD) { bool ketqua = false; ketnoi.TaoKetNoi(); try { string lenh = "update PDVL_CC set CongNoNCC = @cc where MaPDVLCC=@ma"; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters.Add("@cc", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@ma"].Value = dtoPD.MaPDVLCC; ketnoi.LenhKetNoi.Parameters["@cc"].Value = dtoPD.CongNoNCC; if (ketnoi.LenhKetNoi.ExecuteNonQuery() != 0) ketqua = true; } catch (Exception) { } finally { ketnoi.DongKetNoi(); } return ketqua; }
public DTOPhieuDatVatLieuCC LayTTPhieuDatTheoMa(string ma) { ketnoi.TaoKetNoi(); DTOPhieuDatVatLieuCC dtoDH = null; try { string lenh = "Select * from PDVL_CC pd, NhaCungCap ncc where ncc.MaNCC=pd.MaNCC and pd.MaPDVLCC = @ma "; ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); ketnoi.LenhKetNoi.Parameters.Add("@ma", SqlDbType.Int); ketnoi.LenhKetNoi.Parameters["@ma"].Value = ma; DataTable bang = new DataTable(); ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); DataRow dong = bang.Rows[0]; dtoDH = new DTOPhieuDatVatLieuCC(dong); } catch (Exception) { throw; } finally { ketnoi.DongKetNoi(); } return dtoDH; }
// DAOCongNoNCC public List<DTOPhieuDatVatLieuCC> LayDSCongNoNCC() { List<DTOPhieuDatVatLieuCC> ds = new List<DTOPhieuDatVatLieuCC>(); string lenh = "Select * from PDVL_CC vl, NhaCungCap ncc where vl.MaNCC=ncc.MaNCC and vl.CongNoNCC>0"; ketnoi.TaoKetNoi(); DataTable bang = new DataTable(); try { ketnoi.LenhKetNoi = new SqlCommand(lenh, ketnoi.KetNoi); //dong bo lenh ket noi voi du lieu trong database ketnoi.TichHopCSDL = new SqlDataAdapter(ketnoi.LenhKetNoi); ketnoi.TichHopCSDL.Fill(bang); foreach (DataRow dongDL in bang.Rows) { DTOPhieuDatVatLieuCC dtoct = new DTOPhieuDatVatLieuCC(dongDL); ds.Add(dtoct); } } catch { throw; } finally { ketnoi.DongKetNoi(); } return ds; }