/// <summary> /// 获取单据配置信息 /// </summary> /// <param name="fTranType">FTranType</param> /// <param name="userId">用户ID</param> public static List <ModelSqlInfo> GetModelSqlInfo(int fTranType, int userId = 0) { var tranInfo = tranDAL.Get(fTranType); if (tranInfo == null) { throw new Exception("没有FTranType:" + fTranType + "配置信息!"); } //主表 var mTable = tranInfo.Tables.Find(x => x.bSlave == false); List <ModelSqlInfo> mSqlList = new List <ModelSqlInfo>(); var hasMoneyAuth = new Auth_DataDAL().Exist(fTranType, userId); tranInfo.Tables.ForEach(x => { var fields = ICTableFieldDAL.GetTableFields(fTranType, x.FTableName); //====================是否有金额权限=================== if (mTable.bMoneyAuth && !hasMoneyAuth) { fields.ForEach(f => { if (f.FFieldName.ToLower().Contains("amount") || f.FFieldName.ToLower().Contains("price")) { fields.Remove(f); } }); } //====================================================== var minfo = new ModelSqlInfo() { TableInfo = x, SQL_Select = GetSelectSql(x, fields), SQL_Insert = GetInsertSql(x, fields), SQL_Update = GetUpdateSql(x, fields), SQL_Delete = GetDeleteSql(tranInfo, x.FTableName), SQL_List = tranInfo.FListSQL }; mSqlList.Add(minfo); }); return(mSqlList); }
public VoucherDAL(ModelSqlInfo _mInfo, ModelSqlInfo _dInfo) { this.mInfo = _mInfo; this.dInfo = _dInfo; }