protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var pdvId = Request["PDV_ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ThuChiDal.SelectByDraff(con, false);
if (khId != null && khId.Length > 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
}
else
{
Item = ThuChiDal.SelectById(con, new Guid(id));
}
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-CHI");
AddChi.ListLoai = listLoai;
AddChi.Item = Item;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
SuKien Item;
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = new SuKien();
if (!string.IsNullOrEmpty(khId))
{
if (khId.Length > 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
}
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.KH_Ten = kh.Ten;
Item.KH_ID = kh.ID;
}
ViewItem.Item = Item;
}
else
{
Item = SuKienDal.SelectById(new Guid(id));
Item.KH_Ten = maHoa.DecryptString(Item.KH_Ten, Item.KH_ID.ToString());
ViewItem.Item = Item;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var q = Request["q"];
var size = Request["size"];
if (string.IsNullOrEmpty(size))
{
size = "10";
}
var khuVucId = Request["KhuVuc_Id"];
var nguonGocId = Request["NguonGoc_Id"];
var linhVucId = Request["LinhVuc_Id"];
var tuNgay = Request["TuNgay"];
var denNgay = Request["DenNgay"];
using (var con = DAL.con())
{
var pg =
KhachHangDal.pagerAll(con,
string.Format("?q={0}&size={1}&KhuVuc_Id={2}&NguonGoc_Id={3}&LinhVuc_Id={4}&TuNgay={5}&DenNgay={6}&", q, size, khuVucId,
nguonGocId, linhVucId, tuNgay, denNgay) + "{1}={0}", false, null, q, Convert.ToInt32(size), khuVucId,
nguonGocId, linhVucId, "0", tuNgay, denNgay);
DanhSachAll1.List = pg.List;
paging = pg.Paging;
var nguonGocList = DanhMucDal.SelectByLDMMa(con, "NGUON-KH");
var khuVucList = DanhMucDal.SelectByLDMMa(con, "KHUVUC");
var linhVucList = DanhMucDal.SelectByLDMMa(con, "LINHVUC-KH");
LinhVuc.List = linhVucList;
NguonGoc.List = nguonGocList;
KhuVuc.List = khuVucList;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var list = new List <PhieuXuatNhapSanPhamChiTiet>();
var listThuChi = new List <ThuChi>();
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ChoThueVayDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
if (!string.IsNullOrEmpty(khId))
{
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.KH_ID = kh.ID;
Item.KH_Ten = kh.Ten;
}
}
else
{
Item = ChoThueVayDal.SelectById(con, new Guid(id));
list = PhieuXuatNhapSanPhamChiTietDal.SelectByPxnSpId(con, id);
listThuChi = ThuChiDal.SelectByCtvId(con, Item.ID);
}
Add.ListThuChi = listThuChi;
Add.List = list;
Add.Item = Item;;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var list = new List <PhieuXuatNhapSanPhamChiTiet>();
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ChoThueVayDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
if (!string.IsNullOrEmpty(khId))
{
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.KH_ID = kh.ID;
Item.KH_Ten = kh.Ten;
}
}
else
{
Item = ChoThueVayDal.SelectById(con, new Guid(id));
list = PhieuXuatNhapSanPhamChiTietDal.SelectByPxnSpId(con, id);
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Add.LogoStr = logoStr;
Add.List = list;
Add.Item = Item;;
}
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
HttpContext c = HttpContext.Current;
var listRow = new List <jgridRow>();
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
foreach (var item in KhachHangDal.SelectCongNo(false.ToString()))
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[]
{
item.ID.ToString()
, item.Ten
, Lib.TienVietNam(item.CongNo)
}));
}
var gridSpAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, "1"
, "1000"
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSpAdm));
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoCong.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoCong.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "baoCaoCong.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoCong.JScript1.js")
, "{baoCaoCongFn.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 id = Request["ID"];
using (var con = DAL.con())
{
if (!string.IsNullOrEmpty(id))
{
Item = ChoThueVayDal.SelectById(con, new Guid(id));
ThanhLyIn.Item = Item;;
ThanhLyIn.Khach = KhachHangDal.SelectById(Item.KH_ID, con);
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
ThanhLyIn.LogoStr = logoStr;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
Item = PhieuXuatNhapSanPhamDal.SelectById(con, new Guid(id));
var phieuDichVuItem = PhieuDichVuDal.SelectById(con, Item.PDV_ID);
var khachHangItem = KhachHangDal.SelectById(phieuDichVuItem.KH_ID, con);
Print.Item = Item;
Print.Khach = khachHangItem;
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Print.LogoStr = logoStr;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var d = DateTime.Now;
var cuoiThangTruoc = new DateTime(d.Year, d.Month, 1).AddDays(-1);
var muoiNgayToi = cuoiThangTruoc.AddMonths(1);
var dauThangSau = d.AddMonths(6);
using (var con = DAL.con())
{
var list = SuKienDal.SelectPhieuDichVuForCalendar(con, cuoiThangTruoc, dauThangSau, null);
LichThang.List = list;
SinhNhat.List = KhachHangDal.pagerSinhNhat(null, false, null, null, 20, null, null).List;
EventsViewer.List = SuKienDal.SelectPhieuDichVuEventsViewer(con, d.ToString("yyyy-MM-dd"), muoiNgayToi.ToString("yyyy-MM-dd"), null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = PhieuDichVuDal.SelectDraff(con);
Item.Ma = Item.Ma == 0 ? 1 : Item.Ma + 1;
Item.ID = Guid.NewGuid();
}
else
{
Item = PhieuDichVuDal.SelectById(con, new Guid(id));
Item._KhachHang = KhachHangDal.SelectById(Item.KH_ID, con);
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
Add.LogoStr = logoStr;
Add.Item = Item;;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Add1.Item = new KhachHang();;
}
else
{
Add1.Item = KhachHangDal.SelectById(new Guid(id));
}
var nguonGocList = DanhMucDal.SelectByLDMMa(con, "NGUON-KH");
var khuVucList = DanhMucDal.SelectByLDMMa(con, "KHUVUC");
var linhVucList = DanhMucDal.SelectByLDMMa(con, "LINHVUC-KH");
Add1.NguonGoc = nguonGocList;
Add1.KhuVuc = khuVucList;
Add1.LinhVuc = linhVucList;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request["ID"];
var khId = Request["KH_ID"];
var pdvId = Request["PDV_ID"];
var ctvId = Request["CTV_ID"];
var pgvId = Request["PGV_ID"];
var pbhId = Request["PBH_ID"];
using (var con = DAL.con())
{
if (string.IsNullOrEmpty(id))
{
Item = ThuChiDal.SelectByDraff(con, true);
if (khId != null && khId.Length >= 36)
{
khId = khId.Substring(khId.LastIndexOf(',') + 1);
var kh = KhachHangDal.SelectById(new Guid(khId), con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (pdvId != null && pdvId.Length >= 36)
{
pdvId = pdvId.Substring(pdvId.LastIndexOf(',') + 1);
var pdv = PhieuDichVuDal.SelectById(con, new Guid(pdvId));
Item.PDV_ID = pdv.ID;
Item.PDV_Ma = pdv.Ma;
var kh = KhachHangDal.SelectById(pdv.KH_ID, con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (ctvId != null && ctvId.Length >= 36)
{
ctvId = ctvId.Substring(ctvId.LastIndexOf(',') + 1);
var ctv = ChoThueVayDal.SelectById(con, new Guid(ctvId));
Item.CTV_ID = ctv.ID;
Item.CTV_Ma = ctv.Ma;
var kh = KhachHangDal.SelectById(ctv.KH_ID, con);
Item.P_Ten = kh.Ten;
Item.P_ID = kh.ID;
}
if (pgvId != null && pgvId.Length >= 36)
{
pgvId = pgvId.Substring(pgvId.LastIndexOf(',') + 1);
var pgv = PhieuGiatVayDal.SelectById(con, new Guid(pgvId));
Item.PGV_ID = pgv.ID;
Item.PGV_Ma = pgv.Ma;
}
if (pbhId != null && pbhId.Length >= 36)
{
pbhId = pbhId.Substring(pgvId.LastIndexOf(',') + 1);
var pbh = PhieuBaoHongDal.SelectById(con, new Guid(pbhId));
Item.PBH_ID = pbh.ID;
Item.PBH_Ma = pbh.Ma;
}
}
else
{
Item = ThuChiDal.SelectById(con, new Guid(id));
}
var logoStr = DanhMucDal.SelectByMa("BAOCAO-HEADER-THUCHI", con).Description;
InPhieuChi.LogoStr = logoStr;
var listLoai = DanhMucDal.SelectByLDMMa(con, "NDTC-CHI");
InPhieuChi.ListLoai = listLoai;
InPhieuChi.Item = Item;
}
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
#region Tham số
var _ID = Request["ID"];
if (string.IsNullOrEmpty(_ID))
{
_ID = Guid.Empty.ToString();
}
var No = Request["No"];
HttpContext c = HttpContext.Current;
var listRow = new List <jgridRow>();
#endregion
switch (subAct)
{
case "get":
#region lấy dữ liệu cho grid
foreach (var item in KhachHangDal.SelectCongNo(No))
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[]
{
item.ID.ToString()
, item.Ten
, Lib.TienVietNam(item.CongNoDauKy)
, Lib.TienVietNam(item.TongNhap)
, Lib.TienVietNam(item.TongXuat)
, Lib.TienVietNam(item.TongThu)
, Lib.TienVietNam(item.TongChi)
, Lib.TienVietNam(item.TongDichVu)
, Lib.TienVietNam(item.CongNo)
}));
}
var gridSpAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, "1"
, "1000"
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSpAdm));
break;
#endregion
case "getSubXuat":
#region getSubXuat
if (!string.IsNullOrEmpty(_ID))
{
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-X");
var pagerGet = XuatNhapDal.pagerXuatNhap(true.ToString(), false.ToString(), false.ToString(), false.ToString(), _ID,
jgrsidx + " " + jgrsord, string.Empty,
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 "getSubNhap":
#region getSubNhap
if (!string.IsNullOrEmpty(_ID))
{
var danhMucLoaiXuatNhap = DanhMucDal.SelectByMa("LXN-N");
var pagerGet = XuatNhapDal.pagerXuatNhap(false.ToString(), false.ToString(), false.ToString(), false.ToString(), _ID,
jgrsidx + " " + jgrsord, string.Empty,
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 "getSubThu":
#region getSubThu
if (!string.IsNullOrEmpty(_ID))
{
var pagerGet = ThuChiDal.pagerTuNgayDenNgay(jgrsidx + " " + jgrsord, null,
Convert.ToInt32(jgRows),
true, null, null, null, _ID);
var danhMucKyHieu = DanhMucDal.SelectByMa("TC-THU");
string prefixMas = danhMucKyHieu.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.NDTC_Ten
, prefixMas + item.SoPhieu
, item.P_Ten
, item.Mota
, item.NgayTao.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.SoTien)
, item.NguoiTao_Ten
, (item.NguoiTao == Security.Username).ToString()
, (item.XN_ID != Guid.Empty).ToString()
, (item.DV_ID != Guid.Empty).ToString()
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "getSubChi":
#region lấy dữ liệu cho getSubThu
if (!string.IsNullOrEmpty(_ID))
{
var pagerGet = ThuChiDal.pagerTuNgayDenNgay(jgrsidx + " " + jgrsord, null,
Convert.ToInt32(jgRows),
false, null, null, null, _ID);
var danhMucKyHieu = DanhMucDal.SelectByMa("TC-CHI");
string prefixMas = danhMucKyHieu.KyHieu;
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.NDTC_Ten
, prefixMas + item.SoPhieu
, item.P_Ten
, item.Mota
, item.NgayTao.ToString("dd-MM-yyyy")
, Lib.TienVietNam(item.SoTien)
, item.NguoiTao_Ten
, (item.NguoiTao == Security.Username).ToString()
, (item.XN_ID != Guid.Empty).ToString()
, (item.DV_ID != Guid.Empty).ToString()
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.JScript1.js"));
//sb.AppendFormat(@"{0}"
// , cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.Publish.js"));
break;
#endregion
default:
#region nạp
var listFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "baoCaoNo.mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.commonStore.thuChiMgr.baoCaoNo.JScript1.js")
, "{baoCaoNoFn.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 logged = Security.IsAuthenticated();
var Id = Request["Id"];
var IdNull = string.IsNullOrEmpty(Id);
var Ten = Request["Ten"];
var Ma = Request["Ma"];
var DanhGia = Request["DanhGia"];
var Mobile = Request["Mobile"];
var Email = Request["Email"];
var Ym = Request["Ym"];
var FacebookUid = Request["FacebookUid"];
var NguonGoc_ID = Request["NguonGoc_ID"];
var KhuVuc_ID = Request["KhuVuc_ID"];
var XungHo = Request["XungHo"];
var LinhVuc_ID = Request["LinhVuc_ID"];
var NgungTheoDoi = Request["NgungTheoDoi"];
var ThoiGianGoiDien = Request["ThoiGianGoiDien"];
var CMND = Request["CMND"];
var CMND_NgayCap = Request["CMND_NgayCap"];
var CMND_NoiCap = Request["CMND_NoiCap"];
var DiaChi = Request["DiaChi"];
var Anh = Request["Anh"];
var NgaySinh = Request["NgaySinh"];
var NgayCuoi = Request["NgayCuoi"];
var TiemNang = Request["TiemNang"];
var BoQua = Request["BoQua"];
var ThanhCong = Request["ThanhCong"];
var refUrl = Request["refUrl"];
var q = Request["q"];
if (!string.IsNullOrEmpty(refUrl))
{
refUrl = Server.UrlDecode(refUrl);
}
NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
BoQua = !string.IsNullOrEmpty(BoQua) ? "true" : "false";
ThanhCong = !string.IsNullOrEmpty(ThanhCong) ? "true" : "false";
switch (subAct)
{
case "save":
#region Thêm khách hàng
if (logged)
{
var item = IdNull ? new KhachHang() : KhachHangDal.SelectById(new Guid(Id));
item.Ten = Ten;
item.Ma = Ma;
item.Anh = Anh;
item.ThoiGianGoiDien = ThoiGianGoiDien;
item.Mobile = Mobile;
item.FacebookUid = FacebookUid;
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item.NguoiCapNhat = Security.Username;
item.NgayCapNhat = DateTime.Now;
item.DiaChi = DiaChi;
item.Ym = Ym;
item.TiemNang = Convert.ToBoolean(TiemNang);
item.CMND = CMND;
item.XungHo = XungHo;
item.CMND_NoiCap = CMND_NoiCap;
if (!string.IsNullOrEmpty(CMND_NgayCap))
{
item.CMND_NgayCap = Convert.ToDateTime(CMND_NgayCap, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgaySinh))
{
item.NgaySinh = Convert.ToDateTime(NgaySinh, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NgayCuoi))
{
item.NgayCuoi = Convert.ToDateTime(NgayCuoi, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
if (!string.IsNullOrEmpty(LinhVuc_ID))
{
item.LinhVuc_ID = new Guid(LinhVuc_ID);
}
item.DanhGia = Convert.ToInt16(DanhGia);
if (IdNull)
{
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item.ID = Guid.NewGuid();
item = KhachHangDal.Insert(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} thêm mới khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 1
,
Ten = "Thêm"
});
#endregion
}
else
{
item = KhachHangDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} sửa khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 2
,
Ten = "Sửa"
});
#endregion
}
TimKiemDal.Add(item, item.ID);
//SearchManager.Add(Ten,string.Format("Khách hàng: {0}, Mobile: {1}, Địa chỉ: {2}"
// , Ten, Mobile, DiaChi),item.IndexContent, Ten,item.ID.ToString(),item.Url,typeof(KhachHang).Name);
rendertext(item.ID.ToString());
}
break;
#endregion
case "quickSave":
#region Thêm khách hàng nhanh
if (logged)
{
var item = IdNull ? new KhachHang() : KhachHangDal.SelectById(new Guid(Id));
item.Ten = Ten;
item.Ma = Ma;
item.Mobile = Mobile;
item.Email = Email;
item.NguoiCapNhat = Security.Username;
item.NgayCapNhat = DateTime.Now;
item.DiaChi = DiaChi;
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (IdNull)
{
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item.ID = Guid.NewGuid();
item = KhachHangDal.Insert(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} thêm mới khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 1
,
Ten = "Thêm"
});
#endregion
}
else
{
item = KhachHangDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} sửa khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 2
,
Ten = "Sửa"
});
#endregion
}
TimKiemDal.Add(item, item.ID);
rendertext(string.Format("({0})", JavaScriptConvert.SerializeObject(item)));
}
break;
#endregion
case "remove":
#region Xóa khách hàng
if (logged && !IdNull)
{
var item = KhachHangDal.SelectById(new Guid(Id));
if (item.NguoiTao == Security.Username)
{
KhachHangDal.DeleteById(new Guid(Id));
//SearchManager.Remove(Id);
TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} xóa khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 3
,
Ten = "Xóa"
});
#endregion
rendertext("1");
}
else
{
rendertext("0");
}
}
break;
#endregion
case "search":
#region search
var pgTiemNang = KhachHangDal.pagerAll(null, false, "KH_NgayTao desc", q, 20, null, null, null, "0");
rendertext(JavaScriptConvert.SerializeObject(pgTiemNang.List), "text/javascript");
break;
#endregion
default: break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var act = Request["act"];
var logged = Security.IsAuthenticated();
var Id = Request["Id"];
var IdNull = string.IsNullOrEmpty(Id);
var Ten = Request["Ten"];
var Ma = Request["Ma"];
var DanhGia = Request["DanhGia"];
var Mobile = Request["Mobile"];
var Ym = Request["Ym"];
var FacebookUid = Request["FacebookUid"];
var NguonGoc_ID = Request["NguonGoc_ID"];
var KhuVuc_ID = Request["KhuVuc_ID"];
var LinhVuc_ID = Request["LinhVuc_ID"];
var NgungTheoDoi = Request["NgungTheoDoi"];
var ThoiGianGoiDien = Request["ThoiGianGoiDien"];
var DiaChi = Request["DiaChi"];
var Anh = Request["Anh"];
var NgaySinh = Request["NgaySinh"];
var TiemNang = Request["TiemNang"];
var KH_ID = Request["KH_ID"];
var TT_ID = Request["TT_ID"];
var LOAI_ID = Request["LOAI_ID"];
var NoiDung = Request["NoiDung"];
var NgayBatDau = Request["NgayBatDau"];
var DM_ID = Request["DM_ID"];
var NhanVien = Request["NhanVien"];
var MoTa = Request["MoTa"];
var BoQua = Request["BoQua"];
var ThanhCong = Request["ThanhCong"];
var refUrl = Request["refUrl"];
var DV_ID = Request["DV_ID"];
var Gia = Request["Gia"];
var CK = Request["CK"];
var ThanhToan = Request["ThanhToan"];
var ConNo = Request["ConNo"];
var BaoHanh_ID = Request["BaoHanh_ID"];
var NgayLap = Request["NgayLap"];
var NgayLam = Request["NgayLam"];
var TVDV_ID = Request["TVDV_ID"];
var ThuTu = Request["ThuTu"];
var SoLan = Request["SoLan"];
var GhiChu = Request["GhiChu"];
if (!string.IsNullOrEmpty(refUrl))
{
refUrl = Server.UrlDecode(refUrl);
}
NgungTheoDoi = !string.IsNullOrEmpty(NgungTheoDoi) ? "true" : "false";
BoQua = !string.IsNullOrEmpty(BoQua) ? "true" : "false";
ThanhCong = !string.IsNullOrEmpty(ThanhCong) ? "true" : "false";
switch (act)
{
case "KhachHang-Add":
#region Thêm khách hàng
if (logged)
{
var item = IdNull ? new KhachHang() : KhachHangDal.SelectById(new Guid(Id));
item.Ten = Ten;
item.Ma = Ma;
item.Anh = Anh;
item.ThoiGianGoiDien = ThoiGianGoiDien;
item.Mobile = Mobile;
item.FacebookUid = FacebookUid;
item.NgungTheoDoi = Convert.ToBoolean(NgungTheoDoi);
item.NguoiCapNhat = Security.Username;
item.NgayCapNhat = DateTime.Now;
item.DiaChi = DiaChi;
item.Ym = Ym;
item.TiemNang = Convert.ToBoolean(TiemNang);
if (!string.IsNullOrEmpty(NgaySinh))
{
item.NgaySinh = Convert.ToDateTime(NgaySinh, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(NguonGoc_ID))
{
item.NguonGoc_ID = new Guid(NguonGoc_ID);
}
if (!string.IsNullOrEmpty(KhuVuc_ID))
{
item.KhuVuc_ID = new Guid(KhuVuc_ID);
}
if (!string.IsNullOrEmpty(LinhVuc_ID))
{
item.LinhVuc_ID = new Guid(LinhVuc_ID);
}
item.DanhGia = Convert.ToInt16(DanhGia);
if (IdNull)
{
item.NgayTao = DateTime.Now;
item.NguoiTao = Security.Username;
item.ID = Guid.NewGuid();
item = KhachHangDal.Insert(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} thêm mới khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 1
,
Ten = "Thêm"
});
#endregion
}
else
{
item = KhachHangDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} sửa khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 2
,
Ten = "Sửa"
});
#endregion
}
TimKiemDal.Add(item, item.ID);
rendertext(item.ID.ToString());
}
break;
#endregion
case "KhachHang-Xoa":
#region Xóa khách hàng
if (logged && !IdNull)
{
var item = KhachHangDal.SelectById(new Guid(Id));
if (item.NguoiTao == Security.Username)
{
KhachHangDal.DeleteById(new Guid(Id));
TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} xóa khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 3
,
Ten = "Xóa"
});
#endregion
rendertext("1");
}
else
{
rendertext("0");
}
}
break;
#endregion
case "KhachHang-UpgradeFromTiemNang":
#region Nâng cấp tiềm năng thành khách hàng
if (logged && !IdNull)
{
var item = KhachHangDal.SelectById(new Guid(Id));
item.TiemNang = false;
item.NgayCapNhat = DateTime.Now;
KhachHangDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{2} chuyển đổi tiềm năng thành khách hàng {1}-{0}", item.Ten, item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 4
,
Ten = "Chuyển đổi"
});
#endregion
rendertext(Id);
}
break;
#endregion
case "ChamSoc-Add":
#region Thêm chăm sóc
if (Security.IsAuthenticated())
{
ChamSoc item;
if (IdNull)
{
item = new ChamSoc {
ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username
};
item.NgayTao = DateTime.Now;
}
else
{
item = ChamSocDal.SelectById(new Guid(Id));
}
item.Ma = Ma;
if (!string.IsNullOrEmpty(KH_ID))
{
item.KH_ID = new Guid(KH_ID);
}
if (!string.IsNullOrEmpty(TT_ID))
{
item.TT_ID = new Guid(TT_ID);
}
if (!string.IsNullOrEmpty(LOAI_ID))
{
item.LOAI_ID = new Guid(LOAI_ID);
}
item.NoiDung = NoiDung;
if (IdNull)
{
item = ChamSocDal.Insert(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} thêm mới chăm sóc {0}", item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ma
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 1
,
Ten = "Thêm"
});
#endregion
}
else
{
item = ChamSocDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} sửa chăm sóc {0}", item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ma
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 2
,
Ten = "Sửa"
});
#endregion
}
TimKiemDal.Add(item, item.ID);
rendertext(item.ID.ToString());
}
break;
#endregion
case "ChamSoc-Xoa":
#region Xóa chăm sóc
if (Security.IsAuthenticated())
{
var item = ChamSocDal.SelectById(new Guid(Id));
if (item.NguoiTao == Security.Username)
{
ChamSocDal.DeleteById(new Guid(Id));
TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} xóa chăm sóc {0}", item.Ma,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ma
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 3
,
Ten = "Xóa"
});
#endregion
rendertext("1");
}
else
{
rendertext("0");
}
}
break;
#endregion
case "LichHen-Add":
#region Thêm lịch hẹn
if (Security.IsAuthenticated())
{
SuKien item;
if (IdNull)
{
item = new SuKien {
ID = Guid.NewGuid(), NgayTao = DateTime.Now, NguoiTao = Security.Username, NguoiCapNhat = Security.Username, NgayCapNhat = DateTime.Now
};
}
else
{
item = SuKienDal.SelectById(new Guid(Id));
}
item.Ten = Ten;
item.MoTa = MoTa;
if (!string.IsNullOrEmpty(NgayBatDau))
{
item.NgayBatDau = Convert.ToDateTime(NgayBatDau, new CultureInfo("vi-vn"));
}
if (!string.IsNullOrEmpty(KH_ID))
{
item.KH_ID = new Guid(KH_ID);
}
if (!string.IsNullOrEmpty(DM_ID))
{
item.DM_ID = new Guid(DM_ID);
}
item.BoQua = Convert.ToBoolean(BoQua);
item.ThanhCong = Convert.ToBoolean(ThanhCong);
item.NhanVien = NhanVien;
if (IdNull)
{
item = SuKienDal.Insert(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} thêm mới lịch hẹn: {0}", item.Ten,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 1
,
Ten = "Thêm"
});
#endregion
}
else
{
item = SuKienDal.Update(item);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} sửa lịch hẹn: {0}", item.Ten,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 2
,
Ten = "Sửa"
});
#endregion
}
TimKiemDal.Add(item, item.ID);
rendertext(item.ID.ToString());
}
break;
#endregion
case "LichHen-Xoa":
#region Xóa lịch hẹn
if (Security.IsAuthenticated())
{
var item = SuKienDal.SelectById(new Guid(Id));
if (item.NguoiTao == Security.Username)
{
ChamSocDal.DeleteById(new Guid(Id));
TimKiemDal.DeleteByPRowId(DAL.con(), item.ID);
#region log
LogDal.log(item, new Log()
{
Checked = false
,
Info =
string.Format("{1} xóa lịch hẹn: {0}", item.Ten,
Security.Username)
,
NgayTao = DateTime.Now
,
Username = Security.Username
,
PRowId = item.ID
,
PTen = item.Ten
,
RequestIp = Request.UserHostAddress
,
RawUrl = refUrl
,
LLOG_ID = 3
,
Ten = "Xóa"
});
#endregion
rendertext("1");
}
else
{
rendertext("0");
}
}
break;
#endregion
case "Logout":
#region logout this system
Security.LogOut();
break;
#endregion
default: break;
}
}
