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