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