/// <summary>
/// 删除
/// </summary>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int DeleteMultiple(ParameterCollection pc)
{
int ret = 0;
ChinaInfoModel chinainfo = new ChinaInfoModel();
ret = DbUtil.Current.DeleteMultiple(chinainfo, pc);
return(ret);
}
/// <summary>
/// 删除
/// </summary>
/// <returns>影响的记录行数</returns>
public int Delete()
{
int ret = 0;
ChinaInfoModel chinainfo = new ChinaInfoModel();
ret = DbUtil.Current.Delete(chinainfo);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="chinainfo">实体</param>
/// <param name="pc">pc</param>
/// <returns>影响的记录行数</returns>
public int UpdateMultiple(ChinaInfoModel chinainfo, ParameterCollection pc)
{
int ret = 0;
chinainfo.ModifiedBy = SessionUtil.Current.UserId;
chinainfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.UpdateMultiple(chinainfo, pc);
return(ret);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="chinainfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Update(ChinaInfoModel chinainfo)
{
int ret = 0;
chinainfo.ModifiedBy = SessionUtil.Current.UserId;
chinainfo.ModifiedOn = DateTime.Now;
ret = DbUtil.Current.Update(chinainfo);
return(ret);
}
/// <summary>
/// 新建
/// </summary>
/// <param name="chinainfo">实体</param>
/// <returns>影响的记录行数</returns>
public int Create(ChinaInfoModel chinainfo)
{
int ret = 0;
chinainfo.CreatedBy = SessionUtil.Current.UserId;
chinainfo.CreatedOn = DateTime.Now;
chinainfo.ModifiedBy = SessionUtil.Current.UserId;
chinainfo.ModifiedOn = DateTime.Now;
chinainfo.StatusCode = 0;
ret = DbUtil.Current.Create(chinainfo);
return(ret);
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <returns>实体</returns>
public ChinaInfoModel Retrieve()
{
ChinaInfoModel chinainfo = new ChinaInfoModel();
DataTable dt = DbUtil.Current.Retrieve(chinainfo);
if (dt.Rows.Count < 1)
{
return(null);
}
chinainfo.ConvertFrom(dt);
return(chinainfo);
}
/// <summary>
/// 根据条件获取实体集合
/// </summary>
/// <param name="pc">pc</param>
/// <param name="obc">obc</param>
/// <returns>实体</returns>
public List <ChinaInfoModel> RetrieveMultiple(ParameterCollection pc, OrderByCollection obc)
{
List <ChinaInfoModel> chinainfos = new List <ChinaInfoModel>();
ChinaInfoModel chinainfo = new ChinaInfoModel();
DataTable dt = DbUtil.Current.RetrieveMultiple(chinainfo, pc, obc);
for (int i = 0; i < dt.Rows.Count; i++)
{
chinainfo = new ChinaInfoModel();
chinainfo.ConvertFrom(dt, i);
chinainfos.Add(chinainfo);
}
return(chinainfos);
}
public ChinaInfoModel GetChinaInfoByIdFromDatabase(string chinaId)
{
ChinaInfoModel model = null;
string sql = "select * from china_info where id = $id$";
ParameterCollection pc = new ParameterCollection();
pc.Add("id", chinaId);
DataTable dt = ExecuteDataTable(sql, pc);
if (dt != null && dt.Rows.Count > 0)
{
model = new ChinaInfoModel();
ModelConvertFrom(model, dt, 0);
}
return(model);
}
public ChinaInfoModel GetChinaInfo(string chinaId)
{
if (string.IsNullOrEmpty(chinaId))
{
return(null);
}
ChinaInfoModel result = null;
string filterSQL = string.Format("id = " + chinaId);
DataRow[] hasRows = ChinaInfoTable.Select(filterSQL);
if (hasRows.Length > 0)
{
result = new ChinaInfoModel();
ModelConvertFrom(result, hasRows[0]);
}
return(result);
}
public ChinaInfoModel GetChinaInfoById(string chinaId, bool clear)
{
if (string.IsNullOrEmpty(chinaId))
{
return(null);
}
string cacheKey = CacheKey.CHINA_INFO_MODEL.GetKeyDefine(chinaId);
ChinaInfoModel model = CacheUtil.Get <ChinaInfoModel>(cacheKey);
if (model == null || clear)
{
model = GetChinaInfoByIdFromDatabase(chinaId);
if (model != null)
{
CacheUtil.Set(cacheKey, model);
}
}
return(model);
}
