/// <summary> /// 获得指定ID的Material /// </summary> /// <param name="materialID">指定ID</param> /// <returns>MaterialList</returns> public MaterialList LoadMaterialByMaterialID(string materialID) { ExceptionHelper.CheckStringIsNullOrEmpty(materialID, "materialID"); MaterialList materials = new MaterialList(); WhereSqlClauseBuilder wBuilder = new WhereSqlClauseBuilder(); wBuilder.AppendItem("ID", materialID); wBuilder.AppendTenantCode(typeof(Material)); string sql = "SELECT * FROM WF.MATERIAL WHERE " + wBuilder.ToSqlString(TSqlBuilder.Instance); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { using (IDataReader dr = DbHelper.RunSqlReturnDR(sql, GetConnectionName())) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); materials.Add(material); } } } DecorateMaterials(materials); return(materials); }
public MaterialList LoadVersionMaterialsBySceneKey(string resourceID, string wfActivityName) { MaterialList copyVersionMaterials = new MaterialList(); WhereSqlClauseBuilder whereSqlClause = new WhereSqlClauseBuilder(); whereSqlClause.AppendItem("RESOURCE_ID", resourceID); whereSqlClause.AppendItem("VERSION_TYPE", Convert.ToInt16(MaterialVersionType.CopyVersion).ToString()); whereSqlClause.AppendItem("WF_ACTIVITY_NAME", wfActivityName); whereSqlClause.AppendTenantCode(typeof(Material)); string sql = string.Format("SELECT * FROM WF.MATERIAL WHERE {0}", whereSqlClause.ToSqlString(TSqlBuilder.Instance)); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { using (IDataReader dr = DbHelper.RunSqlReturnDR(sql, GetConnectionName())) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); copyVersionMaterials.Add(material); } } } DecorateMaterials(copyVersionMaterials); return(copyVersionMaterials); }
/// <summary> /// 复制一个附件列表 /// </summary> /// <returns></returns> public MaterialList Clone() { MaterialList result = new MaterialList(); this.ForEach(m => result.Add(m.Clone())); return(result); }
/// <summary> /// 生成副本 /// </summary> /// <returns>生成的副本</returns> internal MaterialList GenerateCopyVersion() { ExceptionHelper.TrueThrow <ArgumentNullException>(this == null, "this"); MaterialList materialList = new MaterialList(); foreach (Material material in this) { materialList.Add(material.GenerateCopyVersion()); } return(materialList); }
/// <summary> /// 由类型分组 /// </summary> /// <returns></returns> public MaterialList GetMaterialsByClass(string className) { MaterialList materials = new MaterialList(); foreach (Material m in this) { if (m.MaterialClass == className) { materials.Add(m); } } return(materials); }
/// <summary> /// 产生文件版本 /// </summary> /// <param name="resourceID">新表单ID</param> /// <param name="wfProcessID">新工作流ID</param> /// <param name="wfActivityID">新工作流节点ID</param> /// <param name="wfActivityName">新工作流节点名称</param> /// <param name="department">产生的副本所在的部门</param> /// <returns>生成的副本</returns> public MaterialList GenerateOtherVersion(string resourceID, string wfProcessID, string wfActivityID, string wfActivityName, IOrganization department) { ExceptionHelper.TrueThrow <ArgumentNullException>(this == null, "this"); ExceptionHelper.CheckStringIsNullOrEmpty(resourceID, "resourceID"); ExceptionHelper.CheckStringIsNullOrEmpty(wfProcessID, "wfProcessID"); ExceptionHelper.CheckStringIsNullOrEmpty(wfActivityID, "wfActivityID"); MaterialList materialList = new MaterialList(); foreach (Material material in this) { materialList.Add(material.GenerateOtherVersion(resourceID, wfProcessID, wfActivityID, wfActivityName, department)); } return(materialList); }
/// <summary> /// 转化为附件集合 /// </summary> /// <returns>附件集合</returns> public MaterialList ConvertToMaterialList() { ExceptionHelper.TrueThrow <ArgumentNullException>(this == null, "MaterialModifyObjectCollection"); MaterialList materials = new MaterialList(); foreach (MaterialModifyObject materialModifyObject in this) { if (materialModifyObject != null) { Material m = materialModifyObject.ConvertToMaterial(); materials.Add(m); } } return(materials); }
/// <summary> /// 获得指定附件的副本 /// </summary> /// <param name="materials">附件集合</param> /// <returns>指定附件对应的副本集合</returns> internal MaterialList LoadCopyVersionMaterial(MaterialList materials) { ExceptionHelper.TrueThrow <ArgumentNullException>(materials == null, "materials"); MaterialList copyVersionMaterials = new MaterialList(); if (materials.Count != 0) { ConnectiveSqlClauseCollection orClause = new ConnectiveSqlClauseCollection(LogicOperatorDefine.Or); foreach (Material material in materials) { WhereSqlClauseBuilder whereSqlClause = new WhereSqlClauseBuilder(); whereSqlClause.AppendItem("PARENT_ID", material.ID); whereSqlClause.AppendItem("WF_ACTIVITY_ID", material.WfActivityID); whereSqlClause.AppendItem("VERSION_TYPE", (int)MaterialVersionType.CopyVersion); orClause.Add(whereSqlClause); } string sql = string.Format("SELECT * FROM WF.MATERIAL WHERE {0}", orClause.AppendTenantCodeSqlClause(typeof(Material)).ToSqlString(TSqlBuilder.Instance)); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { using (IDataReader dr = DbHelper.RunSqlReturnDR(sql, GetConnectionName())) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); copyVersionMaterials.Add(material); } } } DecorateMaterials(copyVersionMaterials); } return(copyVersionMaterials); }
/// <summary> /// 获得指定ID的副本 和 它之前的一切副本 按照时间正排序 /// </summary> /// <param name="id">id</param> /// <returns>MaterialList</returns> public MaterialList GetPreMaterialsCopyVersion(string id) { ExceptionHelper.CheckStringIsNullOrEmpty(id, "id"); WhereSqlClauseBuilder whereSqlClause = new WhereSqlClauseBuilder(); whereSqlClause.AppendItem("PARENT_ID", string.Format("(SELECT PARENT_ID FROM WF.MATERIAL WHERE ID = {0})", TSqlBuilder.Instance.CheckQuotationMark(id, true)), "=", true); whereSqlClause.AppendItem("MODIFY_TIME", string.Format("(SELECT MODIFY_TIME FROM WF.MATERIAL WHERE ID = {0})", TSqlBuilder.Instance.CheckQuotationMark(id, true)), "<=", true); whereSqlClause.AppendTenantCode(typeof(Material)); OrderBySqlClauseBuilder orderBySqlClause = new OrderBySqlClauseBuilder(); orderBySqlClause.AppendItem("MODIFY_TIME", FieldSortDirection.Ascending); string sql = string.Format(@"SELECT * FROM WF.MATERIAL WHERE {0} AND VERSION_TYPE = {1} ORDER BY {2}" , whereSqlClause.ToSqlString(TSqlBuilder.Instance), Convert.ToInt16(MaterialVersionType.CopyVersion), orderBySqlClause.ToSqlString(TSqlBuilder.Instance)); MaterialList materials = new MaterialList(); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { using (IDataReader dr = DbHelper.RunSqlReturnDR(sql, GetConnectionName())) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); materials.Add(material); } } } return(materials); }
/// <summary> /// 获得materialID对应的附件对象的所有版本和本身形成的树 /// 对应的存储过程GetMaterialVersions不存在 /// </summary> /// <param name="mainMaterialID">主版本ID</param> /// <returns>以主版本为跟节点各版本为子节点的树</returns> //[Obsolete("对应的存储过程GetMaterialVersions不存在")] public MaterialTreeNode LoadMaterialVersionsByMaterialID(string mainMaterialID) { ExceptionHelper.CheckStringIsNullOrEmpty(mainMaterialID, "mainMaterialID"); MaterialList materials = new MaterialList(); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { Database db = DatabaseFactory.Create(dbi); using (SqlCommand dbc = new SqlCommand()) { SqlParameter sqlParameter = new SqlParameter(); sqlParameter.Value = mainMaterialID; sqlParameter.SqlDbType = SqlDbType.NVarChar; sqlParameter.Size = 36; sqlParameter.ParameterName = "@mainMaterialID"; sqlParameter.SourceColumn = "@mainMaterialID"; sqlParameter.Direction = ParameterDirection.InputOutput; dbc.CommandType = CommandType.StoredProcedure; dbc.CommandText = "GetMaterialVersions"; dbc.Parameters.Add(sqlParameter); using (IDataReader dr = db.ExecuteReader(dbc)) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); materials.Add(material); } } mainMaterialID = sqlParameter.Value.ToString(); } } return(GenerateMaterialVersionTree(materials, mainMaterialID)); }
/// <summary> /// 由资源ID查询 /// </summary> /// <param name="resourceIDs">资源ID</param> /// <returns>查询结果</returns> public MaterialList LoadMaterialsByResourceID(params string[] resourceIDs) { ExceptionHelper.TrueThrow <ArgumentNullException>(resourceIDs == null, "resourceIDs"); MaterialList result = new MaterialList(); if (resourceIDs.Length != 0) { InSqlClauseBuilder inBuilder = new InSqlClauseBuilder("RESOURCE_ID"); inBuilder.AppendItem(resourceIDs); OrderBySqlClauseBuilder orderClause = new OrderBySqlClauseBuilder(); orderClause.AppendItem("SORT_ID", FieldSortDirection.Ascending); string sql = string.Format("SELECT * FROM WF.MATERIAL WHERE {0} AND VERSION_TYPE = '{1}' ORDER BY {2}", inBuilder.AppendTenantCodeSqlClause(typeof(Material)).ToSqlString(TSqlBuilder.Instance), Convert.ToInt32(MaterialVersionType.Normal).ToString(), orderClause.ToSqlString(TSqlBuilder.Instance)); using (DbContext dbi = DbHelper.GetDBContext(GetConnectionName())) { using (IDataReader dr = DbHelper.RunSqlReturnDR(sql, GetConnectionName())) { while (dr.Read()) { Material material = new Material(); ORMapping.DataReaderToObject(dr, material); result.Add(material); } } } DecorateMaterials(result); } return(result); }