示例#1
0
        public IList<CY.CYWebsite.Core.Business.Web_News> GetByModuleCode(string strModuleCode)
        {
            IList<CY.CYWebsite.Core.Business.Web_News> list_news = new List<CY.CYWebsite.Core.Business.Web_News>();
            SqlServerUtility sqlhelper = new SqlServerUtility();
            SqlDataReader reader;
            if (!strModuleCode.Trim().Equals(""))
            {
                sqlhelper.AddParameter("@Module_Code", SqlDbType.VarChar, strModuleCode, 10);
                reader = sqlhelper.ExecuteSqlReader(strSQLSelectByModuleCode.ToString());
            }
            else
            {
                reader = sqlhelper.ExecuteSqlReader(SqlGetAllWeb_News.ToString());
            }

            if (reader != null && !reader.IsClosed)
            {
                while (reader.Read())
                {
                    CY.CYWebsite.Core.Business.Web_News news = new CY.CYWebsite.Core.Business.Web_News();

                    if (!reader.IsDBNull(0)) { news.Id = reader.GetInt32(0); }
                    if (!reader.IsDBNull(1)) { news.News_Content = reader.GetString(1); }
                    if (!reader.IsDBNull(2)) { news.News_PubDate = reader.GetDateTime(2); }
                    if (!reader.IsDBNull(3)) { news.News_Title = reader.GetString(3); }
                    if (!reader.IsDBNull(4)) { news.Module_Code = reader.GetString(4); }
                    if (!reader.IsDBNull(5)) { news.Manager_Code = reader.GetString(5); }
                    list_news.Add(news);
                }
                reader.Close();
                return list_news;
            }
            return null;
        }
        public IList<Core.Business.WishingComment> GetAllWishingComment()
        {
            IList<Core.Business.WishingComment> wishingCommentlist = new List<Core.Business.WishingComment>();
            SqlServerUtility sql = new SqlServerUtility(SqlConnection);

            SqlDataReader reader = sql.ExecuteSqlReader("");

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.WishingComment wishingComment = new Core.Business.WishingComment();

                    if (!reader.IsDBNull(0)) wishingComment.Id = reader.GetInt64(0);
                    if (!reader.IsDBNull(1)) wishingComment.DateCreated = reader.GetDateTime(1);
                    if (!reader.IsDBNull(2)) wishingComment.InstanceId = reader.GetInt64(2);
                    if (!reader.IsDBNull(3)) wishingComment.AuthorId = reader.GetInt64(3);
                    if (!reader.IsDBNull(4)) wishingComment.Content = reader.GetString(4);

                    wishingComment.MarkOld();
                    wishingCommentlist.Add(wishingComment);
                }
                reader.Close();
            }
            return wishingCommentlist;
        }
示例#3
0
        public Core.Business.StudentPass GetPassByStdID(int id)
        {
            SqlServerUtility sql = new SqlServerUtility();
            string sqlwhere = "SELECT [ID], [StuID],[Pass] from [StudentPass] where StuID="+id+"";
            SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                Core.Business.StudentPass studentPass = new Core.Business.StudentPass();

                if (!reader.IsDBNull(0)) studentPass.Id = reader.GetInt32(0);
                if (!reader.IsDBNull(1)) studentPass.StuID = reader.GetInt32(1);
                if (!reader.IsDBNull(2)) studentPass.Pass = reader.GetString(2);

                reader.Close();
                return studentPass;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return null;
            }
        }
