/// <summary> /// 更新一条数据 /// </summary> public bool Update(crm_com_platform model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update crm_com_platform set "); strSql.Append(" ComPlatformValue = @ComPlatformValue, "); strSql.Append(" Type = @Type, "); strSql.Append(" IsSelected = @IsSelected, "); strSql.Append(" UTime = @UTime, "); strSql.Append(" CTime = @CTime, "); strSql.Append(" where Id = @Id"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int32, 11), new MySqlParameter("@ComPlatformValue", MySqlDbType.Double), new MySqlParameter("@Type", MySqlDbType.Int32, 11), new MySqlParameter("@IsSelected", MySqlDbType.Int32, 11), new MySqlParameter("@UTime", MySqlDbType.DateTime), new MySqlParameter("@CTime", MySqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.ComPlatformValue; parameters[2].Value = model.Type; parameters[3].Value = model.IsSelected; parameters[4].Value = model.UTime; parameters[5].Value = model.CTime; return(MySqlHelper.ExecuteNonQuery(BasicConfig.ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(crm_com_platform model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into crm_com_platform("); strSql.Append(" ComPlatformValue,Type,IsSelected,UTime,CTime"); strSql.Append(") values ("); strSql.Append(" @ComPlatformValue,@Type,@IsSelected,@UTime,@CTime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@ComPlatformValue", MySqlDbType.Double), new MySqlParameter("@Type", MySqlDbType.Int32, 11), new MySqlParameter("@IsSelected", MySqlDbType.Int32, 11), new MySqlParameter("@UTime", MySqlDbType.DateTime), new MySqlParameter("@CTime", MySqlDbType.DateTime) }; parameters[0].Value = model.ComPlatformValue; parameters[1].Value = model.Type; parameters[2].Value = model.IsSelected; parameters[3].Value = model.UTime; parameters[4].Value = model.CTime; return(MySqlHelper.ExecuteNonQuery(BasicConfig.ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public crm_com_platform GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,ComPlatformValue,Type,IsSelected,UTime,CTime "); strSql.Append(" from crm_com_platform "); strSql.Append(" where Id=@Id "); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int32, 11) }; parameters[0].Value = Id; _reader = MySqlHelper.ExecuteReader(BasicConfig.ConnectionString, CommandType.Text, strSql.ToString(), parameters); crm_com_platform model = null; while (_reader.Read()) { model = new crm_com_platform { Id = _reader["Id"].ToInt_V(), ComPlatformValue = _reader["ComPlatformValue"].ToDouble_V(), Type = _reader["Type"].ToInt_V(), IsSelected = _reader["IsSelected"].ToInt_V(), UTime = _reader["UTime"].ToDateTime_V(), CTime = _reader["CTime"].ToDateTime_V() }; } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(crm_com_platform model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(crm_com_platform model) { return(dal.Add(model)); }