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