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