/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">MQ推荐批发商实体</param>
/// <returns>返回受影响行数</returns>
public int Add(EyouSoft.Model.MQStructure.IMCommendComapny model)
{
if (model == null)
{
return(0);
}
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="OperatorId">推荐人姓名(为null不作条件)</param>
/// <param name="CompanyId">推荐人公司编号(为null不作条件)</param>
/// <param name="CompanyName">推荐人公司名称(为null不作条件)</param>
/// <param name="DescCompanyName">被推荐的公司名称(为null不作条件)</param>
/// <returns>返回MQ推荐批发商实体集合</returns>
public virtual IList <Model.MQStructure.IMCommendComapny> GetList(string OperatorId, string CompanyId, string CompanyName
, string DescCompanyName)
{
IList <Model.MQStructure.IMCommendComapny> List = new List <Model.MQStructure.IMCommendComapny>();
string strWhere = " where 1 = 1 ";
if (!string.IsNullOrEmpty(OperatorId))
{
strWhere += string.Format(" and OperatorId = '{0}' ", OperatorId);
}
if (!string.IsNullOrEmpty(CompanyId))
{
strWhere += string.Format(" and CompanyId = '{0}' ", CompanyId);
}
if (!string.IsNullOrEmpty(CompanyName))
{
strWhere += string.Format(" and CompanyName like '%{0}%' ", CompanyName);
}
if (!string.IsNullOrEmpty(DescCompanyName))
{
strWhere += string.Format(" and DescCompanyName like '%{0}%' ", DescCompanyName);
}
DbCommand dc = base.MQStore.GetSqlStringCommand(Sql_Select + strWhere);
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore))
{
Model.MQStructure.IMCommendComapny model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMCommendComapny();
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
model.Id = int.Parse(dr["Id"].ToString());
}
model.OperatorId = dr["OperatorId"].ToString();
model.OperatorName = dr["OperatorName"].ToString();
model.CompanyId = dr["CompanyId"].ToString();
model.CompanyName = dr["CompanyName"].ToString();
model.DescCompanyName = dr["DescCompanyName"].ToString();
model.DescContactName = dr["DescContactName"].ToString();
model.DescContactTel = dr["DescContactTel"].ToString();
model.DescContactMobile = dr["DescContactMobile"].ToString();
model.DescCompanyArea = dr["DescCompanyArea"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
List.Add(model);
}
model = null;
}
return(List);
}