示例#4
0
        public IList<Core.Business.Messages> GetAllMessages()
        {
            IList<Core.Business.Messages> messageslist = new List<Core.Business.Messages>();
            SqlServerUtility sql = new SqlServerUtility(connectionString);

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllMessages);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.Messages messages = new Core.Business.Messages();

                    if (!reader.IsDBNull(0)) messages.Id = reader.GetInt64(0);
                    if (!reader.IsDBNull(1)) messages.Content = reader.GetString(1);
                    if (!reader.IsDBNull(2)) messages.Type = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) messages.DateCreated = reader.GetDateTime(3);
                    if (!reader.IsDBNull(4)) messages.SendDate = reader.GetDateTime(4);
                    if (!reader.IsDBNull(5)) messages.IsRead = reader.GetInt32(5);
                    if (!reader.IsDBNull(6)) messages.AuthorId = reader.GetInt64(6);
                    if (!reader.IsDBNull(7)) messages.AccountId = reader.GetInt64(7);
                    if (!reader.IsDBNull(8)) messages.Title = reader.GetString(8);
                    if (!reader.IsDBNull(9)) messages.Attachments = reader.GetString(9);
                    if (!reader.IsDBNull(10)) messages.AuthorName = reader.GetString(10);
                    if (!reader.IsDBNull(11)) messages.AccountName = reader.GetString(11);

                    messages.MarkOld();
                    messageslist.Add(messages);
                }
                reader.Close();
            }
            return messageslist;
        }
        public void Delete(Core.Business.FavoritesComment favoritesComment)
        {
            SqlServerUtility sql = new SqlServerUtility(connectionString);

            sql.AddParameter("@Id", SqlDbType.BigInt, favoritesComment.Id);
            sql.ExecuteSqlReader(SqlDeleteFavoritesComment);
        }
示例#6
0
        public void Insert(Core.Business.Asset asset)
        {
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@AssetType", SqlDbType.NVarChar, asset.AssetType);
            sql.AddParameter("@AssetItemName", SqlDbType.NVarChar, asset.AssetItemName);
            sql.AddParameter("@UnitValue", SqlDbType.Decimal, asset.UnitValue);
            sql.AddParameter("@PurchasingDate", SqlDbType.DateTime, asset.PurchasingDate);
            sql.AddParameter("@RegisterDate", SqlDbType.DateTime, asset.RegisterDate);
            sql.AddParameter("@Num", SqlDbType.Int, asset.Num);

            SqlDataReader reader = sql.ExecuteSqlReader(SqlInsertAsset);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                if (!reader.IsDBNull(0)) asset.Id = int.Parse(reader.GetDecimal(0).ToString());

                reader.Close();
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();
            }
        }
示例#7
0
        public IList<Core.Business.UserAnswer> GetUserAnswerByVoteItemList(IList<CY.CSTS.Core.Business.VoteItem> vIList)
        {
            IList<Core.Business.UserAnswer> userAnswerlist = new List<Core.Business.UserAnswer>();

            foreach (Core.Business.VoteItem vI in vIList )
            {
                SqlServerUtility sql = new SqlServerUtility();

                sql.AddParameter("@voteItemID", SqlDbType.Int, vI.Id);
                SqlDataReader reader = sql.ExecuteSqlReader(SqlGetUserAnswerByVoteItemID);

                if (reader != null)
                {
                    while (reader.Read())
                    {
                        Core.Business.UserAnswer userAnswer = new Core.Business.UserAnswer();

                        if (!reader.IsDBNull(0)) userAnswer.Id = reader.GetInt32(0);
                        if (!reader.IsDBNull(1)) userAnswer.VoteRecordID = reader.GetInt32(1);
                        if (!reader.IsDBNull(2)) userAnswer.VoteItemID = reader.GetInt32(2);
                        if (!reader.IsDBNull(3)) userAnswer.AnswerContent = reader.GetString(3);

                        userAnswer.MarkOld();
                        userAnswerlist.Add(userAnswer);
                    }
                    reader.Close();
                }
            }
            return userAnswerlist;
        }
示例#8
0
        public IList<Core.Business.PlanCourse> GetAllPlanCourse()
        {
            IList<Core.Business.PlanCourse> planCourselist = new List<Core.Business.PlanCourse>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllPlanCourse);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.PlanCourse planCourse = new Core.Business.PlanCourse();

                    if (!reader.IsDBNull(0)) planCourse.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) planCourse.PlanCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) planCourse.CourseCode = reader.GetString(2);
                    if (!reader.IsDBNull(3)) planCourse.TeacherCode = reader.GetString(3);

                    if (!reader.IsDBNull(4)) planCourse.CourseNum = reader.GetInt32(4);
                    if (!reader.IsDBNull(5)) planCourse.CourseScore = reader.GetInt32(5);

                    planCourse.MarkOld();
                    planCourselist.Add(planCourse);
                }
                reader.Close();
            }
            return planCourselist;
        }
        public IList<Core.Business.AccountRecommend> GetAllAccountRecommend()
        {
            IList<Core.Business.AccountRecommend> accountRecommendlist = new List<Core.Business.AccountRecommend>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAccountRecommend);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.AccountRecommend accountRecommend = new Core.Business.AccountRecommend();

                    if (!reader.IsDBNull(0)) accountRecommend.Id = reader.GetInt64(0);
                    if (!reader.IsDBNull(1)) accountRecommend.RecommendDate = reader.GetDateTime(1);
                    if (!reader.IsDBNull(2)) accountRecommend.AccountId = reader.GetInt64(2);
                    if (!reader.IsDBNull(3)) accountRecommend.RecommendId = reader.GetInt64(3);
                    if (!reader.IsDBNull(4)) accountRecommend.AccountName = reader.GetString(4);

                    accountRecommend.MarkOld();
                    accountRecommendlist.Add(accountRecommend);
                }
                reader.Close();
            }
            return accountRecommendlist;
        }
