/// <summary> /// 得到一个对象实体 /// </summary> public Eyousoft_yhq.Model.MSysCity GetSysCityModel(int ID) { Eyousoft_yhq.Model.MSysCity model = null; string StrSql = "SELECT Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled FROM tbl_SysCity WHERE Id=@Id"; DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); this._db.AddInParameter(dc, "Id", DbType.Int32, ID); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; } }; return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateSysCity(Eyousoft_yhq.Model.MSysCity model) { if (model != null && model.ProvinceId > 0 && !string.IsNullOrEmpty(model.Name)) { return(dal.UpdateSysCity(model)); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool AddSysCity(Eyousoft_yhq.Model.MSysCity model) { string StrSql = "INSERT INTO tbl_SysCity(ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled) VALUES(@ProvinceId,@Name,@CenterCityId,@HeaderLetter,@IsSite,@DomainName,@IsEnabled)"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId); this._db.AddInParameter(dc, "Name", DbType.String, model.Name); this._db.AddInParameter(dc, "CenterCityId", DbType.Int32, model.CenterCityId); this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter); this._db.AddInParameter(dc, "IsSite", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsSite)); this._db.AddInParameter(dc, "DomainName", DbType.String, model.DomainName); this._db.AddInParameter(dc, "IsEnabled", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsEnabled)); return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateSysCity(Eyousoft_yhq.Model.MSysCity model) { string StrSql = "UPDATE tbl_SysCity SET ProvinceId = @ProvinceId,Name = @Name,CenterCityId = @CenterCityId,HeaderLetter = @HeaderLetter,IsSite = @IsSite,DomainName = @DomainName,IsEnabled = @IsEnabled WHERE Id=@Id"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId); this._db.AddInParameter(dc, "Name", DbType.String, model.Name); this._db.AddInParameter(dc, "CenterCityId", DbType.Int32, model.CenterCityId); this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter); this._db.AddInParameter(dc, "IsSite", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsSite)); this._db.AddInParameter(dc, "DomainName", DbType.String, model.DomainName); this._db.AddInParameter(dc, "IsEnabled", DbType.AnsiStringFixedLength, this.GetBooleanToStr(model.IsEnabled)); this._db.AddInParameter(dc, "Id", DbType.Int32, model.Id); return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 是否存在该记录 /// </summary> public bool ExistsSysCity(Eyousoft_yhq.Model.MSysCity model) { string StrSql = " select count(1) from tbl_SysCity WHERE 1=1 "; if (model.Id > 0) { StrSql += " AND Id<>@Id "; } if (!string.IsNullOrEmpty(model.Name)) { StrSql += " AND Name=@Name "; } if (!string.IsNullOrEmpty(model.HeaderLetter)) { StrSql += " AND HeaderLetter=@HeaderLetter "; } if (model.ProvinceId > 0) { StrSql += " AND ProvinceId = @ProvinceId "; } DbCommand dc = this._db.GetSqlStringCommand(StrSql); if (model.Id > 0) { this._db.AddInParameter(dc, "Id", DbType.Int32, model.Id); } if (!string.IsNullOrEmpty(model.Name)) { this._db.AddInParameter(dc, "Name", DbType.String, model.Name); } if (!string.IsNullOrEmpty(model.HeaderLetter)) { this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter); } if (model.ProvinceId > 0) { this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId); } return(DbHelper.Exists(dc, _db)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Eyousoft_yhq.Model.MSysCity GetSysCityModel(int ID) { Eyousoft_yhq.Model.MSysCity model = null; string StrSql = "SELECT Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled FROM tbl_SysCity WHERE Id=@Id"; DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); this._db.AddInParameter(dc, "Id", DbType.Int32, ID); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; } }; return model; }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <param name="filedOrder"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.MSysCity> GetSysCityList(int Top, Eyousoft_yhq.Model.MSysCity chaXun, string filedOrder) { IList<Eyousoft_yhq.Model.MSysCity> ResultList = null; string StrSql = string.Format("SELECT {0} Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled FROM tbl_SysCity WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : "")); if (chaXun != null) { if (chaXun.ProvinceId > -1) { StrSql = StrSql + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (!string.IsNullOrEmpty(chaXun.Name)) { StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.CenterCityId > 0) { StrSql = StrSql + string.Format(" AND CenterCityId={0} ", chaXun.CenterCityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (chaXun.IsSite) { StrSql = StrSql + string.Format(" AND IsSite='{0}'", this.GetBooleanToStr(chaXun.IsSite)); } if (!string.IsNullOrEmpty(chaXun.DomainName)) { StrSql = StrSql + string.Format(" AND DomainName like '%{0}%'", chaXun.DomainName); } if (chaXun.IsEnabled) { StrSql = StrSql + string.Format(" AND IsEnabled='{0}'", this.GetBooleanToStr(chaXun.IsEnabled)); } } StrSql = StrSql + (string.IsNullOrEmpty(filedOrder) ? "" : " ORDER BY " + filedOrder + " ASC "); DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { ResultList = new List<Eyousoft_yhq.Model.MSysCity>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCity model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; ResultList.Add(model); model = null; } } return ResultList; }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.MSysCity> GetSysCityList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysCity chaXun) { IList<Eyousoft_yhq.Model.MSysCity> ResultList = null; string tableName = "tbl_SysCity"; string identityColumnName = "Id"; string fields = "Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled"; string query = " 1=1 "; if (chaXun != null) { if (chaXun.ProvinceId > 0) { query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.CenterCityId > 0) { query = query + string.Format(" AND CenterCityId={0} ", chaXun.CenterCityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" OR HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (chaXun.IsSite) { query = query + string.Format(" AND IsSite='{0}'", this.GetBooleanToStr(chaXun.IsSite)); } if (!string.IsNullOrEmpty(chaXun.DomainName)) { query = query + string.Format(" AND DomainName like '%{0}%'", chaXun.DomainName); } if (chaXun.IsEnabled) { query = query + string.Format(" AND IsEnabled='{0}'", this.GetBooleanToStr(chaXun.IsEnabled)); } } string orderByString = " Id ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query, orderByString, "")) { ResultList = new List<Eyousoft_yhq.Model.MSysCity>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCity model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; ResultList.Add(model); model = null; } }; return ResultList; }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <param name="filedOrder"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCity> GetSysCityList(int Top, Eyousoft_yhq.Model.MSysCity chaXun, string filedOrder) { IList <Eyousoft_yhq.Model.MSysCity> ResultList = null; string StrSql = string.Format("SELECT {0} Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled FROM tbl_SysCity WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : "")); if (chaXun != null) { if (chaXun.ProvinceId > -1) { StrSql = StrSql + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (!string.IsNullOrEmpty(chaXun.Name)) { StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.CenterCityId > 0) { StrSql = StrSql + string.Format(" AND CenterCityId={0} ", chaXun.CenterCityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (chaXun.IsSite) { StrSql = StrSql + string.Format(" AND IsSite='{0}'", this.GetBooleanToStr(chaXun.IsSite)); } if (!string.IsNullOrEmpty(chaXun.DomainName)) { StrSql = StrSql + string.Format(" AND DomainName like '%{0}%'", chaXun.DomainName); } if (chaXun.IsEnabled) { StrSql = StrSql + string.Format(" AND IsEnabled='{0}'", this.GetBooleanToStr(chaXun.IsEnabled)); } } StrSql = StrSql + (string.IsNullOrEmpty(filedOrder) ? "" : " ORDER BY " + filedOrder + " ASC "); DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { ResultList = new List <Eyousoft_yhq.Model.MSysCity>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCity model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; ResultList.Add(model); model = null; } } return(ResultList); }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCity> GetSysCityList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysCity chaXun) { IList <Eyousoft_yhq.Model.MSysCity> ResultList = null; string tableName = "tbl_SysCity"; string identityColumnName = "Id"; string fields = "Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled"; string query = " 1=1 "; if (chaXun != null) { if (chaXun.ProvinceId > 0) { query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.CenterCityId > 0) { query = query + string.Format(" AND CenterCityId={0} ", chaXun.CenterCityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" OR HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (chaXun.IsSite) { query = query + string.Format(" AND IsSite='{0}'", this.GetBooleanToStr(chaXun.IsSite)); } if (!string.IsNullOrEmpty(chaXun.DomainName)) { query = query + string.Format(" AND DomainName like '%{0}%'", chaXun.DomainName); } if (chaXun.IsEnabled) { query = query + string.Format(" AND IsEnabled='{0}'", this.GetBooleanToStr(chaXun.IsEnabled)); } } string orderByString = " Id ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query, orderByString, "")) { ResultList = new List <Eyousoft_yhq.Model.MSysCity>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCity model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; ResultList.Add(model); model = null; } }; return(ResultList); }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCity> GetSysCityList(int Top, Eyousoft_yhq.Model.MSysCity chaXun) { return(dal.GetSysCityList((Top < 0 ? 0 : Top), chaXun, "")); }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCity> GetSysCityList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysCity chaXun) { if (!Utils.ValidPaging(pageSize, pageIndex)) { return(null); } return(dal.GetSysCityList(pageSize, pageIndex, ref recordCount, chaXun)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool ExistsSysCity(Eyousoft_yhq.Model.MSysCity model) { return(dal.ExistsSysCity(model)); }