/// <summary> /// 获取固定资产管理实体信息 /// </summary> /// <param name="CompanyId"></param> /// <param name="Id"></param> /// <returns></returns> public EyouSoft.Model.AdminCenterStructure.FixedAsset GetModel(int CompanyId, int Id) { EyouSoft.Model.AdminCenterStructure.FixedAsset model = null; model = (from item in dcDal.FixedAsset where item.CompanyId == CompanyId && item.Id == Id select new EyouSoft.Model.AdminCenterStructure.FixedAsset { Id = item.Id, AssetName = item.AssetName, AssetNo = item.AssetNo, BuyDate = item.BuyDate, Cost = item.Cost, Remark = item.Remark }).FirstOrDefault(); return(model); }
/// <summary> /// 获取固定资产管理信息 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="CompanyId">公司编号</param> /// <param name="FixedAssetNo">固定资产管理编号</param> /// <param name="AssetName">固定资产名称</param> /// <param name="BeginStart">会议时间开始</param> /// <param name="BeginEnd">会议时间结束</param> /// <returns></returns> public IList <EyouSoft.Model.AdminCenterStructure.FixedAsset> GetList(int PageSize, int PageIndex, ref int RecordCount, int CompanyId, string FixedAssetNo, string AssetName, DateTime?BeginStart, DateTime?BeginEnd) { IList <EyouSoft.Model.AdminCenterStructure.FixedAsset> ResultList = null; string tableName = "tbl_FixedAsset"; string identityColumnName = "Id"; string fields = " [Id],[AssetNo],[AssetName],[BuyDate],[Cost],[Remark] "; string query = string.Format("[CompanyId]={0}", CompanyId); if (!string.IsNullOrEmpty(FixedAssetNo)) { query = query + string.Format(" AND AssetNo='{0}'", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(FixedAssetNo)); } if (!string.IsNullOrEmpty(AssetName)) { query = query + string.Format("AND AssetName LIKE '%{0}%' ", EyouSoft.Toolkit.Utils.ReplaceXmlSpecialCharacter(AssetName)); } if (BeginStart.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,'{0}',BuyDate)>=0", BeginStart); } if (BeginEnd.HasValue) { query = query + string.Format(" AND DATEDIFF(DAY,BuyDate,'{0}')>=0", BeginEnd); } string orderByString = " IssueTime DESC"; using (IDataReader dr = DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <EyouSoft.Model.AdminCenterStructure.FixedAsset>(); while (dr.Read()) { EyouSoft.Model.AdminCenterStructure.FixedAsset model = new EyouSoft.Model.AdminCenterStructure.FixedAsset() { Id = dr.GetInt32(dr.GetOrdinal("Id")), AssetName = dr.IsDBNull(dr.GetOrdinal("AssetName")) ? "" : dr.GetString(dr.GetOrdinal("AssetName")), AssetNo = dr.IsDBNull(dr.GetOrdinal("AssetNo")) ? "" : dr.GetString(dr.GetOrdinal("AssetNo")), BuyDate = dr.GetDateTime(dr.GetOrdinal("BuyDate")), Cost = dr.IsDBNull(dr.GetOrdinal("Cost")) ? 0 : dr.GetDecimal(dr.GetOrdinal("Cost")), Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")) }; ResultList.Add(model); model = null; } }; return(ResultList); }
/// <summary> /// 修改 /// </summary> /// <param name="model">固定资产管理实体</param> /// <returns></returns> public bool Update(EyouSoft.Model.AdminCenterStructure.FixedAsset model) { bool IsTrue = false; EyouSoft.Data.FixedAsset DataModel = dcDal.FixedAsset.FirstOrDefault(item => item.Id == model.Id && item.CompanyId == model.CompanyId ); if (DataModel != null) { DataModel.AssetName = model.AssetName; DataModel.AssetNo = model.AssetNo; DataModel.Remark = model.Remark; DataModel.Cost = model.Cost; DataModel.BuyDate = model.BuyDate; dcDal.SubmitChanges(); if (dcDal.ChangeConflicts.Count == 0) { IsTrue = true; } } DataModel = null; return(IsTrue); }
/// <summary> /// 新增 /// </summary> /// <param name="model">固定资产管理实体</param> /// <returns></returns> public bool Add(EyouSoft.Model.AdminCenterStructure.FixedAsset model) { bool IsTrue = false; IsTrue = idal.Add(model); #region LGWR if (IsTrue) { EyouSoft.Model.CompanyStructure.SysHandleLogs logInfo = new EyouSoft.Model.CompanyStructure.SysHandleLogs(); logInfo.CompanyId = 0; logInfo.DepatId = 0; logInfo.EventCode = EyouSoft.Model.CompanyStructure.SysHandleLogsNO.EventCode; logInfo.EventIp = string.Empty; logInfo.EventMessage = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "{0}在" + EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.行政中心_固定资产管理.ToString() + "新增了固定资产信息数据。"; logInfo.EventTime = DateTime.Now; logInfo.EventTitle = "新增固定资产信息"; logInfo.ModuleId = EyouSoft.Model.EnumType.CompanyStructure.SysPermissionClass.行政中心_固定资产管理; logInfo.OperatorId = 0; this.Logwr(logInfo); logInfo = null; } #endregion return(IsTrue); }
/// <summary> /// 新增 /// </summary> /// <param name="model">固定资产管理实体</param> /// <returns></returns> public bool Add(EyouSoft.Model.AdminCenterStructure.FixedAsset model) { bool IsTrue = false; EyouSoft.Data.FixedAsset DataModel = new EyouSoft.Data.FixedAsset() { AssetName = model.AssetName, AssetNo = model.AssetNo, Remark = model.Remark, Cost = model.Cost, BuyDate = model.BuyDate, CompanyId = model.CompanyId, OperatorId = model.OperatorId, IssueTime = System.DateTime.Now }; dcDal.FixedAsset.InsertOnSubmit(DataModel); dcDal.SubmitChanges(); if (dcDal.ChangeConflicts.Count == 0) { IsTrue = true; } DataModel = null; return(IsTrue); }
protected void Page_Load(object sender, EventArgs e) { this.PageType = Eyousoft.Common.Page.PageType.boxyPage; int FixedID = Utils.GetInt(Request["FixedID"], -1); string Method = Utils.GetFormValue("hidMethod"); if (!IsPostBack && FixedID != -1) { //初始化 EyouSoft.BLL.AdminCenterStructure.FixedAsset bllFixedAsset = new EyouSoft.BLL.AdminCenterStructure.FixedAsset(); EyouSoft.Model.AdminCenterStructure.FixedAsset modelFixedAsset = bllFixedAsset.GetModel(CurrentUserCompanyID, FixedID); if (modelFixedAsset != null) { this.hidFixedID.Value = modelFixedAsset.Id.ToString(); Number = modelFixedAsset.AssetNo; AssetName = modelFixedAsset.AssetName; BuyTime = modelFixedAsset.BuyDate; Cost = modelFixedAsset.Cost; Reamrk = modelFixedAsset.Remark; } } if (Method == "save") { EyouSoft.BLL.AdminCenterStructure.FixedAsset bllFixedAsset = new EyouSoft.BLL.AdminCenterStructure.FixedAsset(); EyouSoft.Model.AdminCenterStructure.FixedAsset modelFixedAsset = new EyouSoft.Model.AdminCenterStructure.FixedAsset(); modelFixedAsset.AssetNo = Utils.GetFormValue("txt_Number"); modelFixedAsset.AssetName = Utils.GetFormValue("txt_AssetName"); modelFixedAsset.BuyDate = Utils.GetDateTime(Request.Form["txt_BuyTime"], new DateTime(1990, 01, 01)); modelFixedAsset.Cost = Utils.GetDecimal(Request.Form["txt_Cost"]); modelFixedAsset.Remark = Utils.GetFormValue("txt_Reamrk", 250); modelFixedAsset.CompanyId = CurrentUserCompanyID; if (FixedID == -1) { if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_固定资产管理_新增资产)) { Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.行政中心_固定资产管理_新增资产, true); } if (bllFixedAsset.Add(modelFixedAsset)) { MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "保存成功!", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/fixedAssetsManage/Default.aspx")); } else { MessageBox.Show(this.Page, "保存失败!"); } } if (FixedID != -1) { if (!CheckGrant(global::Common.Enum.TravelPermission.行政中心_固定资产管理_修改资产)) { Utils.ResponseNoPermit(global::Common.Enum.TravelPermission.行政中心_固定资产管理_删除资产, true); } modelFixedAsset.Id = Utils.GetInt(this.hidFixedID.Value); if (bllFixedAsset.Update(modelFixedAsset)) { MessageBox.ResponseScript(this, string.Format("alert('{0}');window.parent.Boxy.getIframeDialog('{1}').hide();window.parent.location='{2}';", "修改成功!", Utils.GetQueryStringValue("iframeId"), "/administrativeCenter/fixedAssetsManage/Default.aspx")); } else { MessageBox.Show(this.Page, "修改失败!"); } } } }