public JsonResult PostExport(string ma)
{
bool success = true;
string message = "Kết quả: Xuất báo cáo thành công.";
try
{
var daoNH = new XuatHangDao();
XuatHang obj_PXK = daoNH.GetByID(ma);
List <ChiTietXuat> lst_CT_PXK = obj_PXK.ChiTietXuats.OrderBy(obj => (obj.ID)).ToList();
List <DT_XuatKho> lst_DT_XK = new List <DT_XuatKho>();
for (int i = 0; i < lst_CT_PXK.Count; i++)
{
DT_XuatKho obj_DT_XK = new DT_XuatKho();
obj_DT_XK.STT = (i + 1).ToString();
obj_DT_XK.Mat_Hang = lst_CT_PXK.ElementAt(i).HangHoa.TenHH.ToString();
obj_DT_XK.So_Luong = lst_CT_PXK.ElementAt(i).SoLuong.ToString();
obj_DT_XK.DVT = lst_CT_PXK.ElementAt(i).HangHoa.DonViTinh.Ten;
obj_DT_XK.Don_Gia = lst_CT_PXK.ElementAt(i).DonGia.ToString();
obj_DT_XK.Ma_Kho = lst_CT_PXK.ElementAt(i).MaKho.ToString();
obj_DT_XK.Thanh_Tien = (int.Parse(obj_DT_XK.So_Luong) * double.Parse(obj_DT_XK.Don_Gia)).ToString();
lst_DT_XK.Add(obj_DT_XK);
}
System.Web.HttpContext.Current.Session["Khach_Hang"] = obj_PXK.KhachHang1.TenKH;
System.Web.HttpContext.Current.Session["SDT"] = obj_PXK.KhachHang1.SDT;
System.Web.HttpContext.Current.Session["Dia_Chi"] = obj_PXK.KhachHang1.DiaChi;
System.Web.HttpContext.Current.Session["Thu_Kho"] = obj_PXK.ThuKho;
System.Web.HttpContext.Current.Session["Nguoi_Lap"] = obj_PXK.NguoiLapPhieu;
System.Web.HttpContext.Current.Session["Dien_Giai"] = obj_PXK.DienGiai;
System.Web.HttpContext.Current.Session["So_CT"] = obj_PXK.IDXuat;
System.Web.HttpContext.Current.Session["Ngay_HT"] = obj_PXK.NgayXuat.Value.Day.ToString() + "/" + obj_PXK.NgayXuat.Value.Month.ToString() + "/" + obj_PXK.NgayXuat.Value.Year.ToString();
System.Web.HttpContext.Current.Session["Tong_Tien"] = String.Format("{0:0,0}", obj_PXK.TongTien.Value);
System.Web.HttpContext.Current.Session["Tien_Chu"] = CommonFunction.ConvertCurrency(obj_PXK.TongTien.Value);
System.Web.HttpContext.Current.Session["Data_Source"] = lst_DT_XK;
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
return(Json(new
{
success = success,
message = message
}));
}
public JsonResult CreatePXK(string khach_hang, string sdt, string dia_chi, string ngay_xuat, string ma,
string thu_kho, string nguoi_lap_phieu, string dien_giai, string tong_tien)
{
bool success = true;
string message = "Kết quả: Tạo phiếu xuất kho thành công!";
//Thêm khách hàng
var daoKH = new KhachHangDao();
KhachHang obj_kh = new KhachHang();
obj_kh.TenKH = khach_hang;
obj_kh.SDT = sdt;
obj_kh.DiaChi = dia_chi;
obj_kh.CreatedDate = DateTime.Now;
obj_kh.Status = true;
obj_kh.CreateBy = Session["UserName"].ToString();
int ma_kh = -1;
try
{
ma_kh = daoKH.Insert(obj_kh);
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
if (ma_kh != -1)
{
//Thêm phiếu xuất hàng
var dao = new XuatHangDao();
var daoID = new CauHinhIDDao();
XuatHang obj = new XuatHang();
obj.IDXuat = ma;
obj.KhachHang = ma_kh;
obj.NgayXuat = DateTime.ParseExact(ngay_xuat, "dd/MM/yyyy", null);
obj.ThuKho = thu_kho;
obj.NguoiLapPhieu = nguoi_lap_phieu;
obj.DienGiai = dien_giai;
obj.LoaiGiaoDichID = 1;
obj.TongTien = decimal.Parse(tong_tien);
obj.CreatedDate = DateTime.Now;
obj.CreateBy = Session["UserName"].ToString();
obj.TrangThai = 1;
try
{
dao.Insert(obj);
daoID.Update("BH");
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
}
return(Json(new
{
success = success,
message = message
}));
}