示例#10
0
        public IList<Core.Business.TRGoupArrange> GetAllTRGoupArrange()
        {
            IList<Core.Business.TRGoupArrange> tRGoupArrangelist = new List<Core.Business.TRGoupArrange>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTRGoupArrange);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.TRGoupArrange tRGoupArrange = new Core.Business.TRGoupArrange();

                    if (!reader.IsDBNull(0)) tRGoupArrange.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) tRGoupArrange.ArrangeCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) tRGoupArrange.Term = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) tRGoupArrange.YearNum = reader.GetString(3);
                    if (!reader.IsDBNull(4)) tRGoupArrange.MakeDate = reader.GetDateTime(4);
                    if (!reader.IsDBNull(5)) tRGoupArrange.CheckerCode = reader.GetString(5);
                    if (!reader.IsDBNull(6)) tRGoupArrange.TRGroupCode = reader.GetString(6);
                    if (!reader.IsDBNull(7)) tRGoupArrange.ArrangeNames = reader.GetString(7);

                    tRGoupArrange.MarkOld();
                    tRGoupArrangelist.Add(tRGoupArrange);
                }
                reader.Close();
            }
            return tRGoupArrangelist;
        }
示例#11
0
        public IList<Core.Business.ISOItem> GetAllISOItem()
        {
            IList<Core.Business.ISOItem> iSOItemlist = new List<Core.Business.ISOItem>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllISOItem);

            if (reader != null && !reader.IsClosed)
            {
                while (reader.Read())
                {
                    Core.Business.ISOItem iSOItem = new Core.Business.ISOItem();

                    if (!reader.IsDBNull(0)) iSOItem.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) iSOItem.Score = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) iSOItem.FileName = reader.GetString(2);
                    if (!reader.IsDBNull(3)) iSOItem.Content = reader.GetString(3);
                    if (!reader.IsDBNull(4)) iSOItem.CheckMethod = reader.GetString(4);
                    if (!reader.IsDBNull(5)) iSOItem.Summary = reader.GetString(5);
                    if (!reader.IsDBNull(6)) iSOItem.Inputter = reader.GetString(6);
                    if (!reader.IsDBNull(7)) iSOItem.CheckCode = reader.GetString(7);

                    iSOItem.MarkOld();
                    iSOItemlist.Add(iSOItem);
                }
                reader.Close();
            }
            return iSOItemlist;
        }
示例#12
0
        public IList<Core.Business.ScoreInPratise> GetScoreInPratiseByTime(string strWhere)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(SqlGetAllScoreInPratise);
            if (!string.IsNullOrEmpty(strWhere))
                sb.Append(" where " + strWhere);

            IList<Core.Business.ScoreInPratise> scoreInPratiselist = new List<Core.Business.ScoreInPratise>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(sb.ToString());

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.ScoreInPratise scoreInPratise = new Core.Business.ScoreInPratise();

                    if (!reader.IsDBNull(0)) scoreInPratise.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) scoreInPratise.StudentCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) scoreInPratise.YearNum = reader.GetString(2);
                    if (!reader.IsDBNull(3)) scoreInPratise.Term = reader.GetInt32(3);
                    if (!reader.IsDBNull(4)) scoreInPratise.ScoreNum = reader.GetDecimal(4);
                    if (!reader.IsDBNull(5)) scoreInPratise.ScoreCate = reader.GetString(5);
                    if (!reader.IsDBNull(6)) scoreInPratise.PracticeId = reader.GetInt32(6);

                    scoreInPratise.MarkOld();
                    scoreInPratiselist.Add(scoreInPratise);
                }
                reader.Close();
            }
            return scoreInPratiselist;
        }
