/// <summary> /// 更新一条数据 /// </summary> public bool Update(Gunark.Model.gun_records model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update gun_records set "); strSql.Append("RECORD_BULLET_TYPE=@RECORD_BULLET_TYPE,"); strSql.Append("RECORD_GUN_UNM=@RECORD_GUN_UNM,"); strSql.Append("RECORD_LEND_TIME=@RECORD_LEND_TIME,"); strSql.Append("RECORD_RETURN_TIME=@RECORD_RETURN_TIME"); strSql.Append(" where GUNARK_RECORD_ID=@GUNARK_RECORD_ID "); MySqlParameter[] parameters = { new MySqlParameter("@RECORD_BULLET_TYPE", MySqlDbType.VarChar, 255), new MySqlParameter("@RECORD_GUN_UNM", MySqlDbType.Int32, 10), new MySqlParameter("@RECORD_LEND_TIME", MySqlDbType.DateTime), new MySqlParameter("@RECORD_RETURN_TIME", MySqlDbType.DateTime), new MySqlParameter("@GUNARK_RECORD_ID", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.RECORD_BULLET_TYPE; parameters[1].Value = model.RECORD_GUN_UNM; parameters[2].Value = model.RECORD_LEND_TIME; parameters[3].Value = model.RECORD_RETURN_TIME; parameters[4].Value = model.GUNARK_RECORD_ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Gunark.Model.gun_records model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into gun_records("); strSql.Append("GUNARK_RECORD_ID,RECORD_BULLET_TYPE,RECORD_GUN_UNM,RECORD_LEND_TIME,RECORD_RETURN_TIME)"); strSql.Append(" values ("); strSql.Append("@GUNARK_RECORD_ID,@RECORD_BULLET_TYPE,@RECORD_GUN_UNM,@RECORD_LEND_TIME,@RECORD_RETURN_TIME)"); MySqlParameter[] parameters = { new MySqlParameter("@GUNARK_RECORD_ID", MySqlDbType.VarChar, 255), new MySqlParameter("@RECORD_BULLET_TYPE", MySqlDbType.VarChar, 255), new MySqlParameter("@RECORD_GUN_UNM", MySqlDbType.Int32, 10), new MySqlParameter("@RECORD_LEND_TIME", MySqlDbType.DateTime), new MySqlParameter("@RECORD_RETURN_TIME", MySqlDbType.DateTime) }; parameters[0].Value = model.GUNARK_RECORD_ID; parameters[1].Value = model.RECORD_BULLET_TYPE; parameters[2].Value = model.RECORD_GUN_UNM; parameters[3].Value = model.RECORD_LEND_TIME; parameters[4].Value = model.RECORD_RETURN_TIME; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.gun_records DataRowToModel(DataRow row) { Gunark.Model.gun_records model = new Gunark.Model.gun_records(); if (row != null) { if (row["GUNARK_RECORD_ID"] != null) { model.GUNARK_RECORD_ID = row["GUNARK_RECORD_ID"].ToString(); } if (row["RECORD_BULLET_TYPE"] != null) { model.RECORD_BULLET_TYPE = row["RECORD_BULLET_TYPE"].ToString(); } if (row["RECORD_GUN_UNM"] != null && row["RECORD_GUN_UNM"].ToString() != "") { model.RECORD_GUN_UNM = int.Parse(row["RECORD_GUN_UNM"].ToString()); } if (row["RECORD_LEND_TIME"] != null && row["RECORD_LEND_TIME"].ToString() != "") { model.RECORD_LEND_TIME = DateTime.Parse(row["RECORD_LEND_TIME"].ToString()); } if (row["RECORD_RETURN_TIME"] != null && row["RECORD_RETURN_TIME"].ToString() != "") { model.RECORD_RETURN_TIME = DateTime.Parse(row["RECORD_RETURN_TIME"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.gun_records DataRowToModel(DataRow row) { Gunark.Model.gun_records model=new Gunark.Model.gun_records(); if (row != null) { if(row["GUNARK_RECORD_ID"]!=null) { model.GUNARK_RECORD_ID=row["GUNARK_RECORD_ID"].ToString(); } if(row["RECORD_BULLET_TYPE"]!=null) { model.RECORD_BULLET_TYPE=row["RECORD_BULLET_TYPE"].ToString(); } if(row["RECORD_GUN_UNM"]!=null && row["RECORD_GUN_UNM"].ToString()!="") { model.RECORD_GUN_UNM=int.Parse(row["RECORD_GUN_UNM"].ToString()); } if(row["RECORD_LEND_TIME"]!=null && row["RECORD_LEND_TIME"].ToString()!="") { model.RECORD_LEND_TIME=DateTime.Parse(row["RECORD_LEND_TIME"].ToString()); } if(row["RECORD_RETURN_TIME"]!=null && row["RECORD_RETURN_TIME"].ToString()!="") { model.RECORD_RETURN_TIME=DateTime.Parse(row["RECORD_RETURN_TIME"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public Gunark.Model.gun_records GetModel(string GUNARK_RECORD_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select GUNARK_RECORD_ID,RECORD_BULLET_TYPE,RECORD_GUN_UNM,RECORD_LEND_TIME,RECORD_RETURN_TIME from gun_records "); strSql.Append(" where GUNARK_RECORD_ID=@GUNARK_RECORD_ID "); MySqlParameter[] parameters = { new MySqlParameter("@GUNARK_RECORD_ID", MySqlDbType.VarChar, 255) }; parameters[0].Value = GUNARK_RECORD_ID; Gunark.Model.gun_records model = new Gunark.Model.gun_records(); 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.gun_records GetModel(string GUNARK_RECORD_ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select GUNARK_RECORD_ID,RECORD_BULLET_TYPE,RECORD_GUN_UNM,RECORD_LEND_TIME,RECORD_RETURN_TIME from gun_records "); strSql.Append(" where GUNARK_RECORD_ID=@GUNARK_RECORD_ID "); MySqlParameter[] parameters = { new MySqlParameter("@GUNARK_RECORD_ID", MySqlDbType.VarChar,255) }; parameters[0].Value = GUNARK_RECORD_ID; Gunark.Model.gun_records model=new Gunark.Model.gun_records(); DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }