void dGrid_ToolBarItemClick(object sender, ToolBarItemClickEventArgs e)
{
if (e.Action != Actions.Add)
{
return;
}
e.Action = Actions.Cancel;
FBEntityService service = new FBEntityService();
QueryExpression qeOwner = this.OrderEntity.GetQueryExpression(FieldName.OwnerID);
QueryExpression qeDept = this.OrderEntity.GetQueryExpression(FieldName.OwnerDepartmentID);
QueryExpression qePost = this.OrderEntity.GetQueryExpression(FieldName.OwnerPostID);
qeDept.RelatedExpression = qeOwner;
qeOwner.RelatedExpression = qePost;
qeDept.QueryType = typeof(T_FB_TRAVELEXPAPPLYDETAIL).Name;
service.QueryFBEntitiesCompleted += (o, ea) =>
{
ObservableCollection <FBEntity> listDetail = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_TRAVELEXPAPPLYDETAIL).Name);
ObservableCollection <FBEntity> listDetailItem = ea.Result;
listDetailItem.ToList().ForEach(item =>
{
T_FB_TRAVELEXPAPPLYDETAIL t = item.Entity as T_FB_TRAVELEXPAPPLYDETAIL;
t.T_FB_TRAVELEXPAPPLYMASTER = this.OrderEntity.Entity as T_FB_TRAVELEXPAPPLYMASTER;
t.SERIALNUMBER = listDetail.Count + 1;
ps.ForEach(p => { t.SetObjValue(p, decimal.Parse("0")); });
t.TOTALCHARGE = decimal.Parse("0");
listDetail.Add(item);
});
};
service.QueryFBEntities(qeDept);
}
public static void Test(EntityObject obj)
{
T_FB_TRAVELEXPAPPLYMASTER bb = obj as T_FB_TRAVELEXPAPPLYMASTER;
BaseBll <T_FB_TRAVELEXPAPPLYMASTER> b = new BaseBll <T_FB_TRAVELEXPAPPLYMASTER>();
T_FB_TRAVELEXPAPPLYMASTER t = b.GetTable().First();
T_FB_TRAVELEXPAPPLYDETAIL t1 = new T_FB_TRAVELEXPAPPLYDETAIL();
T_FB_TRAVELEXPAPPLYDETAIL t2 = bb.T_FB_TRAVELEXPAPPLYDETAIL.ToList()[0];
t.T_FB_TRAVELEXPAPPLYDETAIL.Add(t1);
t.T_FB_TRAVELEXPAPPLYDETAIL.Add(t2);
b.dal.GetDataContext().SaveChanges();
}
void EditForm_Saving(object sender, SavingEventArgs e)
{
ObservableCollection <FBEntity> details = this.OrderEntity.GetRelationFBEntities(typeof(T_FB_TRAVELEXPAPPLYDETAIL).Name);
#region 去掉无关的关联
details.ToList().ForEach(item =>
{
T_FB_TRAVELEXPAPPLYDETAIL detail = item.Entity as T_FB_TRAVELEXPAPPLYDETAIL;
detail.T_FB_SUBJECT.T_FB_BORROWAPPLYDETAIL.Clear();
detail.T_FB_SUBJECT.T_FB_BUDGETACCOUNT.Clear();
detail.T_FB_SUBJECT.T_FB_TRAVELEXPAPPLYDETAIL.Clear();
});
#endregion
if (details.Count == 0)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage(ErrorMessage.NoDetailInfo);
return;
}
List <string> msgs = new List <string>();
details.ToList().ForEach(item =>
{
T_FB_TRAVELEXPAPPLYDETAIL detail = item.Entity as T_FB_TRAVELEXPAPPLYDETAIL;
if (detail.TOTALCHARGE < 0)
{
string errorMessage = string.Format(ErrorMessage.BudgetMoneyZero, detail.T_FB_SUBJECT.SUBJECTNAME);
msgs.Add(errorMessage);
}
if (detail.USABLEMONEY.LessThan(detail.TOTALCHARGE))
{
msgs.Add(string.Format(ErrorMessage.ChargeMoneyBigger, detail.T_FB_SUBJECT.SUBJECTNAME));
}
});
if (msgs.Count > 0)
{
e.Action = Actions.Cancel;
CommonFunction.ShowErrorMessage(msgs);
}
}
/// <summary>
/// 获取T_FB_TRAVELEXPAPPLYDETAIL信息
/// </summary>
/// <param name="strTravelexpApplyDetailId">主键索引</param>
/// <returns></returns>
public T_FB_TRAVELEXPAPPLYDETAIL GetTravelexpApplyDetailByID(string strTravelexpApplyDetailId)
{
if (string.IsNullOrEmpty(strTravelexpApplyDetailId))
{
return(null);
}
TravelexpApplyDetailDAL dalTravelexpApplyDetail = new TravelexpApplyDetailDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strTravelexpApplyDetailId))
{
strFilter.Append(" TRAVELEXPAPPLYDETAILID == @0");
objArgs.Add(strTravelexpApplyDetailId);
}
T_FB_TRAVELEXPAPPLYDETAIL entRd = dalTravelexpApplyDetail.GetTravelexpApplyDetailRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
public static T_FB_TRAVELEXPAPPLYDETAIL CreateT_FB_TRAVELEXPAPPLYDETAIL(string tRAVELEXPAPPLYDETAILID, decimal mONTH, decimal dAY, decimal tOTALCHARGE, string cREATEUSERID, global::System.DateTime cREATEDATE, string uPDATEUSERID, global::System.DateTime uPDATEDATE)
{
T_FB_TRAVELEXPAPPLYDETAIL t_FB_TRAVELEXPAPPLYDETAIL = new T_FB_TRAVELEXPAPPLYDETAIL();
t_FB_TRAVELEXPAPPLYDETAIL.TRAVELEXPAPPLYDETAILID = tRAVELEXPAPPLYDETAILID;
t_FB_TRAVELEXPAPPLYDETAIL.MONTH = mONTH;
t_FB_TRAVELEXPAPPLYDETAIL.DAY = dAY;
t_FB_TRAVELEXPAPPLYDETAIL.TOTALCHARGE = tOTALCHARGE;
t_FB_TRAVELEXPAPPLYDETAIL.CREATEUSERID = cREATEUSERID;
t_FB_TRAVELEXPAPPLYDETAIL.CREATEDATE = cREATEDATE;
t_FB_TRAVELEXPAPPLYDETAIL.UPDATEUSERID = uPDATEUSERID;
t_FB_TRAVELEXPAPPLYDETAIL.UPDATEDATE = uPDATEDATE;
return t_FB_TRAVELEXPAPPLYDETAIL;
}
public void AddToT_FB_TRAVELEXPAPPLYDETAIL(T_FB_TRAVELEXPAPPLYDETAIL t_FB_TRAVELEXPAPPLYDETAIL)
{
base.AddObject("T_FB_TRAVELEXPAPPLYDETAIL", t_FB_TRAVELEXPAPPLYDETAIL);
}
