public IHttpActionResult PutNewsCategoryModel(NewsCategoryModel newsCategoryModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(newsCategoryModel).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NewsCategoryModelExists(newsCategoryModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(Ok(newsCategoryModel));
}
public bool InsertNewsCaetegory(NewsCategoryModel category)
{
using (var db = new CMSdb(_context))
{
using (var tr = db.BeginTransaction())
{
InsertLog(new LogModel
{
PageId = category.Id,
PageName = category.Name,
Section = LogModule.NewsCategory,
Action = LogAction.update
});
int sort = 1;
var q = db.core_material_categories.Where(w => w.f_site == _siteId);
if (q.Any())
{
sort = q.Select(s => s.n_sort).Max() + 1;
}
bool result = db.core_material_categories
.Insert(() => new core_material_categories
{
c_alias = category.Alias,
c_name = category.Name,
n_sort = sort,
f_site = _siteId
}) > 0;
tr.Commit();
return(result);
}
}
}
protected void Button_Submit_Click(object sender, EventArgs e)
{
if (TextBox_CategoryName.Text != String.Empty)
{
NewsCategoryModel model = new NewsCategoryModel();
int ParentID = Convert.ToInt32(Input_ParentCategoryID.Value);
NewsCategoryModel pModel = bll.GetModel(ParentID);
model.CateID = CommDataHelper.GetNewSerialNum("ne");
model.CateLevel = pModel == null?0:pModel.CateLevel + 1;
model.CateName = TextBox_CategoryName.Text;
model.IsHide = Convert.ToInt32(DropDownList_IsHide.SelectedValue) == 1?true:false;
model.ParentID = ParentID;
model.ShowOrder = model.CateID;
model.Status = 1;
bll.Add(model);
MessageBox.Show(this, "添加成功！");
Response.Redirect("list.aspx");
}
else
{
MessageBox.Show(this, "请输入分类名称");
}
}
public bool UpdateNewsCategory(NewsCategoryModel category)
{
using (var db = new CMSdb(_context))
{
using (var tr = db.BeginTransaction())
{
InsertLog(new LogModel
{
PageId = category.Id,
PageName = category.Name,
Section = LogModule.NewsCategory,
Action = LogAction.update
});
var q = db.core_material_categories.Where(w => w.id == category.Id && w.f_site == _siteId);
if (q.Any())
{
q
.Set(s => s.c_name, category.Name)
.Set(s => s.c_alias, category.Alias)
.Update();
tr.Commit();
return(true);
}
return(false);
}
}
}
public IActionResult Put(NewsCategoryModel entityModel)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
//get
var newsCategory = _newsCategoryService.Get(entityModel.Id);
if (newsCategory == null)
{
return(RespondFailure());
}
newsCategory.Name = entityModel.Name;
newsCategory.ParentId = entityModel.ParentId;
newsCategory.Short = entityModel.Short;
newsCategory.DisplayOrder = entityModel.DisplayOrder;
//save it
_newsCategoryService.Update(newsCategory);
VerboseReporter.ReportSuccess("Sửa danh mục thành công", "put");
return(RespondSuccess(newsCategory));
}
protected void LinkButton_SelectParentCategory_Click(object sender, EventArgs e)
{
int SelectedID = Convert.ToInt32(((HtmlInputHidden)NewsCategoryTree1.FindControl("Input_Value")).Value);
NewsCategoryModel model = bll.GetModel(SelectedID);
this.Label_ParentCategory.Text = model == null ? "无从属父类" : model.CateName;
this.Input_ParentCategoryID.Value = SelectedID.ToString();
}
public IHttpActionResult GetNewsCategoryModel(int id)
{
NewsCategoryModel newsCategoryModel = db.NewsCategories.Find(id);
if (newsCategoryModel == null)
{
return(NotFound());
}
return(Ok(newsCategoryModel));
}
/// <summary>
/// ニュースリストを取得します。
/// </summary>
/// <returns>タスク</returns>
private async Task GetNewsList()
{
var handler = new HttpClientHandler()
{
AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate
};
var client = new HttpClient(handler);
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", this.viewModel.AccessToken);
var tokenSource = new CancellationTokenSource();
var url = new Uri($"{App.WebServerApiUrl}news");
var response = await client.GetAsync(url, tokenSource.Token);
if (response.StatusCode == HttpStatusCode.Forbidden)
{
MessageBox.Show("現在ログイン中のアカウントではこの操作は許可されていません。");
this.Close();
return;
}
response.EnsureSuccessStatusCode();
if (response.StatusCode == HttpStatusCode.NoContent)
{
return;
}
var responseText = await response.Content.ReadAsStringAsync();
var responseDto = JsonConvert.DeserializeObject <List <NewsDto> >(responseText);
ObservableCollection <NewsModel> responseModels = new ObservableCollection <NewsModel>();
foreach (var dto in responseDto)
{
NewsModel model = new NewsModel();
NewsCategoryModel category = this.viewModel.NewsCategoryList.Where(e => e.Category == dto.Category).Single();
model.Category = dto.Category;
model.Id = dto.Id;
model.Author = dto.Author;
model.Title = dto.Title;
model.Outline = dto.Outline;
model.MediaURL = dto.MediaURL;
model.CreatedAt = dto.CreatedAt;
model.CategoryName = category.CategoryName;
model.Color = category.Color;
responseModels.Add(model);
}
this.viewModel.NewsList = responseModels;
this.FilterNewsList('\0');
return;
}
public static NewsCategory ToEntity(this NewsCategoryModel n)
{
return(new NewsCategory()
{
Id = n.Id,
Name = n.Name,
Short = n.Short,
ParentId = n.ParentId,
DisplayOrder = n.DisplayOrder
});
}
public void GetSearchCondition()
{
SearchCondition = "";
if (CheckBox_NewsID.Checked)
{
if (PageValidate.IsNumber(TextBox_NewsID.Text))
{
SearchCondition += " and newsid=" + Convert.ToInt32(TextBox_NewsID.Text);
}
else
{
MessageBox.Show(this, "请输入正确的新闻ID");
return;
}
}
if (CheckBox_NewsName.Checked)
{
if (!String.IsNullOrEmpty(TextBox_NewsName.Text))
{
SearchCondition += " and title like '%" + TextBox_NewsName.Text.Trim().Replace("'", "") + "%'";
}
else
{
MessageBox.Show(this, "请输入新闻标题");
return;
}
}
if (CheckBox_Category.Checked)
{
bool test;
NewsCategoryModel model = NewsCategorySelect1.GetSelectedRegionInfo(out test);
if (model != null)
{
SearchCondition += " and dbo.GetNewsCategoryPath(cateid)+'/' like dbo.GetNewsCategoryPath(" + model.CateID + ")+'/%'";
if (!CheckBox_Category.Checked)
{
CheckBox_Category.Checked = true;
}
string CategoryPath = new NewsCategoryModelBll().GetPath(model.CateID);
//CategoryPath = CategoryPath.Contains("/") ? CategoryPath.Substring(0, CategoryPath.LastIndexOf("/")) : CategoryPath;
NewsCategorySelect1.PresetRegionInfo(CategoryPath);
}
else
{
MessageBox.Show(this, "请选择分类");
return;
}
}
}
public JsonResult Manage(NewsCategoryModel model, GridManagingModel manageModel)
{
if (ModelState.IsValid || manageModel.Operation == GridOperationEnums.Del)
{
return(Json(_newsCategorieservices.ManageNewsCategory(manageModel.Operation, model)));
}
return(Json(new ResponseModel
{
Success = false,
Message = GetFirstValidationResults(ModelState).Message
}));
}
public IActionResult Post(NewsCategoryModel entityModel)
{
//if (!ModelState.IsValid)
// return BadRequest();
var newsCategory = entityModel.ToEntity();
//save it
_newsCategoryService.Insert(newsCategory);
VerboseReporter.ReportSuccess("Tạo danh mục thành công", "post");
return(RespondSuccess(entityModel
));
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
int SelectedID = Convert.ToInt32(TreeView1.SelectedValue);
NewsCategoryModel model = bll.GetModel(SelectedID);
TextBox_CategoryName.Text = model.CateName;
DropDownList_IsHide.SelectedValue = model.IsHide ? "1" : "0";
NewsCategoryModel parentModel = bll.GetModel(model.ParentID);
Label_ParentCategory.Text = parentModel == null ? "无从属父类" : parentModel.CateName;
}
public void Update(NewsCategoryModel Model)
{
DbCommand command = dbw.GetStoredProcCommand("UP_neCategory_Update");
dbw.AddInParameter(command, "@cateid", DbType.Int32, Model.CateID);
dbw.AddInParameter(command, "@catename", DbType.String, Model.CateName);
dbw.AddInParameter(command, "@status", DbType.Int16, Model.Status);
dbw.AddInParameter(command, "@ishide", DbType.Boolean, Model.IsHide);
dbw.AddInParameter(command, "@catelevel", DbType.Int32, Model.CateLevel);
dbw.AddInParameter(command, "@parentid", DbType.Int32, Model.ParentID);
dbw.AddInParameter(command, "@showorder", DbType.Int32, Model.ShowOrder);
dbw.ExecuteNonQuery(command);
}
private NewsCategoryModel ReaderBind(IDataReader dataReader)
{
NewsCategoryModel model = new NewsCategoryModel();
model.CateID = Convert.ToInt32(dataReader["cateid"]);
model.CateLevel = Convert.ToInt32(dataReader["catelevel"]);
model.CateName = Convert.ToString(dataReader["catename"]);
model.IsHide = Convert.ToBoolean(dataReader["ishide"]);
model.ParentID = Convert.ToInt32(dataReader["parentid"]);
model.ShowOrder = Convert.ToInt32(dataReader["showorder"]);
model.Status = Convert.ToInt16(dataReader["status"]);
return(model);
}
public IHttpActionResult DeleteNewsCategoryModel([FromBody] int id)
{
NewsCategoryModel newsCategoryModel = db.NewsCategories.Find(id);
if (newsCategoryModel == null)
{
return(NotFound());
}
db.NewsCategories.Remove(newsCategoryModel);
db.SaveChanges();
return(Ok(newsCategoryModel));
}
public IHttpActionResult PostNewsCategoryModel([FromBody] string categoryName)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
NewsCategoryModel category = new NewsCategoryModel()
{
Name = categoryName
};
db.NewsCategories.Add(category);
db.SaveChanges();
return(Ok(category));
//return CreatedAtRoute("DefaultApi", new { id = newsCategoryModel.Id }, newsCategoryModel);
}
public NewsCategoryModel GetModel(int CateID)
{
DbCommand command = dbr.GetStoredProcCommand("UP_neCategory_GetModel");
dbr.AddInParameter(command, "@cateid", DbType.Int32, CateID);
NewsCategoryModel model = null;
using (IDataReader dataReader = dbr.ExecuteReader(command))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// Manage Site Setting
/// </summary>
/// <param name="operation">the operation</param>
/// <param name="model">the setting model</param>
/// <returns></returns>
public ResponseModel ManageNewsCategory(GridOperationEnums operation, NewsCategoryModel model)
{
ResponseModel response;
Mapper.CreateMap <NewsCategoryModel, NewsCategory>();
NewsCategory newsCategory;
switch (operation)
{
case GridOperationEnums.Edit:
newsCategory = GetById(model.Id);
newsCategory.Name = model.Name;
newsCategory.ParentId = model.ParentName.ToNullableInt();
newsCategory.Description = model.Description;
newsCategory.RecordOrder = model.RecordOrder;
response = HierarchyUpdate(newsCategory);
return(response.SetMessage(response.Success ?
_localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::UpdateSuccessfully:::Update news category successfully.")
: _localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::UpdateFailure:::Update news category failed. Please try again later.")));
case GridOperationEnums.Add:
newsCategory = Mapper.Map <NewsCategoryModel, NewsCategory>(model);
response = HierarchyInsert(newsCategory);
return(response.SetMessage(response.Success ?
_localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::CreateSuccessfully:::Create news category successfully.")
: _localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::CreateFailure:::Insert news category failed. Please try again later.")));
case GridOperationEnums.Del:
response = Delete(model.Id);
return(response.SetMessage(response.Success ?
_localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::DeleteSuccessfully:::Delete news category successfully.")
: _localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::DeleteFailure:::Delete news category failed. Please try again later.")));
}
return(new ResponseModel
{
Success = false,
Message = _localizedResourceServices.T("AdminModule:::NewsCategories:::Messages:::ObjectNotFounded:::News category is not founded.")
});
}
protected void Button_Submit_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(TreeView1.SelectedValue))
{
int SelectedID = Convert.ToInt32(TreeView1.SelectedValue);
NewsCategoryModel model = bll.GetModel(SelectedID);
model.CateName = TextBox_CategoryName.Text;
model.IsHide = DropDownList_IsHide.SelectedValue == "1" ? true : false;
bll.Update(model);
MessageBox.Show(this, "修改成功！");
Response.Redirect(Request.RawUrl);
}
else
{
MessageBox.Show(this, "请选择分类！");
}
}
public ActionResult Category(NewsCategoryModel model)
{
if (ModelState.IsValid)
{
if (_cmsRepository.ExistNewsCategory(model.Id))
{
//обновляем
_cmsRepository.UpdateNewsCategory(model);
}
else
{
//создаем
_cmsRepository.InsertNewsCaetegory(model);
}
ViewBag.SuccesAlert = "Запись сохранена.";
}
else
{
ViewBag.DankerAler = "Произошла ошибка.";
}
return(View(model));
}
public NewsCategoryModel GetSelectedRegionInfo(out bool IsEndClass)
{
string regionPath = String.Empty;
string country = Request.Form["category0"];
string province = Request.Form["category1"];
string city = Request.Form["category2"];
string county = Request.Form["category3"];
int curRegionId = 0;
if (curRegionId == 0 && !String.IsNullOrEmpty(county))
{
int.TryParse(county, out curRegionId);
}
if (curRegionId == 0 && !String.IsNullOrEmpty(city))
{
int.TryParse(city, out curRegionId);
}
if (curRegionId == 0 && !String.IsNullOrEmpty(province))
{
int.TryParse(province, out curRegionId);
}
if (curRegionId == 0 && !String.IsNullOrEmpty(country))
{
int.TryParse(country, out curRegionId);
}
NewsCategoryModel result = null;
IsEndClass = false;
if (curRegionId > 0)
{
result = new NewsCategoryModelBll().GetModel(curRegionId);
IsEndClass = !new NewsCategoryModelBll().HasChild(result.CateID);
}
return(result);
}
public void Add(NewsCategoryModel Model)
{
dal.Add(Model);
}
public void Update(NewsCategoryModel Model)
{
dal.Update(Model);
}
