public List <articleData> GetList(string casestr) { List <articleData> listdata = new List <articleData>(); DataTable dt = new DataTable(); DataAccess.CommonDB objDB = new DataAccess.CommonDB(); string sql = "select * from article where 1 = 1 "; sql += casestr; objDB.OpenConnection(); dt = objDB.QueryDataTable(sql, "tabname"); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow tempRow in dt.Rows) { articleData hd = new articleData(); hd.Id = tempRow["Id"].ToString().Trim(); hd.title = tempRow["title"].ToString().Trim(); listdata.Add(hd); } } objDB.CloseConnection(); objDB.Dispose(); objDB = null; return(listdata); }
public bool Modify(articleData datarticle) { int iRel = -1; bool bRel = false; DataAccess.CommonDB objDB = new DataAccess.CommonDB(); try { objDB.OpenConnection(); string strSql = "update article set thumb_media_id=@thumb_media_id,author=@author,title=@title,content_source_url=@content_source_url,content=@content,digest=@digest,show_cover_pic=@show_cover_pic where Id = @Id"; objDB.Command.CommandType = System.Data.CommandType.Text; objDB.Command.CommandText = strSql; objDB.Command.Parameters.AddWithValue("@thumb_media_id", datarticle.thumb_media_id); objDB.Command.Parameters.AddWithValue("@author", datarticle.author); objDB.Command.Parameters.AddWithValue("@title", datarticle.title); objDB.Command.Parameters.AddWithValue("@content_source_url", datarticle.content_source_url); objDB.Command.Parameters.AddWithValue("@content", datarticle.content); objDB.Command.Parameters.AddWithValue("@digest", datarticle.digest); objDB.Command.Parameters.AddWithValue("@show_cover_pic", datarticle.show_cover_pic); objDB.Command.Parameters.AddWithValue("@Id", datarticle.Id); iRel = objDB.Command.ExecuteNonQuery(); } catch (Exception ex) { iRel = -1; } objDB.CloseConnection(); objDB.Dispose(); objDB = null; bRel = (iRel.Equals(1) ? true : false); return(bRel); }
public articleData[] Select(string Id) { int iRel = -1; DataAccess.CommonDB objDB = new DataAccess.CommonDB(); articleData[] datarticle = new articleData[1]; string sql = "select * from article where Id= " + Id + " "; try { objDB.OpenConnection(); DataSet ds = objDB.QueryData(sql, "departmentinfo"); if (ds.Tables.Count > 0) { long nRow = ds.Tables[0].Rows.Count; if (nRow > 0) { datarticle = new articleData[nRow]; for (int i = 0; i < nRow; i++) { datarticle[i] = new articleData(); datarticle[i].thumb_media_id = ds.Tables[0].Rows[i]["thumb_media_id"].ToString(); datarticle[i].author = ds.Tables[0].Rows[i]["author"].ToString(); datarticle[i].title = ds.Tables[0].Rows[i]["title"].ToString(); datarticle[i].content_source_url = ds.Tables[0].Rows[i]["content_source_url"].ToString(); datarticle[i].content = ds.Tables[0].Rows[i]["content"].ToString(); datarticle[i].digest = ds.Tables[0].Rows[i]["digest"].ToString(); datarticle[i].show_cover_pic = ds.Tables[0].Rows[i]["show_cover_pic"].ToString(); } } } } catch (Exception ex) { iRel = -1; } objDB.CloseConnection(); objDB.Dispose(); objDB = null; return(datarticle); }