/// <summary> /// 添加新闻信息 /// </summary> /// <param name="Model">新闻信息</param> /// <returns>新添加的新闻信息</returns> public DGM_News AddDGM_News(DGM_News Model) { DGM_News dgmNewsInfo = null; param.Add("[@NewsTitle],[" + Model.NewsTitle + "]"); param.Add("[@NewContent],[" + Model.NewContent + "]"); param.Add("[@CreateDate],[" + Model.CreateDate + "]"); param.Add("[@NewsAuthor],[" + Model.NewsAuthor + "]"); param.Add("[@NewsType],[" + Model.NewsType + "]"); param.Add("[@IsHomeShow],[" + Model.IsHomeShow + "]"); param.Add("[@NewsHomeText],[" + Model.NewsHomeText + "]"); param.Add("[@DGMNewsImgUrl],[" + Model.DGMNewsImgUrl + "]"); param.Add("[@Explanation],[" + Model.Explanation + "]"); try { ws_mysql.Credentials = new System.Net.NetworkCredential(PublicConst.WS_USERNAME, PublicConst.WS_USERPWD); string obj = ws_mysql.ExecuteScalar(param.ToArray(), "", addSql, "dgm"); // var obj = SqlHelper.ExecuteScalar(SqlHelper.connectionString, CommandType.Text, addSql, param); if (!string.IsNullOrEmpty(obj)) { dgmNewsInfo = GetDGMNewsByDGMNewsId(obj); } } catch { param.Clear(); } return(dgmNewsInfo); }
/// <summary> /// 根据新闻信息Id查询新闻信息 /// </summary> /// <param name="ClassesID"></param> /// <returns></returns> public DGM_News GetDGMNewsByDGMNewsId(string DGMNewsId) { DGM_News DGM_NewsInfo = null; param.Add("[@DGMNewsId],[" + Convert.ToString(DGMNewsId) + "]"); try { ws_mysql.Credentials = new System.Net.NetworkCredential(PublicConst.WS_USERNAME, PublicConst.WS_USERPWD); myDataset = ws_mysql.ExecuteDataSet(param.ToArray(), "", selSql, "dgm"); foreach (DataRow mDr in myDataset.Tables[0].Rows) { DGM_NewsInfo = new DGM_News(); DGM_NewsInfo.DGMNewsId = DGMNewsId; DGM_NewsInfo.NewsTitle = mDr["NewsTitle"].ToString(); DGM_NewsInfo.NewContent = mDr["NewContent"].ToString(); DGM_NewsInfo.CreateDate = mDr["CreateDate"].ToString(); DGM_NewsInfo.NewsAuthor = mDr["NewsAuthor"].ToString(); DGM_NewsInfo.NewsType = mDr["NewsType"].ToString(); DGM_NewsInfo.Explanation = mDr["Explanation"].ToString(); DGM_NewsInfo.IsHomeShow = mDr["IsHomeShow"].ToString(); DGM_NewsInfo.NewsHomeText = mDr["NewsHomeText"].ToString(); DGM_NewsInfo.DGMNewsImgUrl = mDr["DGMNewsImgUrl"].ToString(); } } catch { } finally { param.Clear(); } return(DGM_NewsInfo); }
public DGM_News AddDGM_News(DGM_News Model) { return(new DGM_NewsDAL().AddDGM_News(Model)); }