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