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, "")));
}
void context_AcquireRequestState(object sender, EventArgs e)
{
// 获取应用程序
HttpApplication application = (HttpApplication)sender;
// 检查用户是否已经登录
if (application.Context.Session == null || application.Context.Session[ServiceHelper.LoginSessionKey] == null)
{
// 获取Url
string requestUrl = application.Request.CurrentExecutionFilePath;
string requestPage = requestUrl.Substring(requestUrl.LastIndexOf('/') + 1);
// 如果请求的页面不是登录页面，刚重定向到登录页面。
if (application.Request.CurrentExecutionFilePathExtension == ".aspx")
{
if (requestPage != "default.aspx" && requestPage != "wfmFalse.aspx")
{
//application.Response.Write("<script>window.top.location.href='http://" + application.Request.ServerVariables["Http_Host"] + application.Request.ApplicationPath + "default.aspx';</script>");
application.Response.Write("<script>window.top.location.href='" + application.Request.ApplicationPath.TrimEnd('/') + "/default.aspx';</script>");
application.Response.End();
}
}
if (application.Request.CurrentExecutionFilePathExtension == ".ashx")
{
//Content-Type: text/xml; charset=utf-8
//application.Response.ContentType = "text/plain";
//application.Response.Clear();
//application.Response.Charset = "utf-8";
//application.Response.ContentType = "text/plain";
application.Response.Write(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "loginOvertime")));
//application.Response.Flush();
application.Response.End();
}
}
else
{
// 获取用户名和Url
CommCenter.CMSMStruct.LoginStruct ls = (CommCenter.CMSMStruct.LoginStruct)application.Session[ServiceHelper.LoginSessionKey];
string requestUrl = application.Request.CurrentExecutionFilePath;
string requestPage = requestUrl.Substring(requestUrl.LastIndexOf('/') + 1);
// 如果用户没有被授权，请求被终止，并打印提示信息。
if (application.Request.CurrentExecutionFilePathExtension == ".aspx" &&
requestPage != "default.aspx" && requestPage != "wfmMain.aspx" && requestPage != "Exit.aspx" &&
requestPage != "wfmWelcome.aspx"
//&& requestPage !="wfmOperPurview.aspx"
&& requestPage != "wfmSuccess.aspx" &&
requestPage != "wfmFalse.aspx" &&
requestPage != "wfmFalseHistory.aspx")
{
if (!CanUseModule(application, ls.strLoginID, requestPage))
{
application.CompleteRequest();
application.Response.Write(string.Format("对不起！{0}，您无权访问此模块(" + requestPage + ")！", ls.strOperName));
}
}
}
}
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 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 updateProductClass(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbProductClass productClass = Uow.tbProductClass.GetById(g => g.cnvcProductClassCode == 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"];
Uow.Commit();
//}
}
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 updatetbStockMain(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbStockMain tbStockMain = Uow.tbStockMain.GetById(g => g.cnnMainId == Convert.ToInt64(context.Request.Form["cnnId"]));
tbStockMain.cnvcSupplierCode = context.Request.Form["cnvcSupplierCode"];
tbStockMain.cnvcWhCode = context.Request.Form["cnvcWhCode"];
tbStockMain.cnvcDeptId = context.Request.Form["cnvcDeptId"];
tbStockMain.cndCheckDate = Convert.ToDateTime(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"];
Uow.Commit();
//}
}
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 newtbComputationUnit(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbComputationUnit tbComputationUnit = new DXInfo.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 Uow.tbComputationUnit.GetAll() 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"]);
}
Uow.tbComputationUnit.Add(tbComputationUnit);
Uow.Commit();
//}
}
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 (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbInventory inventory = Uow.tbInventory.GetById(g => g.cnvcInvCode == context.Request.Form["cnvcInvCode"]);
Uow.tbInventory.Delete(inventory);
DXInfo.Models.tbGoods tbGoods = Uow.tbGoods.GetById(g => g.vcGoodsID == inventory.cnvcInvCode);
if (tbGoods != null)
{
Uow.tbGoods.Delete(tbGoods);
}
Uow.Commit();
//}
}
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 newtbStockDetail(HttpContext context)
{
try
{
//using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
//{
DXInfo.Models.tbStockDetail tbStockDetail = new DXInfo.Models.tbStockDetail();
tbStockDetail.cnnMainId = Convert.ToInt64(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"]);
Uow.tbStockDetail.Add(tbStockDetail);
Uow.Commit(); //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 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 updatetbDept(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbDept tbDept = Uow.tbDept.GetById(g => g.cnvcDeptID == 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"]);
Uow.Commit();
//}
}
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 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 updatetbWarehouse(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbWarehouse tbWarehouse = Uow.tbWarehouse.GetById(g => g.cnvcWhCode == 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;
Uow.Commit();
//}
}
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 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 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 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 updatetbSupplier(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbSupplier tbSupplier = Uow.tbSupplier.GetById(g => g.cnvcCode == context.Request.Form["cnvcCode"]);
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.cnbInvalid = context.Request.Form["cnbInvalid"] == "on"?true:false;
Uow.Commit();
//}
}
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 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 updatetbBillOfMaterials(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbBillOfMaterials tbBillOfMaterials = Uow.tbBillOfMaterials.GetById(g => g.cnvcPartInvCode == context.Request.Form["cnvcPartInvCode"] && g.cnvcComponentInvCode == 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"]);
Uow.Commit();
//}
}
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 string newtbMonthlyBalance(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbMonthlyBalance tbMonthlyBalance = new DXInfo.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;
Uow.tbMonthlyBalance.Add(tbMonthlyBalance);
DXInfo.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new DXInfo.Models.tbMonthlyBalanceLog();
ServiceHelper.SetEntity <DXInfo.Models.tbMonthlyBalance, DXInfo.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog);
Uow.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog);
Uow.Commit();
//}
}
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 balance(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
using (TransactionScope transaction = new TransactionScope())
{
//更新月结表
int icnnYear = Convert.ToInt32(context.Request.Form["cnnYear"]);
int icnnMonth = Convert.ToInt32(context.Request.Form["cnnMonth"]);
int icount = (from d in Uow.tbMonthlyBalance.GetAll()
where d.cnnYear <= icnnYear && d.cnnMonth < icnnMonth && !d.cnbIsBalance
select d).Count();
if (icount > 0)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(false, "请先月结以前月份！")));
}
DXInfo.Models.tbMonthlyBalance tbMonthlyBalance = Uow.tbMonthlyBalance.GetById(g => g.cnnYear == icnnYear && g.cnnMonth == 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;
DXInfo.Models.tbMonthlyBalanceLog tbMonthlyBalanceLog = new DXInfo.Models.tbMonthlyBalanceLog();
ServiceHelper.SetEntity <DXInfo.Models.tbMonthlyBalance, DXInfo.Models.tbMonthlyBalanceLog>(tbMonthlyBalance, tbMonthlyBalanceLog);
Uow.tbMonthlyBalanceLog.Add(tbMonthlyBalanceLog);
//更新盘点和领料单的成本
Compute(tbMonthlyBalance, strOperId, strOperName);
Uow.Commit();
transaction.Complete();
}
//}
}
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 newComputationGroup(HttpContext context)
{
try
{
//using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
//{
DXInfo.Models.tbComputationGroup computationGroup = new DXInfo.Models.tbComputationGroup();
computationGroup.cnvcGroupCode = context.Request.Form["cnvcGroupCode"];
computationGroup.cnvcGroupName = context.Request.Form["cnvcGroupName"];
Uow.tbComputationGroup.Add(computationGroup);
Uow.Commit();
//}
}
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 updatetbComputationUnit(HttpContext context)
{
try
{
using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
{
AMSCM.Models.tbComputationUnit tbComputationUnit = amscm.tbComputationUnit.Find(context.Request.Form["cnvcComunitCode"]);
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 (context.Request.Form["cniChangRate"] != "")
{
tbComputationUnit.cniChangRate = Convert.ToDecimal(context.Request.Form["cniChangRate"]);
}
if (tbComputationUnit.cnbMainUnit)
{
int icount = (from d in amscm.tbComputationUnit where d.cnbMainUnit && d.cnvcGroupCode == tbComputationUnit.cnvcGroupCode && d.cnvcComunitCode != tbComputationUnit.cnvcComunitCode select d).Count();
if (icount > 0)
{
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(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 removetbSupplier(HttpContext context)
{
try
{
using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
{
AMSCM.Models.tbSupplier tbSupplier = amscm.tbSupplier.Find(context.Request.Form["cnvcCode"]);
amscm.tbSupplier.Remove(tbSupplier);
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 removetbDept(HttpContext context)
{
try
{
//using (DXInfo.Models.AMSCM amscm = new DXInfo.Models.AMSCM())
//{
DXInfo.Models.tbDept tbDept = Uow.tbDept.GetById(g => g.cnvcDeptID == context.Request.Form["cnvcDeptID"]);
Uow.tbDept.Delete(tbDept);
Uow.Commit();
//}
}
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 removetbStockDetail(HttpContext context)
{
try
{
//using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
//{
DXInfo.Models.tbStockDetail tbStockDetail = Uow.tbStockDetail.GetById(g => g.cnnDetailId == Convert.ToInt64(context.Request.Form["cnnId"]));
Uow.tbStockDetail.Delete(tbStockDetail);
Uow.Commit(); //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 removeComputationGroup(HttpContext context)
{
try
{
//using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
//{
DXInfo.Models.tbComputationGroup computationGroup = Uow.tbComputationGroup.GetById(g => g.cnvcGroupCode == context.Request.Form["cnvcGroupCode"]);
Uow.tbComputationGroup.Delete(computationGroup);
Uow.Commit(); //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 updateComputationGroup(HttpContext context)
{
try
{
using (AMSCM.Models.AMSCM amscm = new AMSCM.Models.AMSCM())
{
AMSCM.Models.tbComputationGroup computationGroup = amscm.tbComputationGroup.Find(context.Request.Form["cnvcGroupCode"]);
computationGroup.cnvcGroupCode = context.Request.Form["cnvcGroupCode"];
computationGroup.cnvcGroupName = context.Request.Form["cnvcGroupName"];
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 GetOperName(HttpContext context)
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)context.Session["Login"];
return(ServiceHelper.JsonSerializer <JEasyUIResult>(new JEasyUIResult(true, ls1.strOperName)));
}