示例#13
0
        public IList<Core.Business.ScoreInPratise> GetAllScoreInPratise()
        {
            IList<Core.Business.ScoreInPratise> scoreInPratiselist = new List<Core.Business.ScoreInPratise>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllScoreInPratise);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.ScoreInPratise scoreInPratise = new Core.Business.ScoreInPratise();

                    if (!reader.IsDBNull(0)) scoreInPratise.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) scoreInPratise.StudentCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) scoreInPratise.YearNum = reader.GetString(2);
                    if (!reader.IsDBNull(3)) scoreInPratise.Term = reader.GetInt32(3);
                    if (!reader.IsDBNull(4)) scoreInPratise.ScoreNum = reader.GetDecimal(4);
                    if (!reader.IsDBNull(5)) scoreInPratise.ScoreCate = reader.GetString(5);
                    if (!reader.IsDBNull(6)) scoreInPratise.PracticeId = reader.GetInt32(6);

                    scoreInPratise.MarkOld();
                    scoreInPratiselist.Add(scoreInPratise);
                }
                reader.Close();
            }
            return scoreInPratiselist;
        }
示例#14
0
        public void Insert(Core.Business.AccidentRcd accidentRcd)
        {
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@DevCode", SqlDbType.NVarChar, accidentRcd.DevCode);
            sql.AddParameter("@DevUnitCode", SqlDbType.NVarChar, accidentRcd.DevUnitCode);
            sql.AddParameter("@ClsRoomCode", SqlDbType.NVarChar, accidentRcd.ClsRoomCode);
            sql.AddParameter("@AccidentDate", SqlDbType.DateTime, accidentRcd.AccidentDate);
            sql.AddParameter("@ReportDate", SqlDbType.DateTime, accidentRcd.ReportDate);
            sql.AddParameter("@Reason", SqlDbType.NVarChar, accidentRcd.Reason);
            sql.AddParameter("@AccinenterName", SqlDbType.NVarChar, accidentRcd.AccinenterName);
            sql.AddParameter("@ReporterName", SqlDbType.NVarChar, accidentRcd.ReporterName);
            sql.AddParameter("@LeaderName", SqlDbType.NVarChar, accidentRcd.LeaderName);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlInsertAccidentRcd);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                if (!reader.IsDBNull(0)) accidentRcd.Id = int.Parse(reader.GetDecimal(0).ToString());

                reader.Close();
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();
            }
        }
示例#15
0
        public IList<Core.Business.AccidentRcd> GetAllAccidentRcd()
        {
            IList<Core.Business.AccidentRcd> accidentRcdlist = new List<Core.Business.AccidentRcd>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAccidentRcd);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.AccidentRcd accidentRcd = new Core.Business.AccidentRcd();

                    if (!reader.IsDBNull(0)) accidentRcd.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) accidentRcd.DevCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) accidentRcd.DevUnitCode = reader.GetString(2);
                    if (!reader.IsDBNull(3)) accidentRcd.ClsRoomCode = reader.GetString(3);
                    if (!reader.IsDBNull(4)) accidentRcd.AccidentDate = reader.GetDateTime(4);
                    if (!reader.IsDBNull(5)) accidentRcd.ReportDate = reader.GetDateTime(5);
                    if (!reader.IsDBNull(6)) accidentRcd.Reason = reader.GetString(6);
                    if (!reader.IsDBNull(7)) accidentRcd.AccinenterName = reader.GetString(7);
                    if (!reader.IsDBNull(8)) accidentRcd.ReporterName = reader.GetString(8);
                    if (!reader.IsDBNull(9)) accidentRcd.LeaderName = reader.GetString(9);

                    accidentRcd.MarkOld();
                    accidentRcdlist.Add(accidentRcd);
                }
                reader.Close();
            }
            return accidentRcdlist;
        }
示例#16
0
        bool CY.GFive.Core.Providers.DALProvider.IDeviceInfoProvider.IsExist(string deviceCode)
        {
            bool flag = false;

            SqlServerUtility utility = new SqlServerUtility();

            if (deviceCode != null)
                utility.AddParameter("DeviceCode", SqlDbType.VarChar, deviceCode);

            SqlDataReader reader = utility.ExecuteSqlReader(SQL_GET_DEVICE_BY_DEVICE_CODE);

            if (reader != null && !reader.IsClosed)
            {
                if (reader.Read())
                    flag = true;

                reader.Close();
            }
            else
            {
                flag = false;
            }

            return flag;
        }
示例#17
0
        public IList<PlanCourse> Fill(CoursePlan plan)
        {
            if (plan == null)
                return null;

            IList<Core.Business.PlanCourse> planCourselist = new List<Core.Business.PlanCourse>();

            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@PlanCode", SqlDbType.NVarChar, plan.PlanCode, 30);

            SqlDataReader reader = sql.ExecuteSqlReader(SqlFillPlanCourse);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.PlanCourse planCourse = new Core.Business.PlanCourse();

                    if (!reader.IsDBNull(0)) planCourse.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) planCourse.PlanCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) planCourse.CourseCode = reader.GetString(2);
                    if (!reader.IsDBNull(3)) planCourse.TeacherCode = reader.GetString(3);

                    if (!reader.IsDBNull(4)) planCourse.CourseNum = reader.GetInt32(4);
                    if (!reader.IsDBNull(5)) planCourse.CourseScore = reader.GetInt32(5);

                    planCourse.MarkOld();

                    planCourselist.Add(planCourse);
                }
                reader.Close();
            }
            return planCourselist;
        }
        public IList<Core.Business.VirtualLabDataBigClass> GetBySql(string sqlwhere)
        {
            IList<Core.Business.VirtualLabDataBigClass> virtualLabDataBigClasslist = new List<Core.Business.VirtualLabDataBigClass>();
            SqlServerUtility sql = new SqlServerUtility();
            string sqlstr = "SELECT * FROM [dbo].[VirtualLabDataBigClass] where ";
            sqlstr += sqlwhere;
            SqlDataReader reader = sql.ExecuteSqlReader(sqlstr);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.VirtualLabDataBigClass virtualLabDataBigClass = new Core.Business.VirtualLabDataBigClass();

                    if (!reader.IsDBNull(0)) virtualLabDataBigClass.Id = reader.GetGuid(0);
                    if (!reader.IsDBNull(1)) virtualLabDataBigClass.Name = reader.GetString(1);
                    if (!reader.IsDBNull(2)) virtualLabDataBigClass.VirturlLabID = reader.GetGuid(2);

                    virtualLabDataBigClass.MarkOld();
                    virtualLabDataBigClasslist.Add(virtualLabDataBigClass);
                }
                reader.Close();
            }
            return virtualLabDataBigClasslist;
        }
示例#19
0
        public IList<Core.Business.UserAnswer> GetAllUserAnswer()
        {
            IList<Core.Business.UserAnswer> userAnswerlist = new List<Core.Business.UserAnswer>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllUserAnswer);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.UserAnswer userAnswer = new Core.Business.UserAnswer();

                    if (!reader.IsDBNull(0)) userAnswer.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) userAnswer.VoteRecordID = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) userAnswer.VoteItemID = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) userAnswer.AnswerContent = reader.GetString(3);

                    userAnswer.MarkOld();
                    userAnswerlist.Add(userAnswer);
                }
                reader.Close();
            }
            return userAnswerlist;
        }
示例#20
0
        public IList<Core.Business.Meterial> GetAllMeterial()
        {
            IList<Core.Business.Meterial> meteriallist = new List<Core.Business.Meterial>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllMeterial);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.Meterial meterial = new Core.Business.Meterial();

                    if (!reader.IsDBNull(0)) meterial.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) meterial.ISBN = reader.GetString(1);
                    if (!reader.IsDBNull(2)) meterial.Name = reader.GetString(2);
                    if (!reader.IsDBNull(3)) meterial.Publish = reader.GetString(3);
                    if (!reader.IsDBNull(4)) meterial.MeterialCate = reader.GetString(4);
                    if (!reader.IsDBNull(5)) meterial.Des = reader.GetString(5);
                    if (!reader.IsDBNull(6)) meterial.Price = reader.GetDecimal(6);
                    if (!reader.IsDBNull(7)) meterial.Vision = reader.GetInt32(7);

                    meterial.MarkOld();
                    meteriallist.Add(meterial);
                }
                reader.Close();
            }
            return meteriallist;
        }
示例#21
0
        public IList<Core.Business.Asset> GetAllAsset()
        {
            IList<Core.Business.Asset> assetlist = new List<Core.Business.Asset>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAsset);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.Asset asset = new Core.Business.Asset();

                    if (!reader.IsDBNull(0)) asset.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) asset.AssetType = reader.GetString(1);
                    if (!reader.IsDBNull(2)) asset.AssetItemName = reader.GetString(2);
                    if (!reader.IsDBNull(3)) asset.UnitValue = reader.GetDecimal(3);
                    if (!reader.IsDBNull(4)) asset.PurchasingDate = reader.GetDateTime(4);
                    if (!reader.IsDBNull(5)) asset.RegisterDate = reader.GetDateTime(5);
                    if (!reader.IsDBNull(6)) asset.Num = reader.GetInt32(6);
                    if (!reader.IsDBNull(7)) asset.TotalValue = reader.GetDecimal(7);

                    asset.MarkOld();
                    assetlist.Add(asset);
                }
                reader.Close();
            }
            return assetlist;
        }
示例#22
0
        public Meterial getByCode(string code)
        {
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@code", SqlDbType.NVarChar, code);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectByCode);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                Core.Business.Meterial meterial = new Core.Business.Meterial();

                if (!reader.IsDBNull(0)) meterial.Id = reader.GetInt32(0);
                if (!reader.IsDBNull(1)) meterial.ISBN = reader.GetString(1);
                if (!reader.IsDBNull(2)) meterial.Name = reader.GetString(2);
                if (!reader.IsDBNull(3)) meterial.Publish = reader.GetString(3);
                if (!reader.IsDBNull(4)) meterial.MeterialCate = reader.GetString(4);
                if (!reader.IsDBNull(5)) meterial.Des = reader.GetString(5);
                if (!reader.IsDBNull(6)) meterial.Price = reader.GetDecimal(6);
                if (!reader.IsDBNull(7)) meterial.Vision = reader.GetInt32(7);

                reader.Close();

                meterial.MarkOld();

                return meterial;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return null;
            }
        }
示例#23
0
        public Core.Business.ControlPermissions2 Select(int id)
        {
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@Id", SqlDbType.Int, id);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectControlPermissions2);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                Core.Business.ControlPermissions2 controlPermissions2 = new Core.Business.ControlPermissions2();

                if (!reader.IsDBNull(0)) controlPermissions2.Id = reader.GetInt32(0);
                if (!reader.IsDBNull(1)) controlPermissions2.ControlKey = reader.GetInt32(1);
                if (!reader.IsDBNull(2)) controlPermissions2.PermissionsKey = reader.GetInt32(2);

                reader.Close();
                return controlPermissions2;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return null;
            }
        }
示例#24
0
        public IList<Core.Business.VoteItem> GetVoteItemByVoteID(int id)
        {
            IList<Core.Business.VoteItem> voteItemlist = new List<Core.Business.VoteItem>();
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@voteid", SqlDbType.Int, id);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetVoteItemByVoteID);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.VoteItem voteItem = new Core.Business.VoteItem();

                    if (!reader.IsDBNull(0)) voteItem.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) voteItem.VoteID = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) voteItem.IsMutiChoose = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) voteItem.IsUserDefine = reader.GetInt32(3);
                    if (!reader.IsDBNull(4)) voteItem.VoteItemContent = reader.GetString(4);

                    voteItem.MarkOld();
                    voteItemlist.Add(voteItem);
                }

                reader.Close();
            }
            return voteItemlist;
        }
        public int GetCommentCountByFavoritesId(CY.UME.Core.Business.Favorites favorites)
        {
            int count = 0;

            if (favorites == null)
            {
                return count;
            }

            SqlServerUtility sql = new SqlServerUtility(connectionString);

            sql.AddParameter("@FavoritesId", SqlDbType.BigInt, favorites.Id);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetFavoritesCommentCountByInstanceId);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                if (!reader.IsDBNull(0)) count = reader.GetInt32(0);

                reader.Close();
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();
            }

            return count;
        }
