/// <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);
}
