/// <summary>
/// 获得个人会员类型Model
/// </summary>
/// <param name="TypeId">个人会员类型Model</param>
/// <returns></returns>
public Model.CrmStructure.MCrmMemberType GetCrmMerberTypeModel(int TypeId)
{
DbCommand dc = _db.GetSqlStringCommand(sql_Crm_SelectMemberType);
_db.AddInParameter(dc, "TypeId", DbType.Int32, TypeId);
using (IDataReader reader = DbHelper.ExecuteReader(dc, _db))
{
Model.CrmStructure.MCrmMemberType memberTpeModel = new EyouSoft.Model.CrmStructure.MCrmMemberType();
memberTpeModel.TypeId = TypeId;
memberTpeModel.Name = (string)reader["Name"];
memberTpeModel.CompanyId = (string)reader["CompanyId"];
return(memberTpeModel);
}
}
/// <summary>
/// 获得所有个人会员类型Model
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <returns></returns>
public IList <Model.CrmStructure.MCrmMemberType> GetCrmMerberTypeModelList(string CompanyId)
{
IList <Model.CrmStructure.MCrmMemberType> list = new List <Model.CrmStructure.MCrmMemberType>();
DbCommand dc = _db.GetSqlStringCommand(sql_Crm_SelectAllMemberType);
_db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, CompanyId);
using (IDataReader reader = DbHelper.ExecuteReader(dc, _db))
{
while (reader.Read())
{
Model.CrmStructure.MCrmMemberType memberTpeModel = new EyouSoft.Model.CrmStructure.MCrmMemberType();
memberTpeModel.TypeId = (int)reader["TypeId"];
memberTpeModel.Name = (string)reader["Name"];
memberTpeModel.CompanyId = CompanyId;
list.Add(memberTpeModel);
}
}
return(list);
}
