public ContentResult InsertNewsInfoPost()
{
#region - paras -
NewsMsgModel nmModel = new NewsMsgModel();
nmModel.Title = Request.Form.Get("newsName");
nmModel.NewsType=Request.Form.Get("newsType")==null?1:int.Parse(Request.Form.Get("newsType"));
nmModel.ImageUrl=Request.Form.Get("imageUrl");
nmModel.Content=Request.Form.Get("newsContent");
#endregion
var rltBool = _newsMsgBll.InsertNewsInfo(nmModel);
return Content(rltBool ? "success" : "fail");
}
/// <summary>
/// 添加新闻信息
/// </summary>
/// <param name="nmModel"></param>
/// <returns></returns>
public bool InsertNewsInfo(NewsMsgModel nmModel)
{
#region - sql qy -
string insertSql = @"INSERT INTO `dinlun`.`newsmsg`
(
`Title`,
`Content`,
`NewsType`,
`ImgUrl`,
`InsertTime`,
`avg1`,
`avg2`)
VALUES (
@Title,
@Content,
@NewsType,
@ImgUrl,
@InsertTime,
@avg1,
@avg2);";
#endregion
#region - paras -
MySqlParameter[] paras = {
new MySqlParameter("@Title",nmModel.Title),
new MySqlParameter("@Content",nmModel.Content),
new MySqlParameter("@NewsType",nmModel.NewsType),
new MySqlParameter("@ImgUrl",nmModel.ImageUrl),
new MySqlParameter("@InsertTime",DateTime.Now),
new MySqlParameter("@Avg1",nmModel.Avg1),
new MySqlParameter("@Avg2",nmModel.Avg2)
};
#endregion
#region - excute -
try
{
//记录查询
int rlt = DbHelperMySql.ExecuteNonQuery(DbHelperMySql.connectionStringManager, CommandType.Text, insertSql, paras);
return rlt > 0;
}
catch (Exception ex)
{
return false;
}
#endregion
}
/// <summary>
/// DataRow 转换至 NewsMsgModel
/// </summary>
/// <param name="row">记录行</param>
/// <returns>NewsMsgModel 实体</returns>
public NewsMsgModel TransNewsMsgModel(DataRow row)
{
NewsMsgModel newsMsgModel = new NewsMsgModel();
newsMsgModel.ID = row["ID"] != null ? (int)row["ID"]: 0;
newsMsgModel.Title = row["Title"] != null ? row["Title"].ToString() : string.Empty;
newsMsgModel.Content = row["Content"] != null ? row["Content"].ToString() : string.Empty;
newsMsgModel.NewsType = row["NewsType"] != null ? (int)row["NewsType"] : 0;
newsMsgModel.ImageUrl = row["ImgUrl"] != null ? row["ImgUrl"].ToString() : string.Empty;
newsMsgModel.InsertTime = row["InsertTime"] != null ? Convert.ToDateTime(row["InsertTime"]) : DateTime.MinValue;
newsMsgModel.Avg1 = row["avg1"] != null ? row["avg1"].ToString() : string.Empty;
newsMsgModel.Avg2 = row["avg2"] != null ? row["avg2"].ToString() : string.Empty;
return newsMsgModel;
}
/// <summary>
/// 添加新闻信息
/// </summary>
/// <param name="nmModel"></param>
/// <returns></returns>
public bool InsertNewsInfo(NewsMsgModel nmModel)
{
return _nesmsgDalInstance.InsertNewsInfo(nmModel);
}