コード例 #1
0
ファイル: SystemRule.cs プロジェクト: riyuexing/rms
        public static DataTable GetUnitListByUserCode(string UserCode)
        {
            DataTable table2;

            try
            {
                DataTable  tb     = new DataTable();
                DataColumn column = new DataColumn();
                tb.Columns.Add("UnitCode");
                tb.Columns.Add("UnitName");
                EntityData userRoleByUserCode = SystemManageDAO.GetUserRoleByUserCode(UserCode);
                foreach (DataRow row in userRoleByUserCode.CurrentTable.Rows)
                {
                    EntityData stationByCode = OBSDAO.GetStationByCode(row["StationCode"].ToString());
                    if (stationByCode.HasRecord())
                    {
                        DataRow row2 = tb.NewRow();
                        row2["UnitCode"] = stationByCode.GetString("UnitCode");
                        row2["UnitName"] = GetUnitName(stationByCode.GetString("UnitCode"));
                        tb.Rows.Add(row2);
                    }
                    stationByCode.Dispose();
                }
                userRoleByUserCode.Dispose();
                table2 = ConvertRule.GetDistinct(tb, "UnitCode", "");
            }
            catch (Exception exception)
            {
                throw exception;
            }
            return(table2);
        }