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