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));
}
