/// <summary> /// 更新一条数据 /// </summary> public bool Update(Gunark.Model.log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update gunark_log set "); strSql.Append("LOG_TIME=@LOG_TIME,"); strSql.Append("LOG_DISCRIBE=@LOG_DISCRIBE,"); strSql.Append("LOG_TYPE=@LOG_TYPE,"); strSql.Append("OPREAT_USER=@OPREAT_USER,"); strSql.Append("BULLET_NUMBER=@BULLET_NUMBER,"); strSql.Append("GUN_NUMBER=@GUN_NUMBER,"); strSql.Append("ALARM_TYPE=@ALARM_TYPE,"); strSql.Append("ALARM_DISCRIBE=@ALARM_DISCRIBE"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@LOG_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@LOG_DISCRIBE", MySqlDbType.VarChar, 255), new MySqlParameter("@LOG_TYPE", MySqlDbType.Int32, 2), new MySqlParameter("@OPREAT_USER", MySqlDbType.VarChar, 255), new MySqlParameter("@BULLET_NUMBER", MySqlDbType.VarChar, 255), new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar, 255), new MySqlParameter("@ALARM_TYPE", MySqlDbType.VarChar, 255), new MySqlParameter("@ALARM_DISCRIBE", MySqlDbType.Int32, 255), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.LOG_TIME; parameters[1].Value = model.LOG_DISCRIBE; parameters[2].Value = model.LOG_TYPE; parameters[3].Value = model.OPREAT_USER; parameters[4].Value = model.BULLET_NUMBER; parameters[5].Value = model.GUN_NUMBER; parameters[6].Value = model.ALARM_TYPE; parameters[7].Value = model.ALARM_DISCRIBE; parameters[8].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.log DataRowToModel(DataRow row) { Gunark.Model.log model = new Gunark.Model.log(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["LOG_TIME"] != null) { model.LOG_TIME = row["LOG_TIME"].ToString(); } if (row["LOG_DISCRIBE"] != null) { model.LOG_DISCRIBE = row["LOG_DISCRIBE"].ToString(); } if (row["LOG_TYPE"] != null && row["LOG_TYPE"].ToString() != "") { model.LOG_TYPE = int.Parse(row["LOG_TYPE"].ToString()); } if (row["OPREAT_USER"] != null) { model.OPREAT_USER = row["OPREAT_USER"].ToString(); } if (row["BULLET_NUMBER"] != null) { model.BULLET_NUMBER = row["BULLET_NUMBER"].ToString(); } if (row["GUN_NUMBER"] != null) { model.GUN_NUMBER = row["GUN_NUMBER"].ToString(); } if (row["ALARM_TYPE"] != null) { model.ALARM_TYPE = row["ALARM_TYPE"].ToString(); } if (row["ALARM_DISCRIBE"] != null && row["ALARM_DISCRIBE"].ToString() != "") { model.ALARM_DISCRIBE = int.Parse(row["ALARM_DISCRIBE"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.log DataRowToModel(DataRow row) { Gunark.Model.log model = new Gunark.Model.log(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["LOG_TIME"] != null) { model.LOG_TIME = row["LOG_TIME"].ToString(); } if (row["LOG_DISCRIBE"] != null) { model.LOG_DISCRIBE = row["LOG_DISCRIBE"].ToString(); } if (row["LOG_TYPE"] != null && row["LOG_TYPE"].ToString() != "") { model.LOG_TYPE = int.Parse(row["LOG_TYPE"].ToString()); } if (row["OPREAT_USER"] != null) { model.OPREAT_USER = row["OPREAT_USER"].ToString(); } if (row["BULLET_NUMBER"] != null) { model.BULLET_NUMBER = row["BULLET_NUMBER"].ToString(); } if (row["GUN_NUMBER"] != null) { model.GUN_NUMBER = row["GUN_NUMBER"].ToString(); } if (row["ALARM_TYPE"] != null) { model.ALARM_TYPE = row["ALARM_TYPE"].ToString(); } if (row["ALARM_DISCRIBE"] != null && row["ALARM_DISCRIBE"].ToString() != "") { model.ALARM_DISCRIBE = int.Parse(row["ALARM_DISCRIBE"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Gunark.Model.log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into gunark_log("); strSql.Append("LOG_TIME,LOG_DISCRIBE,LOG_TYPE,OPREAT_USER,BULLET_NUMBER,GUN_NUMBER,ALARM_TYPE,ALARM_DISCRIBE)"); strSql.Append(" values ("); strSql.Append("@LOG_TIME,@LOG_DISCRIBE,@LOG_TYPE,@OPREAT_USER,@BULLET_NUMBER,@GUN_NUMBER,@ALARM_TYPE,@ALARM_DISCRIBE)"); MySqlParameter[] parameters = { new MySqlParameter("@LOG_TIME", MySqlDbType.VarChar, 255), new MySqlParameter("@LOG_DISCRIBE", MySqlDbType.VarChar, 255), new MySqlParameter("@LOG_TYPE", MySqlDbType.Int32, 2), new MySqlParameter("@OPREAT_USER", MySqlDbType.VarChar, 255), new MySqlParameter("@BULLET_NUMBER", MySqlDbType.VarChar, 255), new MySqlParameter("@GUN_NUMBER", MySqlDbType.VarChar, 255), new MySqlParameter("@ALARM_TYPE", MySqlDbType.VarChar, 255), new MySqlParameter("@ALARM_DISCRIBE", MySqlDbType.Int32, 255) }; parameters[0].Value = model.LOG_TIME; parameters[1].Value = model.LOG_DISCRIBE; parameters[2].Value = model.LOG_TYPE; parameters[3].Value = model.OPREAT_USER; parameters[4].Value = model.BULLET_NUMBER; parameters[5].Value = model.GUN_NUMBER; parameters[6].Value = model.ALARM_TYPE; parameters[7].Value = model.ALARM_DISCRIBE; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.log GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,LOG_TIME,LOG_DISCRIBE,LOG_TYPE,OPREAT_USER,BULLET_NUMBER,GUN_NUMBER,ALARM_TYPE,ALARM_DISCRIBE from gunark_log "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; Gunark.Model.log model = new Gunark.Model.log(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.log GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,LOG_TIME,LOG_DISCRIBE,LOG_TYPE,OPREAT_USER,BULLET_NUMBER,GUN_NUMBER,ALARM_TYPE,ALARM_DISCRIBE from gunark_log "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; Gunark.Model.log model = new Gunark.Model.log(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }