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