void dGrid_ToolBarItemClick(object sender, ToolBarItemClickEventArgs e)
{
if (e.Action != Actions.Add)
{
return;
}
e.Action = Actions.Cancel;
string perm = "3";
string entity = typeof(T_FB_PERSONMONEYASSIGNMASTER).Name;
if (this.EditForm.OperationType == OperationTypes.Edit)
{
perm = ((int)Permissions.Edit).ToString();
}
else if (this.EditForm.OperationType == OperationTypes.Add)
{
perm = ((int)Permissions.Add).ToString();
}
else
{
perm = ((int)Permissions.Browse).ToString();
}
string userID = DataCore.CurrentUser.Value.ToString();
OrganizationLookup ogzLookup = new OrganizationLookup(userID, perm, entity);
ogzLookup.SelectedObjType = OrgTreeItemTypes.Company;
FrameworkElement plRoot = CommonFunction.ParentLayoutRoot;
ogzLookup.SelectedClick += (o, ea) =>
{
if (ogzLookup.SelectedObj.Count > 0)
{
var assignDetail = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_SUMSETTINGSDETAIL).Name);
var selectedObjects = ogzLookup.SelectedObj;
selectedObjects.ForEach(obj =>
{
ITextValueItem cdata = DataCore.FindReferencedData <CompanyData>(obj.ObjectID);
T_FB_SUMSETTINGSDETAIL detail = new T_FB_SUMSETTINGSDETAIL();
detail.SUMSETTINGSDETAILID = Guid.NewGuid().ToString();
detail.T_FB_SUMSETTINGSMASTER = this.OrderEntity.Entity as T_FB_SUMSETTINGSMASTER;
detail.EDITSTATES = 1;
detail.OWNERCOMPANYID = cdata.Value.ToString();
detail.OWNERCOMPANYNAME = cdata.Text;
detail.CREATEDATE = DateTime.Now;
detail.CREATEUSERID = DataCore.CurrentUser.ID.ToString();
detail.CREATEUSERNAME = DataCore.CurrentUser.Text.ToString();
FBEntity fbEntity = detail.ToFBEntity();
fbEntity.FBEntityState = FBEntityState.Added;
assignDetail.Add(fbEntity);
});
}
};
ogzLookup.Show <string>(DialogMode.ApplicationModal, plRoot, "", (result) => { });
}
//自定义汇总
public bool CreateCompanyBudgetSumSetMaster(FBEntity fbMaster)
{
bool bRes = false;
T_FB_COMPANYBUDGETSUMMASTER Master = fbMaster.Entity as T_FB_COMPANYBUDGETSUMMASTER;
foreach (var entity in Master.T_FB_COMPANYBUDGETSUMDETAIL)
{
T_FB_COMPANYBUDGETSUMDETAIL detail = new T_FB_COMPANYBUDGETSUMDETAIL();
detail.COMPANYBUDGETSUMDETAILID = 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_COMPANYBUDGETAPPLYMASTER = entity.T_FB_COMPANYBUDGETAPPLYMASTER;
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_COMPANYBUDGETAPPLYMASTER.OWNERCOMPANYID).And(FieldName.EditStates, "1");
qeDetail.QueryType = "T_FB_SUMSETTINGSDETAIL";
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()).And(FieldName.EditStates, "1");
qeMaster.QueryType = "T_FB_SUMSETTINGSMASTER";
masterset = GetEntities <T_FB_SUMSETTINGSMASTER>(qeMaster).FirstOrDefault();
if (masterset != null)
{
fbSumMaster = GetCompanyBudgetSumSet(entity, masterset);
detail.T_FB_COMPANYBUDGETSUMMASTER = fbSumMaster.Entity as T_FB_COMPANYBUDGETSUMMASTER;
fbSumMaster.AddFBEntities <T_FB_COMPANYBUDGETSUMDETAIL>(new List <FBEntity> {
fbDetail
});
fbSumMasterlist.Add(fbSumMaster);
Master.PARENTID = detail.T_FB_COMPANYBUDGETSUMMASTER.COMPANYBUDGETSUMMASTERID;
Master.SUMSETTINGSMASTERID = masterset.SUMSETTINGSMASTERID;
Master.SUMLEVEL = 1; //0：代表当前汇总单不走自定义汇总流程；1：代表当前汇总单走自定义汇总流程
fbMaster.Entity = Master;
fbMaster.FBEntityState = FBEntityState.Modified;
fbSumMasterlist.Add(fbMaster);
this.FBEntityBLLSaveListNoTrans(fbSumMasterlist);
// this.InnerSave(fbSumMaster);
}
}
}
bRes = true;
return(bRes);
}
public bool SaveListT_FB_SUMSETTINGSMASTER(List <FBEntity> fbEntityList)
{
fbEntityList.ForEach(item =>
{
T_FB_SUMSETTINGSMASTER Master = item.Entity as T_FB_SUMSETTINGSMASTER;
if (Master.EDITSTATES == 0)
{
QueryExpression qeID = QueryExpression.Equal("T_FB_SUMSETTINGSMASTER.SUMSETTINGSMASTERID", Master.SUMSETTINGSMASTERID);
qeID.QueryType = "T_FB_SUMSETTINGSDETAIL";
var result = FBEntityBllGetFBEntities(qeID);
if (result != null)
{
List <FBEntity> fbEntity = result;
fbEntity.ForEach(p =>
{
//QueryExpression qeCompany = QueryExpression.Equal("SUMSETTINGSMASTERID", Master.SUMSETTINGSMASTERID);
//qeCompany.QueryType = "T_FB_COMPANYBUDGETSUMMASTER";
//var v = GetFBEntity(qeCompany);
//QueryExpression qeDept = QueryExpression.Equal("SUMSETTINGSMASTERID", Master.SUMSETTINGSMASTERID);
//qeDept.QueryType = "T_FB_DEPTBUDGETSUMMASTER";
//var q = GetFBEntity(qeCompany);
//if (v != null||q!=null)
//{
// throw new FBBLLException("以下公司已经有汇总使用，不能删除！");
//}
p.FBEntityState = FBEntityState.Modified;
T_FB_SUMSETTINGSDETAIL detail = p.Entity as T_FB_SUMSETTINGSDETAIL;
detail.EDITSTATES = 0;
FBEntityBLLSaveList(fbEntity);
});
}
}
});
return(FBEntityBLLSaveList(fbEntityList));
}
void dGrid_ToolBarItemClick(object sender, ToolBarItemClickEventArgs e)
{
if (e.Action != Actions.Add)
{
return;
}
e.Action = Actions.Cancel;
string perm = "3";
string entity = typeof(T_FB_PERSONMONEYASSIGNMASTER).Name;
if (this.EditForm.OperationType == OperationTypes.Edit)
{
perm = ((int)Permissions.Edit).ToString();
}
else if (this.EditForm.OperationType == OperationTypes.Add)
{
perm = ((int)Permissions.Add).ToString();
}
else
{
perm = ((int)Permissions.Browse).ToString();
}
string userID = DataCore.CurrentUser.Value.ToString();
OrganizationLookup ogzLookup = new OrganizationLookup(userID, perm, entity);
ogzLookup.SelectedObjType = OrgTreeItemTypes.Company;
FrameworkElement plRoot = CommonFunction.ParentLayoutRoot;
ogzLookup.SelectedClick += (o, ea) =>
{
if (ogzLookup.SelectedObj.Count > 0)
{
var assignDetail = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_SUMSETTINGSDETAIL).Name);
var selectedObjects = ogzLookup.SelectedObj;
selectedObjects.ForEach(obj =>
{
ITextValueItem cdata = DataCore.FindReferencedData<CompanyData>(obj.ObjectID);
T_FB_SUMSETTINGSDETAIL detail = new T_FB_SUMSETTINGSDETAIL();
detail.SUMSETTINGSDETAILID = Guid.NewGuid().ToString();
detail.T_FB_SUMSETTINGSMASTER = this.OrderEntity.Entity as T_FB_SUMSETTINGSMASTER;
detail.EDITSTATES =1;
detail.OWNERCOMPANYID = cdata.Value.ToString();
detail.OWNERCOMPANYNAME = cdata.Text;
detail.CREATEDATE = DateTime.Now;
detail.CREATEUSERID = DataCore.CurrentUser.ID.ToString();
detail.CREATEUSERNAME = DataCore.CurrentUser.Text.ToString();
FBEntity fbEntity = detail.ToFBEntity();
fbEntity.FBEntityState = FBEntityState.Added;
assignDetail.Add(fbEntity);
});
}
};
ogzLookup.Show<string>(DialogMode.ApplicationModal, plRoot, "", (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 static T_FB_SUMSETTINGSDETAIL CreateT_FB_SUMSETTINGSDETAIL(string sUMSETTINGSDETAILID, decimal eDITSTATES, string cREATEUSERID, global::System.DateTime cREATEDATE)
{
T_FB_SUMSETTINGSDETAIL t_FB_SUMSETTINGSDETAIL = new T_FB_SUMSETTINGSDETAIL();
t_FB_SUMSETTINGSDETAIL.SUMSETTINGSDETAILID = sUMSETTINGSDETAILID;
t_FB_SUMSETTINGSDETAIL.EDITSTATES = eDITSTATES;
t_FB_SUMSETTINGSDETAIL.CREATEUSERID = cREATEUSERID;
t_FB_SUMSETTINGSDETAIL.CREATEDATE = cREATEDATE;
return t_FB_SUMSETTINGSDETAIL;
}
public void AddToT_FB_SUMSETTINGSDETAIL(T_FB_SUMSETTINGSDETAIL t_FB_SUMSETTINGSDETAIL)
{
base.AddObject("T_FB_SUMSETTINGSDETAIL", t_FB_SUMSETTINGSDETAIL);
}
