public List<FBEntity> QueryFBEntities(QueryExpression qe) { try { using (FBCommonBLL fbCommonBLL = new FBCommonBLL()) { return fbCommonBLL.QueryFBEntities(qe); } } catch (Exception ex) { QueryExpression qeTemp = qe; string parameter = ""; while (qeTemp != null) { parameter += string.Format("Name:{0} ; Value:{1} ; QueryType:{2}", qeTemp.PropertyName, qeTemp.PropertyValue, qeTemp.QueryType) + "\r\n"; qeTemp = qeTemp.RelatedExpression; } Tracer.Debug(ex.ToString() + "\r\n参数: " + parameter); throw ex; } }
public T_FB_EXTENSIONALORDER UpdateExtensionOrder(string strModelCode, string orderID, string strCheckStates, ref string strMsg) { using (FBCommonBLL fbCommonBLL = new FBCommonBLL()) { try { SystemBLL.Debug("UpdateExtensionOrder方法已被调用,参数:strModelCode: " + strModelCode + ", orderID: " + orderID + ", strCheckStates: " + strCheckStates); QueryExpression queryExpression = QueryExpression.Equal("ORDERID", orderID); if (strModelCode == "Travel") { QueryExpression tempQE = QueryExpression.Equal("TravelSubject", "1"); tempQE.RelatedExpression = QueryExpression.Equal("EXTENSIONALTYPECODE", "CCPX"); queryExpression.RelatedExpression = tempQE; } //查出保存的外部单据 queryExpression.QueryType = typeof(T_FB_EXTENSIONALORDER).Name; queryExpression.IsNoTracking = true; List<FBEntity> listDetail = fbCommonBLL.QueryFBEntities(queryExpression); //如果存在外部单据 if (listDetail.Count > 0) { var saveFBEntity = listDetail[0]; saveFBEntity.Entity.SetValue("CHECKSTATES", Decimal.Parse(strCheckStates)); saveFBEntity.FBEntityState = FBEntityState.Modified; //var temp = fbCommonBLL.FBCommSaveEntity(listDetail[0]); SaveResult temp = new SaveResult(); try { temp.FBEntity = fbCommonBLL.SaveT_FB_EXTENSIONALORDER(listDetail[0]); temp.Successful = true; } catch(Exception ex) { temp.Exception = ex.Message; temp.Successful = false; } if (temp.Successful) { return temp.FBEntity.Entity as T_FB_EXTENSIONALORDER; } else { strMsg = temp.Exception; } } else { strMsg = "没有可操作的数据"; } } catch (Exception ex) { strMsg = ex.Message; if (!(ex is FBBLLException)) { // strMsg = "单据审核异常,请联系管理员"; Tracer.Debug("审核" + strModelCode + "的单据[" + orderID + "]出现异常,错误消息为:" + ex.ToString()); } } return null; } }
public List<FBEntity> QueryFBEntities(QueryExpression queryExpression) { using (FBCommonBLL fbCommonBLL = new FBCommonBLL()) { List<string> listOrder = new List<string>(); listOrder.Add(typeof(T_FB_EXTENSIONORDERDETAIL).Name); listOrder.Add(typeof(T_FB_EXTENSIONALORDER).Name); listOrder.Add(typeof(T_FB_EXTENSIONALTYPE).Name); if (!listOrder.Contains(queryExpression.QueryType)) { return new List<FBEntity>(); } queryExpression.IsUnCheckRight = true; List<FBEntity> listDetail = fbCommonBLL.QueryFBEntities(queryExpression); return listDetail; } }