private void toolEdit_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modAssetList mod = (modAssetList)DBGrid.CurrentRow.DataBoundItem;
EditAssetList frm = new EditAssetList();
frm.EditItem(mod.AssetId);
if (frm.ShowDialog() == DialogResult.OK)
{
LoadData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void mnuAssetEvaluate_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modAssetList mod = (modAssetList)DBGrid.CurrentRow.DataBoundItem;
dalAssetEvaluate dal = new dalAssetEvaluate();
BindingCollection <modAssetEvaluate> list = dal.GetIList(string.Empty, string.Empty, mod.AssetId, string.Empty, string.Empty, string.Empty, out Util.emsg);
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList(clsTranslate.TranslateString("Asset Evaluate"), list);
frm.ShowDialog();
}
else
{
MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
public void EditItem(string assetid)
{
try
{
this.Cursor = Cursors.WaitCursor;
_action = "EDIT";
modAssetList mod = _dal.GetItem(assetid, out Util.emsg);
if (mod != null)
{
txtAssetId.Text = mod.AssetId;
txtAssetName.Text = mod.AssetName;
txtAssetProperty.Text = mod.AssetProperty;
dtpSignDate.Value = mod.SignDate;
dtpPurchaseDate.Value = mod.PurchaseDate;
txtControlDepart.Text = mod.ControlDepart;
txtUsingDepart.Text = mod.UsingDepart;
cboDepreMethod.SelectedValue = mod.DepreMethod;
txtRawMny.Text = mod.RawMny.ToString();
txtLastMny.Text = mod.LastMny.ToString();
txtRawQty.Text = mod.RawQty.ToString();
txtDepreUnit.Text = mod.DepreUnit;
txtRemark.Text = mod.Remark;
if (mod.Status == 2)
{
status4.Image = Properties.Resources.audited;
Util.ChangeStatus(this, true);
toolSave.Enabled = false;
}
else
{
status4.Image = null;
Util.ChangeStatus(this, false);
toolSave.Enabled = true;
}
}
else
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void btnAssetId_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
dalAssetList dal = new dalAssetList();
BindingCollection <modAssetList> list = dal.GetIList("1", string.Empty, string.Empty, string.Empty, out Util.emsg);
if (list != null && list.Count > 0)
{
frmViewList frm = new frmViewList();
frm.InitViewList("请选择资产：", list);
frm.Selection = true;
if (frm.ShowDialog() == DialogResult.OK)
{
modAssetList mod = dal.GetItem(Util.retValue1, out Util.emsg);
if (mod != null)
{
txtAssetId.Text = mod.AssetId;
txtAssetName.Text = mod.AssetName;
txtNetMny.Text = mod.NetMny.ToString();
}
else
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
if (!string.IsNullOrEmpty(Util.emsg))
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(clsTranslate.TranslateString("No data found!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// get table record
/// <summary>
/// <param name=assetid>assetid</param>
/// <param name=out emsg>return error message</param>
///<returns>get a record detail of assetlist</returns>
public modAssetList GetItem(string assetid, out string emsg)
{
try
{
//Execute a query to read the categories
string sql = string.Format("select asset_id,asset_name,asset_property,status,sign_date,purchase_date,control_depart,using_depart,depre_method,raw_qty,raw_mny,last_mny,depre_unit,remark,update_user,update_time,acc_name,acc_seq from asset_list where asset_id='{0}' order by asset_id", assetid);
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
modAssetList model = new modAssetList();
model.AssetId = dalUtility.ConvertToString(rdr["asset_id"]);
model.AssetName = dalUtility.ConvertToString(rdr["asset_name"]);
model.AssetProperty = dalUtility.ConvertToString(rdr["asset_property"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.SignDate = dalUtility.ConvertToDateTime(rdr["sign_date"]);
model.PurchaseDate = dalUtility.ConvertToDateTime(rdr["purchase_date"]);
model.ControlDepart = dalUtility.ConvertToString(rdr["control_depart"]);
model.UsingDepart = dalUtility.ConvertToString(rdr["using_depart"]);
model.DepreMethod = dalUtility.ConvertToString(rdr["depre_method"]);
model.RawQty = dalUtility.ConvertToDecimal(rdr["raw_qty"]);
model.RawMny = dalUtility.ConvertToDecimal(rdr["raw_mny"]);
model.LastMny = dalUtility.ConvertToDecimal(rdr["last_mny"]);
model.DepreMny = GetDepreMny(model.AssetId, string.Empty);
model.EvaluateLost = GetEvaluateLost(model.AssetId, string.Empty);
model.NetMny = model.RawMny - model.DepreMny - model.EvaluateLost;
model.DepreUnit = dalUtility.ConvertToString(rdr["depre_unit"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
model.AccName = dalUtility.ConvertToString(rdr["acc_name"]);
model.AccSeq = dalUtility.ConvertToInt(rdr["acc_seq"]);
emsg = null;
return(model);
}
else
{
emsg = "Error on read data";
return(null);
}
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void DBGrid_SelectionChanged(object sender, EventArgs e)
{
if (DBGrid.CurrentRow == null)
{
return;
}
modAssetList mod = (modAssetList)DBGrid.CurrentRow.DataBoundItem;
if (mod.DepreMethod == "工作量法")
{
mnuWorkQty.Enabled = true;
}
else
{
mnuWorkQty.Enabled = false;
}
}
public void InitData(modAssetList mod)
{
modAssetWorkQty modw = _dal.GetItem(mod.AssetId, Util.modperiod.AccName, out Util.emsg);
if (modw != null)
{
txtAssetId.Text = modw.AssetId;
txtAssetName.Text = modw.AssetName;
txtQty.Text = modw.WorkQty.ToString();
txtRemark.Text = modw.Remark;
_action = "EDIT";
}
else
{
txtAssetId.Text = mod.AssetId;
txtAssetName.Text = mod.AssetName;
_action = "NEW";
}
Status1.Text = _action;
//Status2.Text = "工量余存：" + mod.LeftQty;
}
/// <summary>
/// update a assetlist
/// <summary>
/// <param name=assetid>assetid</param>
/// <param name=mod>model object of assetlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Update(string assetid, modAssetList mod, out string emsg)
{
try
{
string sql = string.Format("update asset_list set asset_name='{0}',asset_property='{1}',status='{2}',sign_date='{3}',purchase_date='{4}',control_depart='{5}',using_depart='{6}',depre_method='{7}',raw_qty={8},raw_mny={9},last_mny={10},depre_unit='{11}',remark='{12}' where asset_id='{13}'", mod.AssetName, mod.AssetProperty, 1, mod.SignDate, mod.PurchaseDate, mod.ControlDepart, mod.UsingDepart, mod.DepreMethod, mod.RawQty, mod.RawMny, mod.LastMny, mod.DepreUnit, mod.Remark, assetid);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
/// <summary>
/// insert a assetlist
/// <summary>
/// <param name=mod>model object of assetlist</param>
/// <param name=out emsg>return error message</param>
/// <returns>true/false</returns>
public bool Insert(modAssetList mod, out string emsg)
{
try
{
string sql = string.Format("insert into asset_list(asset_id,asset_name,asset_property,status,sign_date,purchase_date,control_depart,using_depart,depre_method,raw_qty,last_mny,depre_unit,remark,update_user,update_time)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}',{9},{10},'{11}','{12}','{13}',getdate())", mod.AssetId, mod.AssetName, mod.AssetProperty, mod.Status, mod.SignDate, mod.PurchaseDate, mod.ControlDepart, mod.UsingDepart, mod.DepreMethod, mod.RawQty, mod.RawMny, mod.LastMny, mod.DepreUnit, mod.Remark, mod.UpdateUser);
int i = SqlHelper.ExecuteNonQuery(sql);
if (i > 0)
{
emsg = null;
return(true);
}
else
{
emsg = "Unknown error when ExecuteNonQuery!";
return(false);
}
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(false);
}
}
private void mnuWorkQty_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (DBGrid.CurrentRow == null)
{
return;
}
modAssetList mod = (modAssetList)DBGrid.CurrentRow.DataBoundItem;
EditWorkQty frm = new EditWorkQty();
frm.InitData(mod);
frm.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// get all assetlist
/// <summary>
/// <param name=statuslist>statuslist</param>
/// <param name=assetidlist>assetidlist</param>
/// <param name=assetname>assetname</param>
/// <param name=out emsg>return error message</param>
///<returns>details of all assetlist</returns>
public BindingCollection <modAssetList> GetIList(string statuslist, string assetidlist, string assetname, string endaccname, out string emsg)
{
try
{
BindingCollection <modAssetList> modellist = new BindingCollection <modAssetList>();
//Execute a query to read the categories
string statuswhere = string.Empty;
if (!string.IsNullOrEmpty(statuslist) && statuslist.CompareTo("ALL") != 0)
{
statuswhere = "and status in ('" + statuslist.Replace(",", "','") + "') ";
}
string assetidwhere = string.Empty;
if (!string.IsNullOrEmpty(assetidlist) && assetidlist.CompareTo("ALL") != 0)
{
assetidwhere = "and asset_id in ('" + assetidlist.Replace(",", "','") + "') ";
}
string assetnamewhere = string.Empty;
if (!string.IsNullOrEmpty(assetname) && assetname.CompareTo("ALL") != 0)
{
assetnamewhere = "and asset_name like '%" + assetname + "%' ";
}
string sql = "select asset_id,asset_name,asset_property,status,sign_date,purchase_date,control_depart,using_depart,depre_method,raw_qty,raw_mny,last_mny,depre_unit,remark,update_user,update_time,acc_name,acc_seq "
+ "from asset_list where 1=1 " + statuswhere + assetidwhere + assetnamewhere + " order by asset_id";
using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql))
{
while (rdr.Read())
{
modAssetList model = new modAssetList();
model.AssetId = dalUtility.ConvertToString(rdr["asset_id"]);
model.AssetName = dalUtility.ConvertToString(rdr["asset_name"]);
model.AssetProperty = dalUtility.ConvertToString(rdr["asset_property"]);
model.Status = dalUtility.ConvertToInt(rdr["status"]);
model.SignDate = dalUtility.ConvertToDateTime(rdr["sign_date"]);
model.PurchaseDate = dalUtility.ConvertToDateTime(rdr["purchase_date"]);
model.ControlDepart = dalUtility.ConvertToString(rdr["control_depart"]);
model.UsingDepart = dalUtility.ConvertToString(rdr["using_depart"]);
model.DepreMethod = dalUtility.ConvertToString(rdr["depre_method"]);
model.RawQty = dalUtility.ConvertToDecimal(rdr["raw_qty"]);
model.RawMny = dalUtility.ConvertToDecimal(rdr["raw_mny"]);
model.LastMny = dalUtility.ConvertToDecimal(rdr["last_mny"]);
model.DepreMny = GetDepreMny(model.AssetId, endaccname);
model.EvaluateLost = GetEvaluateLost(model.AssetId, endaccname);
model.NetMny = model.RawMny - model.DepreMny - model.EvaluateLost;
model.DepreUnit = dalUtility.ConvertToString(rdr["depre_unit"]);
model.Remark = dalUtility.ConvertToString(rdr["remark"]);
model.UpdateUser = dalUtility.ConvertToString(rdr["update_user"]);
model.UpdateTime = dalUtility.ConvertToDateTime(rdr["update_time"]);
model.AccName = dalUtility.ConvertToString(rdr["acc_name"]);
model.AccSeq = dalUtility.ConvertToInt(rdr["acc_seq"]);
modellist.Add(model);
}
}
emsg = null;
return(modellist);
}
catch (Exception ex)
{
emsg = dalUtility.ErrorMessage(ex.Message);
return(null);
}
}
private void toolSave_Click(object sender, EventArgs e)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (dtpSignDate.Value < Util.modperiod.StartDate)
{
MessageBox.Show("该日期的数据已锁定,不能更新数据!", clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
dtpSignDate.Focus();
return;
}
if (cboDepreMethod.SelectedValue == null || string.IsNullOrEmpty(cboDepreMethod.SelectedValue.ToString()))
{
MessageBox.Show(clsTranslate.TranslateString("Depre Method") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cboDepreMethod.Focus();
return;
}
if (string.IsNullOrEmpty(txtRawMny.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Start Mny") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawMny.Focus();
return;
}
else if (!Util.IsNumeric(txtRawMny.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Start Mny") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawMny.Focus();
return;
}
else if (Convert.ToDecimal(txtRawMny.Text.Trim()) <= 0)
{
MessageBox.Show(clsTranslate.TranslateString("Start Mny") + clsTranslate.TranslateString(" must > 0!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawMny.Focus();
return;
}
if (string.IsNullOrEmpty(txtLastMny.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Last Mny") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtLastMny.Focus();
return;
}
else if (!Util.IsNumeric(txtLastMny.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Last Mny") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtLastMny.Focus();
return;
}
else if (Convert.ToDecimal(txtLastMny.Text.Trim()) < 0)
{
MessageBox.Show(clsTranslate.TranslateString("Last Mny") + clsTranslate.TranslateString(" must >= 0!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtLastMny.Focus();
return;
}
if (string.IsNullOrEmpty(txtRawQty.Text.Trim()))
{
MessageBox.Show(clsTranslate.TranslateString("Raw Qty") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawQty.Focus();
return;
}
else if (!Util.IsNumeric(txtRawQty.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Raw Qty") + clsTranslate.TranslateString(" must be a numeric!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawQty.Focus();
return;
}
else if (Convert.ToDecimal(txtRawQty.Text.Trim()) <= 0)
{
MessageBox.Show(clsTranslate.TranslateString("Raw Qty") + clsTranslate.TranslateString(" must > 0!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtRawQty.Focus();
return;
}
if (string.IsNullOrEmpty(txtAssetName.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Asset Name") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtAssetName.Focus();
return;
}
if (string.IsNullOrEmpty(txtDepreUnit.Text))
{
MessageBox.Show(clsTranslate.TranslateString("Depre Unit") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtDepreUnit.Focus();
return;
}
if (cboDepreMethod.SelectedValue == null)
{
MessageBox.Show(clsTranslate.TranslateString("Depre Method") + clsTranslate.TranslateString(" can not be null!"), clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
cboDepreMethod.Focus();
return;
}
modAssetList mod = new modAssetList();
mod.AssetId = txtAssetId.Text.Trim();
mod.AssetName = txtAssetName.Text.Trim();
mod.AssetProperty = txtAssetProperty.Text.Trim();
mod.ControlDepart = txtControlDepart.Text.Trim();
mod.UsingDepart = txtUsingDepart.Text.Trim();
mod.SignDate = dtpSignDate.Value;
mod.PurchaseDate = dtpPurchaseDate.Value;
mod.DepreMethod = cboDepreMethod.SelectedValue.ToString();
mod.DepreUnit = txtDepreUnit.Text.Trim();
mod.RawMny = Convert.ToDecimal(txtRawMny.Text);
mod.LastMny = Convert.ToDecimal(txtLastMny.Text);
mod.RawQty = Convert.ToDecimal(txtRawQty.Text);
mod.Remark = txtRemark.Text.Trim();
mod.UpdateUser = Util.UserId;
mod.Status = 0;
bool ret;
if (_action == "ADD" || _action == "NEW")
{
ret = _dal.Insert(mod, out Util.emsg);
}
else
{
ret = _dal.Update(mod.AssetId, mod, out Util.emsg);
}
if (ret)
{
this.DialogResult = DialogResult.OK;
this.Dispose();
}
else
{
MessageBox.Show(Util.emsg, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, clsTranslate.TranslateString("Information"), MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
finally
{
this.Cursor = Cursors.Default;
}
}
