private AMSCM.Models.tbStockMain AddStockMain(AMSCM.Models.AMSCM amscm, string cnvcWhCode, string cnvcDeptId, string strOperId, string strOperName, int cnnOperType, DateTime cndBusinessDate) { AMSCM.Models.tbStockMain tbStockMain = new AMSCM.Models.tbStockMain(); tbStockMain.cnvcWhCode = cnvcWhCode; tbStockMain.cnvcDeptId = cnvcDeptId; tbStockMain.cnnOperType = cnnOperType; tbStockMain.cnnSource = 1; tbStockMain.cndCreateDate = DateTime.Now; tbStockMain.cnvcCreaterId = strOperId; tbStockMain.cnvcCreaterName = strOperName; tbStockMain.cndCheckDate = tbStockMain.cndCreateDate; tbStockMain.cnvcCheckerId = tbStockMain.cnvcCreaterId; tbStockMain.cnvcCheckerName = tbStockMain.cnvcCreaterName; tbStockMain.cndBusinessDate = cndBusinessDate; tbStockMain.cnnYear = cndBusinessDate.Year; tbStockMain.cnnMonth = cndBusinessDate.Month; tbStockMain.cnnStatus = (int)StockStatus.Check; tbStockMain.cnvcComments = "月结自动生成下月期初库存"; amscm.tbStockMain.Add(tbStockMain); amscm.SaveChanges(); AMSCM.Models.tbStockMainLog tbStockMainLog = new AMSCM.Models.tbStockMainLog(); ServiceHelper.SetEntity <AMSCM.Models.tbStockMain, AMSCM.Models.tbStockMainLog>(tbStockMain, tbStockMainLog); amscm.tbStockMainLog.Add(tbStockMainLog); return(tbStockMain); }
private string balance(HttpContext context) { try { using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.RequiresNew, new TimeSpan(0, 10, 0))) { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { //amscm.Database.Connection.ConnectionTimeout = 600; //更新月结表 int icnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]); int icnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]); int icount = (from d in amscm.tbMonthlyBalance where d.cnnYear <= icnnYear && d.cnnMonth < icnnMonth && !d.cnbIsBalance select d).Count(); if (icount > 0) { return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "请先月结以前月份!"))); } AMSCM.Models.tbMonthlyBalance tbMonthlyBalance = amscm.tbMonthlyBalance.Find(icnnYear, icnnMonth); if (tbMonthlyBalance.cnbIsBalance) { return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "已月结!"))); } tbMonthlyBalance.cnbIsBalance = true; string strOperId = context.User.Identity.Name; CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"]; string strOperName = ls1.strOperName; tbMonthlyBalance.cndBalanceDate = DateTime.Now; tbMonthlyBalance.cnvcBalancer = strOperId; tbMonthlyBalance.cnvcBalancerName = strOperName; AMSCM.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new AMSCM.Models.tbMonthlyBalanceLog(); ServiceHelper.SetEntity <AMSCM.Models.tbMonthlyBalance, AMSCM.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog); amscm.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog); //更新盘点和领料单的成本 Compute(amscm, tbMonthlyBalance, strOperId, strOperName); amscm.SaveChanges(); transaction.Complete(); } } } catch (TimeoutException tex) { ExceptionPolicy.HandleException(tex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, tex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string UpdateCost(HttpContext context) { try { string strOperId = context.User.Identity.Name; CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"]; string strOperName = ls1.strOperName; int icnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]); int icnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]); AMSCM.Models.tbMonthlyBalance tbMonthlyBalance = new AMSCM.Models.tbMonthlyBalance(); tbMonthlyBalance.cnnYear = icnnYear; tbMonthlyBalance.cnnMonth = icnnMonth; using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { Compute(amscm, tbMonthlyBalance, strOperId, strOperName); } } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, ex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string updatetbWarehouse(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbWarehouse tbWarehouse = amscm.tbWarehouse.Find(context.Request.Form["cnvcWhCode"]); tbWarehouse.cnvcWhCode = context.Request.Form["cnvcWhCode"]; tbWarehouse.cnvcWhName = context.Request.Form["cnvcWhName"]; tbWarehouse.cnvcDepID = context.Request.Form["cnvcDepID"]; tbWarehouse.cnvcWhAddress = context.Request.Form["cnvcWhAddress"]; tbWarehouse.cnvcWhPhone = context.Request.Form["cnvcWhPhone"]; tbWarehouse.cnvcWhPerson = context.Request.Form["cnvcWhPerson"]; tbWarehouse.cnvcWhComments = context.Request.Form["cnvcWhComments"]; tbWarehouse.cnbInvalid = context.Request.Form["cnbInvalid"] == "on" ? true : false; amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string updatetbBillOfMaterials(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbBillOfMaterials tbBillOfMaterials = amscm.tbBillOfMaterials.Find(context.Request.Form["cnvcPartInvCode"], context.Request.Form["cnvcComponentInvCode"]); tbBillOfMaterials.cnvcPartInvCode = context.Request.Form["cnvcPartInvCode"]; tbBillOfMaterials.cnvcComponentInvCode = context.Request.Form["cnvcComponentInvCode"]; tbBillOfMaterials.cnnBaseQtyN = Convert.ToDecimal(context.Request.Form["cnnBaseQtyN"]); tbBillOfMaterials.cnnBaseQtyD = Convert.ToDecimal(context.Request.Form["cnnBaseQtyD"]); amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string newtbMonthlyBalance(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbMonthlyBalance tbMonthlyBalance = new AMSCM.Models.tbMonthlyBalance(); tbMonthlyBalance.cnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]); tbMonthlyBalance.cnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]); tbMonthlyBalance.cnbIsBalance = false; tbMonthlyBalance.cndCreateDate = DateTime.Now; tbMonthlyBalance.cnvcCreater = context.User.Identity.Name; CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"]; tbMonthlyBalance.cnvcCreaterName = ls1.strOperName; //tbMonthlyBalance.cndModifyDate = tbMonthlyBalance.cndCreateDate; //tbMonthlyBalance.cnvcModifier = tbMonthlyBalance.cnvcCreater; //tbMonthlyBalance.cnvcModifierName = tbMonthlyBalance.cnvcCreaterName; amscm.tbMonthlyBalance.Add(tbMonthlyBalance); AMSCM.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new AMSCM.Models.tbMonthlyBalanceLog(); ServiceHelper.SetEntity <AMSCM.Models.tbMonthlyBalance, AMSCM.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog); amscm.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog); amscm.SaveChanges(); } } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string updateProductClass(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbProductClass productClass = amscm.tbProductClass.Find(context.Request.Form["cnvcProductClassCode"]); productClass.cnvcProductType = context.Request.Form["cnvcProductType"]; productClass.cnvcProductClassName = context.Request.Form["cnvcProductClassName"]; productClass.cnnDays = Convert.ToInt32(context.Request.Form["cnnDays"]); productClass.cnvcComments = context.Request.Form["cnvcComments"]; amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private IQueryable <tbLoginSub> QueryCondition(HttpContext context, AMSCM.Models.AMSCM amscm) { string strvcDeptID = context.Request["vcDeptID"] == null ? string.Empty : context.Request["vcDeptID"]; string strvcLoginID = context.Request["vcLoginID"] == null ? string.Empty : context.Request["vcLoginID"]; string strvcOperName = context.Request["vcOperName"] == null ? string.Empty : context.Request["vcOperName"]; string strq = context.Request["q"] == null ? string.Empty : context.Request["q"]; var q = from p in amscm.tbLogin select new tbLoginSub { vcDeptID = p.vcDeptID, vcLoginID = p.vcLoginID, vcOperName = p.vcOperName }; if (strvcDeptID != string.Empty) { q = q.Where(w => w.vcDeptID == strvcDeptID); } if (strvcLoginID != string.Empty) { q = q.Where(w => w.vcLoginID == strvcLoginID); } if (strvcOperName != string.Empty) { q = q.Where(w => w.vcOperName == strvcOperName); } if (strq != string.Empty) { q = q.Where(w => w.vcLoginID.Contains(strq) || w.vcOperName.Contains(strq)); } return(q); }
private string newtbSupplier(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbSupplier tbSupplier = new AMSCM.Models.tbSupplier(); tbSupplier.cnvcCode = context.Request.Form["cnvcCode"]; tbSupplier.cnvcName = context.Request.Form["cnvcName"]; tbSupplier.cnvcAddress = context.Request.Form["cnvcAddress"]; tbSupplier.cnvcPostCode = context.Request.Form["cnvcPostCode"]; tbSupplier.cnvcPhone = context.Request.Form["cnvcPhone"]; tbSupplier.cnvcFax = context.Request.Form["cnvcFax"]; tbSupplier.cnvcEmail = context.Request.Form["cnvcEmail"]; tbSupplier.cnvcLinkName = context.Request.Form["cnvcLinkName"]; //tbSupplier.cnvcCreateOper = context.Request.Form["cnvcCreateOper"]; CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"]; tbSupplier.cnvcCreateOper = ls1.strOperName; tbSupplier.cndCreateDate = DateTime.Now;//context.Request.Form["cndCreateDate"]; tbSupplier.cnbInvalid = context.Request.Form["cnbInvalid"] == "on"?true:false; amscm.tbSupplier.Add(tbSupplier); amscm.SaveChanges(); } } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string removeInventory(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbInventory inventory = amscm.tbInventory.Find(context.Request.Form["cnvcInvCode"]); amscm.tbInventory.Remove(inventory); AMSCM.Models.tbGoods tbGoods = amscm.tbGoods.Find(inventory.cnvcInvCode); if (tbGoods != null) { amscm.tbGoods.Remove(tbGoods); } amscm.SaveChanges(); } } catch (ArgumentNullException aex) { ExceptionPolicy.HandleException(aex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, aex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string updatetbDept(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbDept tbDept = amscm.tbDept.Find(context.Request.Form["cnvcDeptID"]); tbDept.cnvcDeptName = context.Request.Form["cnvcDeptName"]; tbDept.cnvcDeptID = context.Request.Form["cnvcDeptID"]; tbDept.cnvcDeptType = context.Request.Form["cnvcDeptType"]; tbDept.cnvcParentDeptID = context.Request.Form["cnvcParentDeptID"]; tbDept.cnvcComments = context.Request.Form["cnvcComments"]; tbDept.cnnPriority = Convert.ToInt32(context.Request.Form["cnnPriority"]); amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string updatetbStockDetail(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbStockDetail tbStockDetail = amscm.tbStockDetail.Find(context.Request.Form["cnnId"]); //tbStockDetail.cnnId = context.Request.Form["cnnId"]; //tbStockDetail.cnnMainId = context.Request.Form["cnnMainId"]; tbStockDetail.cnvcInvCode = context.Request.Form["cnvcInvCode"]; tbStockDetail.cnvcComUnitCode = context.Request.Form["cnvcComUnitCode"]; tbStockDetail.cnnQuantity = Convert.ToDecimal(context.Request.Form["cnnQuantity"]); tbStockDetail.cnvcMainComUnitCode = context.Request.Form["cnvcMainComUnitCode"]; tbStockDetail.cnnMainQuantity = Convert.ToDecimal(context.Request.Form["cnnMainQuantity"]); tbStockDetail.cnnPrice = Convert.ToDecimal(context.Request.Form["cnnPrice"]); tbStockDetail.cnnAmount = Convert.ToDecimal(context.Request.Form["cnnAmount"]); amscm.SaveChanges(); } } catch (NullReferenceException nex) { ExceptionPolicy.HandleException(nex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, nex.Message))); } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private void ComputationGroupExportToExcel(HttpContext context) { string fileName = "计量单位组.xls"; List <AMSCM.Models.tbComputationGroup> lComputationGroup = new List <AMSCM.Models.tbComputationGroup>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); lComputationGroup = q.OrderBy(o => o.cnvcGroupCode).ToList(); } DataTable dt = List2DataTable(context, lComputationGroup); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnvcGroupCode"; field.HeaderText = "计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupName"; field.HeaderText = "计量单位组名称"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private string newtbStockMain(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbStockMain tbStockMain = new AMSCM.Models.tbStockMain(); //tbStockMain.cnnId = context.Request.Form["cnnId"]; tbStockMain.cnvcSupplierCode = context.Request.Form["cnvcSupplierCode"]; tbStockMain.cnvcWhCode = context.Request.Form["cnvcWhCode"]; tbStockMain.cnvcDeptId = context.Request.Form["cnvcDeptId"]; //tbStockMain.cnvcOperType = Convert.ToInt32(context.Request.Form["cnvcOperType"]); tbStockMain.cndCreateDate = DateTime.Now;//context.Request.Form["cndCreateDate"]; tbStockMain.cnvcCreaterId = context.Request.Form["cnvcCreaterId"]; tbStockMain.cnvcCreaterName = context.Request.Form["cnvcCreaterName"]; //tbStockMain.cndCheckDate = context.Request.Form["cndCheckDate"]; //tbStockMain.cnvcCheckerId = context.Request.Form["cnvcCheckerId"]; //tbStockMain.cnvcCheckerName = context.Request.Form["cnvcCheckerName"]; tbStockMain.cndBusinessDate = Convert.ToDateTime(context.Request.Form["cndBusinessDate"]); tbStockMain.cnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]); tbStockMain.cnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]); tbStockMain.cnnStatus = Convert.ToInt32(context.Request.Form["cnnStatus"]); tbStockMain.cnvcComments = context.Request.Form["cnvcComments"]; amscm.tbStockMain.Add(tbStockMain); amscm.SaveChanges(); } } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
private string newtbComputationUnit(HttpContext context) { try { using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { AMSCM.Models.tbComputationUnit tbComputationUnit = new AMSCM.Models.tbComputationUnit(); tbComputationUnit.cnvcComunitCode = context.Request.Form["cnvcComunitCode"]; tbComputationUnit.cnvcComUnitName = context.Request.Form["cnvcComUnitName"]; tbComputationUnit.cnvcGroupCode = context.Request.Form["cnvcGroupCode"]; tbComputationUnit.cnbMainUnit = context.Request.Form["cnbMainUnit"] == "on"?true:false; if (tbComputationUnit.cnbMainUnit) { int icount = (from d in amscm.tbComputationUnit where d.cnbMainUnit && d.cnvcGroupCode == tbComputationUnit.cnvcGroupCode select d).Count(); if (icount > 0) { return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "此计量单位组已有主计量单位,一个计量单位组只能有一个主计量单位!"))); } } if (context.Request.Form["cniChangRate"] != "") { tbComputationUnit.cniChangRate = Convert.ToDecimal(context.Request.Form["cniChangRate"]); } amscm.tbComputationUnit.Add(tbComputationUnit); amscm.SaveChanges(); } } catch (DbUpdateException dex) { ExceptionPolicy.HandleException(dex, ServiceHelper.ExceptionPolicy); return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, dex.Message))); } return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ""))); }
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)); } }
public static List <AMSCM.Models.tbBillOfMaterials> getBOM(AMSCM.Models.AMSCM amscm) { List <AMSCM.Models.tbBillOfMaterials> ltbBillOfMaterials = (from d in amscm.tbBillOfMaterials select d).ToList(); ltbBillOfMaterials.ForEach(delegate(AMSCM.Models.tbBillOfMaterials tbBillOfMaterials) { tbBillOfMaterials.cnnBaseQtyN = tbBillOfMaterials.cnnBaseQtyD / tbBillOfMaterials.cnnBaseQtyD; tbBillOfMaterials.cnnBaseQtyD = 1; }); return(ltbBillOfMaterials); }
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 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 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 <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 void ProductCLassExportToExcel(HttpContext context) { string fileName = "存货分类.xls"; List <AMSCM.Models.tbProductClass> lProductClass = new List <AMSCM.Models.tbProductClass>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); lProductClass = q.OrderBy(o => o.cnvcProductClassCode).ToList(); } DataTable dt = List2DataTable(context, lProductClass); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field = new BoundField(); field.DataField = "cnvcProductType"; field.HeaderText = "产品组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductTypeComments"; field.HeaderText = "产品组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductClassCode"; field.HeaderText = "类别编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcProductClassName"; field.HeaderText = "类别名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnDays"; field.HeaderText = "过期天数"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComments"; field.HeaderText = "描述"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
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 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 void tbComputationUnitExportToExcel(HttpContext context) { string fileName = "计量单位.xls"; List <AMSCM.Models.tbComputationUnit> ltbComputationUnit = new List <AMSCM.Models.tbComputationUnit>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); ltbComputationUnit = q.OrderBy(o => o.cnvcComunitCode).ToList(); } DataTable dt = List2DataTable(context, ltbComputationUnit); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcComunitCode"; field.HeaderText = "计量单位编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComUnitName"; field.HeaderText = "计量单位名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCode"; field.HeaderText = "计量单位组编码"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcGroupCodeComments"; field.HeaderText = "计量单位组名称"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnbMainUnit"; field.HeaderText = "是否主计量单位"; view.Columns.Add(field); field = new BoundField(); field.DataField = "cniChangRate"; field.HeaderText = "换算率"; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }
private void tbDeptExportToExcel(HttpContext context) { string fileName = "部门.xls"; List <AMSCM.Models.tbDept> ltbDept = new List <AMSCM.Models.tbDept>(); using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM()) { var q = QueryCondition(context, amscm); ltbDept = q.OrderBy(o => o.cnvcDeptID).ToList(); } DataTable dt = List2DataTable(context, ltbDept); GridView view = new GridView(); view.AutoGenerateColumns = false; BoundField field; field = new BoundField(); field.DataField = "cnvcDeptName"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDeptID"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcDeptType"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcParentDeptID"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnvcComments"; field.HeaderText = ""; view.Columns.Add(field); field = new BoundField(); field.DataField = "cnnPriority"; field.HeaderText = ""; view.Columns.Add(field); view.DataSource = dt; view.DataBind(); ServiceHelper.DoExportToExcel(context, fileName, view); }