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