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