示例#26
0
        public IList<Core.Business.ObserveTotal> GetAllObserveTotal()
        {
            IList<Core.Business.ObserveTotal> observeTotallist = new List<Core.Business.ObserveTotal>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllObserveTotal);

            if(reader != null)
            {
                while(reader.Read())
                {
                    Core.Business.ObserveTotal observeTotal = new Core.Business.ObserveTotal();

                    if (!reader.IsDBNull(0)) observeTotal.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) observeTotal.UnitCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) observeTotal.PeerCode = reader.GetString(2);
                    if (!reader.IsDBNull(3)) observeTotal.Num = reader.GetInt32(3);
                    if (!reader.IsDBNull(4)) observeTotal.NumFinish = reader.GetInt32(4);
                    if (!reader.IsDBNull(5)) observeTotal.NumAvail = reader.GetInt32(5);
                    if (!reader.IsDBNull(6)) observeTotal.Des = reader.GetString(6);

                    observeTotal.MarkOld();
                    observeTotallist.Add(observeTotal);
                }
                reader.Close();
            }
            return observeTotallist;
        }
示例#27
0
        public IList<Core.Business.TRGroup> GetAllTRGroup()
        {
            IList<Core.Business.TRGroup> tRGrouplist = new List<Core.Business.TRGroup>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTRGroup);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.TRGroup tRGroup = new Core.Business.TRGroup();

                    if (!reader.IsDBNull(0)) tRGroup.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) tRGroup.TrGroupCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) tRGroup.TrGoupName = reader.GetString(2);
                    if (!reader.IsDBNull(3)) tRGroup.AddDate = reader.GetDateTime(3);
                    if (!reader.IsDBNull(4)) tRGroup.BuildDate = reader.GetDateTime(4);

                    tRGroup.MarkOld();
                    tRGrouplist.Add(tRGroup);
                }
                reader.Close();
            }
            return tRGrouplist;
        }
示例#28
0
        /// <summary>
        /// ������ҵ���
        /// </summary>
        /// <param name="EntCode"></param>
        /// <returns></returns>
        public IList<Group> getByEntCode(string EntCode)
        {
            IList<Core.Business.Group> grouplist = new List<Core.Business.Group>();
            SqlServerUtility sql = new SqlServerUtility();
            sql.AddParameter("@EntCode", SqlDbType.NVarChar, EntCode);

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetGroupByEntCode);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.Group group = new Core.Business.Group();

                    if (!reader.IsDBNull(0)) group.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) group.Num = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) group.Term = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) group.YearCode = reader.GetString(3);
                    if (!reader.IsDBNull(4)) group.EntCode = reader.GetString(4);
                    if (!reader.IsDBNull(5)) group.GroupName = reader.GetString(5);

                    group.MarkOld();
                    grouplist.Add(group);
                }
                reader.Close();
            }
            return grouplist;
        }
        public int getCount(string strWhere)
        {
            SqlServerUtility sql = new SqlServerUtility();

            if (strWhere.Trim().Equals(""))
            {
                strWhere = "1=1";
            }
            string sqlstr = "select count(*) from InstrumentPictureRepository where " + strWhere + "";
            SqlDataReader reader = sql.ExecuteSqlReader(sqlstr);

            int count = 0;
            if (reader != null && !reader.IsClosed && reader.Read())
            {
                if (!reader.IsDBNull(0)) count = reader.GetInt32(0);

                reader.Close();
                return count;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();
                return count;
            }
        }
示例#30
0
        public IList<CY.CSTS.Core.Business.VoteRole> GetByVoteId(int voteID)
        {
            IList<Core.Business.VoteRole> voteRolelist = new List<Core.Business.VoteRole>();
            SqlServerUtility sql = new SqlServerUtility();
            sql.AddParameter("@VoteID",SqlDbType.Int,voteID);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByVoteID);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.VoteRole voteRole = new Core.Business.VoteRole();

                    if (!reader.IsDBNull(0)) voteRole.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) voteRole.DepartmentID = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) voteRole.VoteID = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) voteRole.RoleID = reader.GetInt32(3);

                    voteRole.MarkOld();
                    voteRolelist.Add(voteRole);
                }
                reader.Close();
            }
            return voteRolelist;
        }