/// <summary>
/// 根据id获取新闻信息
/// </summary>
/// <param name="openid"></param>
/// <returns></returns>
public Mnews GetNewsById(string id)
{
Mnews model = null;
string sql = " SELECT id,type,title,`value`,isDelete,isEffective,great_time,modify_time,img,url,sortNum " +
$" FROM news WHERE id=?id ; ";
MySqlParameter[] parameterList = new MySqlParameter[1];
MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25);
parameter.Value = id;
parameterList[0] = parameter;
using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList))
{
if (sqlDataReader.Read())
{
model = new Mnews();
model.id = sqlDataReader["id"] != DBNull.Value ? sqlDataReader["id"].ToString() : string.Empty;
model.title = sqlDataReader["title"] != DBNull.Value ? sqlDataReader["title"].ToString() : string.Empty;
model.value = sqlDataReader["value"] != DBNull.Value ? sqlDataReader["value"].ToString() : string.Empty;
model.img = sqlDataReader["img"] != DBNull.Value ? sqlDataReader["img"].ToString() : string.Empty;
model.url = sqlDataReader["url"] != DBNull.Value ? sqlDataReader["url"].ToString() : string.Empty;
model.type = sqlDataReader["type"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["type"].ToString()) : 0;
model.sortNum = sqlDataReader["sortNum"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["sortNum"].ToString()) : 0;
model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue;
model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue;
}
}
return model;
}
/// <summary>
/// 新增文章
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string AddNews(Mnews model, HttpPostedFileBase productimgurl = null, string path = "", int type = 1)
{
MwxResult mwxResult = new MwxResult()
{
errcode = -1
};
string savePath = string.Empty;
//// 存图片
if (productimgurl != null)
{
string fileSave = FileOpert.UploadImg(productimgurl, path + "uploadFile\\" + System.DateTime.Now.ToString("yyyy") + "\\", out savePath);
if (string.IsNullOrEmpty(fileSave))
{
model.img = savePath.Replace(path, "");
}
}
try
{
if (string.IsNullOrEmpty(model.id))
{
DateTime dateTimeNow = System.DateTime.Now;
model.isDelete = "0";
model.isEffective = "1";
model.great_time = dateTimeNow;
model.modify_time = dateTimeNow;
model.type = type;
model.id = PublicTools.GetRandomNumberByTime();
if (new NewsService().AddNews(model))
{
mwxResult.errcode = 0;
mwxResult.errmsg = "操作成功！";
}
else
{
mwxResult.errmsg = "操作失败！";
}
}
else
{
if (new NewsService().UpdateNews(model))
{
mwxResult.errcode = 0;
mwxResult.errmsg = "操作成功！";
}
else
{
mwxResult.errmsg = "操作失败！";
}
}
}
catch (Exception ex)
{
mwxResult.errmsg = "操作失败！";
}
return(JsonHelper.GetJson <MwxResult>(mwxResult));
}
/// <summary>
/// 分页获取新闻信息
/// </summary>
/// <param name="pagIndex">页码（第一页从1 开始）</param>
/// <param name="pagCount">每页数据条数</param>
/// <returns></returns>
public List<Mnews> GetNewsPagList(int pagIndex, int pagCount,int type=1)
{
string sql = " SELECT id,type,title,`value`,isDelete,isEffective,great_time,modify_time,img,url,sortNum " +
$" FROM news WHERE 1=1 and type="+type+$" ORDER BY sortNum asc ,1 desc limit {((pagIndex - 1) * pagCount)}, {pagCount}; ";
List<Mnews> listModel = null;
using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, null))
{
if (sqlDataReader != null)
{
listModel = new List<Mnews>();
while (sqlDataReader.Read())
{
Mnews model = new Mnews();
model.id = sqlDataReader["id"] != DBNull.Value ? sqlDataReader["id"].ToString() : string.Empty;
model.title = sqlDataReader["title"] != DBNull.Value ? sqlDataReader["title"].ToString() : string.Empty;
model.value = sqlDataReader["value"] != DBNull.Value ? sqlDataReader["value"].ToString() : string.Empty;
model.img = sqlDataReader["img"] != DBNull.Value ? sqlDataReader["img"].ToString() : string.Empty;
model.url = sqlDataReader["url"] != DBNull.Value ? sqlDataReader["url"].ToString() : string.Empty;
model.sortNum = sqlDataReader["sortNum"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["sortNum"].ToString()) : 0;
model.type = sqlDataReader["type"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["type"].ToString()) : 0;
model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue;
model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue;
listModel.Add(model);
}
}
}
return listModel;
}
public string AddNewsMeth(Mnews model)
{
if (!base.CheckIsLogin())
{
return("-1");
}
return(new NewsBus().AddNews(model));
}
public string AddNewsMeth(Mnews model)
{
if (!base.CheckIsLogin())
{
return("-1");
}
HttpPostedFileBase productimgurl = Request.Files["productimgurl"];
return(new NewsBus().AddNews(model, productimgurl, Server.MapPath("/"), 2));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddNews(Mnews model)
{
//// sql语句
string sql = "INSERT INTO news (id,type,title,`value`,isDelete,isEffective,great_time,modify_time,img,url,sortNum) " +
"VALUES (?id,?type,?title,?value,?isDelete,?isEffective,?great_time,?modify_time,?img,?url,?sortNum)";
List<MySqlParameter> parameterList = GetMySqlParameterListByModel(model);
//// 执行操作
return PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0;
}
/// <summary>
/// 获取参数化查询对象
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private List<MySqlParameter> GetMySqlParameterListByModel(Mnews model)
{
List<MySqlParameter> parameterList = new List<MySqlParameter>();
MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25);
parameter.Value = model.id;
parameterList.Add(parameter);
parameter = new MySqlParameter("?title", MySqlDbType.VarChar, 100);
parameter.Value = model.title;
parameterList.Add(parameter);
parameter = new MySqlParameter("?url", MySqlDbType.VarChar, 200);
parameter.Value = model.url;
parameterList.Add(parameter);
parameter = new MySqlParameter("?img", MySqlDbType.VarChar, 200);
parameter.Value = model.img;
parameterList.Add(parameter);
parameter = new MySqlParameter("?value", MySqlDbType.Text);
parameter.Value = model.value;
parameterList.Add(parameter);
parameter = new MySqlParameter("?type", MySqlDbType.Int32);
parameter.Value = model.type;
parameterList.Add(parameter);
parameter = new MySqlParameter("?sortNum", MySqlDbType.Int32);
parameter.Value = model.sortNum;
parameterList.Add(parameter);
parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1);
parameter.Value = model.isDelete;
parameterList.Add(parameter);
parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1);
parameter.Value = model.isEffective;
parameterList.Add(parameter);
DateTime dateTime = System.DateTime.Now;
parameter = new MySqlParameter("?great_time", MySqlDbType.DateTime);
parameter.Value = dateTime;
parameterList.Add(parameter);
parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime);
parameter.Value = dateTime;
parameterList.Add(parameter);
return parameterList;
}
/// <summary>
/// 获取model
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Mnews GetNewsById(string id)
{
Mnews model = null;
try
{
NewsService opert = new NewsService();
model = opert.GetNewsById(id);
}
catch (Exception ex)
{
}
return(model == null ? new Mnews() : model);
}
/// <summary>
/// 根据id更新新闻信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateNews(Mnews model)
{
string sql = "update news set title=?title,value=?value where id=?id ";
List<MySqlParameter> parameterList = new List<MySqlParameter>();
MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25);
parameter.Value = model.id;
parameterList.Add(parameter);
parameter = new MySqlParameter("?title", MySqlDbType.VarChar, 100);
parameter.Value = model.title;
parameterList.Add(parameter);
parameter = new MySqlParameter("?value", MySqlDbType.Text);
parameter.Value = model.value;
parameterList.Add(parameter);
return PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0;
}
/// <summary>
/// 根据id更新新闻信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateNews(Mnews model)
{
return(opertService.UpdateNews(model));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddNews(Mnews model)
{
return(opertService.AddNews(model));
}
