public CC_Search_Page()
{
InitializeComponent();
string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from Cost_Detail";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet dataset = new DataSet();
adapter.Fill(dataset); //把查询结果填充到dataset
DataTable table = dataset.Tables[0];
DataRowCollection rows = table.Rows;
ObservableCollection <CostDetail> t = new ObservableCollection <CostDetail>();
for (int i = 0; i < rows.Count; i++)
{
DataRow row = rows[i];
string CostTime = (string)row["CostTime"];
string CostProj = (string)row["CostProj"];
string CostPlace = (string)row["CostPlace"];
Int16 JoinNum = (Int16)row["JoinNum"];
Int32 OCost = (Int32)row["OCost"];
Int32 CostSum = (Int32)row["CostSum"];
Int32 RCost = (Int32)row["RCost"];
Int32 ID = (Int32)row["ID"];
CostDetail info = new CostDetail
{
CostTime = CostTime,
CostProj = CostProj,
CostPlace = CostPlace,
JoinNum = JoinNum,
OCost = OCost,
CostSum = CostSum,
RCost = RCost
};
t.Add(info);
TB_RCOST.Text = Convert.ToString(RCost);
TB_ATY.Text = Convert.ToString(ID);
}
this.datagrid1.ItemsSource = t;
}
}
}
private void BTN_CC_Search_Click(object sender, RoutedEventArgs e)
{
using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=ClassSystem;User ID=sa;Password=root"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.Parameters.Add(new SqlParameter("@S_CC", TB_SI_Sno.Text));
cmd.CommandText = "select * from Cost_Detail where CostTime=@S_CC";
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet dataset = new DataSet();
adapter.Fill(dataset); //把查询结果填充到dataset
DataTable table = dataset.Tables[0];
DataRowCollection rows = table.Rows;
List <CostDetail> t = new List <CostDetail>();
for (int i = 0; i < rows.Count; i++)
{
DataRow row = rows[i];
string CostTime = (string)row["CostTime"];
string CostProj = (string)row["CostProj"];
string CostPlace = (string)row["CostPlace"];
Int16 JoinNum = (Int16)row["JoinNum"];
Int32 OCost = (Int32)row["OCost"];
Int32 CostSum = (Int32)row["CostSum"];
Int32 RCost = (Int32)row["RCost"];
CostDetail info = new CostDetail
{
CostTime = CostTime,
CostProj = CostProj,
CostPlace = CostPlace,
JoinNum = JoinNum,
OCost = OCost,
CostSum = CostSum,
RCost = RCost
};
t.Add(info);
}
this.datagrid1.ItemsSource = t;
}
}
}
