/// <summary>
/// 增加一条数据
/// </summary>
public bool AddSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
{
string StrSql = "INSERT INTO tbl_SysDistrict(Name,ProvinceId,CityId,HeaderLetter) VALUES(@Name,@ProvinceId,@CityId,@HeaderLetter)";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "Name", DbType.String, model.Name);
this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId);
this._db.AddInParameter(dc, "CityId", DbType.Int32, model.CityId);
this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter);
return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
{
if (model != null && model.ProvinceId > 0 && model.CityId > 0 && !string.IsNullOrEmpty(model.Name))
{
return(dal.UpdateSysDistrict(model));
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
{
string StrSql = "UPDATE tbl_SysDistrict SET Name = @Name,ProvinceId = @ProvinceId,CityId = @CityId,HeaderLetter=@HeaderLetter WHERE Id=@Id";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "Name", DbType.String, model.Name);
this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId);
this._db.AddInParameter(dc, "CityId", DbType.Int32, model.CityId);
this._db.AddInParameter(dc, "HeaderLetter", DbType.String, model.HeaderLetter);
this._db.AddInParameter(dc, "Id", DbType.Int32, model.Id);
return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : 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.MSysDistrict> GetSysDistrictList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysDistrict chaXun)
{
IList <Eyousoft_yhq.Model.MSysDistrict> ResultList = null;
string tableName = "tbl_SysDistrict";
string identityColumnName = "Id";
string fields = "Id, Name,ProvinceId,CityId,HeaderLetter";
string query = " 1=1 ";
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name);
}
if (chaXun.ProvinceId > 0)
{
query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId);
}
if (chaXun.CityId > 0)
{
query = query + string.Format(" AND CityId={0} ", chaXun.CityId);
}
if (!string.IsNullOrEmpty(chaXun.HeaderLetter))
{
query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter);
}
}
string orderByString = " Id ASC";
using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, identityColumnName, fields, query, orderByString))
{
ResultList = new List <Eyousoft_yhq.Model.MSysDistrict>();
while (dr.Read())
{
Eyousoft_yhq.Model.MSysDistrict model = new Eyousoft_yhq.Model.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool ExistsSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
{
string StrSql = " select count(1) from tbl_SysDistrict 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.CityId > 0)
{
StrSql += " AND CityId = @CityId ";
}
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.CityId > 0)
{
this._db.AddInParameter(dc, "CityId", DbType.Int32, model.CityId);
}
if (model.ProvinceId > 0)
{
this._db.AddInParameter(dc, "ProvinceId", DbType.Int32, model.ProvinceId);
}
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.MSysDistrict> GetSysDistrictList(int Top, Eyousoft_yhq.Model.MSysDistrict chaXun, string filedOrder)
{
IList <Eyousoft_yhq.Model.MSysDistrict> ResultList = null;
string StrSql = string.Format("SELECT {0} Id, Name,ProvinceId,CityId,HeaderLetter FROM tbl_SysDistrict WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : ""));
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name);
}
if (chaXun.ProvinceId > 0)
{
StrSql = StrSql + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId);
}
if (chaXun.CityId > -1)
{
StrSql = StrSql + string.Format(" AND CityId={0} ", chaXun.CityId);
}
if (!string.IsNullOrEmpty(chaXun.HeaderLetter))
{
StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter);
}
}
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.MSysDistrict>();
while (dr.Read())
{
Eyousoft_yhq.Model.MSysDistrict model = new Eyousoft_yhq.Model.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
ResultList.Add(model);
model = null;
}
}
return(ResultList);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eyousoft_yhq.Model.MSysDistrict GetSysDistrictModel(int ID)
{
Eyousoft_yhq.Model.MSysDistrict model = null;
string StrSql = "SELECT Id, Name,ProvinceId,CityId,HeaderLetter FROM tbl_SysDistrict 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.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
}
};
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Eyousoft_yhq.Model.MSysDistrict GetSysDistrictModel(int ID)
{
Eyousoft_yhq.Model.MSysDistrict model = null;
string StrSql = "SELECT Id, Name,ProvinceId,CityId,HeaderLetter FROM tbl_SysDistrict 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.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
}
};
return model;
}
/// <summary>
/// 获得前几行数据集合
/// </summary>
/// <param name="Top">0:所有</param>
/// <param name="chaXun"></param>
/// <param name="filedOrder"></param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.MSysDistrict> GetSysDistrictList(int Top, Eyousoft_yhq.Model.MSysDistrict chaXun, string filedOrder)
{
IList<Eyousoft_yhq.Model.MSysDistrict> ResultList = null;
string StrSql = string.Format("SELECT {0} Id, Name,ProvinceId,CityId,HeaderLetter FROM tbl_SysDistrict WHERE 1=1 ", (Top > 0 ? " TOP " + Top + " " : ""));
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
StrSql = StrSql + string.Format(" AND Name like '%{0}%'", chaXun.Name);
}
if (chaXun.ProvinceId > 0)
{
StrSql = StrSql + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId);
}
if (chaXun.CityId > -1)
{
StrSql = StrSql + string.Format(" AND CityId={0} ", chaXun.CityId);
}
if (!string.IsNullOrEmpty(chaXun.HeaderLetter))
{
StrSql = StrSql + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter);
}
}
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.MSysDistrict>();
while (dr.Read())
{
Eyousoft_yhq.Model.MSysDistrict model = new Eyousoft_yhq.Model.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
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.MSysDistrict> GetSysDistrictList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysDistrict chaXun)
{
IList<Eyousoft_yhq.Model.MSysDistrict> ResultList = null;
string tableName = "tbl_SysDistrict";
string identityColumnName = "Id";
string fields = "Id, Name,ProvinceId,CityId,HeaderLetter";
string query = " 1=1 ";
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name);
}
if (chaXun.ProvinceId > 0)
{
query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId);
}
if (chaXun.CityId > 0)
{
query = query + string.Format(" AND CityId={0} ", chaXun.CityId);
}
if (!string.IsNullOrEmpty(chaXun.HeaderLetter))
{
query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter);
}
}
string orderByString = " Id ASC";
using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, identityColumnName, fields, query, orderByString))
{
ResultList = new List<Eyousoft_yhq.Model.MSysDistrict>();
while (dr.Read())
{
Eyousoft_yhq.Model.MSysDistrict model = new Eyousoft_yhq.Model.MSysDistrict()
{
Id = dr.GetInt32(dr.GetOrdinal("Id")),
Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")),
ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")),
CityId = dr.GetInt32(dr.GetOrdinal("CityId")),
HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter"))
};
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.MSysDistrict> GetSysDistrictList(int Top, Eyousoft_yhq.Model.MSysDistrict chaXun)
{
return(dal.GetSysDistrictList((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.MSysDistrict> GetSysDistrictList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysDistrict chaXun)
{
if (!Utils.ValidPaging(pageSize, pageIndex))
{
return(null);
}
return(dal.GetSysDistrictList(pageSize, pageIndex, ref recordCount, chaXun));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool ExistsSysDistrict(Eyousoft_yhq.Model.MSysDistrict model)
{
return(dal.ExistsSysDistrict(model));
}
