private DataTable List2DataTable(HttpContext context, List <DXInfo.Models.tbDept> ltbDept)
{
DataTable dt = ltbDept.ToDataTable <DXInfo.Models.tbDept>();
ServiceHelper.DataTableConvert(context, dt, "cnvcDeptType", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='DeptType'");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <AMSCM.Models.tbSupplier> ltbSupplier)
{
DataTable dt = ltbSupplier.ToDataTable <AMSCM.Models.tbSupplier>();
ServiceHelper.DataTableConvert(context, dt, "cnbInvalid");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <tbLoginSub> ltbLogin)
{
DataTable dt = ltbLogin.ToDataTable <tbLoginSub>();
ServiceHelper.DataTableConvert(context, dt, "vcDeptID", ServiceHelper.Table_tbDept, "cnvcDeptID", "cnvcDeptName", "");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <AMSCM.Models.tbBillOfMaterials> ltbBillOfMaterials)
{
DataTable dt = ltbBillOfMaterials.ToDataTable <AMSCM.Models.tbBillOfMaterials>();
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCode", "cnvcPartInvName", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcInvName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCode", "cnvcPartGroupCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcGroupCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCode", "cnvcPartInvCCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcInvCCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCCode", "cnvcPartInvCName", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductClassName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCCode", "cnvcPartProductType", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductType", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartProductType", "cnvcPartProductTypeName", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='PRODUCTTYPE'");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartGroupCode", "cnvcPartGroupName", ServiceHelper.Table_tbComputationGroup, "cnvcGroupCode", "cnvcGroupName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartInvCode", "cnvcPartProduceUnitCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcProduceUnitCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPartProduceUnitCode", "cnvcPartProduceUnitName", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCode", "cnvcComponentInvName", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcInvName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCode", "cnvcComponentGroupCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcGroupCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCode", "cnvcComponentInvCCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcInvCCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCCode", "cnvcComponentInvCName", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductClassName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCCode", "cnvcComponentProductType", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductType", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentProductType", "cnvcComponentProductTypeName", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='PRODUCTTYPE'");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentGroupCode", "cnvcComponentGroupName", ServiceHelper.Table_tbComputationGroup, "cnvcGroupCode", "cnvcGroupName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentInvCode", "cnvcComponentProduceUnitCode", ServiceHelper.Table_tbInventory, "cnvcInvCode", "cnvcProduceUnitCode", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComponentProduceUnitCode", "cnvcComponentProduceUnitName", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <DXInfo.Models.tbInventory> lInventory)
{
DataTable dt = lInventory.ToDataTable <DXInfo.Models.tbInventory>();
ServiceHelper.DataTableConvert(context, dt, "cnvcInvCCode", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductClassName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcInvCCode", "cnvcProductType", ServiceHelper.Table_tbProductClass, "cnvcProductClassCode", "cnvcProductType", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcProductType", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='PRODUCTTYPE'");
ServiceHelper.DataTableConvert(context, dt, "cnvcCreatePerson", ServiceHelper.Table_tbLogin, "vcLoginID", "vcOperName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcModifyPerson", ServiceHelper.Table_tbLogin, "vcLoginID", "vcOperName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcValueType", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='ValueType'");
ServiceHelper.DataTableConvert(context, dt, "cnvcGroupCode", ServiceHelper.Table_tbComputationGroup, "cnvcGroupCode", "cnvcGroupName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcComUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcSAComUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcPUComUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcSTComUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcProduceUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcShopUnitCode", ServiceHelper.Table_tbComputationUnit, "cnvcComunitCode", "cnvcComUnitName", "");
ServiceHelper.DataTableConvert(context, dt, "cnbProductBill");
ServiceHelper.DataTableConvert(context, dt, "cnbSale");
ServiceHelper.DataTableConvert(context, dt, "cnbPurchase");
ServiceHelper.DataTableConvert(context, dt, "cnbSelf");
ServiceHelper.DataTableConvert(context, dt, "cnbComsume");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <AMSCM.Models.tbProductClass> lProductClass)
{
DataTable dt = lProductClass.ToDataTable <AMSCM.Models.tbProductClass>();
ServiceHelper.DataTableConvert(context, dt, "cnvcProductType", ServiceHelper.Table_tbNameCode, "cnvcCode", "cnvcName", "cnvcType='PRODUCTTYPE'");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <DXInfo.Models.tbComputationUnit> ltbComputationUnit)
{
DataTable dt = ltbComputationUnit.ToDataTable <DXInfo.Models.tbComputationUnit>();
ServiceHelper.DataTableConvert(context, dt, "cnvcGroupCode", ServiceHelper.Table_tbComputationGroup, "cnvcGroupCode", "cnvcGroupName", "");
ServiceHelper.DataTableConvert(context, dt, "cnbMainUnit");
return(dt);
}
private DataTable List2DataTable(HttpContext context, List <DXInfo.Models.tbWarehouse> ltbWarehouse)
{
DataTable dt = ltbWarehouse.ToDataTable <DXInfo.Models.tbWarehouse>();
ServiceHelper.DataTableConvert(context, dt, "cnvcDepID", ServiceHelper.Table_tbDept, "cnvcDeptID", "cnvcDeptName", "");
ServiceHelper.DataTableConvert(context, dt, "cnvcWhPerson", ServiceHelper.Table_tbLogin, "vcLoginID", "vcOperName", "");
ServiceHelper.DataTableConvert(context, dt, "cnbInvalid");
return(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));
}
}
