/// <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); }