/// <summary>
/// 获得物品实体
/// </summary>
/// <param name="GoodId">物品编号ID</param>
/// <param name="CompanyId">公司编号ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovGood GetGovGoodModel(string GoodId, string CompanyId)
{
EyouSoft.Model.GovStructure.MGovGood model = null;
DbCommand dc = this._db.GetSqlStringCommand("SELECT [GoodId],[CompanyId],[GoodName],[Number],[Price],[Stock],[GoodUse],[InTime],[Remark],[OperatorId],[IssueTime],(SELECT TOP 1 ContactName FROM tbl_ComUser WHERE UserId=tbl_GovGood.OperatorId )AS Operator FROM tbl_GovGood WHERE GoodId=@GoodId AND CompanyId=@CompanyId");
this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, CompanyId);
this._db.AddInParameter(dc, "GoodId", DbType.AnsiStringFixedLength, GoodId);
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
if (dr.Read())
{
model = new EyouSoft.Model.GovStructure.MGovGood()
{
GoodId = dr.GetString(dr.GetOrdinal("GoodId")),
CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")),
Name = dr.IsDBNull(dr.GetOrdinal("GoodName")) ? "" : dr.GetString(dr.GetOrdinal("GoodName")),
Number = !dr.IsDBNull(dr.GetOrdinal("Number")) ? dr.GetInt32(dr.GetOrdinal("Number")) : 0,
Price = !dr.IsDBNull(dr.GetOrdinal("Price")) ? dr.GetDecimal(dr.GetOrdinal("Price")) : 0,
Stock = !dr.IsDBNull(dr.GetOrdinal("Stock")) ? dr.GetInt32(dr.GetOrdinal("Stock")) : 0,
Use = dr.IsDBNull(dr.GetOrdinal("GoodUse")) ? "" : dr.GetString(dr.GetOrdinal("GoodUse")),
Time = !dr.IsDBNull(dr.GetOrdinal("InTime")) ? dr.GetDateTime(dr.GetOrdinal("InTime")) : DateTime.Now,
Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")),
OperatorId = !dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? dr.GetString(dr.GetOrdinal("OperatorId")) : "",
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
Operator = !dr.IsDBNull(dr.GetOrdinal("Operator")) ? dr.GetString(dr.GetOrdinal("Operator")) : ""
};
}
}
return(model);
}
/// <summary>
/// 获得物品实体
/// </summary>
/// <param name="GoodId">物品编号ID</param>
/// <param name="CompanyId">公司编号ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovGood GetGovGoodModel(string GoodId, string CompanyId)
{
EyouSoft.Model.GovStructure.MGovGood model = null;
if (!string.IsNullOrEmpty(GoodId) && !string.IsNullOrEmpty(CompanyId))
{
model = new EyouSoft.Model.GovStructure.MGovGood();
model = dal.GetGovGoodModel(GoodId, CompanyId);
}
return(model);
}
