/// <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("修改失败。");
}
}
