//初始化借阅历史表格
private void InitTableToHistory()
{
TableToHistory.InitTableHeightWidth(210, 810);
TableToHistory.SetCanUserAddRows(false);
TableToHistory.AddColumns("Id", "借阅号", 80);
TableToHistory.AddColumns("DataNo", "资料编号", 100);
TableToHistory.AddColumns("LendDate", "借阅日期", 220);
TableToHistory.AddColumns("RyId", "借阅人编号", 120);
TableToHistory.AddColumns("LendCount", "借阅数量", 80);
TableToHistory.AddColumns("Ryname", "借阅人名字", 110);
TableToHistory.AddColumns("Flag", "状态", 80);
}
//初始化借阅历史表格
private void InitTableToHistory()
{
TableToHistory.InitTableHeightWidth(210, 810);
TableToHistory.SetCanUserAddRows(false);
TableToHistory.AddColumns("Zbid", "装备编号", 80);
TableToHistory.AddColumns("ANum", "数量", 100);
TableToHistory.AddColumns("Zbprice", "单价", 80);
TableToHistory.AddColumns("InDep", "调入单位", 120);
TableToHistory.AddColumns("Atype", "类型", 80);
TableToHistory.AddColumns("Person", "提货人", 110);
TableToHistory.AddColumns("ADate", "日期", 220);
}
//初始化借阅历史表格
private void InitTableToHistory()
{
TableToHistory.InitTableHeightWidth(210, 810);
TableToHistory.SetCanUserAddRows(false);
TableToHistory.AddColumns("RepId", "维修记录号", 100);
TableToHistory.AddColumns("ZbId", "装备编号", 80);
TableToHistory.AddColumns("RepairDate", "维修日期", 100);
TableToHistory.AddColumns("Unit", "维修单位", 140);
TableToHistory.AddColumns("Cost", "费用", 120);
TableToHistory.AddColumns("Status", "维修状态", 80);
TableToHistory.AddColumns("Result", "维修结果", 110);
TableToHistory.AddColumns("PostDate", "提交日期", 80);
}
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); //更新左下侧操作历史
}
public void Inittthlbm()
{
string Str = "无操作";
TableToHistory.dgMenu.Items.Add(TableToHistory.AddMenuItem(Str));
}
