/// <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() + "页";
}
