public FBEntity GetDeptBudgetSum(T_FB_DEPTBUDGETAPPLYMASTER entity)
{
FBEntity result = null;
DateTime budgetMonth = entity.BUDGETARYMONTH;
QueryExpression qe = QueryExpression.Equal(FieldName_BudgetMonth, budgetMonth.ToString("yyyy-MM-dd"));
QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString());
QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.OWNERCOMPANYID);
qe.RelatedExpression = qeStates;
qeStates.RelatedExpression = qeCompany;
T_FB_DEPTBUDGETSUMMASTER sumMaster = this.InnerGetEntities <T_FB_DEPTBUDGETSUMMASTER>(qe).FirstOrDefault();
if (sumMaster == null)
{
sumMaster = new T_FB_DEPTBUDGETSUMMASTER();
sumMaster.DEPTBUDGETSUMMASTERID = Guid.NewGuid().ToString();
sumMaster.DEPTBUDGETSUMMASTERCODE = "自动生成";
sumMaster.CREATEUSERID = SYSTEM_USER_ID;
sumMaster.CREATEUSERNAME = "******";
sumMaster.CREATEDATE = System.DateTime.Now;
sumMaster.UPDATEUSERID = SYSTEM_USER_ID;
sumMaster.UPDATEDATE = System.DateTime.Now;
sumMaster.BUDGETARYMONTH = budgetMonth;
sumMaster.CREATECOMPANYID = SYSTEM_USER_ID;
sumMaster.CREATECOMPANYNAME = "系统生成";
sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.CREATEDEPARTMENTNAME = "系统生成";
sumMaster.CREATEPOSTID = SYSTEM_USER_ID;
sumMaster.CREATEPOSTNAME = "系统生成";
sumMaster.OWNERCOMPANYID = entity.OWNERCOMPANYID;
sumMaster.OWNERCOMPANYNAME = entity.OWNERCOMPANYNAME;
sumMaster.OWNERDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.OWNERDEPARTMENTNAME = "系统生成";
sumMaster.OWNERPOSTID = SYSTEM_USER_ID;
sumMaster.OWNERPOSTNAME = "系统生成";
sumMaster.OWNERID = SYSTEM_USER_ID;
sumMaster.OWNERNAME = "系统生成";
sumMaster.SUMLEVEL = 0; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit;
sumMaster.EDITSTATES = (int)EditStates.Actived;
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Added;
}
else
{
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Modified;
}
return(result);
}
protected override void OnLoadDataComplete()
{
var details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_DEPTBUDGETSUMDETAIL).Name);
this.OrderEntity.FBEntity.OrderDetailBy <T_FB_DEPTBUDGETSUMDETAIL>(item =>
{
return(item.T_FB_DEPTBUDGETAPPLYMASTER.OWNERDEPARTMENTID);
});
List <T_FB_DEPTBUDGETAPPLYDETAIL> listDetail = new List <T_FB_DEPTBUDGETAPPLYDETAIL>();
details.ToList().ForEach(item =>
{
var cDetail = (item.Entity as T_FB_DEPTBUDGETSUMDETAIL).T_FB_DEPTBUDGETAPPLYDETAIL;
item.AddFBEntities <T_FB_DEPTBUDGETAPPLYDETAIL>(cDetail.ToFBEntityList());
item.OrderDetailBy <T_FB_DEPTBUDGETAPPLYDETAIL>(detail =>
{
return(detail.T_FB_SUBJECT.SUBJECTCODE);
});
listDetail.AddRange(cDetail);
});
var detailSum = from item in listDetail
group item by item.T_FB_SUBJECT into p
select new V_SubjectDepartmentSum
{
T_FB_SUBJECT = p.Key,
BUDGETMONEY = p.Sum(sumItem => sumItem.TOTALBUDGETMONEY.Value),
T_FB_DEPTBUDGETAPPLYDETAIL = listDetail.Where(de => de.T_FB_SUBJECT == p.Key).ToList()
};
var detailsTwo = this.OrderEntity.GetRelationFBEntities(typeof(V_SubjectDepartmentSum).Name);
foreach (var ds in detailSum)
{
FBEntity fbDetail = ds.ToFBEntity();
fbDetail.AddFBEntities <T_FB_DEPTBUDGETAPPLYDETAIL>(ds.T_FB_DEPTBUDGETAPPLYDETAIL.ToFBEntityList());
fbDetail.OrderDetailBy <T_FB_DEPTBUDGETAPPLYDETAIL>(item =>
{
return(item.T_FB_DEPTBUDGETAPPLYMASTER.OWNERDEPARTMENTID);
});
detailsTwo.Add(fbDetail);
}
this.OrderEntity.FBEntity.OrderDetailBy <V_SubjectDepartmentSum>(item =>
{
return(item.T_FB_SUBJECT.SUBJECTCODE);
});
T_FB_DEPTBUDGETSUMMASTER master = this.OrderEntity.Entity as T_FB_DEPTBUDGETSUMMASTER;
this.OrderMessage = "单据的截止提交时间为：" + master.BUDGETARYMONTH.AddDays(-1).ToLongDateString();
}
/// <summary>
/// 获取T_FB_DEPTBUDGETSUMMASTER信息
/// </summary>
/// <param name="strDeptBudgetSumMasterId">主键索引</param>
/// <returns></returns>
public T_FB_DEPTBUDGETSUMMASTER GetDeptBudgetSumMasterByID(string strDeptBudgetSumMasterId)
{
if (string.IsNullOrEmpty(strDeptBudgetSumMasterId))
{
return(null);
}
DeptBudgetSumMasterDAL dalDeptBudgetSumMaster = new DeptBudgetSumMasterDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strDeptBudgetSumMasterId))
{
strFilter.Append(" DEPTBUDGETSUMMASTERID == @0");
objArgs.Add(strDeptBudgetSumMasterId);
}
T_FB_DEPTBUDGETSUMMASTER entRd = dalDeptBudgetSumMaster.GetDeptBudgetSumMasterRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
public void AddToT_FB_DEPTBUDGETSUMMASTER(T_FB_DEPTBUDGETSUMMASTER t_FB_DEPTBUDGETSUMMASTER)
{
base.AddObject("T_FB_DEPTBUDGETSUMMASTER", t_FB_DEPTBUDGETSUMMASTER);
}
public static T_FB_DEPTBUDGETSUMMASTER CreateT_FB_DEPTBUDGETSUMMASTER(string dEPTBUDGETSUMMASTERID, global::System.DateTime bUDGETARYMONTH, decimal eDITSTATES, decimal cHECKSTATES, string oWNERID, string oWNERPOSTID, string oWNERDEPARTMENTID, string oWNERCOMPANYID, string cREATEUSERID, global::System.DateTime cREATEDATE, string cREATECOMPANYID, string cREATEDEPARTMENTID, string cREATEPOSTID, string uPDATEUSERID, global::System.DateTime uPDATEDATE)
{
T_FB_DEPTBUDGETSUMMASTER t_FB_DEPTBUDGETSUMMASTER = new T_FB_DEPTBUDGETSUMMASTER();
t_FB_DEPTBUDGETSUMMASTER.DEPTBUDGETSUMMASTERID = dEPTBUDGETSUMMASTERID;
t_FB_DEPTBUDGETSUMMASTER.BUDGETARYMONTH = bUDGETARYMONTH;
t_FB_DEPTBUDGETSUMMASTER.EDITSTATES = eDITSTATES;
t_FB_DEPTBUDGETSUMMASTER.CHECKSTATES = cHECKSTATES;
t_FB_DEPTBUDGETSUMMASTER.OWNERID = oWNERID;
t_FB_DEPTBUDGETSUMMASTER.OWNERPOSTID = oWNERPOSTID;
t_FB_DEPTBUDGETSUMMASTER.OWNERDEPARTMENTID = oWNERDEPARTMENTID;
t_FB_DEPTBUDGETSUMMASTER.OWNERCOMPANYID = oWNERCOMPANYID;
t_FB_DEPTBUDGETSUMMASTER.CREATEUSERID = cREATEUSERID;
t_FB_DEPTBUDGETSUMMASTER.CREATEDATE = cREATEDATE;
t_FB_DEPTBUDGETSUMMASTER.CREATECOMPANYID = cREATECOMPANYID;
t_FB_DEPTBUDGETSUMMASTER.CREATEDEPARTMENTID = cREATEDEPARTMENTID;
t_FB_DEPTBUDGETSUMMASTER.CREATEPOSTID = cREATEPOSTID;
t_FB_DEPTBUDGETSUMMASTER.UPDATEUSERID = uPDATEUSERID;
t_FB_DEPTBUDGETSUMMASTER.UPDATEDATE = uPDATEDATE;
return t_FB_DEPTBUDGETSUMMASTER;
}
public FBEntity GetDeptBudgetSumSet(T_FB_DEPTBUDGETSUMDETAIL entity, T_FB_SUMSETTINGSMASTER masterset)
{
FBEntity result = null;
DateTime budgetMonth = entity.T_FB_DEPTBUDGETAPPLYMASTER.BUDGETARYMONTH;
QueryExpression qe = QueryExpression.Equal(FieldName_BudgetMonth, budgetMonth.ToString("yyyy-MM-dd"));
QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString());
QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, masterset.OWNERCOMPANYID);
// QueryExpression qeSumsettings = QueryExpression.Equal("SUMSETTINGSMASTERID", masterset.SUMSETTINGSMASTERID).And("PARENTID", entity.T_FB_DEPTBUDGETSUMMASTER.PARENTID);
qe.RelatedExpression = qeStates;
qeStates.RelatedExpression = qeCompany;
// qeCompany.RelatedExpression = qeSumsettings;
T_FB_DEPTBUDGETSUMMASTER sumMaster = this.InnerGetEntities <T_FB_DEPTBUDGETSUMMASTER>(qe).FirstOrDefault();
if (sumMaster == null)
{
Tracer.Debug("未找到二次汇总单据，生成新的二次汇总单。");
sumMaster = new T_FB_DEPTBUDGETSUMMASTER();
sumMaster.DEPTBUDGETSUMMASTERID = Guid.NewGuid().ToString();
sumMaster.DEPTBUDGETSUMMASTERCODE = "自动生成";
sumMaster.CREATEUSERID = SYSTEM_USER_ID;
sumMaster.CREATEUSERNAME = "******";
sumMaster.CREATEDATE = System.DateTime.Now;
sumMaster.UPDATEUSERID = SYSTEM_USER_ID;
sumMaster.UPDATEDATE = System.DateTime.Now;
sumMaster.BUDGETARYMONTH = budgetMonth;
sumMaster.CREATECOMPANYID = SYSTEM_USER_ID;
sumMaster.CREATECOMPANYNAME = "系统生成";
sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.CREATEDEPARTMENTNAME = "系统生成";
sumMaster.CREATEPOSTID = SYSTEM_USER_ID;
sumMaster.CREATEPOSTNAME = "系统生成";
sumMaster.OWNERCOMPANYID = masterset.OWNERCOMPANYID;
sumMaster.OWNERCOMPANYNAME = masterset.OWNERCOMPANYNAME;
sumMaster.OWNERDEPARTMENTID = masterset.OWNERDEPARTMENTID;
sumMaster.OWNERDEPARTMENTNAME = masterset.OWNERDEPARTMENTNAME;
sumMaster.OWNERPOSTID = masterset.OWNERPOSTID;
sumMaster.OWNERPOSTNAME = masterset.OWNERPOSTNAME;
sumMaster.OWNERID = masterset.OWNERID;
sumMaster.OWNERNAME = masterset.OWNERNAME;
sumMaster.SUMSETTINGSMASTERID = masterset.SUMSETTINGSMASTERID;
sumMaster.SUMLEVEL = 1; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
sumMaster.REMARK = "系统自动生成的二次预算汇总单";
sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit;
sumMaster.EDITSTATES = (int)EditStates.Actived;
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Added;
}
else
{
Tracer.Debug("找到二次汇总单据，添加到二次汇总单中，二次汇总单号:" + sumMaster.DEPTBUDGETSUMMASTERCODE);
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Modified;
}
return(result);
}
//自定义汇总
public bool CreateDeptBudgetSumSetMaster(FBEntity fbMaster)
{
bool bRes = false;
T_FB_DEPTBUDGETSUMMASTER Master = fbMaster.Entity as T_FB_DEPTBUDGETSUMMASTER;
Tracer.Debug("预算汇总单终审开始创建二次预算汇总单据,公司名：" + Master.OWNERCOMPANYNAME + " 单号："
+ Master.DEPTBUDGETSUMMASTERCODE);
try
{
foreach (var entity in Master.T_FB_DEPTBUDGETSUMDETAIL)
{
T_FB_DEPTBUDGETSUMDETAIL detail = new T_FB_DEPTBUDGETSUMDETAIL();
detail.DEPTBUDGETSUMDETAILID = Guid.NewGuid().ToString();
detail.CREATEUSERID = SYSTEM_USER_ID;
detail.CREATEDATE = System.DateTime.Now;
detail.UPDATEUSERID = SYSTEM_USER_ID;
detail.UPDATEDATE = System.DateTime.Now;
detail.T_FB_DEPTBUDGETAPPLYMASTER = entity.T_FB_DEPTBUDGETAPPLYMASTER;
FBEntity fbDetail = detail.ToFBEntity();
fbDetail.FBEntityState = FBEntityState.Added;
List <FBEntity> fbSumMasterlist = new List <FBEntity>();
//查找汇总节点设置 有则新增汇总记录
FBEntity fbSumMaster = new FBEntity();
QueryExpression qeDetail = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.T_FB_DEPTBUDGETAPPLYMASTER.OWNERCOMPANYID);
qeDetail.QueryType = "T_FB_SUMSETTINGSDETAIL";
QueryExpression qeDetailEdits = QueryExpression.Equal(FieldName.EditStates, "1");
qeDetail.RelatedExpression = qeDetailEdits;
T_FB_SUMSETTINGSDETAIL detailset = GetEntities <T_FB_SUMSETTINGSDETAIL>(qeDetail).FirstOrDefault();
T_FB_SUMSETTINGSMASTER masterset = null;
if (detailset != null)
{
QueryExpression qeMaster = QueryExpression.Equal("SUMSETTINGSMASTERID", detailset.T_FB_SUMSETTINGSMASTERReference.EntityKey.EntityKeyValues[0].Value.ToString());
qeMaster.QueryType = "T_FB_SUMSETTINGSMASTER";
QueryExpression qeMasterEdits = QueryExpression.Equal(FieldName.EditStates, "1");
qeMaster.RelatedExpression = qeMasterEdits;
masterset = GetEntities <T_FB_SUMSETTINGSMASTER>(qeMaster).FirstOrDefault();
if (masterset != null)
{
fbSumMaster = GetDeptBudgetSumSet(entity, masterset);
detail.T_FB_DEPTBUDGETSUMMASTER = fbSumMaster.Entity as T_FB_DEPTBUDGETSUMMASTER;
fbSumMaster.AddFBEntities <T_FB_DEPTBUDGETSUMDETAIL>(new List <FBEntity> {
fbDetail
});
fbSumMasterlist.Add(fbSumMaster);
//修改旧汇总单，原因不详
Master.PARENTID = detail.T_FB_DEPTBUDGETSUMMASTER.DEPTBUDGETSUMMASTERID;
Master.SUMSETTINGSMASTERID = masterset.SUMSETTINGSMASTERID;
Master.UPDATEDATE = DateTime.Now;
//Master.SUMLEVEL = 1; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
fbMaster.Entity = Master;
fbMaster.FBEntityState = FBEntityState.Modified;
fbSumMasterlist.Add(fbMaster);
this.FBEntityBLLSaveListNoTrans(fbSumMasterlist);
// this.InnerSave(fbSumMaster);
}
}
}
}
catch (Exception ex)
{
Tracer.Debug("创建二次汇总单异常：" + ex.ToString());
}
bRes = true;
return(bRes);
}
public FBEntity GetDeptBudgetSumSet(T_FB_DEPTBUDGETSUMDETAIL entity, T_FB_SUMSETTINGSMASTER masterset)
{
FBEntity result = null;
DateTime budgetMonth = entity.T_FB_DEPTBUDGETAPPLYMASTER.BUDGETARYMONTH;
QueryExpression qe = QueryExpression.Equal(FieldName_BudgetMonth, budgetMonth.ToString("yyyy-MM-dd"));
QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString());
QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, masterset.OWNERCOMPANYID);
// QueryExpression qeSumsettings = QueryExpression.Equal("SUMSETTINGSMASTERID", masterset.SUMSETTINGSMASTERID).And("PARENTID", entity.T_FB_DEPTBUDGETSUMMASTER.PARENTID);
qe.RelatedExpression = qeStates;
qeStates.RelatedExpression = qeCompany;
// qeCompany.RelatedExpression = qeSumsettings;
T_FB_DEPTBUDGETSUMMASTER sumMaster = this.InnerGetEntities<T_FB_DEPTBUDGETSUMMASTER>(qe).FirstOrDefault();
if (sumMaster == null)
{
Tracer.Debug("未找到二次汇总单据，生成新的二次汇总单。");
sumMaster = new T_FB_DEPTBUDGETSUMMASTER();
sumMaster.DEPTBUDGETSUMMASTERID = Guid.NewGuid().ToString();
sumMaster.DEPTBUDGETSUMMASTERCODE = "自动生成";
sumMaster.CREATEUSERID = SYSTEM_USER_ID;
sumMaster.CREATEUSERNAME = "******";
sumMaster.CREATEDATE = System.DateTime.Now;
sumMaster.UPDATEUSERID = SYSTEM_USER_ID;
sumMaster.UPDATEDATE = System.DateTime.Now;
sumMaster.BUDGETARYMONTH = budgetMonth;
sumMaster.CREATECOMPANYID = SYSTEM_USER_ID;
sumMaster.CREATECOMPANYNAME = "系统生成";
sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.CREATEDEPARTMENTNAME = "系统生成";
sumMaster.CREATEPOSTID = SYSTEM_USER_ID;
sumMaster.CREATEPOSTNAME = "系统生成";
sumMaster.OWNERCOMPANYID = masterset.OWNERCOMPANYID;
sumMaster.OWNERCOMPANYNAME = masterset.OWNERCOMPANYNAME;
sumMaster.OWNERDEPARTMENTID = masterset.OWNERDEPARTMENTID;
sumMaster.OWNERDEPARTMENTNAME = masterset.OWNERDEPARTMENTNAME;
sumMaster.OWNERPOSTID = masterset.OWNERPOSTID;
sumMaster.OWNERPOSTNAME = masterset.OWNERPOSTNAME;
sumMaster.OWNERID = masterset.OWNERID;
sumMaster.OWNERNAME = masterset.OWNERNAME;
sumMaster.SUMSETTINGSMASTERID = masterset.SUMSETTINGSMASTERID;
sumMaster.SUMLEVEL = 1; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
sumMaster.REMARK = "系统自动生成的二次预算汇总单";
sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit;
sumMaster.EDITSTATES = (int)EditStates.Actived;
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Added;
}
else
{
Tracer.Debug("找到二次汇总单据，添加到二次汇总单中，二次汇总单号:"+sumMaster.DEPTBUDGETSUMMASTERCODE);
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Modified;
}
return result;
}
public FBEntity GetDeptBudgetSum(T_FB_DEPTBUDGETAPPLYMASTER entity)
{
FBEntity result = null;
DateTime budgetMonth = entity.BUDGETARYMONTH;
QueryExpression qe = QueryExpression.Equal(FieldName_BudgetMonth, budgetMonth.ToString("yyyy-MM-dd"));
QueryExpression qeStates = QueryExpression.Equal(FieldName.CheckStates, ((int)CheckStates.UnSubmit).ToString());
QueryExpression qeCompany = QueryExpression.Equal(FieldName.OwnerCompanyID, entity.OWNERCOMPANYID);
qe.RelatedExpression = qeStates;
qeStates.RelatedExpression = qeCompany;
T_FB_DEPTBUDGETSUMMASTER sumMaster = this.InnerGetEntities<T_FB_DEPTBUDGETSUMMASTER>(qe).FirstOrDefault();
if (sumMaster == null)
{
sumMaster = new T_FB_DEPTBUDGETSUMMASTER();
sumMaster.DEPTBUDGETSUMMASTERID = Guid.NewGuid().ToString();
sumMaster.DEPTBUDGETSUMMASTERCODE = "自动生成";
sumMaster.CREATEUSERID = SYSTEM_USER_ID;
sumMaster.CREATEUSERNAME = "******";
sumMaster.CREATEDATE = System.DateTime.Now;
sumMaster.UPDATEUSERID = SYSTEM_USER_ID;
sumMaster.UPDATEDATE = System.DateTime.Now;
sumMaster.BUDGETARYMONTH = budgetMonth;
sumMaster.CREATECOMPANYID = SYSTEM_USER_ID;
sumMaster.CREATECOMPANYNAME = "系统生成";
sumMaster.CREATEDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.CREATEDEPARTMENTNAME = "系统生成";
sumMaster.CREATEPOSTID = SYSTEM_USER_ID;
sumMaster.CREATEPOSTNAME = "系统生成";
sumMaster.OWNERCOMPANYID = entity.OWNERCOMPANYID;
sumMaster.OWNERCOMPANYNAME = entity.OWNERCOMPANYNAME;
sumMaster.OWNERDEPARTMENTID = SYSTEM_USER_ID;
sumMaster.OWNERDEPARTMENTNAME = "系统生成";
sumMaster.OWNERPOSTID = SYSTEM_USER_ID;
sumMaster.OWNERPOSTNAME = "系统生成";
sumMaster.OWNERID = SYSTEM_USER_ID;
sumMaster.OWNERNAME = "系统生成";
sumMaster.SUMLEVEL = 0; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
sumMaster.CHECKSTATES = (int)CheckStates.UnSubmit;
sumMaster.EDITSTATES = (int)EditStates.Actived;
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Added;
}
else
{
result = sumMaster.ToFBEntity();
result.FBEntityState = FBEntityState.Modified;
}
return result;
}
