/// <summary> /// 进入清理资产界面 /// </summary> private void ClearEnter() { frmClear clear = new frmClear(); //查选中的资产是否能够清理 if (this.dbgEq.Rows.Count != 0)//资产列表中有数据 { string eqno = this.dbgEq.SelectedRows[0].Cells[0].Value.ToString(); int max = ClearMgr.GetMaxClear(eqno); //可以清理 if (max != -1) { clear.User = this._user; clear.Max = max; clear.Eqno = eqno; clear.ShowDialog(); } else { untCommon.InfoMsg("该笔资产目前全部都正在使用,不能清理。"); } } 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 = ClearMgr.getLogList((curPage - 1) * pageCount, pageCount, _departId, _power); if (dat != null) { //绑定数据 dbgClear.DataSource = dat.DefaultView; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
public void InitDbg() { dat = ClearMgr.GetAll(); dv = new DataView(dat); if (dat != null) { this.dbgClear.DataSource = dv; } }
/// <summary> /// 获取行列表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private List <string> GetRowListBySQL(string Column) { DataTable dat = ClearMgr.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 = ClearMgr.getSortEqList((curPage - 1) * pageCount, pageCount, _departId, _power, SelectedColumns, SortsString, OrderByString[0]); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 dbgClear.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 = ClearMgr.getSortEqList(0, pageCount, _departId, _power, SelectedColumns, SortsString, OrderByString[0]); if (dat != null) { //绑定数据 dbgClear.DataSource = dat.DefaultView; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
private void InitCombo() { DataTable dtType = ClearMgr.GetAllClearType(); this.cbxClearType.DataSource = dtType; this.cbxClearType.DisplayMember = "discrip"; this.cbxClearType.ValueMember = "id"; if (!string.IsNullOrWhiteSpace(defaultType)) { this.cbxClearType.SelectedText = defaultType; } }
/// <summary> /// 刷新数据 /// </summary> private void DataRefresh() { DataTable dat = ClearMgr.getLogList((curPage - 1) * pageCount, pageCount, _departId, _power); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 //绑定数据 dbgClear.DataSource = dat.DefaultView; } this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
public frmClear(string ID, bool view_only) { InitializeComponent(); SetStyle(ControlStyles.UserPaint, true); SetStyle(ControlStyles.AllPaintingInWmPaint, true); // 禁止擦除背景. SetStyle(ControlStyles.DoubleBuffer, true); // 双缓冲 updata_flag = true; this.ID = ID; this.view_only = view_only; DataTable dt = ClearMgr.GetOneClear(ID); this.defaultType = dt.Rows[0][0].ToString(); this.dtpDate.Value = Convert.ToDateTime(dt.Rows[0][1].ToString()); this.textRemark.Text = dt.Rows[0][2].ToString(); this._eqno = dt.Rows[0][3].ToString(); this.frmClear_Load(null, null); }
/// <summary> /// 得到信息的总页数 /// </summary> /// <returns></returns> private int getTotalPage() { int result = ClearMgr.LogCount(); int Total; if (result != 0) { int count = ClearMgr.LogCount() % pageCount; if (count == 0) { Total = ClearMgr.LogCount() / pageCount; } else { Total = ClearMgr.LogCount() / pageCount + 1; } } else { Total = 0; } return(Total); }
private void frmClearLook_Load(object sender, EventArgs e) { curPage = 1; DataTable dat = ClearMgr.getLogList(0, pageCount, _departId, _power); if (dat != null) { dbgClear.DataSource = dat.DefaultView; AvailableColumns.Clear(); foreach (DataGridViewColumn c in dbgClear.Columns) { if (!c.Visible) { continue; } AvailableColumns.Add(c.HeaderText); SelectedColumns.Add(c.HeaderText); } dbgClear.ScrollBars = ScrollBars.Both; this.dbgFrozen(); } TotalPage = this.getTotalPage();//得到数据的总页数 this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; }
private void frmRemark_Load(object sender, EventArgs e) { if (view_only) { this.label1.Text = "审核意见:"; switch (tab_index) { case 0: textBox1.Text = EqMgr.GetAuditFromID(ID); break; case 1: textBox1.Text = ClearMgr.GetAuditFromID(ID); break; case 2: textBox1.Text = EqMgr.GetAuditFromID(ID); break; default: break; } } }
private void btnOk_Click(object sender, EventArgs e) { try { if (int.Parse(txtCount.Text) > int.Parse(txtMax.Text)) { untCommon.InfoMsg("清理数量不能大于可清理数量"); return; } } catch (FormatException) { untCommon.ErrorMsg("发生错误,清理数量请在英文输入状态下输入数字"); return; } Clear cl = new Clear(); cl.Mark = this.txtRemark.Text; cl.EqNo = this.lblEqNo.Text; cl.ClearType = this.cbxClearType.Text; cl.Count = int.Parse(this.txtCount.Text); cl.Clearer = this.txtClear.Text; cl.ClearDate = this.dtpBookDate.Value.ToShortDateString(); if (untCommon.QuestionMsg("清理资产请慎重,确定要清理吗?")) { if (ClearMgr.Clear(cl)) { untCommon.InfoMsg("清理成功。"); this.DialogResult = DialogResult.OK; } else { untCommon.InfoMsg("清理失败。"); } } }
private void btnOk_Click(object sender, EventArgs e) { if (view_only) { untCommon.InfoMsg("当前无法修改。"); } else { Clear clear = new Clear(); clear.ID = this.textSerialNO.Text; clear.EqNo = this.textEqNO.Text; clear.EqName = this.textName.Text; DataTable Empdt = EmployeeMgr.GetAllName(); DataTable Depdt = DepartMgr.GetAllDepartment(); clear.Department = this.name2ID(Depdt, this.textDepartment.Text, "departName"); clear.KeepPlace = this.textKeepPlace.Text; clear.Keeper = this.name2ID(Empdt, this.textKeeper.Text, "name"); clear.CType = this.cbxClearType.Text; clear.CAgent = this.name2ID(Empdt, _user, "name"); clear.CDate = this.dtpDate.Value; clear.Remark = this.textRemark.Text; bool flag; if (updata_flag) { flag = ClearMgr.CUpdate(ID, clear); if (flag) { untCommon.InfoMsg("修改成功。"); } else { untCommon.InfoMsg("修改失败。"); } } else { if (IsEqAvailable(this.textEqNO.Text)) { if (_power == "0" || _power == "1") { flag = ClearMgr.AddWithoutVerify(clear); untCommon.InfoMsg("注销成功。"); } else { flag = ClearMgr.Add(clear); untCommon.InfoMsg("注销成功待审核。"); } flag = EqMgr.ClearEq(clear.EqNo); if (!flag) { untCommon.InfoMsg("注销失败。"); } } else { untCommon.InfoMsg("该资产状态已改变,无法修改该信息。"); } } this.DialogResult = DialogResult.OK; } }