?? dbdetailinfo.cs
字號:
using System;
using System.Data;
using System.Data.SqlClient;
using Data_Common;
using Model;
namespace Data_Access
{
/// <summary>
/// DBDetailInfo 的摘要說明---顏政.。
/// </summary>
public class DBDetailInfo:IDBDetailInfo
{
//定義查詢的字符串
private const string Sql_select_TrainDetailInfo="SELECT * FROM RouteInfo WHERE TrainNO=@TrainNO ORDER BY TrainNO,CityNo";
//定義參數
private const string Parm_TrainNo="@TrainNO";
public DBDetailInfo(){}
//獲取所有參數的
private static SqlParameter[] GetTrainDetailInfo()
{
SqlParameter[] parms=Sqlhelp.GetCachedParameters(Sql_select_TrainDetailInfo);
if(parms==null)
{
parms=new SqlParameter[]{
new SqlParameter(Parm_TrainNo,SqlDbType.VarChar,20)
};
Sqlhelp.CacheParameters(Sql_select_TrainDetailInfo,parms);
}
return parms;
}
/// <summary>
/// 根據列車時刻代碼獲取所有列車信息
/// </summary>
/// <param name="scheduleCode">列車時刻代碼</param>
/// <returns>所有列車信息</returns>
public Train_DetailInfo[] GetTrainDetailInfo(string scheduleCode)
{
SqlParameter[] parms=GetTrainDetailInfo();
parms[0].Value=scheduleCode;
DataTable dt=Sqlhelp.ExecuteDataTable(ConnectionInfo.ConnectionString(),Sql_select_TrainDetailInfo,CommandType.Text,parms);
Train_DetailInfo[] schedule=new Train_DetailInfo[dt.Rows.Count];
Train_DetailInfo x;
for(int i=0;i<dt.Rows.Count;i++)
{
x=new Train_DetailInfo();
x.schedulecode=dt.Rows[i][1].ToString();
x.cityname=dt.Rows[i][2].ToString();
x.arrivaltime=DateTime.Parse(dt.Rows[i][3].ToString());
x.leavetime=DateTime.Parse(dt.Rows[i][4].ToString());;
x.days=int.Parse(dt.Rows[i][5].ToString());
x.distance=int.Parse(dt.Rows[i][6].ToString());
x.cid=int.Parse(dt.Rows[i][7].ToString());
schedule[i]=x;
}
return schedule;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -