private void SubmitAdd_Click(object sender, RoutedEventArgs e) { if (Convert.ToInt32(InCount.Text) < 0) { MessageBox.Show("错误:归档数量不能为负数!"); return; } else if (Detail.Text.Length > 100) { MessageBox.Show("错误:说明不能超过一百字!"); return; } string InDate = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString().ToString();; //获取当前时间 string SQL1 = "insert into DataIn values ('" + InDate + "','" + DataNo.Text + "','" + InCount.Text + "','" + Usersname.Text + "','" + Ryname.Text + "','" + Detail.Text + "','" + Flag.Text + "')"; try { SqlCommand CMD_1 = new SqlCommand(SQL1, Temp.GetConn()); CMD_1.ExecuteNonQuery(); } catch { MessageBox.Show("错误:类型编号重复,或不可重复添加!"); return; } TableToDataFile.DataTableSelect(SQLStr, "更新"); dt = TableToDataFile.Getdt(); }
public void Initttalbm()//右键菜单 { MenuItem TempMenu = TableToDataFile.AddMenuItem("删除"); TempMenu.Click += Delete_Click; TableToDataFile.dgMenu.Items.Add(TempMenu); }
int IdCount = 0; //已删除的归档号数量 public ConfidentialMembers_NewEquipmentInformationAdded() { InitializeComponent(); InitTable(); Initttalbm(); TableToDataFile.DataTableSelect(SQLStr, "更新"); TableToDataFile.dataGrid.SelectionChanged += TableToDataFile_SelectionChanged; dt = TableToDataFile.Getdt(); ArchiveTotal.Content = dt.Rows.Count;//获取总行数 }
public void InitTable() { TableToDataFile.InitTableHeightWidth(480, 880); TableToDataFile.SetCanUserAddRows(false); TableToDataFile.AddColumns("Id", "归档号", 80); TableToDataFile.AddColumns("InDate", "归档日期", 80); TableToDataFile.AddColumns("DataNo", "资料编号", 80); TableToDataFile.AddColumns("InCount", "归档数量", 80); TableToDataFile.AddColumns("Username", "经办人", 80); TableToDataFile.AddColumns("Ryname", "审批人", 80); TableToDataFile.AddColumns("Detail", "说明", 300); TableToDataFile.AddColumns("Flag", "审核标记", 75); }
private void ExportThree_Click(object sender, RoutedEventArgs e) { string[] Str = { "申请编号", "申请人编号", "申请人名字", "工作岗位", "申请日期", "申请资料编号", "申请数量", "申请原因", "操作状态" }; TableToDataFile.ExportExcel(SQLStr, Str, "归档表.xlsx"); }