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