/// <summary>删除一条数据 /// /// </summary> public bool Delete(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CacheConfig "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); #region 缓存配置行 h.CreateCommand("select * from CacheConfig where id =" + Id + ""); DataTable dt = h.ExecuteQuery(); dt.TableName = "CacheConfig"; #endregion h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); bool blnReturn = h.ExecuteNonQuery(); if (blnReturn) { #region 修改缓存配置:如果是则需要推送更新缓存的消息。即是发消息告诉服务端我修改了缓存配置,让服务端统一向所有在线客户端发送更新缓存消息 string strCacheTableName = dt.Rows[0]["CacheTableName"].ToString(); CacheMessageEntity messageEntity = new CacheMessageEntity { CacheKey = strCacheTableName, Operation = "Delete", DataTableCache = dt }; CacheListener.AddMessage(messageEntity); #endregion } return(blnReturn); }
/// <summary>分页获取数据列表 /// /// </summary> /// <param name="strFields">字段</param> /// <param name="strOrder">排序</param> /// <param name="strOrderType">排序类型</param> /// <param name="intPageSize">每页大小</param> /// <param name="intPageIndex">当前第N页</param> /// <param name="strWhere">条件</param> /// <returns>返回符合条件的对象集合</returns> public List <Nikita.Assist.CodeMaker.Model.Bse_ControlType> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere) { SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); DataTable dt = h.FengYe("Bse_ControlType", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex); List <Nikita.Assist.CodeMaker.Model.Bse_ControlType> list = new List <Nikita.Assist.CodeMaker.Model.Bse_ControlType>(); foreach (DataRow row in dt.Rows) { list.Add(new Model.Bse_ControlType() { Ctl_Id = int.Parse(row["Ctl_Id"].ToString()), ControlType = row["ControlType"].ToString(), Ctl_Simple = row["Ctl_Simple"].ToString(), Ctl_Name = row["Ctl_Name"].ToString(), Ctl_NameSpace = row["Ctl_NameSpace"].ToString(), Ctl_Width = int.Parse(row["Ctl_Width"].ToString()), Ctl_Height = int.Parse(row["Ctl_Height"].ToString()), Ctl_Type = row["Ctl_Type"].ToString(), State = row["State"].ToString(), Sort = int.Parse(row["Sort"].ToString()), Type = row["Type"].ToString(), IsSelf = row["IsSelf"].ToString(), }); } return(list); }
public void OnMouseDown() { GlobalHelp mygh = FindObjectOfType <GlobalHelp>(); mygh.SetGlobalHelpOff(); switch (_gameMode) { case MyGameMode.Play: // Reset game by reloading BaseLevelController _lc = FindObjectOfType <BaseLevelController>(); int level = _lc.GetLevel(); string levelName = "Level" + level; SceneManager.LoadScene(levelName); break; case MyGameMode.Placement: LightBulb[] light_bulbs = FindObjectsOfType <LightBulb>(); InputSwitch[] input_switches = FindObjectsOfType <InputSwitch>(); if (input_switches.Length > 1 && light_bulbs.Length > 1) { SetRouteMode(); } break; case MyGameMode.Route: SetPlayMode(); break; } }
public ActionResult OcjenaSnimi(int Id, int OcjenaINT = 0) { if (GlobalHelp.GetOcjena(Id) == 0) { if (OcjenaINT == null || OcjenaINT == 0) { return(RedirectToAction("IndexOcjena", "DetaljiProizvoda", new { proizvodID = Id, ok = 3 })); } else { Ocjene o; o = new Ocjene(); ctx.Ocjene.Add(o); o.Datum = DateTime.Now; o.Ocjena = OcjenaINT; o.KupacID = GlobalHelp.prijavljeniKupac.KupacID; o.ProizvodID = Id; ctx.SaveChanges(); return(RedirectToAction("IndexOcjena", "DetaljiProizvoda", new { proizvodID = Id, ok = 4 })); } } else { return(RedirectToAction("IndexOcjena", "DetaljiProizvoda", new { proizvodID = Id, ok = 4 })); } }
public ActionResult OcjenaDizajneraSnimi(int KorisnikID, int OcjenaINT = 0) { if (GlobalHelp.GetOcjenaDizajnera(KorisnikID) == 0) { if (OcjenaINT == null || OcjenaINT == 0) { return(RedirectToAction("IndexW", "Lookbook", new { ok = 7 })); } else { OcjeneDizajnera o; o = new OcjeneDizajnera(); ctx.OcjeneDizajnera.Add(o); o.Datum = DateTime.Now; o.Ocjena = OcjenaINT; o.KupacID = GlobalHelp.prijavljeniKupac.KupacID; o.KorisnikID = KorisnikID; ctx.SaveChanges(); return(RedirectToAction("IndexW", "Lookbook", new { ok = 6 })); } } else { return(RedirectToAction("IndexW", "Lookbook", new { ok = 6 })); } }
/// <summary>增加一条数据 /// /// </summary> public int Add(Model.Set model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tb_Set("); strSql.Append("SetKey, SetText, SetValue, State, Remark )"); strSql.Append(" values ("); strSql.Append("@SetKey, @SetText, @SetValue, @State, @Remark )"); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.SetValue == null) { h.AddParameter("@SetValue", DBNull.Value); } else { h.AddParameter("@SetValue", model.SetValue); } h.AddParameter("@State", model.State); if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } h.ExecuteNonQuery(); const string strSql2 = "select max(id) from Tb_Set"; h.CreateCommand(strSql2); int result; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out result)) { return(0); } return(result); }
/// <summary>分页获取数据列表 /// /// </summary> public DataSet GetList(string fileds, string order, string ordertype, int intPageSize, int intPageIndex, string strWhere) { SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); DataTable dt = h.FengYe("Tb_Set", fileds, order, ordertype, strWhere, intPageSize, intPageIndex); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>分页获取数据列表 /// /// </summary> /// <param name="strFields">字段</param> /// <param name="strOrder">排序</param> /// <param name="strOrderType">排序类型</param> /// <param name="intPageSize">每页大小</param> /// <param name="intPageIndex">当前第N页</param> /// <param name="strWhere">条件</param> /// <returns>返回符合条件的DataSet数据集</returns> public DataSet GetList(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere) { SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); DataTable dt = h.FengYe("Bse_UI", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Base.CacheStore.Model.CacheSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CacheSetting("); strSql.Append("SetKey, SetText, CreateDate, Remark )"); strSql.Append(" values ("); strSql.Append("@SetKey, @SetText, @CreateDate, @Remark )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } return(intResult); }
/// <summary>删除一条数据 /// /// </summary> public bool Delete(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CacheSetting "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); return(h.ExecuteNonQuery()); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Base.CacheStore.Model.CacheSetting model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheSetting set "); strSql.Append("SetKey=@SetKey, SetText=@SetText, CreateDate=@CreateDate, Remark=@Remark "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.Id == null) { h.AddParameter("@Id", DBNull.Value); } else { h.AddParameter("@Id", model.Id); } if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.CreateDate == null) { h.AddParameter("@CreateDate", DBNull.Value); } else { h.AddParameter("@CreateDate", model.CreateDate); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } return(h.ExecuteNonQuery()); }
/// <summary>删除一条数据 /// /// </summary> /// <param name="intId">主键ID</param> /// <returns>返回受影响的行数</returns> public bool Delete(int intId) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Bse_UI "); strSql.Append(" where Ui_Id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@id", intId); return(h.ExecuteNonQuery()); }
/// <summary>计算记录数 /// /// </summary> /// <param name="p"></param> /// <returns></returns> public int CalcCount(string cond) { string sql = "select count(1) from CacheSetting"; if (!string.IsNullOrEmpty(cond)) { sql += " where " + cond; } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(sql); return(int.Parse(h.ExecuteScalar())); }
/// <summary>计算记录数 /// /// </summary> /// <param name="strCond">条件</param> /// <returns>总数量</returns> public int CalcCount(string strCond) { string sql = "select count(1) from Bse_UI"; if (!string.IsNullOrEmpty(strCond)) { sql += " where " + strCond; } SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(sql); return(int.Parse(h.ExecuteScalar())); }
/// <summary>根据条件删除数据 /// /// </summary> public bool DeleteByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from CacheSetting "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); return(h.ExecuteNonQuery()); }
/// <summary>根据条件删除数据 /// /// </summary> /// <param name="strCond">条件</param> /// <returns>返回受影响的行数</returns> public bool DeleteByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from Bse_UI "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); return(h.ExecuteNonQuery()); }
/// <summary>分页获取数据列表 /// /// </summary> /// <param name="strFields">字段</param> /// <param name="strOrder">排序</param> /// <param name="strOrderType">排序类型</param> /// <param name="intPageSize">每页大小</param> /// <param name="intPageIndex">当前第N页</param> /// <param name="strWhere">条件</param> /// <returns>返回符合条件的对象集合</returns> public List <Nikita.Assist.CodeMaker.Model.Bse_UI> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere) { SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); DataTable dt = h.FengYe("Bse_UI", strFields, strOrder, strOrderType, strWhere, intPageSize, intPageIndex); List <Nikita.Assist.CodeMaker.Model.Bse_UI> list = new List <Nikita.Assist.CodeMaker.Model.Bse_UI>(); foreach (DataRow row in dt.Rows) { list.Add(new Model.Bse_UI() { Ui_Id = int.Parse(row["Ui_Id"].ToString()), TableName = row["TableName"].ToString(), PanelName = row["PanelName"].ToString(), ColumnName = row["ColumnName"].ToString(), ColumnType = row["ColumnType"].ToString(), FrmNameSpace = row["FrmNameSpace"].ToString(), ControlNameSpace = row["ControlNameSpace"].ToString(), ControlType = row["ControlType"].ToString(), Ctl_Simple = row["Ctl_Simple"].ToString(), ControlName = row["ControlName"].ToString(), GridSpeicalCtlName = row["GridSpeicalCtlName"].ToString(), ControlSort = row["ControlSort"].ToString(), DefaultValue = row["DefaultValue"].ToString(), IsAddLable = row["IsAddLable"].ToString(), LabelName = row["LabelName"].ToString(), LabelText = row["LabelText"].ToString(), IsNeed = row["IsNeed"].ToString(), IsReadonly = row["IsReadonly"].ToString(), FiledText = row["FiledText"].ToString(), FiledValue = row["FiledValue"].ToString(), DataSourse = row["DataSourse"].ToString(), DefaultFiledText = row["DefaultFiledText"].ToString(), DefaultFiledValue = row["DefaultFiledValue"].ToString(), DefaultDataSourse = row["DefaultDataSourse"].ToString(), Remark = row["Remark"].ToString(), State = int.Parse(row["State"].ToString()), CreateDate = DateTime.Parse(row["CreateDate"].ToString()), CreateUserId = int.Parse(row["CreateUserId"].ToString()), }); } return(list); }
/// <summary>分页获取数据列表 /// /// </summary> public List <Model.SetOrd> GetListArray(string fileds, string order, string ordertype, int intPageSize, int intPageIndex, string strWhere) { SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); DataTable dt = h.FengYe("Tb_SetOrd", fileds, order, ordertype, strWhere, intPageSize, intPageIndex); return((from DataRow row in dt.Rows select new Model.SetOrd() { Id = int.Parse(row["id"].ToString()), SetOrdText = row["SetOrdText"].ToString(), SetOrdKey = row["SetOrdKey"].ToString(), State = int.Parse(row["State"].ToString()), Remark = row["Remark"].ToString(), }).ToList()); }
/// <summary>根据条件更新字段 /// /// </summary> public bool Update(string strFieldWithValue, string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheSetting set "); strSql.Append(strFieldWithValue); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); return(h.ExecuteNonQuery()); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Model.Set model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tb_Set set "); strSql.Append("SetKey=@SetKey, SetText=@SetText, SetValue=@SetValue, State=@State, Remark=@Remark "); strSql.Append(" where id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); if (model.SetKey == null) { h.AddParameter("@SetKey", DBNull.Value); } else { h.AddParameter("@SetKey", model.SetKey); } if (model.SetText == null) { h.AddParameter("@SetText", DBNull.Value); } else { h.AddParameter("@SetText", model.SetText); } if (model.SetValue == null) { h.AddParameter("@SetValue", DBNull.Value); } else { h.AddParameter("@SetValue", model.SetValue); } h.AddParameter("@State", model.State); if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } h.AddParameter("@id", model.Id); return(h.ExecuteNonQuery()); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Base.CacheStore.Model.CacheTables model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CacheTables("); strSql.Append("TableName, Remark, Status )"); strSql.Append(" values ("); strSql.Append("@TableName, @Remark, @Status )"); strSql.Append(";select @@IDENTITY"); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } return(intResult); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Base.CacheStore.Model.CacheTables model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CacheTables set "); strSql.Append("TableName=@TableName, Remark=@Remark, Status=@Status "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); if (model.Id == null) { h.AddParameter("@Id", DBNull.Value); } else { h.AddParameter("@Id", model.Id); } if (model.TableName == null) { h.AddParameter("@TableName", DBNull.Value); } else { h.AddParameter("@TableName", model.TableName); } if (model.Remark == null) { h.AddParameter("@Remark", DBNull.Value); } else { h.AddParameter("@Remark", model.Remark); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } return(h.ExecuteNonQuery()); }
/// <summary>分页获取数据列表 /// /// </summary> public DataSet GetList(string strFileds, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere) { IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateStoredCommand("[proc_SplitPage]"); h.AddParameter("@tblName", "CacheSetting"); h.AddParameter("@strFields", strFileds); h.AddParameter("@strOrder", strOrder); h.AddParameter("@strOrderType", strOrderType); h.AddParameter("@PageSize", intPageSize); h.AddParameter("@PageIndex", intPageIndex); h.AddParameter("@strWhere", strWhere); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>获得数据列表 /// /// </summary> public DataSet GetList(string strWhere, string strFields) { StringBuilder strSql = new StringBuilder(); strSql.Append("select " + strFields + " "); strSql.Append(" FROM CacheSetting "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>获得数据列表 /// /// </summary> /// <param name="strWhere">条件</param> /// <returns>返回符合条件的DataSet数据集</returns> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM Bse_UI "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>得到一个对象实体 /// /// </summary> /// <param name="intId">主键</param> /// <returns>返回对象实体</returns> public Nikita.Assist.CodeMaker.Model.Bse_UI GetModel(int intId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Bse_UI "); strSql.Append(" where Ui_Id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@id", intId); Nikita.Assist.CodeMaker.Model.Bse_UI model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from CacheSetting "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Model.Set GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from Tb_Set "); strSql.Append(" where id=@id "); SQLiteHelper h = GlobalHelp.GetSQLiteHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@id", id); Model.Set model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } h.CloseConn(); return(model); }
public void Update() { GameMode mygamemode = FindObjectOfType <GameMode>(); if (!mygamemode.IsInPlayMode()) { return; } LineRenderer _lr = GetComponent <LineRenderer>(); if (!_lr) { return; } _lr.startWidth = 0.1f; _lr.endWidth = 0.1f; _lr.widthMultiplier = 0.1f; GlobalHelp _gh = FindObjectOfType <GlobalHelp>(); if (_gh.IsGlobalHelpOn() || _show_output_value) { if (_out) { _lr.startColor = Color.green; _lr.endColor = Color.green; } else { _lr.startColor = Color.red; _lr.endColor = Color.red; } } else { _lr.startColor = Color.black; _lr.endColor = Color.black; } }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from CacheSetting "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }