/// <summary> /// 根据条件查询密保问题信息 /// </summary> /// <returns></returns> public static Issue GetIssueByConn(string demandType, string demandContent) { string sql = "Select * from Issue where " + demandType + " = @" + demandType; Issue obj = new Issue(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { obj = new Issue() { P_LoginName = dr["P_LoginName"].ToString(), Issue_No = Convert.ToInt32(dr["Issue_No"]), Answer_1 = dr["Answer_1"].ToString(), Answer_2 = dr["Answer_2"].ToString(), Answer_3 = dr["Answer_3"].ToString(), Issue_1 = dr["Issue_1"].ToString(), Issue_2 = dr["Issue_2"].ToString(), Issue_3 = dr["Issue_3"].ToString() }; } dr.Close(); DBHelper.CloseCon(); return(obj); }
/// <summary> /// 根据条件查询评价信息 /// </summary> /// <returns></returns> public static List<Comment> GetCommentByConn(string demandType, string demandContent) { List<Comment> list = new List<Comment>(); string sql = "Select * from Comment where " + demandType + " = @" + demandType; Comment comment = new Comment(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType,demandContent) }); while (dr.Read()) { comment = new Comment() { Aduit_No = Convert.ToInt32(dr["Aduit_No"]), A_No = Convert.ToInt32(dr["A_No"]), Com_Cause = dr["Com_Cause"].ToString(), Com_Datetime = dr["Com_Datetime"].ToString(), Com_Content = dr["Com_Content"].ToString(), Com_No = Convert.ToInt32(dr["Com_No"]), NickName = dr["NickName"].ToString() }; list.Add(comment); } dr.Close(); DBHelper.CloseCon(); return list; }
/// <summary> /// 根据条件查询留言信息 /// </summary> /// <returns></returns> public static List <MassageBoard> GetMassageBoardByConn(string demandType, string demandContent) { string sql = "Select * from MassageBoard where " + demandType + " = @" + demandType; List <MassageBoard> list = new List <MassageBoard>(); MassageBoard massage = new MassageBoard(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); while (dr.Read()) { massage = new MassageBoard() { Aduit_No = Convert.ToInt32(dr["Aduit_No"]), Mb_NickName = dr["Mb_NickName"].ToString(), Mb_Cause = dr["Mb_Cause"].ToString(), Mb_Content = dr["Mb_Content"].ToString(), Mb_Datetime = dr["Mb_Datetime"].ToString(), Mb_No = Convert.ToInt32(dr["Mb_No"]) }; list.Add(massage); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询文章信息:多条 /// </summary> /// <returns></returns> public static List <Article> GetArticleByConns(string demandType, string demandContent) { List <Article> list = new List <Article>(); string sql = "Select * from Article where " + demandType + " = @" + demandType + " order by A_No desc"; Article article = new Article(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); while (dr.Read()) { article = new Article() { A_Author = dr["A_Author"].ToString(), A_Content = dr["A_Content"].ToString(), A_DateTime = dr["A_DateTime"].ToString(), A_No = Convert.ToInt32(dr["A_No"]), A_Title = dr["A_Title"].ToString(), A_TypeName = dr["A_TypeName"].ToString(), A_CoverImageUrl = dr["A_CoverImageUrl"].ToString() }; list.Add(article); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询登录日志信息 /// </summary> /// <returns></returns> public static LoginLog GetLoginLogByConn(string demandType, string demandContent) { string sql = "Select * from LoginLog where " + demandType + " = @" + demandType; LoginLog LoginLog = new LoginLog(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { LoginLog = new LoginLog() { Log_City = dr["Log_City"].ToString(), Log_Country = dr["Log_Country"].ToString(), Log_Date = dr["Log_Date"].ToString(), Log_ipAddress = dr["Log_ipAddress"].ToString(), Log_Province = dr["Log_Province"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), Log_No = Convert.ToInt32(dr["Log_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(LoginLog); }
/// <summary> /// 根据条件查询个人信息 /// </summary> /// <returns></returns> public static PersonageInfo GetPersonageInfoByConn(string demandType, string demandContent) { string sql = "Select * from PersonageInfo where " + demandType + " = @" + demandType; PersonageInfo personagerInfo = new PersonageInfo(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { personagerInfo = new PersonageInfo() { P_DataTime = dr["P_DataTime"].ToString(), P_Head = dr["P_Head"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), P_LoginPwd = dr["P_LoginPwd"].ToString(), P_MyExplain = dr["P_MyExplain"].ToString(), P_Phone = dr["P_Phone"].ToString(), P_NickName = dr["P_NickName"].ToString() }; } dr.Close(); DBHelper.CloseCon(); return(personagerInfo); }
/// <summary> /// 获取全部登录日志信息(按序号从大到小排序) /// </summary> /// <returns></returns> public static List <LoginLog> GetAllLoginLogByDesc(string LoginName) { List <LoginLog> list = new List <LoginLog>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_LoginLogByDesc", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@P_LoginName", LoginName) }); while (dr.Read()) { LoginLog atype = new LoginLog() { Log_City = dr["Log_City"].ToString(), Log_Country = dr["Log_Country"].ToString(), Log_Date = dr["Log_Date"].ToString(), Log_ipAddress = dr["Log_ipAddress"].ToString(), Log_Province = dr["Log_Province"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), Log_No = Convert.ToInt32(dr["Log_No"]) }; list.Add(atype); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询文章信息 /// </summary> /// <returns></returns> public static Article GetArticleByConn(string demandType, string demandContent) { string sql = "Select * from Article where " + demandType + " = @" + demandType; Article article = new Article(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { article = new Article() { A_Author = dr["A_Author"].ToString(), A_Content = dr["A_Content"].ToString(), A_DateTime = dr["A_DateTime"].ToString(), A_No = Convert.ToInt32(dr["A_No"]), A_Title = dr["A_Title"].ToString(), A_TypeName = dr["A_TypeName"].ToString(), A_CoverImageUrl = dr["A_CoverImageUrl"].ToString() }; } dr.Close(); DBHelper.CloseCon(); return(article); }
/// <summary> /// 获取全部文章类型信息 /// </summary> /// <returns></returns> public static List <ArticleType> GetAllArticleType() { List <ArticleType> list = new List <ArticleType>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_ArticleType", CommandType.StoredProcedure); while (dr.Read()) { ArticleType atype = new ArticleType() { At_Name = dr["At_Name"].ToString(), At_No = Convert.ToInt32(dr["At_No"]) }; list.Add(atype); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 获取全部问题库信息 /// </summary> /// <returns></returns> public static List <Issue_library> GetAllIssue_library() { List <Issue_library> list = new List <Issue_library>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_Issue_library", CommandType.StoredProcedure); while (dr.Read()) { Issue_library obj = new Issue_library() { IssueI_Name = dr["IssueI_Name"].ToString(), IssueI_No = Convert.ToInt32(dr["IssueI_No"]) }; list.Add(obj); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 获取全部信息统计信息 /// </summary> /// <returns></returns> public static List <InfoCount> GetAllInfoCount() { List <InfoCount> list = new List <InfoCount>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_InfoCount", CommandType.StoredProcedure); while (dr.Read()) { InfoCount infoCount = new InfoCount() { A_No = Convert.ToInt32(dr["A_No"]), IC_Count = Convert.ToInt32(dr["IC_Count"]) }; list.Add(infoCount); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 获取全部审核信息 /// </summary> /// <returns></returns> public static List <Aduit> GetAllAduit() { string sql = "Select_Aduit"; List <Aduit> list = new List <Aduit>(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.StoredProcedure); while (dr.Read()) { Aduit aduit = new Aduit() { Aduit_Name = dr["Aduit_Name"].ToString(), Aduit_No = Convert.ToInt32(dr["Aduit_No"]) }; list.Add(aduit); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 获取全部回复信息 /// </summary> /// <returns></returns> public static List <Reply> GetAllReply() { List <Reply> list = new List <Reply>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_Reply", CommandType.StoredProcedure); while (dr.Read()) { Reply reply = new Reply() { Com_No = Convert.ToInt32(dr["Com_No"]), R_Content = dr["R_Content"].ToString(), R_Datetime = dr["R_Datetime"].ToString(), R_No = Convert.ToInt32(dr["R_No"]) }; list.Add(reply); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询文章类型信息 /// </summary> /// <returns></returns> public static ArticleType GetArticleTypeByConn(string demandType, string demandContent) { string sql = "Select * from ArticleType where " + demandType + " = @" + demandType; ArticleType articleType = new ArticleType(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { articleType = new ArticleType() { At_Name = dr["At_Name"].ToString(), At_No = Convert.ToInt32(dr["At_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(articleType); }
/// <summary> /// 根据条件查询问题库信息 /// </summary> /// <returns></returns> public static Issue_library GetIssue_libraryByConn(string demandType, string demandContent) { string sql = "Select * from Issue_library where " + demandType + " = @" + demandType; Issue_library obj = new Issue_library(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { obj = new Issue_library() { IssueI_Name = dr["IssueI_Name"].ToString(), IssueI_No = Convert.ToInt32(dr["IssueI_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(obj); }
/// <summary> /// 获取全部网站信息 /// </summary> /// <returns></returns> public static List <WebInfo> GetAllWebInfo() { List <WebInfo> list = new List <WebInfo>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_WebInfo", CommandType.StoredProcedure); while (dr.Read()) { WebInfo webinfo = new WebInfo() { Web_Date = dr["Web_Date"].ToString(), Web_Index = dr["Web_Index"].ToString(), Web_Name = dr["Web_Name"].ToString(), Web_No = Convert.ToInt32(dr["Web_No"]) }; list.Add(webinfo); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询信息统计信息 /// </summary> /// <returns></returns> public static InfoCount GetInfoCountByConn(string demandType, string demandContent) { string sql = "Select * from InfoCount where " + demandType + " = @" + demandType; InfoCount infoCount = new InfoCount(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { infoCount = new InfoCount() { A_No = Convert.ToInt32(dr["A_No"]), IC_Count = Convert.ToInt32(dr["IC_Count"]) }; } dr.Close(); DBHelper.CloseCon(); return(infoCount); }
/// <summary> /// 根据条件查询审核信息 /// </summary> /// <returns></returns> public static Aduit GetAduitByConn(string demandType, string demandContent) { string parameter = "@" + demandType; Aduit aduit = null; string sql = "Select * from Aduit where " + demandType + "=" + parameter; SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter(parameter, demandContent) }); if (dr.Read()) { aduit = new Aduit() { Aduit_Name = dr["Aduit_Name"].ToString(), Aduit_No = Convert.ToInt32(dr["Aduit_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(aduit); }
/// <summary> /// 获取全部评价信息 /// </summary> /// <returns></returns> public static List<Comment> GetAllComment() { List<Comment> list = new List<Comment>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_Comment",CommandType.StoredProcedure); while (dr.Read()) { Comment comment = new Comment() { Aduit_No=Convert.ToInt32( dr["Aduit_No"]), A_No = Convert.ToInt32(dr["A_No"]), Com_Cause= dr["Com_Cause"].ToString(), Com_Datetime = dr["Com_Datetime"].ToString(), Com_Content = dr["Com_Content"].ToString(), Com_No = Convert.ToInt32(dr["Com_No"]), NickName = dr["NickName"].ToString() }; list.Add(comment); } dr.Close(); DBHelper.CloseCon(); return list; }
/// <summary> /// 根据条件查询网站信息 /// </summary> /// <returns></returns> public static WebInfo GetWebInfoByConn(string demandType, string demandContent) { string sql = "Select * from WebInfo where " + demandType + "= @" + demandType; WebInfo webinfo = new WebInfo(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { webinfo = new WebInfo() { Web_Date = dr["Web_Date"].ToString(), Web_Index = dr["Web_Index"].ToString(), Web_Name = dr["Web_Name"].ToString(), Web_No = Convert.ToInt32(dr["Web_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(webinfo); }
/// <summary> /// 获取全部留言信息 /// </summary> /// <returns></returns> public static List <MassageBoard> GetAllMassageBoard() { List <MassageBoard> list = new List <MassageBoard>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_MassageBoard", CommandType.StoredProcedure); while (dr.Read()) { MassageBoard massage = new MassageBoard() { Aduit_No = Convert.ToInt32(dr["Aduit_No"]), Mb_NickName = dr["Mb_NickName"].ToString(), Mb_Cause = dr["Mb_Cause"].ToString(), Mb_Content = dr["Mb_Content"].ToString(), Mb_Datetime = dr["Mb_Datetime"].ToString(), Mb_No = Convert.ToInt32(dr["Mb_No"]) }; list.Add(massage); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 根据条件查询回复信息 /// </summary> /// <returns></returns> public static Reply GetReplyByConn(string demandType, string demandContent) { string sql = "Select * from Reply where " + demandType + " = @" + demandType; Reply reply = new Reply(); SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] { new SqlParameter("@" + demandType, demandContent) }); if (dr.Read()) { reply = new Reply() { Com_No = Convert.ToInt32(dr["Com_No"]), R_Content = dr["R_Content"].ToString(), R_Datetime = dr["R_Datetime"].ToString(), R_No = Convert.ToInt32(dr["R_No"]) }; } dr.Close(); DBHelper.CloseCon(); return(reply); }
/// <summary> /// 获取全部个人信息 /// </summary> /// <returns></returns> public static List <PersonageInfo> GetAllPersonageInfo() { List <PersonageInfo> list = new List <PersonageInfo>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_PersonageInfo", CommandType.StoredProcedure); while (dr.Read()) { PersonageInfo personagerInfo = new PersonageInfo() { P_DataTime = dr["P_DataTime"].ToString(), P_Head = dr["P_Head"].ToString(), P_LoginName = dr["P_LoginName"].ToString(), P_LoginPwd = dr["P_LoginPwd"].ToString(), P_MyExplain = dr["P_MyExplain"].ToString(), P_Phone = dr["P_Phone"].ToString(), P_NickName = dr["P_NickName"].ToString() }; list.Add(personagerInfo); } dr.Close(); DBHelper.CloseCon(); return(list); }
/// <summary> /// 获取全部密保问题信息 /// </summary> /// <returns></returns> public static List <Issue> GetAllIssue() { List <Issue> list = new List <Issue>(); SqlDataReader dr = DBHelper.ExecuteReader("Select_Issue", CommandType.StoredProcedure); while (dr.Read()) { Issue obj = new Issue() { P_LoginName = dr["P_LoginName"].ToString(), Issue_No = Convert.ToInt32(dr["Issue_No"]), Answer_1 = dr["Answer_1"].ToString(), Answer_2 = dr["Answer_2"].ToString(), Answer_3 = dr["Answer_3"].ToString(), Issue_1 = dr["Issue_1"].ToString(), Issue_2 = dr["Issue_2"].ToString(), Issue_3 = dr["Issue_3"].ToString() }; list.Add(obj); } dr.Close(); DBHelper.CloseCon(); return(list); }