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