public List <PR_ChiTiet> LayDanhSachPR_ChTiet_DaDuyet(int id_phongban)
{
DAC kn = new DAC();
List <PR_ChiTiet> pr_Chitiet_col = new List <PR_ChiTiet>();
SqlParameter pm = new SqlParameter("@id_phongban", id_phongban);
//SqlParameter pm2 = new SqlParameter("@tinhtrangvattu", tinhtrangvattu);
SqlParameter[] param = new SqlParameter[1] {
pm
};
DataTable tb = kn.get_by_procedure("proc_LayDS_PR_PRChiTiet_DaDuyet", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PR_ChiTiet pr_chitiet = new PR_ChiTiet();
pr_chitiet.ID_PR_Chi_Tiet = Convert.ToInt32(row["ID"]);
pr_chitiet.ID_PR = Convert.ToInt32(row["ID_PR"]);
pr_chitiet.Ma_Hang = row["MaHang"].ToString();
pr_chitiet.Ten_Hang = row["TenHang"].ToString();
pr_chitiet.DVT = row["DVT"].ToString();
pr_chitiet.Ton_Kho = Convert.ToInt32(row["TonKho"]);
pr_chitiet.So_Luong_Yeu_cau = Convert.ToInt32(row["SoLuongYeuCau"]);
pr_chitiet.Don_Gia = Convert.ToDouble(row["DonGia"]);
pr_chitiet.Ti_Gia = Convert.ToInt32(row["TiGia"]);
pr_chitiet.Thanh_Tien_Tam_Ung = Convert.ToDouble(row["ThanhTienTamUng"]);
pr_chitiet.Nha_Cung_cap = row["NhaCungCap"].ToString();
pr_chitiet.Tinh_Trang_Vat_Tu = Convert.ToInt32(row["TinhTrangVatTu"]);
pr_chitiet.Ngay_Can_Hang = Convert.ToDateTime(row["NgayCanHang"]);
pr_chitiet.Thoi_Gian_Xu_Dung = row["ThoiGianSuDung"].ToString();
pr_chitiet.Cong_Dung = row["CongDung"].ToString();
pr_chitiet.So_PR_Full = row["SoPR_Full"].ToString();
pr_chitiet.Ngay_Duyet_PR = Convert.ToDateTime(row["NgayDuyet"]);
pr_chitiet.Lead_Time = Convert.ToInt32(row["leadtime"]);
pr_chitiet.So_Luong_Con_Lai = Convert.ToInt32(row["SoLuongConLai"]);
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = "";
if (!row.IsNull("NguoiPTMuaHang"))
{
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = row["NguoiPTMuaHang"].ToString();
}
pr_chitiet.VAT = 0;
if (!row.IsNull("VAT"))
{
pr_chitiet.VAT = Convert.ToInt32(row["VAT"].ToString());
}
pr_chitiet.GiaNhapTay = false;
if (!row.IsNull("GiaNhapTay"))
{
pr_chitiet.GiaNhapTay = Convert.ToBoolean(row["GiaNhapTay"]);
}
pr_Chitiet_col.Add(pr_chitiet);
}
}
return(pr_Chitiet_col);
}
public List <PR_ChiTiet> LayDanhSachPR_ChTiet(int action, int id, int idpr, string mahang, string tenhang, string dvt, int tonkho, int soluongyeucau, double dongia, int tigia, double thanhtientamung, string nhacungcap, int tinhtrangvattu, string ngaycanhang, string thoigiansudung, string congdung, int leadtime, int nhommuaid, string nhommuaname, int vat, bool gianhaptay)
{
DateTime ngaych;
if (string.IsNullOrEmpty(ngaycanhang) == true)
{
ngaych = Convert.ToDateTime(DateTime.Now.ToShortDateString());
}
else
{
ngaych = Convert.ToDateTime(ngaycanhang);
}
DAC kn = new DAC();
List <PR_ChiTiet> pr_Chitiet_col = new List <PR_ChiTiet>();
SqlParameter pm = new SqlParameter("@action", action);
SqlParameter pm2 = new SqlParameter("@id", id);
SqlParameter pm3 = new SqlParameter("@idpr", idpr);
SqlParameter pm4 = new SqlParameter("@mahang", mahang);
SqlParameter pm5 = new SqlParameter("@tenhang", tenhang);
SqlParameter pm6 = new SqlParameter("@dvt", dvt);
SqlParameter pm7 = new SqlParameter("@tonkho", tonkho);
SqlParameter pm8 = new SqlParameter("@soluongyeucau", soluongyeucau);
SqlParameter pm9 = new SqlParameter("@dongia", dongia);
SqlParameter pm10 = new SqlParameter("@tigia", tigia);
SqlParameter pm11 = new SqlParameter("@thanhtientamung", thanhtientamung);
SqlParameter pm12 = new SqlParameter("@nhacungcap", nhacungcap);
SqlParameter pm13 = new SqlParameter("@tinhtrangvattu", tinhtrangvattu);
SqlParameter pm14 = new SqlParameter("@ngaycanhang", Convert.ToDateTime(ngaych));
SqlParameter pm15 = new SqlParameter("@thoigiansudung", thoigiansudung);
SqlParameter pm16 = new SqlParameter("@congdung", congdung);
SqlParameter pm17 = new SqlParameter("@leadtime", leadtime);
SqlParameter pm18 = new SqlParameter("@nhommuaid", nhommuaid);
SqlParameter pm19 = new SqlParameter("@nhommuaname", nhommuaname);
SqlParameter pm20 = new SqlParameter("@vat", vat);
SqlParameter pm21 = new SqlParameter("@gianhaptay", gianhaptay);
SqlParameter[] param = new SqlParameter[21] {
pm, pm2, pm3, pm4, pm5, pm6, pm7, pm8, pm9, pm10, pm11, pm12, pm13, pm14, pm15, pm16, pm17, pm18, pm19, pm20, pm21
};
DataTable tb = kn.get_by_procedure("proc_Action_PR_ChiTiet", param);
if (tb != null)
{
foreach (DataRow row in tb.Rows)
{
PR_ChiTiet pr_chitiet = new PR_ChiTiet();
pr_chitiet.ID_PR_Chi_Tiet = Convert.ToInt32(row["ID"]);
pr_chitiet.ID_PR = Convert.ToInt32(row["ID_PR"]);
pr_chitiet.Ma_Hang = row["MaHang"].ToString();
pr_chitiet.Ten_Hang = row["TenHang"].ToString();
pr_chitiet.DVT = row["DVT"].ToString();
pr_chitiet.Ton_Kho = Convert.ToInt32(row["TonKho"]);
pr_chitiet.So_Luong_Yeu_cau = Convert.ToInt32(row["SoLuongYeuCau"]);
pr_chitiet.Don_Gia = Convert.ToDouble(row["DonGia"]);
pr_chitiet.Ti_Gia = Convert.ToInt32(row["TiGia"]);
pr_chitiet.Thanh_Tien_Tam_Ung = Convert.ToDouble(row["ThanhTienTamUng"]);
pr_chitiet.Nha_Cung_cap = row["NhaCungCap"].ToString();
pr_chitiet.Tinh_Trang_Vat_Tu = Convert.ToInt32(row["TinhTrangVatTu"]);
pr_chitiet.Ngay_Can_Hang = Convert.ToDateTime(row["NgayCanHang"]);
pr_chitiet.Thoi_Gian_Xu_Dung = row["ThoiGianSuDung"].ToString();
pr_chitiet.Cong_Dung = row["CongDung"].ToString();
pr_chitiet.Lead_Time = Convert.ToInt32(row["LeadTime"]);
pr_chitiet.So_Luong_Con_Lai = Convert.ToInt32(row["SoLuongConLai"]);
pr_chitiet.Nhom_Mua_ID = 0;
if (!row.IsNull("NhomMuaID"))
{
pr_chitiet.Nhom_Mua_ID = Convert.ToInt32(row["NhomMuaID"]);
}
if (row["NhomMuaName"] != null)
{
pr_chitiet.Nhom_Mua_Name = row["NhomMuaName"].ToString();
}
else
{
pr_chitiet.Nhom_Mua_Name = "";
}
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = "";
if (!row.IsNull("NguoiPTMuaHang"))
{
pr_chitiet.Nguoi_Phu_Trach_Mua_Hang = row["NguoiPTMuaHang"].ToString();
}
pr_chitiet.VAT = 0;
if (!row.IsNull("VAT"))
{
pr_chitiet.VAT = Convert.ToInt32(row["VAT"].ToString());
}
pr_chitiet.GiaNhapTay = false;
if (!row.IsNull("GiaNhapTay"))
{
pr_chitiet.GiaNhapTay = Convert.ToBoolean(row["GiaNhapTay"]);
}
pr_Chitiet_col.Add(pr_chitiet);
}
}
return(pr_Chitiet_col);
}
