/// <summary> /// 对象实体绑定数据 /// </summary> public BD_StatusTableInfo ReaderBind(IDataReader dataReader) { BD_StatusTableInfo model = new BD_StatusTableInfo(); model.name = dataReader["name"].ToString(); model.value = dataReader["value"].ToString(); return(model); }
private static void AddOrUpdate(BD_StatusTableDal statusTableDal, BD_StatusTableInfo model) { if (statusTableDal.Exists(ISNORMALEXITVALUE)) { statusTableDal.Update(model); } else { statusTableDal.Add(model); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BD_StatusTableInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BD_StatusTable set "); strSql.Append("value='" + model.value + "'"); strSql.Append(" where name='" + model.name + "' "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 增加一条数据(带事务) /// </summary> public void Add(BD_StatusTableInfo model, Database db, DbTransaction transaction) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BD_StatusTable("); strSql.Append("name,value"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.name + "',"); strSql.Append("'" + model.value + "'"); strSql.Append(")"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.ExecuteNonQuery(dbCommand, transaction); }
/// <summary> /// 增加一条数据(不带事务) /// </summary> public void Add(BD_StatusTableInfo model) { Database db = DatabaseFactory.CreateDatabase(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BD_StatusTable("); strSql.Append("name,value"); strSql.Append(")"); strSql.Append(" values ("); strSql.Append("'" + model.name + "',"); strSql.Append("'" + model.value + "'"); strSql.Append(")"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 根据name获取日期 /// </summary> /// <param name="name"></param> /// <returns></returns> private static string GetByName(string name) { BD_StatusTableInfo statusTable = null; BD_StatusTableDal bd_StatusTableDal = new BD_StatusTableDal(); try { statusTable = bd_StatusTableDal.GetModel(name); } catch (Exception ex) { LogHelper.WriteError(ex.Message, ex); } if (statusTable == null) { return(""); } return(statusTable.value); }
/// <summary> /// 得到一个对象实体 /// </summary> public BD_StatusTableInfo GetModel(string name) { StringBuilder strSql = new StringBuilder(); strSql.Append("select name,value from BD_StatusTable "); strSql.Append(" where name='{0}' "); string sql = string.Format(strSql.ToString(), name); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(sql); BD_StatusTableInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 添加正常退出标志 /// </summary> public static void AddNormalFlag() { BD_StatusTableDal statusTableDal = new BD_StatusTableDal(); //if (statusTableDal.Exists(ISNORMALEXITVALUE)) statusTableDal.Delete(ISNORMALEXITVALUE); BD_StatusTableInfo model = new BD_StatusTableInfo(); model.name = ISNORMALEXIT; model.value = ISNORMALEXITVALUE; bool isSuccess = false; try { AddOrUpdate(statusTableDal, model); isSuccess = true; } catch (Exception ex) { LogHelper.WriteError(ex.Message, ex); } if (!isSuccess) { statusTableDal.Delete(ISNORMALEXITVALUE); try { AddOrUpdate(statusTableDal, model); } catch (Exception ex) { LogHelper.WriteError(ex.Message, ex); } } }
/// <summary> /// 更新当前日期到数据库状态表中 /// </summary> /// <param name="name"></param> /// <param name="tm"></param> private static void DoUpdate(string name, ReckoningTransaction tm) { BD_StatusTableDal dal = new BD_StatusTableDal(); BD_StatusTableInfo statusTable = dal.GetModel(name); if (statusTable != null) { if (tm == null) { dal.Delete(name); } else { dal.Delete(name, tm); } } statusTable = new BD_StatusTableInfo(); statusTable.name = name; statusTable.value = DateTime.Now.ToString(); if (tm != null) { dal.Add(statusTable, tm.Database, tm.Transaction); } else { dal.Add(statusTable); } string format = "更新系统状态表[Name={0},Date={1}]"; string desc = string.Format(format, name, statusTable.value); LogHelper.WriteInfo(desc); }