public IHttpActionResult views(int id, string query) { string json = HttpUtility.UrlDecode(query); SearchParams reqParams = Tools.JsonDeserialize <SearchParams>(json); return(Ok(ExtendModule.ViewArticles(id, reqParams))); }
public IHttpActionResult MultDelete(int[] ids) { var query = Dbctx.GgcmsArticles.Where(x => ids.Contains(x.Id)); foreach (GgcmsArticles item in query.ToList()) { //删除关联附件 var attalist = Dbctx.GgcmsAttachments.Where(x => x.Articles_Id == item.Id); Dbctx.GgcmsAttachments.RemoveRange(attalist); //删除关联模型数据 var category = dbHelper.Categories(Math.Abs(item.Category_Id)); if (category != null) { if (category.ExtModelId > 0) { ExtendModule.Delete(item.Id, category.ExtModelId); } updateArticleNumber(item.Category_Id, -1); } //删除关联分页 Dbctx.GgcmsArticlePages.RemoveRange(Dbctx.GgcmsArticlePages.Where(x => x.Article_Id == item.Id)); } Dbctx.GgcmsArticles.RemoveRange(query); int c = Dbctx.SaveChanges(); ClearCache(); CacheHelper.RemoveAllCache(CacheTypeNames.Categorys); return(Ok(c)); }
public void Bind(ExtendModule.InstrumentAndConsumables mvaluables) { EquipPhoto.ImageUrl = "~/Equipment/PicShow.aspx?ID=" + mvaluables.ID; tbInstrumentNum.Text = mvaluables.Numbers; tbKindNum.Text = mvaluables.ClassNumber; tbInstrumentName.Text = mvaluables.Name; tbStandards.Text = mvaluables.Standards; tbModel.Text = mvaluables.Model; tbCountryCode.Text = mvaluables.CountryCode; tbAmount.Text = mvaluables.Quantity.ToString(); tbUnitPrice.Text = mvaluables.UnitPrice; tbFactoryCode.Text = mvaluables.FactoryCode; tbDocuments.Text = mvaluables.Documents; tbMeasurement.Text = mvaluables.Measurement; try { tbProductionDate.Text = mvaluables.ProductionDate.Value.ToShortDateString(); tbPurchaseDate.Text = mvaluables.PurchaseDate.Value.ToShortDateString(); tbOpeningTime.Text = mvaluables.OpeningTime.Value.ToShortDateString(); tbCreatedDate.Text = mvaluables.CreatedDate.Value.ToShortDateString(); } catch { } tbResponesoblePerson.Text = mvaluables.ResponesoblePerson; tbContactPhone.Text = mvaluables.ContactPhone; tbCharges.Text = mvaluables.Charges; tbZipCode.Text = mvaluables.ZipCode; tbMailingAddress.Text = mvaluables.MailingAddress; tbPurpose.Text = mvaluables.Purpose; }
// DELETE: api/GgcmsCategories/5 public IHttpActionResult Delete(int id) { GgcmsArticles info = Dbctx.GgcmsArticles.Find(id); if (info == null) { return(BadRequest("信息不存在")); } //删除关联模型数据 var category = dbHelper.Categories(Math.Abs(info.Category_Id)); if (category != null) { if (category.ExtModelId > 0) { ExtendModule.Delete(info.Id, category.ExtModelId); } updateArticleNumber(info.Category_Id, -1); } Dbctx.GgcmsArticles.Remove(info); //删除关联附件 Dbctx.GgcmsAttachments.RemoveRange(Dbctx.GgcmsAttachments.Where(x => x.Articles_Id == info.Id)); //删除关联分页 Dbctx.GgcmsArticlePages.RemoveRange(Dbctx.GgcmsArticlePages.Where(x => x.Article_Id == info.Id)); Dbctx.SaveChanges(); ClearCache(); CacheHelper.RemoveAllCache(CacheTypeNames.Categorys); return(Ok(info)); }
// POST: api/GgcmsCategories public IHttpActionResult Add(GgcmsArticles info) { //提交除附加模型外的文件-标题图,内容中的图 UpFileClass.FileSave(info, info.files.FindAll(x => x.fileType != 3)); info.CreateTime = DateTime.Now; updateArticleNumber(info.Category_Id, 1); CacheHelper.RemoveAllCache(CacheTypeNames.Categorys); if (info.ModuleInfo != null && info.ModuleInfo.Id > 0) { info.ExtModelId = info.ModuleInfo.Id; } info.pagesCount = info.pages.Count + 1; var result = Dbctx.GgcmsArticles.Add(info); Dbctx.SaveChanges(); //附件 using (GgcmsDB db = new GgcmsDB()) { foreach (GgcmsAttachments attach in info.attachments) { attach.Articles_Id = info.Id; attach.CreateTime = DateTime.Now; db.GgcmsAttachments.Add(attach); } db.SaveChanges(); } //数据模型 if (info.ModuleInfo != null && info.ModuleInfo.Id > 0) { foreach (var file in info.files.FindAll(x => x.fileType == 3)) { foreach (var item in info.ModuleInfo.Columns) { if (item.ColName == file.propertyName) { item.Value = UpFileClass.FileSave(file.filePath.ToString(), item.Value.ToString(), (int)file.fileType); } } } ExtendModule.SaveData(info.Id, info.ModuleInfo); } //分页保存 if (info.pages.Count > 0) { foreach (var page in info.pages) { UpFileClass.FileSave(page, page.files); page.Article_Id = info.Id; Dbctx.GgcmsArticlePages.Add(page); } Dbctx.SaveChanges(); } ClearCache(); return(Ok(result)); }
// GET: api/GgcmsCategories/5 public IHttpActionResult GetInfo(int id) { GgcmsModules module = ExtendModule.GetGgcmsModule(id); if (module != null) { return(Ok(module)); } return(BadRequest("信息不存在")); }
public IHttpActionResult Delete(int id) { ExtendModule.TableDelete(id); GgcmsModules module = Dbctx.GgcmsModules.Where(x => x.Id == id).FirstOrDefault(); if (module != null) { Dbctx.GgcmsModules.Remove(module); Dbctx.SaveChanges(); } ClearCache(); return(Ok(id)); }
// POST: api/GgcmsCategories public IHttpActionResult Add(GgcmsModules module) { if (!ExtendModule.ColumnsCheck(module)) { return(BadRequest("字段关键字重复")); } var result = Dbctx.GgcmsModules.Add(module); Dbctx.SaveChanges(); result.TableName = "moduleTab_" + result.Id.ToString(); result.ViewName = "moduleView_" + result.Id.ToString(); ExtendModule.TableCreate(module); Dbctx.SaveChanges(); ClearCache(); return(Ok(result)); }
// PUT: api/GgcmsCategories/5 public IHttpActionResult Edit(GgcmsModules module) { if (!ExtendModule.ColumnsCheck(module)) { return(BadRequest("字段关键字重复")); } if (module.Columns != null) { GgcmsModules oldModule = ExtendModule.GetGgcmsModule(module.Id); module.TableName = oldModule.TableName; module.ViewName = oldModule.ViewName; ExtendModule.TableChange(module, oldModule); } Dbctx.SaveChanges(); ClearCache(); return(Ok(module)); }
public void Bind(ExtendModule.GoodsMaintain mgoods) { tbLabNum.Text = mgoods.LabName.ToString(); tbManager.Text = mgoods.AssetManagers.ToString(); try { tbReportTime.Text = mgoods.ReportedTime.Value.ToShortDateString(); } catch { } tbTelNum.Text = mgoods.Tel.ToString(); tbStoreAdd.Text = mgoods.StorageSites.ToString(); tbLowname.Text = mgoods.Name.ToString(); tbLowNum.Text = mgoods.Numbers.ToString(); tbApplyer.Text = mgoods.Applicant.ToString(); isInTime.SelectedValue = mgoods.Guarantee.ToString(); tbDescription.Text = mgoods.Describe.ToString(); }
public void bindDDL(ExtendModule.InstrumentAndConsumables instrument) { ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); tbCreatedDate.Text = DateTime.Today.ToLongDateString(); listCClass = eDictionary.GetItemListByDClass("haocaileibie"); ddlCClass.DataSource = listCClass; ddlCClass.DataTextField = "Name"; ddlCClass.DataValueField = "Code"; ddlCClass.DataBind(); listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan"); ddlSource.DataSource = listCClass; ddlSource.DataTextField = "Name"; ddlSource.DataValueField = "Code"; ddlSource.DataBind(); listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang"); ddlArrow.DataSource = listCClass; ddlArrow.DataTextField = "Name"; ddlArrow.DataValueField = "Code"; ddlArrow.DataBind(); listCClass = eDictionary.GetItemListByDClass("jingfeikemu"); ddlFundsSubject.DataSource = listCClass; ddlFundsSubject.DataTextField = "Name"; ddlFundsSubject.DataValueField = "Code"; ddlFundsSubject.DataBind(); listCClass = eDictionary.GetItemListByDClass("dangwei"); ddlModle.DataSource = listCClass; ddlModle.DataTextField = "Name"; ddlModle.DataValueField = "Code"; ddlModle.DataBind(); ExtendBLL.InstrumentAndConsumables eConsum = new ExtendBLL.InstrumentAndConsumables(); int iMaxCID = eConsum.GetMaxId(); MaxCID.Value = iMaxCID.ToString("D10"); tbInstrumentNum.Text = iMaxCID.ToString("D10"); tbLocation.Text = instrument.LabName; tbLocationCode.Text = instrument.StockLocation; }
public void bindDDL(ExtendModule.InstrumentAndConsumables mconsum) { labelCreatDate.Text = DateTime.Today.ToShortDateString(); ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); listCClass = eDictionary.GetItemListByDClass("haocaileibie"); ddlCClass.DataSource = listCClass; ddlCClass.DataTextField = "Name"; ddlCClass.DataValueField = "Code"; ddlCClass.DataBind(); ddlCClass.SelectedValue = mconsum.ClassNumber; listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan"); ddlComeFrom.DataSource = listCClass; ddlComeFrom.DataTextField = "Name"; ddlComeFrom.DataValueField = "Code"; ddlComeFrom.DataBind(); ddlComeFrom.SelectedValue = mconsum.Source; listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang"); ddlArrow.DataSource = listCClass; ddlArrow.DataTextField = "Name"; ddlArrow.DataValueField = "Code"; ddlArrow.DataBind(); ddlArrow.SelectedValue = mconsum.Arrow; listCClass = eDictionary.GetItemListByDClass("jingfeikemu"); ddlFundsSubject.DataSource = listCClass; ddlFundsSubject.DataTextField = "Name"; ddlFundsSubject.DataValueField = "Code"; ddlFundsSubject.DataBind(); ddlFundsSubject.SelectedValue = mconsum.FundsSubject; listCClass = eDictionary.GetItemListByDClass("dangwei"); ddlModle.DataSource = listCClass; ddlModle.DataTextField = "Name"; ddlModle.DataValueField = "Code"; ddlModle.DataBind(); ddlModle.SelectedValue = mconsum.Measurement; tbLocation.Text = mconsum.LabName; tbLocationCode.Text = mconsum.StockLocation; }
public IHttpActionResult MultDelete(int[] ids) { try { var query = Dbctx.GgcmsModules.Where(x => ids.Contains(x.Id)); foreach (var item in query.ToList()) { GgcmsModules module = item as GgcmsModules; ExtendModule.TableDelete(module.Id); } Dbctx.GgcmsModules.RemoveRange(query); int c = Dbctx.SaveChanges(); ClearCache(); return(Ok(c)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public void bindDDL(ExtendModule.InstrumentAndConsumables mvaluables) { tbCreatedDate.Text = DateTime.Today.ToShortDateString(); ExtendBLL.Dictionary eDictionary = new ExtendBLL.Dictionary(); List<Model.Dictionary> listCClass = new List<LabMS.Model.Dictionary>(); listCClass = eDictionary.GetItemListByDClass("shebeilaiyuan"); ddlSource.DataSource = listCClass; ddlSource.DataTextField = "Name"; ddlSource.DataValueField = "Code"; ddlSource.DataBind(); ddlSource.SelectedValue = mvaluables.Source; listCClass = eDictionary.GetItemListByDClass("shiyongfangxiang"); ddlArrow.DataSource = listCClass; ddlArrow.DataTextField = "Name"; ddlArrow.DataValueField = "Code"; ddlArrow.DataBind(); ddlArrow.SelectedValue = mvaluables.Arrow; listCClass = eDictionary.GetItemListByDClass("shebeizhuangtai"); ddlPresentSituation.DataSource = listCClass; ddlPresentSituation.DataTextField = "Name"; ddlPresentSituation.DataValueField = "Code"; ddlPresentSituation.DataBind(); ddlPresentSituation.SelectedValue = mvaluables.ResponesoblePerson; listCClass = eDictionary.GetItemListByDClass("jingfeikemu"); ddlFundsSubject.DataSource = listCClass; ddlFundsSubject.DataTextField = "Name"; ddlFundsSubject.DataValueField = "Code"; ddlFundsSubject.DataBind(); ddlFundsSubject.SelectedValue = mvaluables.FundsSubject; tbLocation.Text = mvaluables.LabName; tbLocationCode.Text = mvaluables.StockLocation; }
void bind(ExtendModule.InstrumentAndConsumables mconsum) { EquipPhoto.ImageUrl = "~/Equipment/PicShow.aspx?ID=" + mconsum.ID; lbClassNub.Text = mconsum.ClassNumber.ToString(); lbCName.Text = mconsum.Name; lbCNub.Text = mconsum.Numbers; lbCountry.Text = mconsum.CountryCode; lbDocuments.Text = mconsum.Documents.ToString(); lbFNub.Text = mconsum.FactoryCode.ToString(); lbNub.Text = mconsum.Quantity.ToString(); lbPrice.Text = mconsum.UnitPrice; lbPurpose.Text = mconsum.Purpose; try { lbProduceDate.Text = mconsum.ProductionDate.Value.ToShortDateString(); } catch { } try { lbCreatDate.Text = mconsum.CreatedDate.Value.ToShortDateString(); } catch { } try { lbBuyDate.Text = mconsum.PurchaseDate.Value.ToShortDateString(); } catch { } lbTypeNub.Text = mconsum.Model; lbVENDOR.Text = "";//应加上 }
public IHttpActionResult GetGgcmsModuleValue(int aid, int mid) { return(Ok(ExtendModule.GetModuleToDict(aid, mid))); }
// PUT: api/GgcmsCategories/5 public IHttpActionResult Edit(GgcmsArticles info) { if (Dbctx.GgcmsArticles.Where(x => x.Id == info.Id).Count() == 0) { return(BadRequest("信息不存在")); } //Dbctx.GgcmsArticles.Attach(info); //Dbctx.Entry(info).Property("goods_name").IsModified = true; var ent = Dbctx.Entry(info); ent.State = EntityState.Modified; info.pagesCount = info.pages.Where(x => x.state != EntityState.Deleted).Count() + 1; UpFileClass.FileSave(info, info.files.FindAll(x => x.fileType != 3)); var old = Dbctx.GgcmsArticles.Find(info.Id); if (old.Category_Id != info.Category_Id) { updateArticleNumber(info.Category_Id, 1); updateArticleNumber(old.Category_Id, -1); CacheHelper.RemoveAllCache(CacheTypeNames.Categorys); } var list = Dbctx.GgcmsAttachments.Where(x => x.Articles_Id == info.Id).ToList(); //附件 foreach (GgcmsAttachments attach in list) { var item = info.attachments.Find(x => x.Id == attach.Id); if (item == null) { Dbctx.GgcmsAttachments.Remove(attach); } else { attach.AttaUrl = item.AttaUrl; attach.AttaTitle = item.AttaTitle; attach.Describe = item.Describe; attach.CreateTime = DateTime.Now; attach.RealName = item.RealName; } } foreach (GgcmsAttachments attach in info.attachments) { if (attach.Id == 0) { attach.Articles_Id = info.Id; attach.CreateTime = DateTime.Now; Dbctx.GgcmsAttachments.Add(attach); } } if (info.ModuleInfo != null) { info.ExtModelId = info.ModuleInfo.Id; if (old.ExtModelId > 0 && info.ExtModelId != old.ExtModelId) { ExtendModule.Delete(info.Id, old.ExtModelId); } foreach (var file in info.files.FindAll(x => x.fileType == 3)) { foreach (var item in info.ModuleInfo.Columns) { if (item.ColName == file.propertyName) { item.Value = UpFileClass.FileSave(file.filePath.ToString(), item.Value.ToString(), (int)file.fileType); } } } ExtendModule.SaveData(info.Id, info.ModuleInfo); } else if (old.ExtModelId > 0) { ExtendModule.Delete(info.Id, old.ExtModelId); } //分页保存 if (info.pages.Count > 0) { foreach (var page in info.pages) { UpFileClass.FileSave(page, page.files); if (page.state == EntityState.Added) { page.Article_Id = info.Id; Dbctx.GgcmsArticlePages.Add(page); } else if (page.state == EntityState.Modified) { var pageEnt = Dbctx.Entry(page); pageEnt.State = EntityState.Modified; } else if (page.state == EntityState.Deleted) { var p = Dbctx.GgcmsArticlePages.Find(page.Id); if (p != null) { Dbctx.GgcmsArticlePages.Remove(p); } } //只更新分页信息 else if (page.state == EntityState.Unchanged) { Dbctx.GgcmsArticlePages.Attach(page); Dbctx.Entry(info).Property("OrderId").IsModified = true; } } } Dbctx.SaveChanges(); ClearCache(); return(Ok(info)); }
void bind(ExtendModule.InstrumentAndConsumables instrument) { EquipPhoto.ImageUrl = "~/Equipment/PicShow.aspx?ID=" + instrument.ID; tbStandards.Text = instrument.Standards; tbContactPhone.Text = instrument.ContactPhone.ToString(); tbResponesoblePerson.Text = instrument.ResponesoblePerson; tbPurpose.Text = instrument.Purpose; tbModel.Text = instrument.Model; tbKindNum.Text = instrument.ClassNumber.ToString(); tbInstrumentName.Text = instrument.Name; tbInstrumentNum.Text = instrument.Numbers; tbCountry.Text = instrument.CountryCode; tbDocuments.Text = instrument.Documents.ToString(); tbFactoryCode.Text = instrument.FactoryCode.ToString(); tbAmount.Text = instrument.Quantity.ToString(); tbUnitPrice.Text = instrument.UnitPrice; try { tbProductionDate.Text = instrument.ProductionDate.Value.ToShortDateString(); } catch { } try { tbCreatedDate.Text = instrument.CreatedDate.Value.ToShortDateString(); } catch { } try { tbPurchaseDate.Text = instrument.PurchaseDate.Value.ToShortDateString(); } catch { } //tbVENDOR.Text = "";//应加上 }