/// <summary>
/// 添加
/// </summary>
/// <param name="model">待新增公用价格等级实体</param>
/// <returns></returns>
public virtual bool Add(EyouSoft.Model.CompanyStructure.CommonPriceStandAdd model)
{
DbCommand dc = this._database.GetSqlStringCommand(SQL_CommonPriceStandAdd_INSERT);
this._database.AddInParameter(dc, "companyid", DbType.AnsiStringFixedLength, model.CompanyId);
this._database.AddInParameter(dc, "operatorid", DbType.AnsiStringFixedLength, model.OperatorId);
this._database.AddInParameter(dc, "pricestandname", DbType.String, model.PriceStandName);
if (DbHelper.ExecuteSql(dc, this._database) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CompanyStructure.CommonPriceStandAdd> GetList()
{
IList <EyouSoft.Model.CompanyStructure.CommonPriceStandAdd> list = new List <EyouSoft.Model.CompanyStructure.CommonPriceStandAdd>();
EyouSoft.Model.CompanyStructure.CommonPriceStandAdd model = null;
DbCommand dc = this._database.GetSqlStringCommand(SQL_CommonPriceStandAdd_SELECT_List);
using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database))
{
while (dr.Read())
{
model = new EyouSoft.Model.CompanyStructure.CommonPriceStandAdd();
model.ID = dr.GetInt32(dr.GetOrdinal("ID"));
model.CompanyId = dr.GetString(dr.GetOrdinal("companyId"));
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("issueTime"));
model.OperatorId = dr.GetString(dr.GetOrdinal("operatorId"));
model.PriceStandName = dr.GetString(dr.GetOrdinal("priceStandName"));
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">待新增公用价格等级实体</param>
/// <returns></returns>
public virtual bool Add(EyouSoft.Model.CompanyStructure.CommonPriceStandAdd model)
{
return(idal.Add(model));
}
