/// <summary> /// 确定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { if (this.checkBox1.Checked) { Borrow br = new Borrow(); DataTable Empdt = EmployeeMgr.GetAllName(); br.RAgent = this.name2ID(Empdt, this._user, "name"); br.RDate = this.dtpBDate1.Value; br.rRemark = this.textRRemark.Text; string eqno = this.textEqNO.Text; if (_power == "0" || _power == "1") { bool flag = BoroowMgr.RUpdateWithoutVerify(_id, br); flag = EqMgr.ReturnEq(eqno); untCommon.InfoMsg("归还成功。"); } else { bool flag = BoroowMgr.RUpdate(_id, br); untCommon.InfoMsg("归还待审核。"); } } this.DialogResult = DialogResult.OK; this.Close(); }
/// <summary> /// 进入资产领用界面 /// </summary> private void BoroowEnter() { if (this.dbgEq.Rows.Count == 0) { untCommon.InfoMsg("没有可供领用的资产。"); return; } if (dbgEq.SelectedRows.Count == 0) { untCommon.InfoMsg("请在资产列表中选择所要领用的资产。"); return; } string eqNo = this.dbgEq.SelectedRows[0].Cells[0].Value.ToString(); frmBorrow boroow = new frmBorrow(); //检查选中的资产是否可以借用 int max = BoroowMgr.GetMaxBoroow(eqNo); if (max != -1) { boroow.Max = max; boroow.User = this._user; boroow.Eqno = eqNo; boroow.ShowDialog(); } else { untCommon.InfoMsg("这笔资产已经被领用完了"); } }
/// <summary> /// 查询指定页数的数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFind_Click(object sender, EventArgs e) { if (txtPage.Text.Trim() == "") { untCommon.InfoMsg("请输入所要查询的页数。"); return; } try { curPage = int.Parse(this.txtPage.Text); } catch (FormatException) { untCommon.InfoMsg("所要查询的页数请输入数字。"); return; } if (curPage > TotalPage || curPage < 1) { untCommon.InfoMsg("没有您所要查询的页数。"); return; } DataTable dat = BoroowMgr.getLogList((curPage - 1) * pageCount, pageCount, _departId, _power); if (dat != null) { //绑定数据 dbgBorrow.DataSource = dat.DefaultView; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 初始化资产领用表 /// </summary> private void InitDbgBoroow() { dat = BoroowMgr.GetAll(); dv = new DataView(dat); if (dv != null) { this.dbgBorrow.DataSource = dv; } }
/// <summary> /// //加载个类资产领用情况统计图 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { DataTable dt = BoroowMgr.TypeBorrowSatat(); if (dt != null) { type = new ReportByType(); type.SetDataSource(dt); } }
/// <summary> /// 获取行列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private List <string> GetRowListBySQL(string Column) { DataTable dat = BoroowMgr.getEqRowList(_departId, _power, Column, SortsString); List <string> result = new List <string>();; for (int i = 0; i < dat.Rows.Count; i++) { result.Add(dat.Rows[i][0].ToString()); } return(result); }
/// <summary> /// 刷新筛选数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DataRefreshBySQL() { DataTable dat = BoroowMgr.getSortEqList((curPage - 1) * pageCount, pageCount, _departId, _power, SelectedColumns, SortsString, OrderByString[0]); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 dbgBorrow.DataSource = dat.DefaultView; } this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 首页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFirst_Click(object sender, EventArgs e) { curPage = 1; DataTable dat = BoroowMgr.getSortEqList(0, pageCount, _departId, _power, SelectedColumns, SortsString, OrderByString[0]); if (dat != null) { //绑定数据 dbgBorrow.DataSource = dat.DefaultView; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 领用资产 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { Borrow br = new Borrow(); br.ID = this.textSerialNO.Text; br.EqNo = this.textEqNO.Text; br.EqName = this.textName.Text; DataTable Empdt = EmployeeMgr.GetAllName(); DataTable Depdt = DepartMgr.GetAllDepartment(); br.Department = this.name2ID(Depdt, this.textDepartment.Text, "departName"); br.KeepPlace = this.textKeepPlace.Text; br.Keeper = this.name2ID(Empdt, this.textKeeper.Text, "name"); br.BAgent = this.name2ID(Empdt, _user, "name"); br.Borrower = this.cbxborrower.SelectedValue.ToString(); br.BDate = this.dtpBDate.Value; br.RDate = this.dtpRDate.Value; br.bRemark = this.textBorrowRemark.Text; bool flag; if (updata_flag) { flag = BoroowMgr.BUpdate(ID, br); } else { if (IsEqAvailable(this.textEqNO.Text)) { if (_power == "0" || _power == "1") { flag = BoroowMgr.AddWithoutVerify(br); } else { flag = BoroowMgr.Add(br); } flag = EqMgr.BorrowEq(br.EqNo); if (flag) { untCommon.InfoMsg("出借成功。"); } else { untCommon.InfoMsg("出借失败。"); } } else { untCommon.InfoMsg("该资产状态已改变,无法修改该信息。"); } } this.DialogResult = DialogResult.OK; }
/// <summary> /// 刷新数据 /// </summary> private void DataRefresh() { DataTable dat = BoroowMgr.getLogList((curPage - 1) * pageCount, pageCount, _departId, _power); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 //绑定数据 dbgBorrow.DataSource = dat.DefaultView; } this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 加载报表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { //加载个部门资产领用统计图 if (this.tbcStat.SelectedIndex == 1) { DataTable dt = BoroowMgr.BorrowStat(); if (dt != null) { rptbydepart = new ReportBorrowByDepart(); rptbydepart.SetDataSource(dt); return; } } }
/// <summary> /// 领用资产 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { Borrow br = new Borrow(); if (this.nubCount.Value.ToString() == "") { untCommon.InfoMsg("请输入领用的数量。"); return; } if (int.Parse(this.nubCount.Value.ToString()) == 0) { untCommon.InfoMsg("领用数量不能为0"); return; } if (br.Count > this._max) { untCommon.InfoMsg("您领用的数量不能大于最大可领用数量。"); return; } try { br.depart = this.cbxDepart.Text; } catch (FormatException) { untCommon.InfoMsg("领用数量请在英文输入法状态下输入数字"); return; } br.Booker = this.txtBooker.Text; br.Count = int.Parse(this.nubCount.Value.ToString()); br.Date = this.dtpDate.Value; br.EqNo = this.txtEqNO.Text; br.Borrower = int.Parse(this.cbxEmp.SelectedValue.ToString()); if (BoroowMgr.Add(br)) { untCommon.InfoMsg("您成功的领用了该笔资产。"); this.DialogResult = DialogResult.OK; } else { untCommon.InfoMsg("领用失败。"); } }
public frmBorrow(string ID) { InitializeComponent(); SetStyle(ControlStyles.UserPaint, true); SetStyle(ControlStyles.AllPaintingInWmPaint, true); // 禁止擦除背景. SetStyle(ControlStyles.DoubleBuffer, true); // 双缓冲 updata_flag = true; this.ID = ID; DataTable dt = BoroowMgr.GetOneBorrow(ID); this.defaultBorrower = dt.Rows[0][0].ToString(); this.dtpBDate.Value = Convert.ToDateTime(dt.Rows[0][1].ToString()); this.dtpRDate.Value = Convert.ToDateTime(dt.Rows[0][2].ToString()); this.textBorrowRemark.Text = dt.Rows[0][3].ToString(); this._eqno = dt.Rows[0][4].ToString(); this.frmBorrow_Load(null, null); }
/// <summary> /// 得到某员工领用的某比资产的领用信息 /// </summary> /// <returns>true:成功的取得信息;fasle:查询信息失败</returns> private ArrayList GetBorrowInfo() { DataTable dt = BoroowMgr.GetOneBorrow(this.txtEqNo.Text, int.Parse(this.txtborrower.Text)); if (dt.Rows.Count != 0) { ArrayList al = new ArrayList(); for (int i = 0; i < dt.Columns.Count; i++) { al.Add(dt.Rows[0][i].ToString()); } return(al); } else { return(null); } }
/// <summary> /// 加载资产的资料; /// </summary> private void LoadEqInfo() { DataTable dt = BoroowMgr.GetOneAllBorrow(_id); if (dt != null) { this.textSerialNO.Text = dt.Rows[0][0].ToString(); this.textEqNO.Text = dt.Rows[0][1].ToString(); this.textName.Text = dt.Rows[0][2].ToString(); this.textDepartment.Text = dt.Rows[0][4].ToString(); this.textKeepPlace.Text = dt.Rows[0][5].ToString(); this.textKeeper.Text = dt.Rows[0][6].ToString(); this.textBorrower.Text = dt.Rows[0][7].ToString(); this.textBAgent.Text = dt.Rows[0][8].ToString(); this.textBReviewer.Text = dt.Rows[0][9].ToString(); this.textBDate.Text = dt.Rows[0][10].ToString(); this.textBRemark.Text = dt.Rows[0][11].ToString(); this.textRDate.Text = dt.Rows[0][14].ToString(); } }
/// <summary> /// 得到信息的总页数 /// </summary> /// <returns></returns> private int getTotalPage() { int result = BoroowMgr.LogCount(); int Total; if (result != 0) { int count = BoroowMgr.LogCount() % pageCount; if (count == 0) { Total = BoroowMgr.LogCount() / pageCount; } else { Total = BoroowMgr.LogCount() / pageCount + 1; } } else { Total = 0; } return(Total); }
private void frmBorrowLook_Load(object sender, EventArgs e) { curPage = 1; DataTable dat = BoroowMgr.getLogList(0, pageCount, _departId, _power); if (dat != null) { dbgBorrow.DataSource = dat.DefaultView; AvailableColumns.Clear(); foreach (DataGridViewColumn c in dbgBorrow.Columns) { if (!c.Visible) { continue; } AvailableColumns.Add(c.HeaderText); SelectedColumns.Add(c.HeaderText); } dbgBorrow.ScrollBars = ScrollBars.Both; this.dbgFrozen(); } TotalPage = this.getTotalPage();//得到数据的总页数 this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; }