/// <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;
}
}
