/// <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, "修改失败!");
}
}
}
}
