public int DeleteByTrans2(CauseObject_V_MCE_ASSETS_DEPR_MTN cause, IDbTransaction transaction) { if (LocalMode) { return(HelperObject_V_MCE_ASSETS_DEPR_MTN.Delete(cause, transaction)); //平台自动生成代码 } else { throw new InvalidConstraintException(); } }
public DisplayObject_V_MCE_ASSETS_DEPR_MTN[] Query(CauseObject_V_MCE_ASSETS_DEPR_MTN cause, PagingParamter paging, OrderByParameter order) { if (LocalMode) { SystemLogic.Proxy.AuditQuery(cause); //平台自动生成代码 return(HelperObject_V_MCE_ASSETS_DEPR_MTN.Query(cause, paging, order)); } else { using (ServiceManager <ServiceContract_V_MCE_ASSETS_DEPR_MTN> smgr = new ServiceManager <ServiceContract_V_MCE_ASSETS_DEPR_MTN>(ServiceUri)) { return(smgr.Service.Query(cause, paging, order)); } } }
public BizLogicMsg Delete(CauseObject_V_MCE_ASSETS_DEPR_MTN cause) { if (LocalMode) { BizLogicMsg msg = new BizLogicMsg(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { int amount = HelperObject_V_MCE_ASSETS_DEPR_MTN.Delete(cause, transaction); //平台自动生成代码 transaction.Commit(); } catch (Exception expt) { transaction.Rollback(); msg = new BizLogicMsg(false, expt.Message); Error(expt); } finally { IDALProvider.IDAL.PushConnection(connection); } } } return(msg); } else { using (ServiceManager <ServiceContract_V_MCE_ASSETS_DEPR_MTN> smgr = new ServiceManager <ServiceContract_V_MCE_ASSETS_DEPR_MTN>(ServiceUri)) { return(smgr.Service.Delete(cause)); } } }
public void ProcessRequest(HttpContext context) { //允许跨域 context.Response.AddHeader("Access-Control-Allow-Origin", "*"); JSON_MSG jsonMsg = new JSON_MSG(); try { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; OrderByParameter orderBy = new OrderByParameter(); orderBy.Asc = true; orderBy.OrderBy = "FINANCE_CYCLE"; PagingParamter pager = new PagingParamter(); pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString()); pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1; if (string.IsNullOrEmpty(request["id"])) { throw new Exception("参数错误."); } CauseObject_V_MCE_ASSETS_DEPR_MTN p = new CauseObject_V_MCE_ASSETS_DEPR_MTN(); p.ASSERTS_ID = request["id"]; List <DisplayObject_V_MCE_ASSETS_DEPR_MTN> list = new List <DisplayObject_V_MCE_ASSETS_DEPR_MTN>(); DisplayObject_V_MCE_ASSETS_DEPR_MTN[] list0 = BizLogicObject_V_MCE_ASSETS_DEPR_MTN.Proxy.Query(p, pager, orderBy); if (list0 != null && list0.Length > 0) { list = list0.ToList(); } object objMoney = list.Sum(l => l.MAINTAIN_MONEY); DisplayObject_V_MCE_ASSETS_DEPR_MTN pageItem = new DisplayObject_V_MCE_ASSETS_DEPR_MTN(); pageItem.FINANCE_CYCLE = "小计"; if (!string.IsNullOrEmpty(objMoney.ToString())) { pageItem.MAINTAIN_MONEY = decimal.Parse(objMoney.ToString()); } list.Add(pageItem); DisplayObject_V_MCE_ASSETS_DEPR_MTN[] list1 = BizLogicObject_V_MCE_ASSETS_DEPR_MTN.Proxy.Query(p); object objTotMoney = list1.Sum(l => l.MAINTAIN_MONEY); DisplayObject_V_MCE_ASSETS_DEPR_MTN totalItem = new DisplayObject_V_MCE_ASSETS_DEPR_MTN(); totalItem.FINANCE_CYCLE = "总计"; if (!string.IsNullOrEmpty(objTotMoney.ToString())) { totalItem.MAINTAIN_MONEY = decimal.Parse(objTotMoney.ToString()); } list.Add(totalItem); JSON_PAGER jsonPager = new JSON_PAGER(); jsonPager.total = pager.TotalRecords; jsonPager.rows = list; jsonMsg.Message = jsonPager; jsonMsg.Succeed = 1; } catch (Exception ex) { jsonMsg.Succeed = 0; jsonMsg.Message = ex.Message; } finally { IsoDateTimeConverter timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm" }; string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter); strMsg = strMsg.Replace("0001-01-01 00:00", ""); context.Response.Write(strMsg); context.Response.End(); } }