public IList<GetArtisticworksByID> GetArtisticworksByID(GetArtisticworksByID obj) { StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT "); sql.AppendLine(" Artisticworks_ID, "); sql.AppendLine(" Artisticworks_Name, "); sql.AppendLine(" Artisticworks_Date, "); sql.AppendLine(" Artisticworks_Picture, "); sql.AppendLine(" Member_Name "); sql.AppendLine("FROM Artisticworks "); sql.AppendLine("LEFT JOIN Member "); sql.AppendLine(" ON Artisticworks.Member_ID = Member.Member_ID "); sql.AppendLine("WHERE Artisticworks.Member_ID = @Member_ID"); List<SqlParameter> parameter = new List<SqlParameter>() { new SqlParameter() {ParameterName = "@Member_ID",Value = obj.Member_ID} }; DataTable table = ConnectDBToGetData(sql, parameter); return DataTableToList<GetArtisticworksByID>(table); }
public string GetArtisticworksdata(GetArtisticworksByID obj) { IList<GetArtisticworksByID> objArtisticworksdata = AWS.GetArtisticworksByID(obj); return Base.ConvertToJson<GetArtisticworksByID>(objArtisticworksdata); }