private void button1_Click(object sender, EventArgs e) { string str = ""; str += " SELECT r.sort ,r.teachermane,sum(s.totalsalary ) totalsalar,avg (s.totalsalary) avgsalary ,count (s.monthes) monthes, sum(s.monthcount ) mothescount FROM Teacher r ,teacher_salary s WHERE r.teacherno = s.teacherno"; str += " AND r.sort <999"; str += " GROUP BY r.sort ,r.teachermane"; str += " ORDER BY r.sort ;"; DataTable dt = Sql_Class.GetDataTable(str, str); double totalsalar = 0; double salar = 0; int monthes = 0; for (int i = 0; i < dt.Rows.Count; i++) { salar = Convert.ToDouble(dt.Rows[i]["totalsalar"]); totalsalar += salar; monthes = Convert.ToInt32(dt.Rows[i]["mothescount"]); if (monthes == 4) { dt.Rows[i]["avgsalary"] = Convert.ToDouble(salar / 4).ToString("0.00"); } else { dt.Rows[i]["avgsalary"] = Convert.ToDouble(salar / 12).ToString("0.00"); } } DataRow dw = dt.NewRow(); dw["totalsalar"] = totalsalar; //dw["monthes"] = monthes; //dw["avgsalary"] = totalsalar / monthes; dw["teachermane"] = "合计"; dt.Rows.Add(dw); this.gridControl1.DataSource = dt; this.gridView1.RefreshData(); }
public PackingList_CONTROL() { sql = new Sql_Class(); }
public YarnReciept_Control() { sql = new Sql_Class(); }
public Delivery_Order() { sql = new Sql_Class(); }
public Contract_Control() { sql = new Sql_Class(); }
public Add_Item() { sql = new Sql_Class(); ofd = new OpenFileDialog(); InitializeComponent(); }
public Invoice_CONTROL() { sql = new Sql_Class(); }