public int UpdateById(CopyrightModle modle)
{
String sql = "UPDATE Copyright SET TITLE=@TITLE WHERE(ID=@ID)";
return(dbo.NoQuery(sql, new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@ID",
SqlDbType = SqlDbType.Int,
Value = modle.Id,
}, new SqlParameter()
{
ParameterName = "@TITLE",
SqlDbType = SqlDbType.Int,
Value = modle.Id,
},
}));
}
public int Insert(CopyrightModle modle)
{
return(dal.Insert(modle));
}
public int UpdateById(CopyrightModle modle)
{
return(dal.UpdateById(modle));
}
public int Insert(CopyrightModle modle)
{
String sql = "INSERT INTO Copyright VALUES(@Title,@Content,@Address,@Tel1,@Tel2,@QQ1,@QQ2,@Wechat,@Email,@Logo,@Images)";
return(dbo.NoQuery(sql, new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@Title",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Title
},
new SqlParameter()
{
ParameterName = "@Content",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Content
},
new SqlParameter()
{
ParameterName = "@Address",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Address
},
new SqlParameter()
{
ParameterName = "@Tel1",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Tel1
},
new SqlParameter()
{
ParameterName = "@Tel2",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Tel2
},
new SqlParameter()
{
ParameterName = "@QQ1",
SqlDbType = SqlDbType.NVarChar,
Value = modle.QQ1
},
new SqlParameter()
{
ParameterName = "@QQ2",
SqlDbType = SqlDbType.NVarChar,
Value = modle.QQ2
},
new SqlParameter()
{
ParameterName = "@Wechat",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Wechat
},
new SqlParameter()
{
ParameterName = "@Email",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Email
},
new SqlParameter()
{
ParameterName = "@Images",
SqlDbType = SqlDbType.NVarChar,
Value = modle.Images
},
}));
}
