public override void KhoiTao(SqlConnection con, Page page)
{
var sb = new StringBuilder();
var cs = page.ClientScript;
var c = HttpContext.Current;
var _id = c.Request["VID"];
#region bien
var ID = c.Request["ID"];
var TV_ID = c.Request["TV_ID"];
var DV_ID = c.Request["DV_ID"];
var NgayTao = c.Request["NgayTao"];
var NguoiTao = c.Request["NguoiTao"];
var Gia = c.Request["Gia"];
var GhiChu = c.Request["GhiChu"];
var SoLan = c.Request["SoLan"];
var ThanhToan = c.Request["ThanhToan"];
var ConNo = c.Request["ConNo"];
var NgayLap = c.Request["NgayLap"];
var BaoHanh_ID = c.Request["BaoHanh_ID"];
var Xoa = c.Request["Xoa"];
var NgayLam = c.Request["NgayLam"];
var ThuTu = c.Request["ThuTu"];
var TVDV_ID = c.Request["TVDV_ID"];
var KHO_ID = c.Request["KHO_ID"];
var CKTyLe = Request["CKTyLe"];
var CKTien = Request["CKTien"];
var HH_ID = Request["HH_ID"];
var SoLuong = Request["SoLuong"];
var DonGia = Request["DonGia"];
var Tong = Request["Tong"];
var VAT = Request["VAT"];
var XN_ID = Request["XN_ID"];
var KH_ID = Request["KH_ID"];
var CK = Request["CK"];
var NhanVien = Request["NhanVien"];
var LoaiQuy = Request["LoaiQuy"];
#endregion
switch (subAct)
{
case "get":
#region Nạp js
break;
#endregion
case "draff":
#region Nạp draff
if (Security.IsAuthenticated())
{
var tuVanDichVuItem = TuVanDichVuDal.SelectById(con, new Guid(TVDV_ID));
var tieuHaoList = DichVuChiTietDal.SelectByDvId(con, tuVanDichVuItem.DV_ID.ToString());
var item = XuatNhapDal.SelectByDraff(true);
foreach (var tieuHao in tieuHaoList)
{
var itemHH = HangHoaDal.SelectById(tieuHao.HH_ID);
XuatNhapChiTietDal.Insert(new XuatNhapChiTiet()
{
CKTien = 0
, CKTyLe = 0
, DonGia = tieuHao.Gia
, Draff = true
, DraffDate = DateTime.Now
, DV_ID = itemHH.DonVi_ID
, GhiChu = "Xuất kho tiêu hao làm dịch vụ"
, HH_ID = tieuHao.HH_ID
, NgayCapNhat = DateTime.Now
, NgayTao = DateTime.Now
, NguoiTao = Security.Username
, SoLuong = tieuHao.SoLuong
, VAT = 0
, Tong = tieuHao.Gia * tieuHao.SoLuong
, XN_ID = item.ID
, ID = Guid.NewGuid()
});
}
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
string prefixMa = danhMucLoaiXuatNhap.KyHieu;
item.Ma = prefixMa + item.Ma;
item.XNCT = XuatNhapChiTietDal.SelectByXN_ID(item.ID.ToString());
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "saveTuVanDichVu":
#region Save TuVanDichVu
if (!string.IsNullOrEmpty(DV_ID))
{
// Phiếu tư vấn dịch vụ
var item = new TuVanDichVu();
if (!string.IsNullOrEmpty(ID))
{
item = TuVanDichVuDal.SelectById(new Guid(ID));
}
if (!string.IsNullOrEmpty(DV_ID))
{
item.DV_ID = new Guid(DV_ID);
}
if (!string.IsNullOrEmpty(TV_ID))
{
item.TV_ID = new Guid(TV_ID);
}
if (!string.IsNullOrEmpty(BaoHanh_ID))
{
item.BaoHanh_ID = new Guid(BaoHanh_ID);
}
if (!string.IsNullOrEmpty(TV_ID))
{
item.TV_ID = new Guid(TV_ID);
}
if (!string.IsNullOrEmpty(KHO_ID))
{
item.KHO_ID = new Guid(KHO_ID);
}
if (!string.IsNullOrEmpty(SoLan))
{
item.SoLan = Convert.ToInt32(SoLan);
}
item.NhanVien = NhanVien;
item.CK = Convert.ToDouble(CK);
item.GhiChu = GhiChu;
item.Gia = Convert.ToDouble(Gia);
item.ConNo = Convert.ToDouble(ConNo);
item.ThanhToan = Convert.ToDouble(ThanhToan);
if(!string.IsNullOrEmpty(NgayLap))
{
item.NgayLap = Convert.ToDateTime(NgayLap, new CultureInfo("vi-Vn"));
}
if (!string.IsNullOrEmpty(ID))
{
item =TuVanDichVuDal.Update(item);
}
else
{
item.ID = Guid.NewGuid();
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item = TuVanDichVuDal.Insert(item);
}
// Thu chi
var thuChi = ThuChiDal.SelectByDvId(item.ID.ToString());
thuChi.LoaiQuy = Convert.ToInt32(LoaiQuy);
thuChi.SoTien = item.ThanhToan;
thuChi.NgayTao = Convert.ToDateTime(NgayLap, new CultureInfo("vi-Vn"));
if (thuChi.ID == Guid.Empty)
{
var ndtcItem = DanhMucDal.SelectByMa("NDTC-THU-KHANGTRA-DVU");
thuChi = ThuChiDal.SelectByDraff(true);
thuChi.LoaiCandoi = 0;
thuChi.Mota = string.Format("{0}: {1}", ndtcItem.Ten, item._DichVu.Ten);
thuChi.NDTC_ID = ndtcItem.ID;
thuChi.Thu = true;
thuChi.DV_ID = item.ID;
thuChi.NguoiTao = Security.Username;
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
thuChi.P_ID = item._TuVan.KH_ID;
thuChi.isCandoi = false;
thuChi.SoTien = item.ThanhToan;
ThuChiDal.Insert(thuChi);
}
else
{
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
ThuChiDal.Update(thuChi);
}
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "SaveXNChiTiet":
#region SaveXNChiTiet
if (Security.IsAuthenticated())
{
var item = XuatNhapChiTietDal.SelectById(new Guid(ID));
item.CKTien = Convert.ToDouble(CKTien);
item.CKTyLe = Convert.ToDouble(CKTyLe);
item.DonGia = Convert.ToDouble(DonGia);
item.DV_ID = new Guid(DV_ID);
item.GhiChu = GhiChu;
item.NgayCapNhat = DateTime.Now;
item.NguoiCapNhat = Security.Username;
item.SoLuong = Convert.ToDouble(SoLuong);
item.Tong = Convert.ToDouble(Tong);
item.VAT = Convert.ToDouble(VAT);
if (!string.IsNullOrEmpty(KH_ID))
{
item.KH_ID = new Guid(KH_ID);
}
item = XuatNhapChiTietDal.Update(item);
sb.Append("1");
}
break;
#endregion
case "XoaXNChiTiet":
#region Xóa tài liệu đính kèm
if (!string.IsNullOrEmpty(ID))
{
XuatNhapChiTietDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "ThemXNChiTiet":
#region Them xuat nhap chi tiet
if (!string.IsNullOrEmpty(XN_ID))
{
var itemHH = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var itemXNCT = new XuatNhapChiTiet();
var tuVanItem = TuVanDal.SelectById(new Guid(TV_ID));
itemXNCT.CKTien = 0;
itemXNCT.CKTyLe = 0;
itemXNCT.DonGia = itemHH.GNY;
itemXNCT.DV_ID = itemHH.DonVi_ID;
itemXNCT.HH_ID = itemHH.ID;
itemXNCT.ID = Guid.NewGuid();
itemXNCT.NgayCapNhat = DateTime.Now;
itemXNCT.NgayTao = DateTime.Now;
itemXNCT.NguoiCapNhat = Security.Username;
itemXNCT.NguoiTao = Security.Username;
itemXNCT.SoLuong = 1;
itemXNCT.Tong = itemXNCT.SoLuong * itemXNCT.DonGia;
itemXNCT.VAT = Convert.ToDouble(VAT);
itemXNCT.XN_ID = new Guid(XN_ID);
itemXNCT.Draff = true;
itemXNCT.DraffDate = DateTime.Now;
itemXNCT = XuatNhapChiTietDal.Insert(itemXNCT);
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(itemXNCT));
}
break;
#endregion
case "saveLamDichVu":
#region saveLamDichVu
if (!string.IsNullOrEmpty(TVDV_ID) || !string.IsNullOrEmpty(ID))
{
var item = new TuVanLamDichVu();
if (!string.IsNullOrEmpty(ID))
{
item = TuVanLamDichVuDal.SelectById(new Guid(ID));
}
if (!string.IsNullOrEmpty(TVDV_ID))
{
item.TVDV_ID = new Guid(TVDV_ID);
var itemDv = TuVanDichVuDal.SelectById(con, new Guid(TVDV_ID));
var itemTv = TuVanDal.SelectById(itemDv.TV_ID);
item.KH_ID = itemTv.KH_ID;
}
if (!string.IsNullOrEmpty(ThuTu))
{
item.ThuTu = Convert.ToInt32(ThuTu);
}
item.NhanVien = NhanVien;
if (!string.IsNullOrEmpty(NgayLam))
{
item.NgayLam = Convert.ToDateTime(NgayLam, new CultureInfo("vi-Vn"));
}
if (!string.IsNullOrEmpty(ID))
{
item = TuVanLamDichVuDal.Update(item);
}
else
{
item.ID = Guid.NewGuid();
item = TuVanLamDichVuDal.Insert(item);
}
var itemTvdv = TuVanDichVuDal.SelectById(item.TVDV_ID);
var khItem = KhachHangDal.SelectById(itemTvdv._TuVan.KH_ID);
// Phiếu Xuất nhập
var itemXn = XuatNhapDal.SelectTvDv(item.ID);
//itemXn.CongTienHang = itemTvdv.Gia;
//itemXn.ThanhToan = itemTvdv.ThanhToan;
//itemXn.ConNo = itemTvdv.Gia - itemTvdv.ThanhToan;
itemXn.Xuat = true;
itemXn.KH_ID = itemTvdv._TuVan.KH_ID;
itemXn.NgayCapNhat = DateTime.Now;
itemXn.NguoiCapNhat = Security.Username;
itemXn.DienGiai = string.Format("Xuất hàng kèm dịch vụ [{0}] cho khách hàng {1}, ", itemTvdv._DichVu.Ten, khItem.Ten);
itemXn.GhiChu = string.Format("Xuất hàng kèm dịch vụ [{0}] cho khách hàng {1}, ", itemTvdv._DichVu.Ten, khItem.Ten);
if (itemXn.ID == Guid.Empty)
{
var itemXn1 = XuatNhapDal.SelectByDraff(true);
itemXn1.ID = new Guid(XN_ID);
itemXn.Ma = itemXn1.Ma;
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
itemXn.LOAI_ID = danhMucLoaiXuatNhap.ID;
itemXn.ChietKhau = 0;
itemXn.NgayHoaDon = itemTvdv.NgayLap;
itemXn.NhanVien = Security.Username;
itemXn.VAT = 0;
itemXn.ID = Guid.NewGuid();
itemXn.KHO_ID = itemTvdv.KHO_ID;
itemXn.TVDV_ID = item.ID;
itemXn.NgayTao = DateTime.Now;
itemXn.NguoiTao = Security.Username;
itemXn.KH_ID = khItem.ID;
itemXn = XuatNhapDal.Insert(itemXn);
}
else
{
itemXn = XuatNhapDal.Update(itemXn);
}
// Xuất nhập chi tiết
// Xóa bỏ cũ
XuatNhapChiTietDal.DeleteByXnId(itemXn.ID);
// Thêm mới
foreach (var xnChiTiet in DichVuChiTietDal.SelectByDvId(con, itemTvdv.DV_ID.ToString()))
{
var itemXNCT = new XuatNhapChiTiet();
var hhItem = docsoft.entities.HangHoaDal.SelectById(xnChiTiet.HH_ID);
itemXNCT.CKTien = 0;
itemXNCT.CKTyLe = 0;
itemXNCT.DonGia = xnChiTiet.Gia;
itemXNCT.DV_ID = hhItem.DonVi_ID;
itemXNCT.HH_ID = xnChiTiet.HH_ID;
itemXNCT.ID = Guid.NewGuid();
itemXNCT.NgayCapNhat = DateTime.Now;
itemXNCT.NgayTao = itemXn.NgayTao;
itemXNCT.NguoiCapNhat = Security.Username;
itemXNCT.NguoiTao = Security.Username;
itemXNCT.SoLuong = xnChiTiet.SoLuong;
itemXNCT.Tong = itemXNCT.SoLuong * itemXNCT.DonGia;
itemXNCT.VAT = Convert.ToDouble(0);
itemXNCT.XN_ID = itemXn.ID;
itemXNCT.Draff = false;
itemXNCT.DraffDate = DateTime.Now;
itemXNCT = XuatNhapChiTietDal.Insert(itemXNCT);
}
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "delTuVan":
#region delTuVan
if (Security.IsAuthenticated())
{
TuVanDichVuDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "delDichVu":
#region delDichVu
if (Security.IsAuthenticated())
{
TuVanDichVuDal.DeleteById(new Guid(ID));
var thuChi = ThuChiDal.SelectByDvId(ID);
ThuChiDal.DeleteById(thuChi.ID);
}
break;
#endregion
case "delLamDichVu":
#region delDichVu
if (!string.IsNullOrEmpty(ID))
{
TuVanLamDichVuDal.DeleteById(new Guid(ID));
var xnItem = XuatNhapDal.SelectTvDv(new Guid(ID));
XuatNhapDal.DeleteById(xnItem.ID);
XuatNhapChiTietDal.DeleteByXnId(xnItem.ID);
}
break;
#endregion
case "editTuVan":
#region edit
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(TuVanDichVuDal.SelectById(new Guid(ID))));
break;
#endregion
case "editDichVu":
#region editDichVu
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(TuVanDichVuDal.SelectById(new Guid(ID))));
break;
#endregion
case "editLamDichVu":
#region editLamDichVu
if(!string.IsNullOrEmpty(ID))
{
var itemLdv = TuVanLamDichVuDal.SelectById(new Guid(ID));
itemLdv._XuatNhap = XuatNhapDal.SelectTvDv(itemLdv.ID);
itemLdv._XuatNhap.XNCT = XuatNhapChiTietDal.SelectByXN_ID(itemLdv._XuatNhap.ID.ToString());
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(itemLdv));
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(DanhSach), "appStore.pmSpa.desktop.controls.TuVanView.TuVan.js"));
break;
#endregion
default:
#region nạp
break;
#endregion
}
Html = sb.ToString();
base.KhoiTao(con);
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
var ID = Request["ID"];
var XN_ID = Request["XN_ID"];
var HH_ID = Request["HH_ID"];
var DV_ID = Request["DV_ID"];
var SoLuong = Request["SoLuong"];
var DonGia = Request["DonGia"];
var Tong = Request["Tong"];
var VAT = Request["VAT"];
var CKTyLe = Request["CKTyLe"];
var CKTien = Request["CKTien"];
var NgayTao = Request["NgayTao"];
var NguoiTao = Request["NguoiTao"];
var NgayCapNhat = Request["NgayCapNhat"];
var NguoiCapNhat = Request["NguoiCapNhat"];
var GhiChu = Request["GhiChu"];
var TV_ID = Request["TV_ID"];
var GH_ID = Request["GH_ID"];
var LOAI_ID = Request["LOAI_ID"];
var Ma = Request["Ma"];
var KH_ID = Request["KH_ID"];
var NgayHoaDon = Request["NgayHoaDon"];
var NhanVien = Request["NhanVien"];
var CongTienHang = Request["CongTienHang"];
var DienGiai = Request["DienGiai"];
var ThanhToan = Request["ThanhToan"];
var ConNo = Request["ConNo"];
var ChietKhau = Request["ChietKhau"];
var KHO_ID = Request["KHO_ID"];
var _q = Request["q"];
var draff = Request["draff"];
var Loai = Request["Loai"];
var Rep_Ten = Request["Rep_Ten"];
var Rep_Ngay = Request["Rep_Ngay"];
List<jgridRow> ListRow = new List<jgridRow>();
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
var isXuat = true;
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
var pagerGet = XuatNhapDal.pagerXuatNhap(true.ToString(), false.ToString(), true.ToString(),
false.ToString(), null,
jgrsidx + " " + jgrsord, _q,
Convert.ToInt32(jgRows));
string prefixMas = danhMucLoaiXuatNhap.KyHieu;
foreach (var item in pagerGet.List)
{
ListRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.LOAI_Ten
, prefixMas + item.Ma
, item.KH_Ten
, item.NgayHoaDon.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.CongTienHang)
, Lib.TienVietNam(item.VAT)
, Lib.TienVietNam(item.ChietKhau)
, Lib.TienVietNam(item.CongTienHang + item.VAT - item.ChietKhau)
, Lib.TienVietNam(item.ThanhToan)
, Lib.TienVietNam(item.ConNo)
, string.Format("{0:dd/MM/yy}",item.NgayCapNhat)
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, ListRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
break;
#endregion
case "del":
#region xóa
if (!string.IsNullOrEmpty(ID))
{
XuatNhapDal.DeleteById(new Guid(ID));
XuatNhapChiTietDal.DeleteByXnId(new Guid(ID));
var thuChi = ThuChiDal.SelectByXnId(ID);
ThuChiDal.DeleteById(thuChi.ID);
}
break;
#endregion
case "edit":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
var item = XuatNhapDal.SelectById(new Guid(ID));
string prefixMa = danhMucLoaiXuatNhap.KyHieu;
item.Ma = prefixMa + item.Ma;
item.XNCT = XuatNhapChiTietDal.SelectByXN_ID(item.ID.ToString());
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "draff":
#region draff
if (Security.IsAuthenticated())
{
var item = XuatNhapDal.SelectByDraff(isXuat);
string prefixMa = danhMucLoaiXuatNhap.KyHieu;
item.Ma = prefixMa + item.Ma;
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(item));
}
break;
#endregion
case "autoCompleteByQ":
#region lấy dữ liệu cho grid
//var pagerByQ = HangHoaDal.ByDm("", false, string.Empty, _q, 10, string.Empty);
//sb.Append(JavaScriptConvert.SerializeObject(pagerByQ.List));
break;
#endregion
case "save":
#region save
if (Security.IsAuthenticated())
{
var item = draff == "1" ? new XuatNhap() : XuatNhapDal.SelectById(new Guid(ID));
item.ChietKhau = 0;
item.CongTienHang = 0;
item.ConNo = 0;
item.GhiChu = GhiChu;
item.LOAI_ID = danhMucLoaiXuatNhap.ID;
item.Xuat = isXuat;
var prefixMa = danhMucLoaiXuatNhap.KyHieu;
Ma = Ma.Replace(prefixMa, "");
item.Ma = Ma;
if (!string.IsNullOrEmpty(KHO_ID))
{
item.KHO_ID = new Guid(KHO_ID);
}
if (!string.IsNullOrEmpty(TV_ID))
{
item.TVDV_ID = new Guid(TV_ID);
}
item.NoiBo = true;
item.NgayCapNhat = DateTime.Now;
item.NgayHoaDon = Convert.ToDateTime(NgayHoaDon, new CultureInfo("vi-Vn"));
item.NguoiCapNhat = Security.Username;
item.NhanVien = NhanVien;
item.ThanhToan = 0;
item.VAT = 0;
item.ID = new Guid(ID);
if (draff == "1")
{
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item = XuatNhapDal.Insert(item);
}
else
{
item = XuatNhapDal.Update(item);
}
sb.Append("1");
}
break;
#endregion
case "SaveXNChiTiet":
#region SaveXNChiTiet
if (Security.IsAuthenticated())
{
var item = XuatNhapChiTietDal.SelectById(new Guid(ID));
item.CKTien = Convert.ToDouble(CKTien);
item.CKTyLe = Convert.ToDouble(CKTyLe);
item.DonGia = Convert.ToDouble(DonGia);
item.DV_ID = new Guid(DV_ID);
item.GhiChu = GhiChu;
item.NgayCapNhat = DateTime.Now;
item.NguoiCapNhat = Security.Username;
item.SoLuong = Convert.ToDouble(SoLuong);
item.Tong = Convert.ToDouble(Tong);
item.VAT = Convert.ToDouble(VAT);
if(!string.IsNullOrEmpty(KH_ID))
{
item.KH_ID = new Guid(KH_ID);
}
item = XuatNhapChiTietDal.Update(item);
sb.Append("1");
}
break;
#endregion
case "XoaXNChiTiet":
#region Xóa tài liệu đính kèm
if (!string.IsNullOrEmpty(ID))
{
XuatNhapChiTietDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "ThemXNChiTiet":
#region Them xuat nhap chi tiet
if (!string.IsNullOrEmpty(ID))
{
var itemHH = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var itemXNCT = new XuatNhapChiTiet();
itemXNCT.CKTien = 0;
itemXNCT.CKTyLe = 0;
itemXNCT.DonGia = itemHH.GiaNhap;
itemXNCT.DV_ID = itemHH.DonVi_ID;
itemXNCT.HH_ID = itemHH.ID;
itemXNCT.ID = Guid.NewGuid();
itemXNCT.NgayCapNhat = DateTime.Now;
itemXNCT.NgayTao = DateTime.Now;
itemXNCT.NguoiCapNhat = Security.Username;
itemXNCT.NguoiTao = Security.Username;
itemXNCT.SoLuong = 1;
itemXNCT.Tong = itemXNCT.SoLuong * itemXNCT.DonGia;
itemXNCT.VAT = Convert.ToDouble(VAT);
itemXNCT.XN_ID = new Guid(ID);
itemXNCT.Draff = true;
itemXNCT.DraffDate = DateTime.Now;
itemXNCT = XuatNhapChiTietDal.Insert(itemXNCT);
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(itemXNCT));
}
break;
#endregion
case "reports":
#region bao cao
if (!string.IsNullOrEmpty(ID))
{
var item = XuatNhapDal.SelectById(new Guid(ID));
string prefixMa = danhMucLoaiXuatNhap.KyHieu;
item.Ma = prefixMa + item.Ma;
item.XNCT = XuatNhapChiTietDal.SelectByXN_ID(item.ID.ToString());
var itemIn = Lib.GetResource(Assembly.GetExecutingAssembly(), "noiBoXuat.in.htm");
var itemInRow = Lib.GetResource(Assembly.GetExecutingAssembly(), "noiBoXuat.in-row.htm");
var danhMucReportHeader = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI");
var sbRow = new StringBuilder();
var stt = 0;
foreach (var xnct in item.XNCT)
{
stt++;
sbRow.AppendFormat(itemInRow
, stt
, xnct.HH_Ten
, xnct.HH_Ma
, xnct.DV_Ten
, Lib.TienVietNam(xnct.DonGia)
, xnct.SoLuong
, Lib.TienVietNam(xnct.CKTien)
, Lib.TienVietNam(xnct.VAT)
, Lib.TienVietNam(xnct.Tong));
}
sb.AppendFormat(itemIn
, string.Format("Ngày {4}{0} tháng {3}{1} năm {2}", item.NgayTao.Day, item.NgayTao.Month, item.NgayTao.Year, item.NgayTao.Month < 10 ? "0" : "", item.NgayTao.Day < 10 ? "0" : "")
, item.Ma
, item.KH_Ten
, item.GhiChu
, item.KHO_Ten
, Lib.TienVietNam(item.CongTienHang)
, Lib.TienVietNam(item.VAT)
, Lib.TienVietNam(item.ChietKhau)
, Lib.TienVietNam(item.CongTienHang - item.VAT - item.ChietKhau)
, Lib.TienVietNam(item.ThanhToan)
, Lib.TienVietNam(item.ConNo)
, danhMucReportHeader.Description
, domain
, sbRow
, Lib.So_chu(item.CongTienHang)
, item.NhanVien
);
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.xuatNhapMgr.noiBoXuat.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.xuatNhapMgr.noiBoXuat.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "noiBoXuat.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.xuatNhapMgr.noiBoXuat.JScript1.js")
, "{noiBoXuatFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(listFn));
break;
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
protected void Page_Load(object sender, EventArgs e)
{
var act = Request["act"];
var Ten = Request["Ten"];
var Ho = Request["Ho"];
var ID = Request["ID"];
var XungHo = Request["XungHo"];
var NgaySinh = Request["NgaySinh"];
var Mobile = Request["Mobile"];
var FacebookUid = Request["FacebookUid"];
var NguonGoc_ID = Request["NguonGoc_ID"];
var KhuVuc_ID = Request["KhuVuc_ID"];
var DiaChi = Request["DiaChi"];
var NgungTheoDoi = Request["NgungTheoDoi"];
var HH_ID = Request["HH_ID"];
var GhiChu = Request["GhiChu"];
var FacebookUrl = Request["FacebookUrl"];
var UuTien = Request["UuTien"];
var NgayGiao = Request["NgayGiao"];
var NgayGiaoYeuCau = Request["NgayGiaoYeuCau"];
var NgayDat = Request["NgayDat"];
NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
switch (act)
{
case "add":
#region add
if(Security.IsAuthenticated())
{
KhachHang item;
if(string.IsNullOrEmpty(ID))
{
item=new KhachHang();
item.ID = Guid.NewGuid();
item.NgayTao = DateTime.Now;
}
else
{
item = KhachHangDal.SelectById(new Guid(ID));
}
item.NguoiTao = Security.Username;
item.Ten = Ten;
item.Mobile = Mobile;
item.FacebookUid = FacebookUid;
item.DiaChi = DiaChi;
if(!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID=new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item.NgayCapNhat = DateTime.Now;
item = string.IsNullOrEmpty(ID) ? KhachHangDal.Insert(item) : KhachHangDal.Update(item);
rendertext(item.ID.ToString());
}
break;
#endregion
case "xoa":
#region add
if (Security.IsAuthenticated())
{
KhachHangDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "addAndShip":
#region add
if (Security.IsAuthenticated())
{
var item = new KhachHang
{
ID = Guid.NewGuid(),
NgayTao = DateTime.Now,
NguoiTao = Security.Username,
Ten = Ten,
Mobile = Mobile,
FacebookUid = FacebookUid,
DiaChi = DiaChi,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
};
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item = KhachHangDal.Insert(item);
var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var dh = new DatHang
{
GiaTri = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
KH_DiaChi = DiaChi,
KH_ID = item.ID,
KH_Mobile = Mobile,
KH_Ten = Ten,
Readed = false,
Tong = Convert.ToInt32(hh.GNY),
PhiVanChuyen = 0,
NgayTao = DateTime.Now,
Username = Security.Username,
GhiChu = GhiChu,
FacebookUrl = FacebookUrl,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10),
UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien)
};
if (!string.IsNullOrEmpty(NgayGiaoYeuCau))
{
dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayDat))
{
dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn"));
}
else
{
dh.NgayDat = DateTime.Now;
}
if (!string.IsNullOrEmpty(NgayGiao))
{
dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
dh.NguonGoc_ID = new Guid(NguonGoc_ID);
}
dh = DatHangDal.Insert(dh);
var dhct = new DatHangChiTiet
{
DH_ID = dh.ID,
HH_ID = hh.ID,
HH_Gia = Convert.ToInt32(hh.GNY),
HH_SoLuong = 1,
HH_Ten = hh.Ten,
HH_Tong = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
NgayTao = DateTime.Now
};
dhct = DatHangChiTietDal.Insert(dhct);
var ship = new Shipping()
{
ID = Guid.NewGuid()
, DH_ID = dh.ID
, DH_Ma = dh.Ma
, Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
, DaGiao = false
, DiaChi = dh.KH_DiaChi
, HD_ID = dhct.HH_ID
, NgayGiao = DateTime.Now
, NgayTao = DateTime.Now
, NguoiTao = Security.Username
, Phi = dh.PhiVanChuyen
, Readed = false
, TraTien = false
, PhaiThu = dh.Tong
};
ship = ShippingDal.Insert(ship);
// Xuất nhập
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
var xn = XuatNhapDal.SelectByDraff(true);
xn.TVDV_ID = dh.ID;
xn.ChietKhau = 0;
xn.ChuyenDoi = false;
xn.ConNo = 0;
xn.CongTienHang = dh.Tong;
xn.DauKy = false;
xn.DienGiai = string.Format("Thêm hóa đơn bán lẻ cho đặt hàng {0}", dh.Ma);
xn.ID = Guid.NewGuid();
xn.KHO_ID = KhoHangDal.SelectAll()[0].ID;
xn.KH_ID = dh.KH_ID;
xn.KH_Ten = dh.KH_Ten;
xn.NgayCapNhat = DateTime.Now;
xn.NgayHoaDon = DateTime.Now;
xn.NgayTao = DateTime.Now;
xn.NguoiCapNhat = Security.Username;
xn.NguoiTao = Security.Username;
xn.NhanVien = Security.Username;
xn.NoiBo = false;
xn.ThanhToan = dh.Tong;
xn.TuVanVien = Security.Username;
xn.VAT = 0;
xn.Xuat = true;
xn.LOAI_ID = danhMucLoaiXuatNhap.ID;
xn = XuatNhapDal.Insert(xn);
// Xuất nhập chi tiết
var itemXnCt = new XuatNhapChiTiet
{
ID = Guid.NewGuid(),
CKTien = Convert.ToDouble(0),
CKTyLe = Convert.ToDouble(0),
DonGia = Convert.ToDouble(dhct.HH_Gia),
HH_ID = dhct.HH_ID,
GhiChu = GhiChu,
NgayCapNhat = DateTime.Now,
NguoiCapNhat = Security.Username,
SoLuong = Convert.ToDouble(dhct.HH_SoLuong),
Tong = Convert.ToDouble(dhct.HH_Tong),
VAT = Convert.ToDouble(0),
KH_ID = dh.KH_ID
};
itemXnCt = XuatNhapChiTietDal.Update(itemXnCt);
// Thu chi
var thuChi = ThuChiDal.SelectByXnId(xn.ID.ToString());
thuChi.LoaiQuy = Convert.ToInt32(0);
thuChi.P_ID = xn.KH_ID;
thuChi.NgayTao = DateTime.Now;
thuChi.SoTien = dh.Tong;
if (thuChi.ID == Guid.Empty)
{
var ndtcItem = DanhMucDal.SelectByMa("NDTC-THU-KHANGTRA");
thuChi = ThuChiDal.SelectByDraff(true);
thuChi.LoaiCandoi = 0;
thuChi.Mota = string.Format("{0}: {1}", ndtcItem.Ten, item.Ma);
thuChi.NDTC_ID = ndtcItem.ID;
thuChi.Thu = true;
thuChi.XN_ID = item.ID;
thuChi.NguoiTao = Security.Username;
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
thuChi.isCandoi = false;
ThuChiDal.Insert(thuChi);
}
else
{
thuChi.NguoiSua = Security.Username;
thuChi.NgaySua = DateTime.Now;
ThuChiDal.Update(thuChi);
}
rendertext(dh.ID.ToString());
}
break;
#endregion
case "addAndHoaDon":
#region addAndHoaDon
if (Security.IsAuthenticated())
{
var item = new KhachHang
{
ID = Guid.NewGuid(),
NgayTao = DateTime.Now,
NguoiTao = Security.Username,
Ten = Ten,
Mobile = Mobile,
FacebookUid = FacebookUid,
DiaChi = DiaChi,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
};
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item = KhachHangDal.Insert(item);
var hh = docsoft.entities.HangHoaDal.SelectById(new Guid(HH_ID));
var dh = new DatHang
{
GiaTri = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
KH_DiaChi = DiaChi,
KH_ID = item.ID,
KH_Mobile = Mobile,
KH_Ten = Ten,
Readed = false,
Tong = Convert.ToInt32(hh.GNY),
PhiVanChuyen = 0,
NgayTao = DateTime.Now,
Username = Security.Username,
GhiChu = GhiChu,
FacebookUrl = FacebookUrl,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10),
UuTien = Convert.ToInt32(string.IsNullOrEmpty(UuTien) ? "1" : UuTien)
};
if (!string.IsNullOrEmpty(NgayGiaoYeuCau))
{
dh.NgayGiaoYeuCau = Convert.ToDateTime(NgayGiaoYeuCau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayDat))
{
dh.NgayDat = Convert.ToDateTime(NgayDat, new CultureInfo("vi-vn"));
}
else
{
dh.NgayDat = DateTime.Now;
}
if (!string.IsNullOrEmpty(NgayGiao))
{
dh.NgayGiao = Convert.ToDateTime(NgayGiao, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
dh.NguonGoc_ID = new Guid(NguonGoc_ID);
}
dh = DatHangDal.Insert(dh);
var dhct = new DatHangChiTiet
{
DH_ID = dh.ID,
HH_ID = hh.ID,
HH_Gia = Convert.ToInt32(hh.GNY),
HH_SoLuong = 1,
HH_Ten = hh.Ten,
HH_Tong = Convert.ToInt32(hh.GNY),
ID = Guid.NewGuid(),
NgayTao = DateTime.Now
};
dhct = DatHangChiTietDal.Insert(dhct);
var ship = new Shipping()
{
ID = Guid.NewGuid()
,
DH_ID = dh.ID
,
DH_Ma = dh.Ma
,
Ma = CaptchaImage.GenerateRandomCode(CaptchaType.Numeric, 10)
,
DaGiao = false
,
DiaChi = dh.KH_DiaChi
,
HD_ID = dhct.HH_ID
,
NgayGiao = DateTime.Now
,
NgayTao = DateTime.Now
,
NguoiTao = Security.Username
,
Phi = dh.PhiVanChuyen
,
Readed = false
,
TraTien = false
,
PhaiThu = dh.Tong
};
ship = ShippingDal.Insert(ship);
rendertext(dh.ID.ToString());
}
break;
#endregion
default:
break;
}
}
