/// <summary> /// 获取列表[团队负责人表+未存在于团队负责人表中的子帐号信息] /// </summary> /// <param name="companyId">公司ID</param> /// <param name="contactName">联系人姓名(若为空,则不作为查询条件)</param> /// <returns></returns> public virtual IList <EyouSoft.Model.CompanyStructure.TourContactInfo> GetList(string companyId, string contactName) { IList <EyouSoft.Model.CompanyStructure.TourContactInfo> list = new List <EyouSoft.Model.CompanyStructure.TourContactInfo>(); DbCommand dc = null; if (string.IsNullOrEmpty(contactName)) { dc = this._database.GetSqlStringCommand(SQL_TourContactList_SELECT_All); } else { dc = this._database.GetSqlStringCommand(SQL_TourContactList_SELECT); } this._database.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, companyId); this._database.AddInParameter(dc, "ContactName", DbType.String, contactName); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { while (dr.Read()) { EyouSoft.Model.CompanyStructure.TourContactInfo model = new EyouSoft.Model.CompanyStructure.TourContactInfo(); model.CompanyID = dr.IsDBNull(dr.GetOrdinal("CompanyID")) == true ? "" : dr.GetString(dr.GetOrdinal("CompanyID")); model.ContactMQId = dr.IsDBNull(dr.GetOrdinal("ContactMQId")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactMQId")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.ContactQQ = dr.IsDBNull(dr.GetOrdinal("ContactQQ")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactQQ")); model.ContactTel = dr.IsDBNull(dr.GetOrdinal("ContactTel")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactTel")); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) == true ? "" : dr.GetString(dr.GetOrdinal("UserName")); list.Add(model); model = null; } } return(list); }
/// <summary> /// 添加团队负责人[若负责人已存在,则修改负责人信息] /// </summary> /// <param name="model">团队负责人实体</param> /// <returns></returns> public virtual bool Add(EyouSoft.Model.CompanyStructure.TourContactInfo model) { int rows = 0; DbCommand dc = this._database.GetStoredProcCommand("proc_TourContactInfo_Insert"); this._database.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyID); this._database.AddInParameter(dc, "ContactName", DbType.String, model.ContactName); this._database.AddInParameter(dc, "ContactTel", DbType.String, model.ContactTel); this._database.AddInParameter(dc, "ContactQQ", DbType.String, model.ContactQQ); this._database.AddInParameter(dc, "ContactMQId", DbType.String, model.ContactMQId); this._database.AddInParameter(dc, "UserName", DbType.String, model.UserName); this._database.AddOutParameter(dc, "ReturnValue", DbType.Int32, 4); DbHelper.RunProcedure(dc, this._database); object obj = this._database.GetParameterValue(dc, "ReturnValue"); if (obj != null) { rows = Convert.ToInt32(obj); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 添加团队负责人[若负责人已存在,则修改负责人信息] /// </summary> /// <param name="model">团队负责人实体</param> /// <returns></returns> public bool Add(EyouSoft.Model.CompanyStructure.TourContactInfo model) { return(idal.Add(model)); }