public ActionResult Create(DictionaryDetails model)
{
//
if (ModelState.IsValid)
{
db.DictionaryDetailses.Add(model); //添加
db.SaveChanges(); //提交至数据库
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Edit(DictionaryDetails model)
{
if (ModelState.IsValid)
{
//把存储状态修改成“modified”
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
//
// GET: /Home/
public ActionResult Index(int?pageIndex, DictionaryDetails model)
{
var modelTypes = db.DictionaryTypes;
string options = String.Empty;
bool hasSelect = false;//是否被选中如果被选中selected=selected
foreach (var mt in modelTypes)
{
if (model.DictTypeID > 0 && model.DictTypeID == mt.DictTypeID)
{
options += "<option value='" + mt.DictTypeID + "'selected=selected >" + mt.DictTypeValue + "</option>";
hasSelect = true;
}
else
{
options += "<option value='" + mt.DictTypeID + "'>" + mt.DictTypeValue + "</option>";
}
}
if (hasSelect == false)
{
options = "<option value='0' selected=selected>不限</option>" + options;
}
else
{
options = "<option value='0'>不限</option>" + options;
}
ViewBag.Options = options;
ViewBag.DictDetValue = model.DictDetValue;
//linq语法
var models = from m in db.DictionaryDetailses select m;
if (model.DictTypeID > 0)
{
models = models.Where(m => m.DictTypeID == model.DictTypeID);
}
if (!string.IsNullOrEmpty(model.DictDetValue))
{
models = models.Where(m => m.DictDetValue == model.DictDetValue);
}
models = models.OrderBy(m => m.DictDetID);
PagedList <DictionaryDetails> pagedList = new PagedList <DictionaryDetails>(models, pageIndex, CommonData.pagesize);
return(View(pagedList));
}
private void SaveAndGoBack(object obj)
{
var filteredList = DictionaryDetails.Where(x => x.Key != null && x.Value != null).ToList();
//avoid case sensitivity
//Convert all keys to to lower then check duplicacy
var duplicateKeys = filteredList.Select(x => x.Key.ToUpper()).ToList().GroupBy(x => x).Where(x => x.Count() > 1).Select(x => x.Key).ToList();
if (duplicateKeys != null && duplicateKeys.Count != 0)
{
new DialogService().ShowError("Error!!", "Please remove duplicate keys from dictionary.", "Ok", null);
}
else
{
var result = App.PritixDB.DeleteDetailsByMappingIndex(UserSelectedDictionaryMapping.MappingIndex).Result;
App.PritixDB.SaveAllDictionaryDetails(filteredList).Wait();
var xxxx = App.PritixDB.GetDictionaryDetailsByMappingIndex(UserSelectedDictionaryMapping.MappingIndex);
Navigation.PopModalAsync();
}
}
