/// <summary> /// 初始化资产折旧表 /// </summary> private void InitBecomeOld() { new System.Data.DataTable(); dtBecomeOld = EpMgr.BecomeOld(); if (dtBecomeOld != null) { //便利所有的单元格,如果有负数,就将该单元格内的值变成零 for (int row = 0; row < dtBecomeOld.Rows.Count; row++) //控制行的循环 { for (int column = 0; column < dtBecomeOld.Columns.Count; column++) //控制列的循环 { if (dtBecomeOld.Rows[row][column].GetType() == typeof(decimal)) { if (decimal.Parse(dtBecomeOld.Rows[row][column].ToString()) < 0 && dtBecomeOld.Rows[row][column] != null) { dtBecomeOld.Rows[row][column] = "0.0000";//将资产负的现总净值便为零 } } } } this.dbgBecomeOld.DataSource = dtBecomeOld; } }
/// <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 = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 统计出每笔资产的利用率 /// </summary> private void GetEqUseing() { this.dtUseing = EpMgr.eqUing(); if (dtUseing != null) { this.dbgEqUseing.DataSource = dtUseing; } }
/// <summary> /// 接收从主界面传过来的资产编号, /// 并查出该资产的信息放在相应的控件中 /// </summary> private void load() { DataTable dt = EpMgr.GetOneMostInfo(this.Eqno); if (dt != null) { if (dt.Rows.Count != 0) { this.lblEqNo.Text = dt.Rows[0][0].ToString(); this.cbxType.Text = dt.Rows[0][1].ToString(); this.cbxEqName.Text = dt.Rows[0][2].ToString(); this.txtLable.Text = dt.Rows[0][3].ToString(); this.txtModle.Text = dt.Rows[0][4].ToString(); this.txtPluse.Text = dt.Rows[0][5].ToString(); this.nudNum.Value = decimal.Parse(dt.Rows[0][6].ToString()); this.cbxUnit.Text = dt.Rows[0][7].ToString(); this.txtPrice.Text = dt.Rows[0][8].ToString(); this.txtMaker.Text = dt.Rows[0][9].ToString(); this.dtpBirth.Value = DateTime.Parse(dt.Rows[0][10].ToString()); this.cbxAddType.Text = dt.Rows[0][11].ToString(); this.cbxKeepPlace.Text = dt.Rows[0][12].ToString(); this.cbxKeeper.Text = this._keeper; this.txtUsetime.Text = dt.Rows[0][14].ToString(); this.txtBooker.Text = dt.Rows[0][15].ToString(); this.dtpBookDate.Value = DateTime.Parse(dt.Rows[0][16].ToString()); //将查出来的相片放在图片框内 const int oleTypeStart = 20; const int oleTypeLength = 12; // MessageBox.Show(dt.Rows[0][16]) if (!(dt.Rows[0][17] is DBNull)) { byte[] imageBytes = (byte[])(dt.Rows[0][17]); if (imageBytes == null || imageBytes.Length == 0) { return; } MemoryStream photoStream; string type = System.Text.Encoding.ASCII.GetString(imageBytes, oleTypeStart, oleTypeLength); photoStream = new MemoryStream(imageBytes, 0, imageBytes.Length); this.picPhoto.Image = Image.FromStream(photoStream); } else { this.picPhoto.Image = imageList1.Images[0]; //如果没有图片,就将默认图片放在图片框内 } } } }
/// <summary> /// 查询所有信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolbtnSearchAll_Click(object sender, EventArgs e) { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; this.toolStrip3.Enabled = true; } }
/// <summary> /// 首页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnFirst_Click(object sender, EventArgs e) { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 刷新数据 /// </summary> private void DataRefresh() { DataTable dat = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { TotalPage = this.getTotalPage();//得到数据的总页数 //绑定数据 dbgEq.DataSource = dat; } this.lblTotalpage.Text = "共" + TotalPage.ToString() + "页"; this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 初始化资产表 /// </summary> private void InitDbgEq() { curPage = 1; DataTable dat = EpMgr.getEqList(0, pageCount); if (dat != null) { this.dbgEqSet(); //绑定数据 dbgEq.DataSource = dat; dbgEq.ScrollBars = ScrollBars.Both; } }
/// <summary> /// 下一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnNext_Click(object sender, EventArgs e) { if (curPage < TotalPage) { curPage++; } DataTable dat = EpMgr.getEqList((curPage - 1) * pageCount, pageCount); if (dat != null) { //绑定数据 dbgEq.DataSource = dat; } this.lblCurPage.Text = "第" + curPage.ToString() + "页"; }
/// <summary> /// 按登记人查找 /// </summary> public void SearchByBooker(string booker) { DataTable dt = EpMgr.GetInfobyBooker(booker); if (dt != null) { if (dt.Rows.Count != 0) { this.dbgEq.DataSource = dt; } else { untCommon.InfoMsg("没有您所要查找的记录。"); } } }
/// <summary> /// 按资产编号查找 /// </summary> private void SearchByEqno(string eqno) { DataTable dt = EpMgr.GetInfobyEqno(eqno); if (dt != null) { if (dt.Rows.Count != 0) { this.dbgEq.DataSource = dt; } else { untCommon.InfoMsg("没有您所要查找的记录。"); } } }
/// <summary> /// 按增长方式查找 /// </summary> private void searchByAddtype(string addtype) { DataTable dt = EpMgr.GetInfobyAddtype(addtype); if (dt != null) { if (dt.Rows.Count != 0) { this.dbgEq.DataSource = dt; } else { untCommon.InfoMsg("没有您所要查找的记录。"); } } }
/// <summary> /// 按保存地点查找 /// </summary> private void SearchByKeepPlace(string place) { DataTable dt = EpMgr.GetInfobyKeepplace(place); if (dt != null) { if (dt.Rows.Count != 0) { this.dbgEq.DataSource = dt; } else { untCommon.InfoMsg("没有您所要查找的记录。"); } } }
/// <summary> /// 加载资产的资料; /// </summary> private void LoadEqInfo() { DataTable dt = EpMgr.GetOneMostInfo(this._eqno); if (dt != null) { this.txtEqNO.Text = dt.Rows[0][0].ToString(); this.txtName.Text = dt.Rows[0][1].ToString(); this.txtType.Text = dt.Rows[0][2].ToString(); this.txtLabel.Text = dt.Rows[0][3].ToString(); this.txtModel.Text = dt.Rows[0][4].ToString(); this.txtPlus.Text = dt.Rows[0][5].ToString(); this.txtMaxNO.Text = this._max.ToString(); this.txtBooker.Text = this._user; } }
/// <summary> /// 自动产生资产编号 /// </summary> private void SetEqNo() { string No = EpMgr.GetLastEqNo(); string yy = DateTime.Now.Year.ToString().Substring(2); if (No != "") { //如果从数据库中查到有值,就才分字符串后自加1 string eqNo = (int.Parse(No.Substring(7)) + 1).ToString(); lblEqNo.Text = yy + DateTime.Now.ToString("MMdd") + "-" + eqNo; } else { //取当前时间的月,年,和数字拼成编号 string eqno = yy + DateTime.Now.ToString("MMdd") + "-" + "1000"; lblEqNo.Text = eqno; } }
public void GetInfo() { DataTable dt = EpMgr.GetOneBaseInfo(this._eqno); if (dt != null) { if (dt.Rows.Count != 0) { this.lblLabel.Text = dt.Rows[0][1].ToString(); this.lblPrice.Text = dt.Rows[0][2].ToString(); this.lblBirth.Text = dt.Rows[0][3].ToString(); this.lblModel.Text = dt.Rows[0][4].ToString(); this.lblPluse.Text = dt.Rows[0][5].ToString();//5%1%a%s%p%x this.lblUseTime.Text = dt.Rows[0][6].ToString(); this.lblMaker.Text = dt.Rows[0][7].ToString(); //将查出来的相片放在图片框内 const int oleTypeStart = 20; const int oleTypeLength = 12; MemoryStream photoStream; // MessageBox.Show(dt.Rows[0][16]) if (!(dt.Rows[0][8] is DBNull)) { byte[] imageBytes = (byte[])(dt.Rows[0][8]); if (imageBytes == null || imageBytes.Length == 0) { return; } string type = System.Text.Encoding.ASCII.GetString(imageBytes, oleTypeStart, oleTypeLength); photoStream = new MemoryStream(imageBytes, 0, imageBytes.Length); this.pictureBox1.Image = Image.FromStream(photoStream); } else { this.pictureBox1.Image = imageList1.Images[0]; } } } }
/// <summary> /// 得到指定资产的信息 /// </summary> private ArrayList GetInfo() { DataTable dt = EpMgr.GetOneInfo(this.txtEqNo.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 { //untCommon.InfoMsg("该资产不存在,请检查资产编号输入是否正确。"); return(null); } }
/// <summary> /// 初始化将要清理的资产信息 /// </summary> private void load() { DataTable dt = EpMgr.GetOneMostInfo(this._eqno); if (dt != null) { this.lblEqNo.Text = dt.Rows[0][0].ToString(); this.txttype.Text = dt.Rows[0][1].ToString(); this.txtName.Text = dt.Rows[0][2].ToString(); this.txtLable.Text = dt.Rows[0][3].ToString(); this.txtModle.Text = dt.Rows[0][4].ToString(); this.txtPluse.Text = dt.Rows[0][5].ToString(); this.txtTotal.Text = dt.Rows[0][6].ToString(); this.txtUnit.Text = dt.Rows[0][7].ToString(); this.txtPrice.Text = dt.Rows[0][8].ToString(); this.txtMaker.Text = dt.Rows[0][9].ToString(); this.dtpBirth.Value = DateTime.Parse(dt.Rows[0][10].ToString()); this.txtUsetime.Text = dt.Rows[0][14].ToString(); this.txtClear.Text = this._user; this.txtMax.Text = this._max.ToString(); } this.txtCount.Focus(); }
/// <summary> /// 得到信息的总页数 /// </summary> /// <returns></returns> private int getTotalPage() { int result = EpMgr.EqCount(); int Total; if (result != 0) { int count = EpMgr.EqCount() % pageCount; if (count == 0) { Total = EpMgr.EqCount() / pageCount; } else { Total = EpMgr.EqCount() / pageCount + 1; } } else { Total = 0; } return(Total); }
/// <summary> /// 添加资产 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { if (this.checkInput()) { Equipment eq = new Equipment(); eq.Keeper = int.Parse(this.cbxKeeper.SelectedValue.ToString()); eq.KeepPlace = this.cbxKeepPlace.Text; eq.Lable = txtLable.Text; eq.Maker = this.txtMaker.Text; eq.Count = int.Parse(this.nudNum.Value.ToString()); eq.Booker = this.Booker; eq.BookDate = dtpBookDate.Value.ToShortDateString(); eq.AddType = this.cbxAddType.Text; eq.Model = this.txtModle.Text; eq.Plus = this.txtPluse.Text; eq.Unit = this.cbxUnit.Text; eq.Birthday = this.dtpBirth.Value.ToShortDateString(); eq.Name = this.cbxEqName.Text; eq.EqNo = this.lblEqNo.Text; eq.Type = this.cbxType.Text; if (PhotoFilePath == "") { PhotoFilePath = Application.StartupPath + @"\defaultImage\no_image_available_large.gif";; } eq.Photo = PhotoFilePath; try { eq.Price = double.Parse(this.txtPrice.Text); } catch (FormatException) { untCommon.ErrorMsg("单价请输入数字。"); return; } try { eq.UseTime = int.Parse(this.txtUsetime.Text); } catch (FormatException) { untCommon.ErrorMsg("预期寿命请输入数字。"); return; } if (EpMgr.Add(eq)) { untCommon.InfoMsg("添加成功"); ClearInput(); this.PhotoFilePath = ""; picPhoto.Image = imageList1.Images[0]; this.SetEqNo(); } else { untCommon.InfoMsg("添加失败。"); } } }
/// <summary> /// 资产更新 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnOK_Click(object sender, EventArgs e) { Equipment equ = new Equipment(); try { equ.Price = double.Parse(this.txtPrice.Text); } catch (FormatException) { untCommon.ErrorMsg("单价请输入数字。"); return; } if (this.txtPrice.Text.Trim() == "") { untCommon.InfoMsg("请输入资产的单价。"); return; } if (int.Parse(this.txtUsetime.Text) <= 0) { untCommon.InfoMsg("单价请输入大于零的数字"); return; } try { equ.UseTime = int.Parse(this.txtUsetime.Text); } catch (FormatException) { untCommon.ErrorMsg("预期寿命请输入数字。"); return; } if (int.Parse(this.txtUsetime.Text) <= 0) { untCommon.InfoMsg("预计寿命请输入大于零的数字"); return; } if (this.txtUsetime.Text.Trim() == "") { untCommon.InfoMsg("请输入预计寿命"); return; } equ.Keeper = int.Parse(this.cbxKeeper.SelectedValue.ToString()); equ.KeepPlace = this.cbxKeepPlace.Text; equ.Lable = txtLable.Text; equ.Maker = this.txtMaker.Text; equ.Count = int.Parse(this.nudNum.Value.ToString()); equ.Booker = this.txtBooker.Text; equ.BookDate = this.dtpBookDate.Value.ToShortDateString(); equ.AddType = this.cbxAddType.Text; equ.Model = this.txtModle.Text; equ.Plus = this.txtPluse.Text; equ.Unit = this.cbxUnit.Text; equ.UseTime = int.Parse(this.txtUsetime.Text); equ.Birthday = this.dtpBirth.Value.ToShortDateString(); equ.Name = this.cbxEqName.Text; equ.EqNo = this.lblEqNo.Text; equ.Type = this.cbxType.Text; equ.Price = double.Parse(this.txtPrice.Text); equ.Photo = this.PhotoFilePath; if (EpMgr.Update(equ)) { untCommon.InfoMsg("资产更新成功。"); } else { untCommon.InfoMsg("修改失败。"); } }