private void search(searchType searchtype)
{
SqlConnection sqlconnection = new SqlConnection(conStr);
switch (searchtype)
{
case searchType.searchHistory:
{
try
{
sqlconnection.Open();
string comStr = string.Format("select Book_ISBN 图书ISBN,Book_NAME 图书名,Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
+ " from dboBook,dboSearchRecord"
+ " where dboBook.Book_ISBN=dboSearchRecord.SearchRecord_Book_ISBN and dboSearchRecord.SearchRecord_user_IID = \'{0}\'"
+ " order by (dboSearchRecord.SearchRecord_COUNT)", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
MostSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception)
{
}
finally
{
sqlconnection.Close();
}
break;
}
case searchType.borrowHistory:
{
try
{
sqlconnection.Open();
string comStr = string.Format("select Book_NAME 图书名,Borrow_BORROW_TIME 借书日期,Borrow_RETURN_TIME 还书日期, Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
+ " from dboBook,dboBorrow"
+ " where dboBook.Book_ISBN = dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE = 1"
+ " order by (dboBorrow.Borrow_BORROW_TIME)", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
HistotySearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception)
{
}
finally
{
sqlconnection.Close();
}
break;
}
case searchType.borrowNow:
{
try
{
string nowTime = DateTime.Now.Date.ToString().Substring(0, 10);
sqlconnection.Open();
string comStr = string.Format("select Book_NAME 图书名, DateDiff(day, Borrow_BORROW_TIME, '" + nowTime + "') AS 距还书日期_天, Book_MAINAUTHOR 主编,Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介"
+ " from dboBook,dboBorrow"
+ " where dboBook.Book_ISBN=dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE=0"
+ " order by DateDiff(day, Borrow_BORROW_TIME, Borrow_RETURN_TIME) asc", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
BorrowingSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception)
{
MessageBox.Show("error");
}
finally
{
sqlconnection.Close();
}
break;
}
}
}
private void l2D_StripMenuItem_Click(object sender, EventArgs e)
{
type = searchType.L2D;
SSL1.Text = "Linq2DataSet";
}
private void l2XML_StripMenuItem_Click(object sender, EventArgs e)
{
type = searchType.L2X;
SSL1.Text = "Linq2XML";
}
public Form_exp5()
{
InitializeComponent();
type = searchType.L2X;
SSL1.Text = "Linq2XML";
}
private void search(searchType searchtype)
{
SqlConnection sqlconnection = new SqlConnection(conStr);
switch (searchtype)
{
case searchType.searchHistory:
{
try
{
sqlconnection.Open();
string comStr = string.Format("select Book_ISBN 图书ISBN,Book_NAME 图书名,Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
+ " from dboBook,dboSearchRecord"
+ " where dboBook.Book_ISBN=dboSearchRecord.SearchRecord_Book_ISBN and dboSearchRecord.SearchRecord_user_IID = \'{0}\'"
+ " order by (dboSearchRecord.SearchRecord_COUNT)", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
MostSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception)
{
}
finally
{
sqlconnection.Close();
}
break;
}
case searchType.borrowHistory:
{
try
{
sqlconnection.Open();
string comStr = string.Format("select Book_NAME 图书名,Borrow_BORROW_TIME 借书日期,Borrow_RETURN_TIME 还书日期, Book_MAINAUTHOR 主编, Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介,Book_REMAIN 剩余量"
+ " from dboBook,dboBorrow"
+ " where dboBook.Book_ISBN = dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE = 1"
+ " order by (dboBorrow.Borrow_BORROW_TIME)", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
HistotySearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception )
{
}
finally
{
sqlconnection.Close();
}
break;
}
case searchType.borrowNow:
{
try
{
string nowTime = DateTime.Now.Date.ToString().Substring(0,10);
sqlconnection.Open();
string comStr = string.Format("select Book_NAME 图书名, DateDiff(day, Borrow_BORROW_TIME, '" + nowTime +"') AS 距还书日期_天, Book_MAINAUTHOR 主编,Book_SEARCHID 检索号,Book_CLASS 图书类别,Book_PUBLISHER 出版社,Book_INTRODUCTION 图书简介"
+ " from dboBook,dboBorrow"
+" where dboBook.Book_ISBN=dboBorrow.Borrow_Book_ISBN and dboBorrow.Borrow_user_IID = \'{0}\' and dboBorrow.Borrow_BORROW_STATE=0"
+" order by DateDiff(day, Borrow_BORROW_TIME, Borrow_RETURN_TIME) asc", loginID);
DataSet dataSet = SqlCommondClass.GetDataSet(comStr, "result", sqlconnection);
BorrowingSearchFm.dataGridView1.DataSource = dataSet.Tables[0];
}
catch (System.Exception )
{
MessageBox.Show("error");
}
finally
{
sqlconnection.Close();
}
break;
}
}
}
SearchTypeVMs.Add(new SearchTypeVM(searchType, name, toolTip, icon, flags));
