protected override int Add(EntryViewModel model, UserInfo sysUser, string viewTitle)
{
string sql = @"select * from AssetsSell where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, DbUpdate.cmd).Tables[0];
dt.TableName = "AssetsSell";
DataRow dr = dt.NewRow();
string assetsSellId = IdGenerator.GetMaxId(dt.TableName);
int retApprove = InitFirstApproveTask("AssetsSell", "AssetsSellId", assetsSellId, viewTitle, "", sysUser.UserId);
EntryModel myModel = model as EntryModel;
dr["assetsSellNo"] = myModel.AssetsSellNo;
dr["assetsSellName"] = myModel.AssetsSellName;
dr["sellDate"] = DataConvert.ToDBObject(myModel.SellDate);
dr["setBooksId"] = sysUser.MySetBooks.SetBooksId;
string updateType = "Add";
if (retApprove != 0)
{
dr["approveState"] = "O";
updateType = "ApproveAdd";
}
dr["AssetsSellId"] = assetsSellId;
dt.Rows.Add(dr);
Create5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
List <AssetsSell> gridData = JsonHelper.JSONStringToList <AssetsSell>(DataConvert.ToString(myModel.EntryGridString));
foreach (AssetsSell assetsSell in gridData)
{
AddDetail(assetsSell, assetsSellId, sysUser, viewTitle, updateType);
if (retApprove != 0)
{
UpdateAssetsState(assetsSell.AssetsId, "XI", sysUser.UserId, viewTitle);
}
}
return(1);
}
public async Task <IActionResult> Index(int id)
{
var result = await HttpClientGet($"entry/getall/{id}");
if (result == null)
{
return(View());
}
EntryViewModel viewModel = new EntryViewModel();
viewModel.Entries = JsonConvert.DeserializeObject <List <Entry> >(result);
viewModel.PhoneBook = new PhoneBook();
result = await HttpClientGet($"phonebook/get/{id}");
if (result != null)
{
viewModel.PhoneBook = JsonConvert.DeserializeObject <PhoneBook>(result);
}
return(View(viewModel));
}
public ActionResult Entry(EntryViewModel viewModel)
{
if (ModelState.IsValid)
{
var result = db.Gauges.Find(viewModel.Gauge.Id);
result.LastCal = viewModel.Gauge.LastCal;
result.NextCal = viewModel.Gauge.NextCal;
result.Status = result.Status;
var comment = new Comment();
comment.GaugeId = viewModel.Gauge.Id;
comment.Date = viewModel.Comments.Date;
comment.Name = viewModel.Comments.Name;
comment.Text = viewModel.Comments.Text;
db.Comments.Add(comment);
db.SaveChanges();
return(RedirectToAction("Index", "Gauges", new { plant = result.Plant }));
}
return(View(viewModel));
}
protected override int Modified(EntryViewModel model, UserInfo sysUser, string pkValue, string viewTitle, string formMode)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("approveTable", pkValue);
string sql = @"select * from AppWorkFlow where approveTable=@approveTable";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0];
dt.TableName = "AppWorkFlow";
EntryModel myModel = model as EntryModel;
dt.Rows[0]["wfName"] = myModel.WfName;
dt.Rows[0]["approveTable"] = myModel.ApproveTable;
dt.Rows[0]["remark"] = myModel.Remark;
dt.Rows[0]["wfjson"] = myModel.WorkFlowJson;
string workFlowJson = myModel.WorkFlowJson.ToString();
SaveDetail(workFlowJson, pkValue);
Update5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
return(1);
}
public IActionResult Post([FromBody] EntryViewModel entryVM)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
//Should be a mapper tool
var entry = new Entry()
{
UserId = Int32.Parse(User.FindFirst(ClaimTypes.NameIdentifier).Value),
Content = entryVM.Content,
Summary = entryVM.Summary,
Title = entryVM.Title,
State = entryVM.IsPrivate ? EntryStateEnum.Private : EntryStateEnum.Public,
Image = entryVM.Image
};
var result = _service.Create(entry);
return(Ok(result));
}
protected override int Modified(EntryViewModel model, UserInfo sysUser, string pkValue, string viewTitle, string formMode)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("AssetsMergeId", pkValue);
string sql = @"select * from AssetsMerge where AssetsMergeId=@AssetsMergeId";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, paras, DbUpdate.cmd).Tables[0];
dt.TableName = "AssetsMerge";
string AssetsMergeId = DataConvert.ToString(dt.Rows[0]["AssetsMergeId"]);
EntryModel myModel = model as EntryModel;
dt.Rows[0]["assetsMergeNo"] = myModel.AssetsMergeNo;
dt.Rows[0]["assetsMergeName"] = myModel.AssetsMergeName;
string updateType = "Modified";
if (formMode == "reapply")
{
dt.Rows[0]["approveState"] = "O";
updateType = "Reapply";
}
Update5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
DeleteDetail(pkValue, sysUser, viewTitle);
List <AssetsMerge> gridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(myModel.EntryGridString));
AssetsMerge AssetsMerge = gridData[0];
List <AssetsMerge> upGridData = JsonHelper.JSONStringToList <AssetsMerge>(DataConvert.ToString(myModel.UpEntryGridString));
foreach (AssetsMerge OriginalAssetsMerge in upGridData)
{
AddDetail(AssetsMerge, OriginalAssetsMerge, pkValue, sysUser, viewTitle, updateType);
}
if (formMode == "reapply")
{
InitFirstApproveTask("AssetsMerge", "AssetsMergeId", AssetsMergeId, viewTitle, formMode, sysUser.UserId);
}
return(1);
}
public ResponseModel <List <EntryViewModel> > Entry_CheckGet()
{
var list = _db.Entry.Where(x => x.No == "0");
var joblist = _db.Job.Where(x => true);
List <EntryViewModel> reList = new List <EntryViewModel>();
foreach (var item in list)
{
EntryViewModel entry = new EntryViewModel
{
Id = item.Id.ToString(),
StaffName = item.StaffName,
Sex = item.Sex == true ? "男" : "女",
BirthDay = Convert.ToDateTime(item.BirthDay),
Address = item.Address,
Email = item.Email,
Tel = item.Tel,
ProbationarySalary = item.ProbationarySalary,
CorrectSalary = item.CorrectSalary,
EntryDate = Convert.ToDateTime(item.EntryDate),
CreateStaffeId = item.CreateStaffeId.ToString(),
CreateTime = Convert.ToDateTime(item.CreateTime),
WorkNumber = joblist.Where(x => x.Id.ToString().ToLower() == item.WorkNumber.ToString().ToLower())
.FirstOrDefault().Name
};
;
entry.No = item.No;
entry.Title = item.Title;
entry.IsDel = item.IsDel;
reList.Add(entry);
}
return(new ResponseModel <List <EntryViewModel> >
{
code = (int)code.Success,
data = reList,
message = ""//获取未审核入职信息成功
});
}
public TestDroppableViewModel()
{
IProfile exProfile = new FileSystemInfoExProfile(null, null);
DropHelper = new DropHelper <IEntryModel>(
() => "Test Droppable",
(ems, eff) =>
QueryDropResult.CreateNew(DragDropEffects.Copy),
da =>
exProfile.DragDrop().GetEntryModels(da),
(ems, da, eff) =>
{
if (ems.Count() > 1)
{
Label = ems.Count() + " items.";
}
else
{
Label = ems.First().FullPath;
}
return(DragDropEffects.Copy);
}, em => EntryViewModel.FromEntryModel(em));
}
private void RecaclulateCommonTags(EntryViewModel add)
{
var images = GetAllImages(new EntryViewModel[] { add });
try
{
if (SelectedEntries.Count == 0 && images.Count() > 0)
{
IEnumerable <TagViewModel> tags = Chains.Where(a => a.ImageID == images.First().ID).Select(a => a.Tag).ToList();
SelectedEntityTags.AddRange(tags);
}
foreach (var image in images)
{
IEnumerable <TagViewModel> tags = Chains.Where(a => a.ImageID == image.ID).Select(a => a.Tag).ToList();
SelectedEntityTags = SelectedEntityTags.Intersect(tags).ToList();
}
}
catch (InvalidOperationException e)
{
s_logger.Warn(e);
}
}
protected override int Modified(EntryViewModel model, UserInfo sysUser, string pkValue, string viewTitle, string formMode)
{
Dictionary <string, object> paras = new Dictionary <string, object>();
paras.Add("barcodeStyleId", pkValue);
string sql = @"select * from BarcodeStyle where barcodeStyleId=@barcodeStyleId";
DataTable dt = AppMember.DbHelper.GetDataSet(sql, paras).Tables[0];
dt.TableName = "BarcodeStyle";
EntryModel myModel = model as EntryModel;
dt.Rows[0]["barcodeStyleName"] = myModel.BarcodeStyleName;
dt.Rows[0]["remark"] = myModel.Remark;
dt.Rows[0]["isDefaultStyle"] = myModel.IsDefaultStyle ? "Y" : "N";
string barcodeStyleJson = myModel.StyleJson.ToString();
string sync = myModel.Sync.ToString();
SaveDetail(ref barcodeStyleJson, pkValue, sync);
dt.Rows[0]["stylejson"] = barcodeStyleJson;
Update5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
return(1);
}
public async Task <ActionResult <EntryViewModel> > Create(EntryViewModel entry)
{
try
{
if (!ModelState.IsValid)
{
return(CustomResponse(ModelState));
}
var origin = CreateAccountInstance(entry.OriginAccountNumber, entry.Value);
var destiny = CreateAccountInstance(entry.DestinyAccountNumber, entry.Value * (-1));
if (!IsValid())
{
return(CustomResponse());
}
await _accountingEntryService.Save(origin, destiny);
}
catch (Exception ex)
{
NotifyError(ex.Message);
}
return(CustomResponse(entry));
}
protected override int Add(EntryViewModel model, UserInfo sysUser, string viewTitle)
{
string sqlcnt = @"select * from AppUser where isSysUser='******'";
DataTable dtcnt = AppMember.DbHelper.GetDataSet(sqlcnt).Tables[0];
if (dtcnt.Rows.Count >= 45)
{
throw new Exception("可创建的最大用户数为45，不能继续创建，请联系供应商。");
}
string sql = @"select * from AppUser where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AppUser";
DataRow dr = dt.NewRow();
EntryModel myModel = model as EntryModel;
SetDataRow(myModel, dr);
dr["userPwd"] = AppSecurity.Encryption.Encryt("123");
dr["userId"] = IdGenerator.GetMaxId(dt.TableName);
dt.Rows.Add(dr);
Create5Field(dt, sysUser.UserId, viewTitle);
return(DbUpdate.Update(dt));
}
public EntryViewModel UpdateEntry(EntryViewModel entryViewModel)
{
var model = _entryRepository.Get(x => x.Id == entryViewModel.Id);
model.Content = entryViewModel.Content;
model.UpdateDate = DateTime.Now;
try
{
var entity = _entryRepository.Update(model);
_entryRepository.SaveChanges();
return(new EntryViewModel()
{
Id = entity.Id, Content = entity.Content
});
}
catch (Exception ex)
{
var errorMessage = ex.Message;
throw;
}
}
public void FullyQualifiedUrl_ReturnsCorrectUrl()
{
// arrange
var urlHelper = new Mock <UrlHelper>();
var entry = new Entry(PostType.BlogPost)
{
Id = 123,
EntryName = "post-slug"
};
var blog = new Blog {
Host = "localhost"
};
var subtextContext = new Mock <ISubtextContext>();
subtextContext.Setup(c => c.UrlHelper.EntryUrl(It.IsAny <Entry>())).Returns("/2009/01/23/post-slug.aspx");
subtextContext.Setup(c => c.Blog).Returns(blog);
// act
var model = new EntryViewModel(entry, subtextContext.Object);
// assert
Assert.AreEqual(model.FullyQualifiedUrl, "http://localhost/2009/01/23/post-slug.aspx");
}
public ResponseModel <bool> Entry_Add(EntryViewModel item)
{
Entry entry = new Entry
{
Id = Guid.NewGuid(),
StaffName = item.StaffName,
Sex = item.Sex == "男" ? true : false,
BirthDay = Convert.ToDateTime(item.BirthDay),
Address = item.Address,
Email = item.Email,
Tel = item.Tel,
ProbationarySalary = item.ProbationarySalary,
CorrectSalary = item.CorrectSalary,
EntryDate = Convert.ToDateTime(item.EntryDate)
};
var user = _db.AspNetUsers.Where(x => x.UserName == item.CreateStaffeId).FirstOrDefault();
entry.CreateStaffeId = new Guid(user.Id);
entry.CreateTime = DateTime.Now;
entry.UpdateTime = DateTime.Now;
entry.WorkNumber = item.WorkNumber;
//默认
entry.No = "0";
entry.IsDel = false;
_db.Entry.Add(entry);
int num = _db.SaveChanges();
if (num > 0)
{
return(new ResponseModel <bool> {
code = (int)code.Success, data = true, message = "添加入职信息成功"
});
}
return(new ResponseModel <bool> {
code = (int)code.AddEntryFail, data = false, message = "添加入职信息失败"
});
}
public ActionResult Edit(int id)
{
var dbEntry = _entryRepo.GetEntry(id);
if (dbEntry == null)
{
return(HttpNotFound());
}
GetSignedUser();
if (!_signedUser.CanManageAllContent() && !dbEntry.Account.Equals(_signedUser))
{
return(RedirectToAction("Index", "Home"));
}
var viewModel = new EntryViewModel
{
Entry = dbEntry,
ContentCategories = _contentCategoryRepo.GetActiveContentCategories(),
ContentSubCategories = _contentCategoryRepo.GetContentSubcategoriesByParentId(dbEntry.ContentCategory.Id)
};
return(View(viewModel));
}
public EntryViewModel AddEntry(EntryViewModel model)
{
var entry = new Entry();
entry.Content = model.Content;
entry.CreateDate = DateTime.Now;
entry.UserId = model.UserId;
entry.PostId = model.PostId;
var entity = _entryRepository.Add(entry);
try
{
_entryRepository.SaveChanges();
return(new EntryViewModel()
{
Id = entity.Id, Content = entity.Content
});
}
catch (Exception ex)
{
var errorMessage = ex.Message;
throw;
}
}
public ActionResult ViewEntry(Int32 id = -1)
{
if (id == -1)
{
ViewBag.Error = "Válasszon bejegyzést!";
}
else
{
string uid = User.Identity.GetUserId();
if (User.IsInRole("Member"))
{
Entry entry = entities.Entry.FirstOrDefault(b => b.Id == id && b.UserId == uid);
if (entry != null)
{
EntryViewModel model = new EntryViewModel(entry.Id, entry.Title, entry.Desc, entry.Created, entry.Expire, entry.DoneDate);
ApplicationUser user = context.Users.FirstOrDefault(x => x.Id == entry.OwnerId);
model.Owner = user.UserName;
return(View(model));
}
}
else if (User.IsInRole("Admin"))
{
Entry entry = entities.Entry.FirstOrDefault(b => b.Id == id && b.OwnerId == uid);
if (entry != null)
{
EntryViewModel model = new EntryViewModel(entry.Id, entry.Title, entry.Desc, entry.Created, entry.Expire, entry.DoneDate);
ApplicationUser user = context.Users.FirstOrDefault(x => x.Id == entry.UserId);
model.Member = user.UserName;
return(View(model));
}
}
}
return(View());
}
public ActionResult SingleEntry(string Code)
{
EntryViewModel viewModel = new EntryViewModel();
HttpClient client = GetHttpClient();
var result = client.GetAsync($"/episerverapi/commerce/entries/{Code}").Result.Content.ReadAsStringAsync().Result;
viewModel.SelectedEntry = JsonConvert.DeserializeObject <Entry>(result);
var priceResult = client.GetAsync($"/episerverapi/commerce/entries/{Code}/prices").Result.Content.ReadAsStringAsync().Result;
viewModel.Prices = JsonConvert.DeserializeObject <IEnumerable <Price> >(priceResult);
var nodesResult = client.GetAsync("/episerverapi/commerce/catalog/Fashion/nodes").Result.Content.ReadAsStringAsync().Result;
IEnumerable <Node> rootNodes = JsonConvert.DeserializeObject <IEnumerable <Node> >(nodesResult);
foreach (var node in rootNodes)
{
viewModel.Nodes = FlattenNodes(node, client);
}
return(View(viewModel));
}
protected override int Add(EntryViewModel model, UserInfo sysUser, string viewTitle)
{
string sql = @"select * from AppWorkFlow where 1<>1 ";
DataTable dt = AppMember.DbHelper.GetDataSet(sql).Tables[0];
dt.TableName = "AppWorkFlow";
DataRow dr = dt.NewRow();
EntryModel myModel = model as EntryModel;
dr["wfName"] = myModel.WfName;
dr["approveTable"] = myModel.ApproveTable;
dr["remark"] = myModel.Remark;
dr["wfjson"] = myModel.WorkFlowJson;
string pk = DataConvert.ToString(myModel.ApproveTable);
dt.Rows.Add(dr);
string workFlowJson = myModel.WorkFlowJson.ToString();
SaveDetail(workFlowJson, pk);
Create5Field(dt, sysUser.UserId, viewTitle);
DbUpdate.Update(dt);
return(1);
}
public IActionResult AddEntry(EntryViewModel model, int postId)
{
var UserId = 0;
var user = HttpContext.User;
var dbUser = _userManager.GetUserAsync(user).Result;
UserId = dbUser.Id;
if (ModelState.IsValid)
{
model.PostId = postId;
model.UserId = UserId;
var entryEntity = _entryService.AddEntry(model);
if (entryEntity.Id > 0)
{
return(RedirectToAction(nameof(HomeController.Index), "Home"));
}
else
{
ModelState.AddModelError(string.Empty, "Kayıt başarısız");
}
}
return(View());
}
protected override bool CheckSelfBeforeSave(EntryViewModel model)
{
var myModel = model as EntryModel;
if (myModel.FormMode != "new")
{
if (Repository.HasApprovingFlow(myModel))
{
model.HasError = "true";
model.Message = AppMember.AppText["WorkflowHasProcessing"];
return(false);
}
}
else
{
if (Repository.HasWorkFlowForTableName(myModel))
{
model.HasError = "true";
model.Message = AppMember.AppText["WorkflowHasApproveTable"];
return(false);
}
}
return(true);
}
public async Task <IActionResult> SaveAsync(EntryViewModel entry)
{
if (!User.Identity.IsAuthenticated)
{
return(Redirect("/Home/Index"));
}
if (!ModelState.IsValid)
{
return(View("Create", entry));
}
HttpClient httpClient = new HttpClient();
AddTokenToClient(httpClient);
var response = await httpClient.PostAsJsonAsync($"{APIUrl}/api/Entries", entry);
if (!response.IsSuccessStatusCode)
{
return(View("Error"));
}
return(View("SavedSuccesfully"));
}
public void NavigateToUserProfile(EntryViewModel from)
{
var controller = NavigationViewProvider.GetViewController <RootNavigationViewController, EntryViewModel>(from);
controller.PushViewController(new UserProfileViewController(), false);
}
public static void AddEntry(EntryViewModel entry)
{
_entries.Add(entry);
}
public ViewerBaseViewModel(Profile <FI, DI, FSI> profile,
EntryViewModel <FI, DI, FSI> embedEntryViewModel)
: this(profile)
{
_embeddedEntryViewModel = embedEntryViewModel;
}
public DirectoryChangedEvent(object sender, IEntryModel newM, IEntryModel originalM)
: this(sender, EntryViewModel.FromEntryModel(newM), originalM == null ? null : EntryViewModel.FromEntryModel(originalM))
{
}
/// <summary>
/// Copies values from model to viewmodel
/// </summary>
public void CopyFromModel()
{
Properties = new EntryViewModel(Model.Properties.Clone(true));
}
public void NavigateToLogin(EntryViewModel fromViewModel)
{
var rootViewController = GetViewController <EntryViewModel, RootNavigationController>(fromViewModel);
rootViewController.NotNull().PushViewController(new LoginViewController(), false);
}
public IActionResult Create()
{
var vm = new EntryViewModel(new Entry(), _ctx.BlogCategories.ToList());
return(View(vm));
}
