/// <summary> /// 更新一条数据 /// </summary> public bool UpdateSysProvince(Eyousoft_yhq.Model.MSysProvince model) { if (model != null && model.ID > 0 && !string.IsNullOrEmpty(model.Name)) { return(dal.UpdateSysProvince(model)); } else { return(false); } }
/// <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.MSysProvince> GetSysProvinceList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysProvince chaXun) { IList <Eyousoft_yhq.Model.MSysProvince> ResultList = null; string tableName = "tbl_SysProvince"; string fields = "ID, CountryId,HeaderLetter,Name,AreaId,SortId,(select [Id],[ProvinceId],[Name],[CenterCityId],[HeaderLetter],[IsSite],[DomainName],[IsEnabled] from tbl_SysCity where tbl_SysCity.ProvinceId = tbl_SysProvince.ID for xml raw,root('Root')) as CityList "; string query = " 1=1 "; if (chaXun != null) { if (chaXun.CountryId > 0) { query = query + string.Format(" AND CountryId={0} ", chaXun.CountryId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.AreaId > 0) { query = query + string.Format(" AND AreaId={0} ", chaXun.AreaId); } } string orderByString = " ID ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query , orderByString, string.Empty)) { ResultList = new List <Eyousoft_yhq.Model.MSysProvince>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysProvince model = new Eyousoft_yhq.Model.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; if (!dr.IsDBNull(dr.GetOrdinal("CityList"))) { model.CityList = (List <Eyousoft_yhq.Model.MSysCity>) this.GetCity(dr.GetString(dr.GetOrdinal("CityList"))); } ResultList.Add(model); model = null; } }; return(ResultList); }
/// <summary> /// 增加一条数据 /// </summary> public bool AddSysProvince(Eyousoft_yhq.Model.MSysProvince model) { string StrSql = "INSERT INTO tbl_SysProvince(CountryId,HeaderLetter,Name,AreaId,SortId) VALUES(@CountryId,@HeaderLetter,@Name,@AreaId,@SortId)"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "CountryId", DbType.Int32, model.CountryId); this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter); this._db.AddInParameter(dc, "Name", DbType.String, model.Name); this._db.AddInParameter(dc, "AreaId", DbType.Int32, model.AreaId); this._db.AddInParameter(dc, "SortId", DbType.Int32, model.SortId); return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdateSysProvince(Eyousoft_yhq.Model.MSysProvince model) { string StrSql = "UPDATE tbl_SysProvince SET CountryId=@CountryId,HeaderLetter=@HeaderLetter,Name=@Name,AreaId=@AreaId,SortId=@SortId WHERE ID=@ID"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "CountryId", DbType.Int32, model.CountryId); this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter); this._db.AddInParameter(dc, "Name", DbType.String, model.Name); this._db.AddInParameter(dc, "AreaId", DbType.Int32, model.AreaId); this._db.AddInParameter(dc, "SortId", DbType.Int32, model.SortId); this._db.AddInParameter(dc, "ID", DbType.Int32, model.ID); return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 是否存在该记录 /// </summary> public bool ExistsSysProvince(Eyousoft_yhq.Model.MSysProvince model) { string StrSql = " select count(1) from tbl_SysProvince 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.CountryId > 0) { StrSql += " AND CountryId = @CountryId "; } if (model.AreaId > 0) { StrSql += " AND AreaId = @AreaId "; } 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.CountryId > 0) { this._db.AddInParameter(dc, "CountryId", DbType.Int32, model.CountryId); } if (model.AreaId > 0) { this._db.AddInParameter(dc, "AreaId", DbType.Int32, model.AreaId); } return(DbHelper.Exists(dc, _db)); }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <param name="filedOrder"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysProvince> GetSysProvinceList(int Top, Eyousoft_yhq.Model.MSysProvince chaXun, string filedOrder) { IList <Eyousoft_yhq.Model.MSysProvince> ResultList = null; string StrSql = string.Format("SELECT {0} ID, CountryId,HeaderLetter,Name,AreaId,SortId FROM tbl_SysProvince WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : "")); if (chaXun != null) { if (chaXun.CountryId > 0) { StrSql = StrSql + string.Format(" AND CountryId={0} ", chaXun.CountryId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (!string.IsNullOrEmpty(chaXun.Name)) { StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.AreaId > 0) { StrSql = StrSql + string.Format(" AND AreaId={0} ", chaXun.AreaId); } } 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.MSysProvince>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysProvince model = new Eyousoft_yhq.Model.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; ResultList.Add(model); model = null; } } return(ResultList); }
/// <summary> /// 得到一个对象实体 /// </summary> public Eyousoft_yhq.Model.MSysProvince GetSysProvinceModel(int ID) { Eyousoft_yhq.Model.MSysProvince model = null; string StrSql = "SELECT ID, CountryId,HeaderLetter,Name,AreaId,SortId FROM tbl_SysProvince 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.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; } }; return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Eyousoft_yhq.Model.MSysProvince GetSysProvinceModel(int ID) { Eyousoft_yhq.Model.MSysProvince model = null; string StrSql = "SELECT ID, CountryId,HeaderLetter,Name,AreaId,SortId FROM tbl_SysProvince 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.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; } }; return model; }
/// <summary> /// 获得前几行数据集合 /// </summary> /// <param name="Top">0:所有</param> /// <param name="chaXun"></param> /// <param name="filedOrder"></param> /// <returns></returns> public IList<Eyousoft_yhq.Model.MSysProvince> GetSysProvinceList(int Top, Eyousoft_yhq.Model.MSysProvince chaXun, string filedOrder) { IList<Eyousoft_yhq.Model.MSysProvince> ResultList = null; string StrSql = string.Format("SELECT {0} ID, CountryId,HeaderLetter,Name,AreaId,SortId FROM tbl_SysProvince WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : "")); if (chaXun != null) { if (chaXun.CountryId > 0) { StrSql = StrSql + string.Format(" AND CountryId={0} ", chaXun.CountryId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (!string.IsNullOrEmpty(chaXun.Name)) { StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.AreaId > 0) { StrSql = StrSql + string.Format(" AND AreaId={0} ", chaXun.AreaId); } } 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.MSysProvince>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysProvince model = new Eyousoft_yhq.Model.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; 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.MSysProvince> GetSysProvinceList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysProvince chaXun) { IList<Eyousoft_yhq.Model.MSysProvince> ResultList = null; string tableName = "tbl_SysProvince"; string fields = "ID, CountryId,HeaderLetter,Name,AreaId,SortId,(select [Id],[ProvinceId],[Name],[CenterCityId],[HeaderLetter],[IsSite],[DomainName],[IsEnabled] from tbl_SysCity where tbl_SysCity.ProvinceId = tbl_SysProvince.ID for xml raw,root('Root')) as CityList "; string query = " 1=1 "; if (chaXun != null) { if (chaXun.CountryId > 0) { query = query + string.Format(" AND CountryId={0} ", chaXun.CountryId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.AreaId > 0) { query = query + string.Format(" AND AreaId={0} ", chaXun.AreaId); } } string orderByString = " ID ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query , orderByString, string.Empty)) { ResultList = new List<Eyousoft_yhq.Model.MSysProvince>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysProvince model = new Eyousoft_yhq.Model.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; if (!dr.IsDBNull(dr.GetOrdinal("CityList"))) model.CityList = (List<Eyousoft_yhq.Model.MSysCity>)this.GetCity(dr.GetString(dr.GetOrdinal("CityList"))); 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.MSysProvince> GetSysProvinceList(int Top, Eyousoft_yhq.Model.MSysProvince chaXun) { return(dal.GetSysProvinceList((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.MSysProvince> GetSysProvinceList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysProvince chaXun) { if (!Utils.ValidPaging(pageSize, pageIndex)) { return(null); } return(dal.GetSysProvinceList(pageSize, pageIndex, ref recordCount, chaXun)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool ExistsSysProvince(Eyousoft_yhq.Model.MSysProvince model) { return(dal.ExistsSysProvince(model)); }