public void Initttalbm() { MenuItem TempMenu = TableToApply.AddMenuItem("查看更多"); TempMenu.Click += LookMore; TableToApply.dgMenu.Items.Add(TempMenu); }
private void UpDateRLR(int Sign) { if (Sign == 1) { ApplyRLR.SetValues(UITemp.UserInfoTemp.Ryid, ApplyType); } ApplyRLR.UpdateShowLables(TableToApply.Getdt()); }
public void LookMore(object sender, RoutedEventArgs e) { if (TableToApply.dataGrid.SelectedIndex == -1) { return; } admiw = new ApplyDataMoreInfoWindows(); admiw.SetValues(TableToApply.Getdt(), TableToApply.dataGrid.SelectedIndex, TableToApply.Rows); admiw.Show(); admiw_OpenSign = 1; }
//初始化申请历史表格 private void InitTabelToApply() { TableToApply.InitTableHeightWidth(210, 810); TableToApply.SetCanUserAddRows(false); TableToApply.AddColumns("Ryname", "姓名", 80); TableToApply.AddColumns("ApplyDataID", "资料编号", 100); TableToApply.AddColumns("ApplyCount", "数量", 40); TableToApply.AddColumns("ApplyDate", "申请日期", 170); TableToApply.AddColumns("ApplyID", "申请编号", 80); TableToApply.AddColumns("Status", "同意状态", 80); TableToApply.AddColumns("ApplyReason", "申请原因", 240); }
//申请提交按钮功能 private void ApplicationSubmit_Click(object sender, RoutedEventArgs e) { if (ApplicationMaintenanceCount.Text.Length == 0 || ApplicationEquipmentNumber.Text.Length == 0) { MessageBox.Show("错误:装备编号或申请数量为空!"); } else if (Convert.ToInt32(ApplicationMaintenanceCount.Text) < 0) { MessageBox.Show("错误:申请数量不能负数!"); } else if (ApplicationReasons.Text.Length > 100) { MessageBox.Show("错误:申请原因字数不能超过100!"); } else if (UITemp.GetRyidStatus) { if (UITemp.UserInfoTemp.Position == "") { UITemp.UserInfoTemp.Position = "信息暂无"; } string Date = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString().ToString();;//获取当前时间 string StrSQL = "insert into ApplyMaintain values('" + UITemp.UserInfoTemp.Ryid + "','" + UITemp.UserInfoTemp.RyName + "','" + UITemp.UserInfoTemp.Position + "','" + Date + "','" + ApplicationEquipmentNumber.Text + "'," + ApplicationMaintenanceCount.Text + ",'" + ApplicationReasons.Text + "','未操作')"; try { SqlCommand cmd = new SqlCommand(StrSQL, Temp.GetConn()); cmd.ExecuteNonQuery(); } catch { MessageBox.Show("申请失败!"); return; } MessageBox.Show("申请成功,请耐心等待批准结果。。。"); TableToApply.DataTableSelect(ApplyTableSql, "更新"); //申请成功更新:申请历史表格 UpDataLog(); //更新操作日志 UpDateRLR(0); //更新左下部操作提示 ApplicationHistoryCount.Content = TableToApply.Rows; //更新申请总计 if (mmiw_OpenSign == 1) { mmiw.updata(TableToApply.Getdt(), TableToApply.Rows);//更新查看详细信息窗口的总行数 } } else { MessageBox.Show("个人信息拉取失败或个人信息未填写充分,无法提交申请!"); } }
int admiw_OpenSign; //详细信息窗口标记,0为未打开过! public OrdinaryUsers_Databorrow() { InitializeComponent(); ApplyTableSql = "select * from ApplyData where Ryid='" + UITemp.UserInfoTemp.Ryid + "'"; HistoryTableSql = "select * from DataLend where RyId='" + UITemp.UserInfoTemp.Ryid + "'"; InitTabelToApply(); //申请历史表格初始化 InitTableToHistory(); //借阅历史表格初始化 TableToApply.DataTableSelect(ApplyTableSql, "更新"); Initttalbm(); ApplicationHistoryCount.Content = TableToApply.Rows;//申请总计 TableToHistory.DataTableSelect(HistoryTableSql, "更新"); Inittthlbm(); BorrowHistoryCount.Content = TableToHistory.Rows; //借阅历史总计 UpDateRLR(1); //更新左下侧操作历史 }
int mmiw_OpenSign = 0; //详细信息窗口标记,0为未打开过! public OrdinaryUsers_MaintenanceApplication() { InitializeComponent(); ApplyTableSql = "select * from ApplyMaintain where Ryid='" + UITemp.UserInfoTemp.Ryid + "'"; HistoryTableSql = "select * from ArmsRepair where RyId='" + UITemp.UserInfoTemp.Ryid + "'"; InitTabelToApply(); //申请历史表格初始化 InitTableToHistory(); //借阅历史表格初始化 TableToApply.DataTableSelect(ApplyTableSql, "更新"); Initttalbm(); ApplicationHistoryCount.Content = TableToApply.Rows;//申请总计 TableToHistory.DataTableSelect(HistoryTableSql, "更新"); Inittthlbm(); MaintenanceHistoryCount.Content = TableToHistory.Rows; //借阅历史总计 UpDateRLR(1); //更新左下侧操作历史 }
private void ExportTable_BH_Click(object sender, RoutedEventArgs e) { string[] Str = { "借阅号", "资料编号", "借阅日期", "借阅人编号", "借阅数量", "借阅人名字", "状态" }; TableToApply.ExportExcel(HistoryTableSql, Str, "借阅历史表格.xlsx"); }
private void ExportTable_AH_Click(object sender, RoutedEventArgs e) { string[] Str = { "申请编号", "申请人编号", "申请人名字", "工作岗位", "申请日期", "申请资料编号", "申请数量", "申请原因", "操作状态" }; TableToApply.ExportExcel(ApplyTableSql, Str, "借阅申请历史表格.xlsx"); }
//申请提交按钮功能 private void ApplicationSubmit_Click(object sender, RoutedEventArgs e) { if (ApplicationDataCount.Text.Length == 0 || ApplicationDataNumber.Text.Length == 0) { MessageBox.Show("错误:资料编号或申请数量为空!"); } else if (Convert.ToInt32(ApplicationDataCount.Text) < 0) { MessageBox.Show("错误:申请数量不能负数!"); } else if (ApplicationReasons.Text.Length > 100) { MessageBox.Show("错误:申请原因字数不能超过100!"); } else if (UITemp.GetRyidStatus) { if (UITemp.UserInfoTemp.Position == "") { UITemp.UserInfoTemp.Position = "信息暂无"; } string Date = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString().ToString();;//获取当前时间 string StrSQL1 = "insert into ApplyData values('" + UITemp.UserInfoTemp.Ryid + "','" + UITemp.UserInfoTemp.RyName + "','" + UITemp.UserInfoTemp.Position + "','" + Date + "','" + ApplicationDataNumber.Text + "'," + ApplicationDataCount.Text + ",'" + ApplicationReasons.Text + "','未操作')"; string StrSQL2 = "select * from ArmsData where DataNo ='" + ApplicationDataNumber.Text + "'"; SqlCommand CMD_1 = new SqlCommand(StrSQL2, Temp.GetConn()); SqlDataReader Sdr_1 = CMD_1.ExecuteReader(); if (!Sdr_1.Read()) { MessageBox.Show("错误:暂无编号为 " + ApplicationDataNumber.Text + " 的资料!"); } else { if (Convert.ToInt32(Sdr_1[3].ToString()) < Convert.ToInt32(ApplicationDataCount.Text)) { MessageBox.Show("编号为 " + ApplicationDataNumber.Text + " 的资料,暂不能满足申请数量!"); return; } Sdr_1.Close(); try { CMD_1.CommandText = StrSQL1; CMD_1.ExecuteNonQuery(); } catch { MessageBox.Show("申请失败!"); return; } MessageBox.Show("申请成功,请耐心等待批准结果。。。"); TableToApply.DataTableSelect(ApplyTableSql, "更新"); //申请成功更新:申请历史表格 UpDataLog(); //更新操作日志 UpDateRLR(0); //更新左下部操作提示 ApplicationHistoryCount.Content = TableToApply.Rows; //更新申请总计 if (admiw_OpenSign == 1) { admiw.updata(TableToApply.Getdt(), TableToApply.Rows);//更新查看详细信息窗口的总行数 } } Sdr_1.Close(); } else { MessageBox.Show("个人信息拉取失败或个人信息未填写充分,无法提交申请!"); } }
/* * 功能:导出借阅历史表格按钮事件 */ private void ExportTable_BH_Click(object sender, RoutedEventArgs e) { string[] Str = { "调拨单号", "单号对应申请人编号", "装备编号", "数量", "单价", "调出单位", "调入单位", "调拨类型", "提货人", "有效时间", "批准人", "承办人", "日期", "备注" }; TableToApply.ExportExcel(HistoryTableSql, Str, "装备调拨历史表格.xlsx"); }
private void ApplicationSubmit_Click(object sender, RoutedEventArgs e)//待修改 { if (ApplicationEquipmentCount.Text.Length == 0 || ApplicationEquipmentNumber.Text.Length == 0 || TransferredUnit.Text.Length == 0) { MessageBox.Show("错误:装备编号或申请数量或调入单位为空!"); } else if (Convert.ToInt32(ApplicationEquipmentCount.Text) < 0) { MessageBox.Show("错误:申请数量不能负数!"); } else if (ApplicationReasons.Text.Length > 100) { MessageBox.Show("错误:申请原因字数不能超过100!"); } else if (UITemp.GetRyidStatus) { string Date = DateTime.Now.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToLongTimeString().ToString();; //获取当前时间 if (AllotType.SelectedIndex == 0) { AType = "价拨"; } else { AType = "调拨"; } if (UITemp.UserInfoTemp.Position == "") { UITemp.UserInfoTemp.Position = "信息暂无"; } string StrSQL = "insert into ApplyEquip values('" + UITemp.UserInfoTemp.Ryid + "','" + UITemp.UserInfoTemp.RyName + "','" + UITemp.UserInfoTemp.Position + "','" + Date + "','" + ApplicationEquipmentNumber.Text + "'," + ApplicationEquipmentCount.Text + ",'" + AType + "','" + TransferredUnit.Text + "','" + ApplicationReasons.Text + "','未操作')"; string StrSQL2 = "select * from ArmsSurplus where ZbId ='" + ApplicationEquipmentNumber.Text + "'"; SqlCommand CMD_1 = new SqlCommand(StrSQL2, Temp.GetConn()); SqlDataReader Sdr_1 = CMD_1.ExecuteReader(); if (!Sdr_1.Read()) { MessageBox.Show("错误:仓库暂无编号为 " + ApplicationEquipmentNumber.Text + " 的装备!"); } else { if (Convert.ToInt32(Sdr_1[3].ToString()) < Convert.ToInt32(ApplicationEquipmentCount.Text)) { MessageBox.Show("编号为 " + ApplicationEquipmentNumber.Text + " 的装备,库存不能满足申请数量!"); return; } Sdr_1.Close(); try { CMD_1.CommandText = StrSQL; CMD_1.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show("申请失败!" + ex); return; } MessageBox.Show("申请成功,请耐心等待批准结果。。。"); TableToApply.DataTableSelect(ApplyTableSql, "更新"); //申请成功更新:申请历史表格 UpDataLog(); //更新操作日志 UpDateRLR(0); //更新左下部操作提示 ApplicationHistoryCount.Content = TableToApply.Rows; //更新申请总计 if (aemiw_OpenSign == 1) { aemiw.updata(TableToApply.Getdt(), TableToApply.Rows);//更新查看详细信息窗口的总行数 } } Sdr_1.Close(); } else { MessageBox.Show("个人信息拉取失败或个人信息未填写充分,无法提交申请!"); } }
/* * 功能:导出借阅历史表格按钮事件 */ private void ExportTable_BH_Click(object sender, RoutedEventArgs e) { string[] Str = { "维修记录号", "送修人编号", "送修人姓名", "装备编号", "维修日期", "维修单位", "故障原因", "维修状态", "维修费用", "维修结果", "维修负责人", "提交日期" }; TableToApply.ExportExcel(HistoryTableSql, Str, "维修历史表格.xlsx"); }