public int EditFriendShips(FriendShips friendShips)
{
string sql =
"update FriendShips set FriendShips_Title = @FriendShips_Title,FriendShips_Link = @FriendShips_Link,FriendShips_UpdateTime = @FriendShips_UpdateTime where FriendShips_Id = @FriendShips_Id";
SqlParameter[] param =
{
new SqlParameter("@FriendShips_Title", friendShips.FriendShips_Title),
new SqlParameter("@FriendShips_Link", friendShips.FriendShips_Link),
new SqlParameter("@FriendShips_UpdateTime", friendShips.UpdateTime),
new SqlParameter("@FriendShips_Id", friendShips.Id)
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
public int AddFriendShips(FriendShips friendShips)
{
string sql =
"insert into FriendShips(FriendShips_Id,FriendShips_Title,FriendShips_Link,FriendShips_DeleteId,FriendShips_CreateTime,FriendShips_UpdateTime)values(@FriendShips_Id,@FriendShips_Title,@FriendShips_Link,@FriendShips_DeleteId,@FriendShips_CreateTime,@FriendShips_UpdateTime)";
SqlParameter[] param =
{
new SqlParameter("@FriendShips_Id", friendShips.Id),
new SqlParameter("@FriendShips_Title", friendShips.FriendShips_Title),
new SqlParameter("@FriendShips_Link", friendShips.FriendShips_Link),
new SqlParameter("@FriendShips_DeleteId", friendShips.DeleteId),
new SqlParameter("@FriendShips_CreateTime", friendShips.CreateTime),
new SqlParameter("@FriendShips_UpdateTime", friendShips.UpdateTime),
};
return(SqlHelper.ExecuteNonQuery(sql, param));
}
public List <FriendShips> FillData(DataTable dt)
{
var list = new List <FriendShips>();
foreach (DataRow dr in dt.Rows)
{
var item = new FriendShips()
{
Id = Guid.Parse(dr["FriendShips_Id"].ToString()),
FriendShips_Title = dr["FriendShips_Title"].ToString(),
FriendShips_Link = dr["FriendShips_Link"].ToString(),
DeleteId = int.Parse(dr["FriendShips_DeleteId"].ToString()),
UpdateTime = DateTime.Parse(dr["FriendShips_UpdateTime"].ToString())
};
list.Add(item);
}
return(list);
}
public int Edit(FriendShips model)
{
return(dal.Edit(model));
}
public int Add(FriendShips model)
{
return(dal.Add(model));
}
public int Add(FriendShips model)
{
string sql = "insert into FriendShips(FriendShips_Id,FriendShips_Title,FriendShips_Link,FriendShips_DeleteId,FriendShips_CreateTime,FriendShips_UpdateTime) values(@FriendShips_Id,@FriendShips_Title,@FriendShips_Link,@FriendShips_DeleteId,@FriendShips_CreateTime,@FriendShips_UpdateTime)";
return(SqlHelper <FriendShips> .ExceuteNonQuery(sql, model));
}
public int Edit(FriendShips model)
{
string sql = "update FriendShips set FriendShips_Title = @FriendShips_Title,FriendShips_Link = @FriendShips_Link,FriendShips_UpdateTime = @FriendShips_UpdateTime where FriendShips_Id = @FriendShips_Id";
return(SqlHelper <FriendShips> .ExceuteNonQuery(sql, model));
}
public int EditFriendShips(FriendShips friendShips)
{
return(fm.EditFriendShips(friendShips));
}
public int AddFriendShips(FriendShips friendShips)
{
return(fm.AddFriendShips(friendShips));
}
