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