private void InitTabelToOutLayIn()
{
TableToOutLayIn.InitTableHeightWidth(460, 878);
TableToOutLayIn.SetCanUserAddRows(false);
TableToOutLayIn.AddColumns("Id", "入账编号", 80);
TableToOutLayIn.AddColumns("Source", "入账来源", 148);
TableToOutLayIn.AddColumns("TypeName", "项目名称", 100);
TableToOutLayIn.AddColumns("InSum", "入账金额", 80);
TableToOutLayIn.AddColumns("Ryname", "经办人", 80);
TableToOutLayIn.AddColumns("InDate", "入账日期", 170);
TableToOutLayIn.AddColumns("Memo", "备注", 220);
}
public FinancialAdministrator_BookingAndHistory()
{
TableSql = "select * from OutlayIn,Types where ItemId = TypeId";
InitializeComponent();
InitTabelToOutLayIn();
TableToOutLayIn.DataTableSelect(TableSql, "更新");
TableToOutLayIn.dataGrid.SelectionChanged += TableToOutLayIn_SelectionChanged;
dt = TableToOutLayIn.Getdt();
Total.Content = dt.Rows.Count;//获取总行数
}
private void button_Click(object sender, RoutedEventArgs e)
{
string Date = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString().ToString();; //获取当前时间
string SQL1 = "insert into OutlayIn values ('" + Source.Text + "','" + Itemld.Text + "','" + InSum.Text + "','" + Ryname.Text + "','" +
Date + "','" + Memo.Text + "')";
string SQL2 = "insert into Types values('" + Itemld.Text + "','" + TypeName.Text + "',2)";
try
{
SqlCommand CMD_1 = new SqlCommand(SQL2, Temp.GetConn());
CMD_1.ExecuteNonQuery();
CMD_1.CommandText = SQL1;
CMD_1.ExecuteNonQuery();
}
catch
{
MessageBox.Show("错误：类型编号重复，或不可重复添加！");
return;
}
TableToOutLayIn.DataTableSelect(TableSql, "更新");
dt = TableToOutLayIn.Getdt();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
string[] Str = { "入账编号", "经费来源", "项目编号", "金额", "经办人", "入账时间",
"备注", "项目编号", "项目名称", "项目标记" };
TableToOutLayIn.ExportExcel("select * from OutlayIn", Str, "入账表格.xlsx");
}
