public JsonResult DeleteBanner(long?NewInfoId)
{
NewInfoModel model = new NewInfoModel();
var resultModel = new ResultModel();
if (NewInfoId.HasValue)
{
model.NewInfoId = NewInfoId.Value;
var result = this._newInfoService.DeleteNewInfo(model).IsValid;
if (result)
{
resultModel.IsValid = true;
resultModel.Messages = new List <string> {
"Delete success"
};
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Delete failed"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Parameter ID error"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 更新新闻信息表 wuyf
/// </summary>
/// <param name="model">新闻信息表模型</param>
/// <returns>是否修改成功</returns>
public ResultModel UpdateNewInfos(NewInfoModel model)
{
var result = new ResultModel
{
Data = _database.Db.NewInfo.UpdateByNewInfoId(NewInfoId: model.NewInfoId, NewContent: model.NewContent, NewImage: model.NewImage, NewTitle: model.NewTitle, NewType: model.NewType, UpdateBy: model.UpdateBy, UpdateDT: model.UpdateDT)
};
return(result);
}
/// <summary>
/// 添加新闻信息表 wuyf
/// </summary>
/// <param name="model">新闻信息表</param>
/// <returns>是否成功</returns>
public ResultModel AddNewInfo(NewInfoModel model)
{
var result = new ResultModel
{
Data = _database.Db.NewInfo.Insert(model)
};
return(result);
}
//[UserAuthorize]
public JsonResult UpdateIsRecommend(long?NewInfoId, int IsRecommend)
{
NewInfoModel model = new NewInfoModel();
var resultModel = new ResultModel();
if (NewInfoId.HasValue)
{
model.NewInfoId = NewInfoId.Value;
model.IsRecommend = IsRecommend;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
var result = this._newInfoService.UpdateNewInfo(model).IsValid;
if (result)
{
resultModel.IsValid = true;
if (IsRecommend == 1)
{
resultModel.Messages = new List <string> {
"Recommend success"
};
}
else
{
resultModel.Messages = new List <string> {
"Not Recommend success"
};
}
}
else
{
resultModel.IsValid = false;
if (IsRecommend == 1)
{
resultModel.Messages = new List <string> {
"Recommend failed"
};
}
else
{
resultModel.Messages = new List <string> {
"Not Recommend failed"
};
}
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
else
{
resultModel.IsValid = false;
resultModel.Messages = new List <string> {
"Parameter ID error"
};
}
return(Json(resultModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="model">新闻信息表模型</param>
/// <returns>是否删除成功</returns>
public ResultModel DeleteNewInfo(NewInfoModel model)
{
var result = new ResultModel()
{
Data = base._database.Db.NewInfo.Delete(NewInfoId: model.NewInfoId)
};
result.IsValid = result.Data > 0 ? true : false;
return(result);
}
public ActionResult Add(NewInfoModel model)
{
var opera = string.Empty;
if (ModelState.IsValid)
{
ResultModel resultModel = new ResultModel();
if (model.NewInfoId != 0)
{
model.UpdateBy = UserInfo.CurrentUserName;//asuser.UserName;
model.UpdateDT = DateTime.Now;
resultModel = this._newInfoService.UpdateNewInfos(model);
resultModel.Messages = new List <string>()
{
resultModel.Data > 0 ? "Modify success" : "Modify failed"
};
opera = string.Format("修改新闻:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "企业信息--新闻信息-修改");
}
else
{
model.NewInfoId = MemCacheFactory.GetCurrentMemCache().Increment("commonId");
model.CreateBy = UserInfo.CurrentUserName;
model.CreateDT = DateTime.Now;
model.UpdateBy = UserInfo.CurrentUserName;
model.UpdateDT = DateTime.Now;
model.IsRecommend = 0;
if (model.NewImage != null && model.NewImage.Trim() == ImagePath.Trim())
{
model.NewImage = null;//前台会根据空值,加载默认图片
}
resultModel = this._newInfoService.AddNewInfo(model);
resultModel.Messages = new List <string>()
{
resultModel.Data != 0 ? "Add success" : "Add failed"
};
opera = string.Format("添加新闻:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages);
LogPackage.InserAC_OperateLog(opera, "企业信息--新闻信息-添加");
}
if (resultModel.IsValid)
{
Response.Redirect("/NewInfo/Index");
}
else
{
ViewBag.Messages = resultModel.Messages;
return(View(model));
}
//return Json(resultModel, JsonRequestBehavior.AllowGet);
}
return(View(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(NewInfoModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into NewInfo(");
strSql.Append("NewSummary,NewTitle,NewContent,CreateTime,CreateUser,NewSourse,HotLv,RecommendLv,ClickLv,NewClassId,FlagInvalid");
strSql.Append(") values (");
strSql.Append("@NewSummary,@NewTitle,@NewContent,@CreateTime,@CreateUser,@NewSourse,@HotLv,@RecommendLv,@ClickLv,@NewClassId,@FlagInvalid");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@NewSummary", SqlDbType.NVarChar, 1000),
new SqlParameter("@NewTitle", SqlDbType.NVarChar, 200),
new SqlParameter("@NewContent", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.Decimal, 9),
new SqlParameter("@NewSourse", SqlDbType.VarChar, 50),
new SqlParameter("@HotLv", SqlDbType.Int, 4),
new SqlParameter("@RecommendLv", SqlDbType.Int, 4),
new SqlParameter("@ClickLv", SqlDbType.Int, 4),
new SqlParameter("@NewClassId", SqlDbType.Decimal, 9),
new SqlParameter("@FlagInvalid", SqlDbType.Bit, 1)
};
parameters[0].Value = model.NewSummary;
parameters[1].Value = model.NewTitle;
parameters[2].Value = model.NewContent;
parameters[3].Value = model.CreateTime;
parameters[4].Value = model.CreateUser;
parameters[5].Value = model.NewSourse;
parameters[6].Value = model.HotLv;
parameters[7].Value = model.RecommendLv;
parameters[8].Value = model.ClickLv;
parameters[9].Value = model.NewClassId;
parameters[10].Value = model.FlagInvalid;
bool result = false;
try
{
helper.ExecSqlReInt(strSql.ToString(), parameters);
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
/// <summary>
/// Banner加载数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Create(long?id)
{
ViewBag.RootImage = ImagePath;
NewInfoModel model = new NewInfoModel();
if (id.HasValue)
{
ResultModel result = _newInfoService.GetNewsById(id.Value);
if (result != null)
{
model = result.Data;
}
}
return(PartialView(model));
}
/// <summary>
/// 更新新闻信息表(更新推荐) wuyf
/// </summary>
/// <param name="model">新闻信息表模型</param>
/// <returns>是否修改成功</returns>
public ResultModel UpdateNewInfo(NewInfoModel model)
{
var result = new ResultModel();
using (var tx = _database.Db.BeginTransaction())
{
try
{
//tx.NewInfo.UpdateAll(IsRecommend: 0, Condition: tx.NewInfo.IsRecommend > 0);//先把所以修改成为未推荐
tx.NewInfo.UpdateByNewInfoId(NewInfoId: model.NewInfoId, IsRecommend: model.IsRecommend);//在把单个改成推荐
tx.Commit();
}
catch (Exception ex)
{
tx.Rollback();
result.IsValid = false;
result.Messages.Add(ex.Message);
}
}
return(result);
}
public async Task LoadNewInfoData()
{
var result = await HomeService.GetNewInfoAsync();
NewInfos = new ObservableCollection <NewInfoModel>();
foreach (var item in result)
{
var model = new NewInfoModel
{
Code = item.Code,
Consignee = item.Consignee,
EnumExpressType = item.EnumExpressType,
Ponus = item.Ponus,
Remarks = item.Remarks,
PickUpCode = item.PickUpCode,
Sendaddress = item.Sendaddress,
UserName = item.UserName,
PickUpAddress = item.PickUpAddress,
};
NewInfos.Add(model);
}
newInfoList.ItemsSource = NewInfos;
}
public static NewInfo ToEntity(this NewInfoModel model)
{
return(Mapper.Map <NewInfo>(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(NewInfoModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update NewInfo set ");
strSql.Append(" NewSummary = @NewSummary , ");
strSql.Append(" NewTitle = @NewTitle , ");
strSql.Append(" NewContent = @NewContent , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" CreateUser = @CreateUser , ");
strSql.Append(" NewSourse = @NewSourse , ");
strSql.Append(" HotLv = @HotLv , ");
strSql.Append(" RecommendLv = @RecommendLv , ");
strSql.Append(" ClickLv = @ClickLv , ");
strSql.Append(" NewClassId = @NewClassId , ");
strSql.Append(" FlagInvalid = @FlagInvalid ");
strSql.Append(" where NewId=@NewId ");
SqlParameter[] parameters =
{
new SqlParameter("@NewId", SqlDbType.Decimal, 9),
new SqlParameter("@NewSummary", SqlDbType.NVarChar, 1000),
new SqlParameter("@NewTitle", SqlDbType.NVarChar, 200),
new SqlParameter("@NewContent", SqlDbType.NVarChar),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUser", SqlDbType.Decimal, 9),
new SqlParameter("@NewSourse", SqlDbType.VarChar, 50),
new SqlParameter("@HotLv", SqlDbType.Int, 4),
new SqlParameter("@RecommendLv", SqlDbType.Int, 4),
new SqlParameter("@ClickLv", SqlDbType.Int, 4),
new SqlParameter("@NewClassId", SqlDbType.Decimal, 9),
new SqlParameter("@FlagInvalid", SqlDbType.Bit, 1)
};
parameters[0].Value = model.NewId;
parameters[1].Value = model.NewSummary;
parameters[2].Value = model.NewTitle;
parameters[3].Value = model.NewContent;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.CreateUser;
parameters[6].Value = model.NewSourse;
parameters[7].Value = model.HotLv;
parameters[8].Value = model.RecommendLv;
parameters[9].Value = model.ClickLv;
parameters[10].Value = model.NewClassId;
parameters[11].Value = model.FlagInvalid; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
