/// <summary>
///Add
/// </summary>
public int Add(PopularSport model)
{
string sql = "insert into PopularSport (CategoryId,Name,Remark,Client,AddDate,ImgPath1,ImgPath2,ImgPath3) values (@CategoryId,@Name,@Remark,@Client,@AddDate,@ImgPath1,@ImgPath2,@ImgPath3);select @IDENTITYVal = @@IDENTITY;";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter()
{
ParameterName = "@IDENTITYVal", SqlDbType = SqlDbType.Int
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@CategoryId", SqlDbType = SqlDbType.Int, Value = model.CategoryId
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Value = model.Name
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = model.Remark
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Client", SqlDbType = SqlDbType.NVarChar, Value = model.Client
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@AddDate", SqlDbType = SqlDbType.DateTime, Value = model.AddDate
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath1", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath1
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath2", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath2
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath3", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath3
});
sqlParams[0].Direction = ParameterDirection.Output;
int result = SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["SqlConnection"].ToString(), CommandType.Text, sql, sqlParams.ToArray());
int identityV = Convert.ToInt32(sqlParams[0].Value);
return(identityV);
}
/// <summary>
///更新
/// </summary>
public bool Update(PopularSport model)
{
string sql = "update PopularSport set CategoryId=@CategoryId,Name=@Name,Remark=@Remark,Client=@Client,AddDate=@AddDate,ImgPath1=@ImgPath1,ImgPath2=@ImgPath2,ImgPath3=@ImgPath3 where Id=@Id";
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Id", SqlDbType = SqlDbType.Int, Value = model.Id
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@CategoryId", SqlDbType = SqlDbType.Int, Value = model.CategoryId
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Value = model.Name
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Remark", SqlDbType = SqlDbType.NVarChar, Value = model.Remark
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@Client", SqlDbType = SqlDbType.NVarChar, Value = model.Client
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@AddDate", SqlDbType = SqlDbType.DateTime, Value = model.AddDate
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath1", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath1
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath2", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath2
});
sqlParams.Add(new SqlParameter()
{
ParameterName = "@ImgPath3", SqlDbType = SqlDbType.NVarChar, Value = model.ImgPath3
});
int result = SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["SqlConnection"].ToString(), CommandType.Text, sql, sqlParams.ToArray());
return(result > 0);
}
/// <summary>
///更新
/// </summary>
public bool Update(PopularSport model)
{
return(dal.Update(model));
}
/// <summary>
///Add
/// </summary>
public int Add(PopularSport model)
{
return(dal.Add(model));
}