private string GetAlltbMonthlyBalance(HttpContext context) { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var ltbMonthlyBalance = (from l in amscm.tbMonthlyBalance select l).ToList(); DataTable dt = List2DataTable(context, ltbMonthlyBalance); return(ServiceHelper.DataTableToEasyUIJson(dt)); } }
private string GetAlltbLogin(HttpContext context) { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var ltbLogin = (from l in amscm.tbLogin select new { l.vcDeptID, l.vcLoginID, l.vcOperName }).ToList(); DataTable dt = ltbLogin.ToDataTable(); ServiceHelper.DataTableConvert(context, dt, "vcDeptID", ServiceHelper.Table_tbDept, "cnvcDeptID", "cnvcDeptName", ""); return(ServiceHelper.DataTableToEasyUIJson(dt)); } }
private string GetAlltbMonthlyBalance(HttpContext context) { //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ var ltbMonthlyBalance = (from l in Uow.tbMonthlyBalance.GetAll() select l).ToList(); DataTable dt = List2DataTable(context, ltbMonthlyBalance); return(ServiceHelper.DataTableToEasyUIJson(dt)); //} }
private string getMonths(HttpContext context) { IEnumerable <KeyValuePair <int, string> > lMonths = GetAllMonths(); List <SelectOption> m = (from d in lMonths select new SelectOption { id = d.Key.ToString(), text = d.Value }).ToList(); DataTable dt = m.ToDataTable <SelectOption>(); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAllComputationGroup(HttpContext context) { List <AMSCM.Models.tbComputationGroup> lComputationGroup = new List <AMSCM.Models.tbComputationGroup>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { lComputationGroup = amscm.tbComputationGroup.ToList(); } DataTable dt = List2DataTable(context, lComputationGroup); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAllInventory(HttpContext context) { List <AMSCM.Models.tbInventory> lInventory = new List <AMSCM.Models.tbInventory>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { lInventory = amscm.tbInventory.ToList(); } DataTable dt = List2DataTable(context, lInventory); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAllProductClass(HttpContext context) { List <AMSCM.Models.tbProductClass> lProductClass = new List <AMSCM.Models.tbProductClass>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { lProductClass = amscm.tbProductClass.ToList(); } DataTable dt = List2DataTable(context, lProductClass); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbSupplier(HttpContext context) { List <AMSCM.Models.tbSupplier> ltbSupplier = new List <AMSCM.Models.tbSupplier>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbSupplier = amscm.tbSupplier.Where(w => w.cnbInvalid == false).ToList(); } DataTable dt = List2DataTable(context, ltbSupplier); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbComputationUnit(HttpContext context) { List <AMSCM.Models.tbComputationUnit> ltbComputationUnit = new List <AMSCM.Models.tbComputationUnit>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbComputationUnit = amscm.tbComputationUnit.ToList(); } DataTable dt = List2DataTable(context, ltbComputationUnit); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbBillOfMaterials(HttpContext context) { List <AMSCM.Models.tbBillOfMaterials> ltbBillOfMaterials = new List <AMSCM.Models.tbBillOfMaterials>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbBillOfMaterials = amscm.tbBillOfMaterials.ToList(); } DataTable dt = List2DataTable(context, ltbBillOfMaterials); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbStockDetail(HttpContext context) { List <AMSCM.Models.tbStockDetail> ltbStockDetail = new List <AMSCM.Models.tbStockDetail>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbStockDetail = amscm.tbStockDetail.ToList(); } DataTable dt = List2DataTable(context, ltbStockDetail); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbWarehouse(HttpContext context) { List <AMSCM.Models.tbWarehouse> ltbWarehouse = new List <AMSCM.Models.tbWarehouse>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbWarehouse = amscm.tbWarehouse.ToList(); } DataTable dt = List2DataTable(context, ltbWarehouse); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAllProductClass(HttpContext context) { List <DXInfo.Models.tbProductClass> lProductClass = new List <DXInfo.Models.tbProductClass>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ lProductClass = Uow.tbProductClass.GetAll().ToList(); //} DataTable dt = List2DataTable(context, lProductClass); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbDept(HttpContext context) { List <DXInfo.Models.tbDept> ltbDept = new List <DXInfo.Models.tbDept>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ ltbDept = Uow.tbDept.GetAll().ToList(); //} DataTable dt = List2DataTable(context, ltbDept); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetSomeNameCode(HttpContext context) { List <DXInfo.Models.tbNameCode> ltbNameCode = new List <DXInfo.Models.tbNameCode>(); string method = context.Request["method"]; //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ ltbNameCode = Uow.tbNameCode.GetAll().Where(w => w.cnvcType == method).ToList(); //} DataTable dt = List2DataTable(context, ltbNameCode); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAllInventory(HttpContext context) { List <DXInfo.Models.tbInventory> lInventory = new List <DXInfo.Models.tbInventory>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ lInventory = Uow.tbInventory.GetAll().ToList(); //} DataTable dt = List2DataTable(context, lInventory); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetAlltbSupplier(HttpContext context) { List <DXInfo.Models.tbSupplier> ltbSupplier = new List <DXInfo.Models.tbSupplier>(); //using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM()) //{ ltbSupplier = Uow.tbSupplier.GetAll().Where(w => w.cnbInvalid == false).ToList(); //} DataTable dt = List2DataTable(context, ltbSupplier); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetSomeNameCode(HttpContext context) { List <AMSCM.Models.tbNameCode> ltbNameCode = new List <AMSCM.Models.tbNameCode>(); string method = context.Request["method"]; using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { ltbNameCode = amscm.tbNameCode.Where(w => w.cnvcType == method).ToList(); } DataTable dt = List2DataTable(context, ltbNameCode); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string getYears(HttpContext context) { List <int> lYears = new List <int>(); lYears.Add(DateTime.Now.Year - 1); lYears.Add(DateTime.Now.Year); lYears.Add(DateTime.Now.Year + 1); List <SelectOption> y = (from d in lYears select new SelectOption { id = d.ToString(), text = d.ToString() + "年" }).ToList(); DataTable dt = y.ToDataTable <SelectOption>(); return(ServiceHelper.DataTableToEasyUIJson(dt)); }
private string GetProductType(HttpContext context) { DataTable dt = Helper.Query("select cnvcCode as id,cnvcName as text from tbNameCode where cnvcType='PRODUCTTYPE'"); return(ServiceHelper.DataTableToEasyUIJson(dt)); }