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