public struct workloadItem { public string Name; public string RefTable; public decimal AllocPercent; public decimal? AllocWorkLoad; } [System.Web.Services.WebMethod] public static workloadItem[] GetWorkLoadItem(int assetid) { string sql = "select Name,AllocPercent,AllocWorkLoad,RefTable from dbo.View_FA_CardDepartment where AssetID=" + assetid + " and IsHistory='y' or IsHistory is null"; System.Collections.Generic.List<workloadItem> items = new System.Collections.Generic.List<workloadItem>(); System.Data.IDataReader reader= IFCA.Framework.Utility.DataAccess.DataAccessHelper.ExecuteReader(sql); string sql2 = "select EntityName,ProjectTypeName,AllocPercent,RefTable from View_FA_CardProject where AssetID=" + assetid + " and IsHistory='y' or IsHistory is null"; System.Data.IDataReader reader2 = IFCA.Framework.Utility.DataAccess.DataAccessHelper.ExecuteReader(sql); try { while (reader.Read()) { workloadItem item = new workloadItem(); item.Name = reader.GetString(0); item.AllocPercent = reader.GetDecimal(1); item.RefTable = reader.GetString(3); if(!reader.IsDBNull(2)) item.AllocWorkLoad = reader.GetDecimal(2); items.Add(item); } return items.ToArray(); } finally { reader.Close(); } try { while (reader2.Read()) { workloadItem item = new workloadItem(); item.Name = reader2.GetString(0); item.AllocPercent = reader2.GetDecimal(1); item.RefTable = reader2.GetString(3); items.Add(item); } return items.ToArray(); } finally { reader2.Close(); } }
sdaf
最新推荐文章于 2022-08-11 16:00:22 发布