/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.FixedAssets model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hownet.Model.FixedAssets model) { return(dal.Update(model)); }
/// <summary> /// 获得数据列表 /// </summary> public List <Hownet.Model.FixedAssets> DataTableToList(DataTable dt) { List <Hownet.Model.FixedAssets> modelList = new List <Hownet.Model.FixedAssets>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { Hownet.Model.FixedAssets model; for (int n = 0; n < rowsCount; n++) { model = new Hownet.Model.FixedAssets(); if (dt.Rows[n]["A"].ToString() != "") { model.A = int.Parse(dt.Rows[n]["A"].ToString()); } if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.Sn = dt.Rows[n]["Sn"].ToString(); model.Barcode = dt.Rows[n]["Barcode"].ToString(); model.Name = dt.Rows[n]["Name"].ToString(); if (dt.Rows[n]["FATypeID"].ToString() != "") { model.FATypeID = int.Parse(dt.Rows[n]["FATypeID"].ToString()); } model.Spec = dt.Rows[n]["Spec"].ToString(); if (dt.Rows[n]["CompanyID"].ToString() != "") { model.CompanyID = int.Parse(dt.Rows[n]["CompanyID"].ToString()); } model.GBCode = dt.Rows[n]["GBCode"].ToString(); model.More = dt.Rows[n]["More"].ToString(); if (dt.Rows[n]["DateOfOut"].ToString() != "") { model.DateOfOut = DateTime.Parse(dt.Rows[n]["DateOfOut"].ToString()); } if (dt.Rows[n]["UseDeparmentID"].ToString() != "") { model.UseDeparmentID = int.Parse(dt.Rows[n]["UseDeparmentID"].ToString()); } if (dt.Rows[n]["UseTypeID"].ToString() != "") { model.UseTypeID = int.Parse(dt.Rows[n]["UseTypeID"].ToString()); } model.StoreAccess = dt.Rows[n]["StoreAccess"].ToString(); if (dt.Rows[n]["Custodian"].ToString() != "") { model.Custodian = int.Parse(dt.Rows[n]["Custodian"].ToString()); } if (dt.Rows[n]["Amount"].ToString() != "") { model.Amount = decimal.Parse(dt.Rows[n]["Amount"].ToString()); } if (dt.Rows[n]["MeasureID"].ToString() != "") { model.MeasureID = int.Parse(dt.Rows[n]["MeasureID"].ToString()); } if (dt.Rows[n]["Price"].ToString() != "") { model.Price = decimal.Parse(dt.Rows[n]["Price"].ToString()); } if (dt.Rows[n]["AddTypeID"].ToString() != "") { model.AddTypeID = int.Parse(dt.Rows[n]["AddTypeID"].ToString()); } if (dt.Rows[n]["OldMoney"].ToString() != "") { model.OldMoney = decimal.Parse(dt.Rows[n]["OldMoney"].ToString()); } if (dt.Rows[n]["NowMoney"].ToString() != "") { model.NowMoney = decimal.Parse(dt.Rows[n]["NowMoney"].ToString()); } if (dt.Rows[n]["Depreciation"].ToString() != "") { model.Depreciation = int.Parse(dt.Rows[n]["Depreciation"].ToString()); } if (dt.Rows[n]["ResidualValue"].ToString() != "") { model.ResidualValue = decimal.Parse(dt.Rows[n]["ResidualValue"].ToString()); } if (dt.Rows[n]["UseDate"].ToString() != "") { model.UseDate = DateTime.Parse(dt.Rows[n]["UseDate"].ToString()); } if (dt.Rows[n]["Interval"].ToString() != "") { model.Interval = int.Parse(dt.Rows[n]["Interval"].ToString()); } if (dt.Rows[n]["DepreciationYear"].ToString() != "") { model.DepreciationYear = int.Parse(dt.Rows[n]["DepreciationYear"].ToString()); } if (dt.Rows[n]["DepreciationMonth"].ToString() != "") { model.DepreciationMonth = int.Parse(dt.Rows[n]["DepreciationMonth"].ToString()); } model.Remark = dt.Rows[n]["Remark"].ToString(); if (dt.Rows[n]["IsOut"].ToString() != "") { if ((dt.Rows[n]["IsOut"].ToString() == "1") || (dt.Rows[n]["IsOut"].ToString().ToLower() == "true")) { model.IsOut = true; } else { model.IsOut = false; } } modelList.Add(model); } } return(modelList); }