private void GetABCD( List<T_FB_COMPANYBUDGETAPPLYMASTER> T_FB_COMPANYBUDGETAPPLYMASTERList, List<T_FB_COMPANYBUDGETAPPLYDETAIL> T_FB_COMPANYBUDGETAPPLYDETAILList, List<T_FB_COMPANYBUDGETMODMASTER> T_FB_COMPANYBUDGETMODMASTERList , List<T_FB_COMPANYBUDGETMODDETAIL> T_FB_COMPANYBUDGETMODDETAILList, List<T_FB_DEPTBUDGETAPPLYMASTER> T_FB_DEPTBUDGETAPPLYMASTERList, List<T_FB_DEPTBUDGETAPPLYDETAIL> T_FB_DEPTBUDGETAPPLYDETAILList , List<T_FB_DEPTBUDGETADDMASTER> T_FB_DEPTBUDGETADDMASTERList, List<T_FB_DEPTBUDGETADDDETAIL> T_FB_DEPTBUDGETADDDETAILList, List<T_FB_CHARGEAPPLYMASTER> T_FB_CHARGEAPPLYMASTERList, List<T_FB_CHARGEAPPLYDETAIL> T_FB_CHARGEAPPLYDETAILList, List<T_FB_PERSONBUDGETAPPLYDETAIL> T_FB_PERSONBUDGETAPPLYDETAILList, List<T_FB_PERSONBUDGETADDDETAIL> T_FB_PERSONBUDGETADDDETAILList, T_FB_BUDGETACCOUNT item, ref decimal A,ref decimal B, ref decimal C, ref decimal C1, ref decimal D1, ref decimal C2, ref decimal D2, ref decimal D, ref decimal E, ref decimal F, ref decimal H, ref decimal G) { #region//年度预算A var YearMoney = from a in T_FB_COMPANYBUDGETAPPLYMASTERList join b in T_FB_COMPANYBUDGETAPPLYDETAILList on a.COMPANYBUDGETAPPLYMASTERID equals b.T_FB_COMPANYBUDGETAPPLYMASTER.COMPANYBUDGETAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETYEAR == item.BUDGETYEAR && a.CHECKSTATES==2 select b.BUDGETMONEY; if (YearMoney.Count() > 0) { foreach (var va in YearMoney) { A = A + va; } } #endregion #region//年度增补B var YearAddMoney = from a in T_FB_COMPANYBUDGETMODMASTERList join b in T_FB_COMPANYBUDGETMODDETAILList on a.COMPANYBUDGETMODMASTERID equals b.T_FB_COMPANYBUDGETMODMASTER.COMPANYBUDGETMODMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETYEAR == item.BUDGETYEAR && a.CHECKSTATES == 2 select b.BUDGETMONEY; if (YearAddMoney.Count() > 0) { foreach (var va in YearAddMoney) { B = B + va; } } #endregion #region//月度预算部门C var MonthMoeny = from a in T_FB_DEPTBUDGETAPPLYMASTERList join b in T_FB_DEPTBUDGETAPPLYDETAILList on a.DEPTBUDGETAPPLYMASTERID equals b.T_FB_DEPTBUDGETAPPLYMASTER.DEPTBUDGETAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select b.TOTALBUDGETMONEY; if (MonthMoeny.Count() > 0) { foreach (var va in MonthMoeny) { C = C + va.Value; } } #endregion #region//月度预算增补部门D var MonthAddMoeny = from a in T_FB_DEPTBUDGETADDMASTERList join b in T_FB_DEPTBUDGETADDDETAILList on a.DEPTBUDGETADDMASTERID equals b.T_FB_DEPTBUDGETADDMASTER.DEPTBUDGETADDMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select b.TOTALBUDGETMONEY; if (MonthAddMoeny.Count() > 0) { foreach (var va in MonthAddMoeny) { D = D + va.Value; } } #endregion #region//月度预算-部门公共C1 var DepartmentCommonMonthMoeny = from a in T_FB_DEPTBUDGETAPPLYMASTERList join b in T_FB_DEPTBUDGETAPPLYDETAILList on a.DEPTBUDGETAPPLYMASTERID equals b.T_FB_DEPTBUDGETAPPLYMASTER.DEPTBUDGETAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select b.BUDGETMONEY; if (DepartmentCommonMonthMoeny.Count() > 0) { foreach (var va in DepartmentCommonMonthMoeny) { C1 = C1 + va; } } #endregion #region//月度预算增补-部门公共D1 var DepartmentMonthAddMoeny = from a in T_FB_DEPTBUDGETADDMASTERList join b in T_FB_DEPTBUDGETADDDETAILList on a.DEPTBUDGETADDMASTERID equals b.T_FB_DEPTBUDGETADDMASTER.DEPTBUDGETADDMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select b.BUDGETMONEY; if (DepartmentMonthAddMoeny.Count() > 0) { foreach (var va in DepartmentMonthAddMoeny) { D1 = D1 + va; } } #endregion #region//月度预算-个人C2 var PersonCommonMonthMoeny = from a in T_FB_DEPTBUDGETAPPLYMASTERList join b in T_FB_DEPTBUDGETAPPLYDETAILList on a.DEPTBUDGETAPPLYMASTERID equals b.T_FB_DEPTBUDGETAPPLYMASTER.DEPTBUDGETAPPLYMASTERID join c in T_FB_PERSONBUDGETAPPLYDETAILList on b.DEPTBUDGETAPPLYDETAILID equals c.T_FB_DEPTBUDGETAPPLYDETAIL.DEPTBUDGETAPPLYDETAILID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && c.OWNERPOSTID == item.OWNERPOSTID && c.OWNERID == item.OWNERID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select c.BUDGETMONEY; if (PersonCommonMonthMoeny.Count() > 0) { foreach (var va in PersonCommonMonthMoeny) { C2 = C2 + va.Value; } } #endregion #region//月度预算增补-个人D2 var PersonMonthAddMoeny = from a in T_FB_DEPTBUDGETADDMASTERList join b in T_FB_DEPTBUDGETADDDETAILList on a.DEPTBUDGETADDMASTERID equals b.T_FB_DEPTBUDGETADDMASTER.DEPTBUDGETADDMASTERID join c in T_FB_PERSONBUDGETADDDETAILList on b.DEPTBUDGETADDDETAILID equals c.T_FB_DEPTBUDGETADDDETAIL.DEPTBUDGETADDDETAILID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && c.OWNERPOSTID == item.OWNERPOSTID && c.OWNERID == item.OWNERID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 select c.BUDGETMONEY; if (PersonMonthAddMoeny.Count() > 0) { foreach (var va in PersonMonthAddMoeny) { D2 = D2 + va.Value; } } #endregion #region//个人费用部门科目报销已终审E if(T_FB_CHARGEAPPLYDETAILList!=null) { var ChargeMoenyChecked = from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 && b.CHARGETYPE==2//部门 select b.CHARGEMONEY; if (ChargeMoenyChecked.Count() > 0) { foreach (var va in ChargeMoenyChecked) { E = E + va; } } } #endregion #region//个人费用部门科目报销终审中F if (T_FB_CHARGEAPPLYDETAILList != null) { var ChargeingMoeny = from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERDEPARTMENTID == item.OWNERDEPARTMENTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 1 && b.CHARGETYPE == 2//部门 select b.CHARGEMONEY; if (ChargeingMoeny.Count() > 0) { foreach (var va in ChargeingMoeny) { F = F + va; } } } #endregion #region//个人费用个人科目报销已终审G if (T_FB_CHARGEAPPLYDETAILList != null) { var ChargeMoenyPersonChecked = from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERPOSTID == item.OWNERPOSTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 2 && b.CHARGETYPE == 1//个人 select b.CHARGEMONEY; if (ChargeMoenyPersonChecked.Count() > 0) { foreach (var va in ChargeMoenyPersonChecked) { G = G + va; } } } #endregion #region//个人费用个人科目报销终审中H if (T_FB_CHARGEAPPLYDETAILList != null) { var ChargeingPersonMoeny = from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where a.OWNERCOMPANYID == item.OWNERCOMPANYID && b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERPOSTID == item.OWNERPOSTID && a.BUDGETARYMONTH.Year == item.BUDGETYEAR && a.CHECKSTATES == 1 && b.CHARGETYPE == 1//个人 select b.CHARGEMONEY; if (ChargeingPersonMoeny.Count() > 0) { foreach (var va in ChargeingPersonMoeny) { H = H + va; } } } #endregion }
/// <summary> /// 用于向 T_FB_BUDGETACCOUNT EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToT_FB_BUDGETACCOUNT(T_FB_BUDGETACCOUNT t_FB_BUDGETACCOUNT) { base.AddObject("T_FB_BUDGETACCOUNT", t_FB_BUDGETACCOUNT); }
private void GetJFABCD( List<T_FB_PERSONMONEYASSIGNMASTER> T_FB_PERSONMONEYASSIGNMASTERList, List<T_FB_PERSONMONEYASSIGNDETAIL> T_FB_PERSONMONEYASSIGNDETAILList, List<T_FB_CHARGEAPPLYMASTER> T_FB_CHARGEAPPLYMASTERList, List<T_FB_CHARGEAPPLYDETAIL> T_FB_CHARGEAPPLYDETAILList, T_FB_BUDGETACCOUNT item, ref decimal A, ref decimal B, ref decimal C, ref decimal C1, ref decimal D1, ref decimal C2, ref decimal D2, ref decimal D, ref decimal E, ref decimal F, ref decimal H, ref decimal G, ref string OwnerName) { #region "活动经费" if (item.T_FB_SUBJECT.SUBJECTID == "d5134466-c207-44f2-8a36-cf7b96d5851f") { var YearMoney = (from a in T_FB_PERSONMONEYASSIGNMASTERList join b in T_FB_PERSONMONEYASSIGNDETAILList on a.PERSONMONEYASSIGNMASTERID equals b.T_FB_PERSONMONEYASSIGNMASTER.PERSONMONEYASSIGNMASTERID where b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && b.OWNERID == item.OWNERID && a.CHECKSTATES == 2 select new { b.PERSONBUDGETAPPLYDETAILID, b.BUDGETMONEY, OwnerName=b.OWNERCOMPANYNAME+"-"+b.OWNERNAME }).ToList().Distinct(); if (YearMoney.Count() > 0) { foreach (var va in YearMoney) { OwnerName = va.OwnerName; if (OwnerName.Contains("田少林")) { } C2 = C2 + va.BUDGETMONEY.Value; } } } #endregion #region//个人费用部门科目报销已终审E if (T_FB_CHARGEAPPLYDETAILList != null) { var ChargeMoenyChecked = (from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERID == item.OWNERID && a.CHECKSTATES == 2 select new { b.CHARGEAPPLYDETAILID, b.CHARGEMONEY }).ToList().Distinct(); if (ChargeMoenyChecked.Count() > 0) { foreach (var va in ChargeMoenyChecked) { E = E + va.CHARGEMONEY; } } } #endregion #region//个人费用部门科目报销终审中F if (T_FB_CHARGEAPPLYDETAILList != null) { var ChargeingMoeny = (from a in T_FB_CHARGEAPPLYMASTERList join b in T_FB_CHARGEAPPLYDETAILList on a.CHARGEAPPLYMASTERID equals b.T_FB_CHARGEAPPLYMASTER.CHARGEAPPLYMASTERID where b.T_FB_SUBJECT.SUBJECTID == item.T_FB_SUBJECT.SUBJECTID && a.OWNERID == item.OWNERID && a.CHECKSTATES == 1 select new { b.CHARGEAPPLYDETAILID, b.CHARGEMONEY }).ToList().Distinct(); if (ChargeingMoeny.Count() > 0) { foreach (var va in ChargeingMoeny) { F = F + va.CHARGEMONEY; } } } #endregion }
/// <summary> /// 创建新的 T_FB_BUDGETACCOUNT 对象。 /// </summary> /// <param name="bUDGETACCOUNTID">BUDGETACCOUNTID 属性的初始值。</param> /// <param name="oWNERCOMPANYID">OWNERCOMPANYID 属性的初始值。</param> public static T_FB_BUDGETACCOUNT CreateT_FB_BUDGETACCOUNT(global::System.String bUDGETACCOUNTID, global::System.String oWNERCOMPANYID) { T_FB_BUDGETACCOUNT t_FB_BUDGETACCOUNT = new T_FB_BUDGETACCOUNT(); t_FB_BUDGETACCOUNT.BUDGETACCOUNTID = bUDGETACCOUNTID; t_FB_BUDGETACCOUNT.OWNERCOMPANYID = oWNERCOMPANYID; return t_FB_BUDGETACCOUNT; }