public void Delete(AscmMaterialCategory ascmMaterialCategory) { try { YnDaoHelper.GetInstance().nHibernateHelper.Delete<AscmMaterialCategory>(ascmMaterialCategory); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmMaterialCategory)",ex); throw; } }
public ContentResult MaterialStockFormatRepair() { string userName = string.Empty; if (User.Identity.IsAuthenticated) { userName = User.Identity.Name; } JsonObjectResult jsonObjectResult = new JsonObjectResult(); List<AscmMaterialItem> list = null; try { string sql = string.Empty; object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialItem where isFlag = 0"); int nI = 0; int times = 0; if (int.TryParse(obj.ToString(), out nI) && nI > 0) { decimal temp = Convert.ToDecimal(nI) / 10000; times = Convert.ToInt16(Math.Ceiling(temp)); } if (times > 0) { for (int i = 0; i < times; i++) { #region 维护逻辑 sql = "from AscmMaterialItem where isFlag = 0 and rownum <= 10000 order by id"; IList<AscmMaterialItem> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialItem>(sql); if (ilist != null && ilist.Count > 0) { foreach (AscmMaterialItem ascmMaterialItem in ilist) { //添加物料大类 string categoryStr = ascmMaterialItem.docNumber.Substring(0, 4); object objcategory = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialCategory where categoryCode = '" + categoryStr + "'"); int categoryNI = 0; if (int.TryParse(objcategory.ToString(), out categoryNI) && categoryNI == 0) { AscmMaterialCategory ascmMaterialCategory = new AscmMaterialCategory(); int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialCategory"); ascmMaterialCategory.id = ++maxId; ascmMaterialCategory.createUser = userName; ascmMaterialCategory.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialCategory.modifyUser = userName; ascmMaterialCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialCategory.categoryCode = categoryStr; AscmMaterialCategoryService.GetInstance().Save(ascmMaterialCategory); } //添加物料小类 string subcategoryStr = ascmMaterialItem.docNumber.Substring(4, 3); AscmMaterialCategory category = AscmMaterialCategoryService.GetInstance().GetId(categoryStr); string combinationCode = categoryStr + "." + subcategoryStr; object objsubcategory = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialSubCategory where subCategoryCode = '" + subcategoryStr + "' and categoryId = " + category.id); int subcategoryNI = 0; if (int.TryParse(objsubcategory.ToString(), out subcategoryNI) && subcategoryNI == 0) { AscmMaterialSubCategory ascmMaterialSubCategory = new AscmMaterialSubCategory(); int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialSubCategory"); ascmMaterialSubCategory.id = ++maxId; ascmMaterialSubCategory.createUser = userName; ascmMaterialSubCategory.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialSubCategory.modifyUser = userName; ascmMaterialSubCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialSubCategory.subCategoryCode = subcategoryStr; ascmMaterialSubCategory.categoryId = category.id; ascmMaterialSubCategory.combinationCode = categoryStr + "." + subcategoryStr; AscmMaterialSubCategoryService.GetInstance().Save(ascmMaterialSubCategory); } else if (int.TryParse(objsubcategory.ToString(), out subcategoryNI) && subcategoryNI > 0) { sql = "from AscmMaterialSubCategory where combinationCode = '" + combinationCode + "'"; IList<AscmMaterialSubCategory> ilistSubCategory = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialSubCategory>(sql); if (ilistSubCategory != null && ilistSubCategory.Count > 0) { foreach (AscmMaterialSubCategory ascmMaterialSubCategory in ilistSubCategory) { if (!string.IsNullOrEmpty(ascmMaterialSubCategory.zMtlCategoryStatus)) { ascmMaterialItem.zMtlCategoryStatus = ascmMaterialSubCategory.zMtlCategoryStatus; } if (!string.IsNullOrEmpty(ascmMaterialSubCategory.dMtlCategoryStatus)) { ascmMaterialItem.dMtlCategoryStatus = ascmMaterialSubCategory.dMtlCategoryStatus; } if (!string.IsNullOrEmpty(ascmMaterialSubCategory.wMtlCategoryStatus)) { ascmMaterialItem.wMtlCategoryStatus = ascmMaterialSubCategory.wMtlCategoryStatus; } } } } AscmMaterialSubCategory subCategory = AscmMaterialSubCategoryService.GetInstance().GetId(combinationCode); if (subCategory != null) { ascmMaterialItem.subCategoryId = subCategory.id; ascmMaterialItem.isFlag = 1; AscmMaterialItemService.GetInstance().Update(ascmMaterialItem); } } } #endregion } } jsonObjectResult.result = true; jsonObjectResult.message = "已完成物料大类、小类及物料信息维护!"; } catch (Exception ex) { jsonObjectResult.result = false; jsonObjectResult.message = ex.Message; } string sReturn = JsonConvert.SerializeObject(jsonObjectResult); return Content(sReturn); }
public ContentResult MaterialCategorySave(AscmMaterialCategory ascmMaterialCategory_Model, int? id) { JsonObjectResult jsonObjectResult = new JsonObjectResult(); try { string userName = string.Empty; if (User.Identity.IsAuthenticated) { userName = User.Identity.Name; } AscmMaterialCategory ascmMaterialCategory = null; if (id.HasValue) { ascmMaterialCategory = AscmMaterialCategoryService.GetInstance().Get(id.Value); ascmMaterialCategory.modifyUser = userName; ascmMaterialCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } else { ascmMaterialCategory = new AscmMaterialCategory(); int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialCategory"); ascmMaterialCategory.id = ++maxId; ascmMaterialCategory.createUser = userName; ascmMaterialCategory.createUser = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialCategory.modifyUser = userName; ascmMaterialCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } if (ascmMaterialCategory == null) throw new Exception("保存物料大类信息失败!"); ascmMaterialCategory.description = ascmMaterialCategory_Model.description; ascmMaterialCategory.tip = ascmMaterialCategory_Model.tip; if (id.HasValue) { object object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmMaterialCategory id <>" + id.Value + " "); if (object1 == null) throw new Exception("查询异常!"); int iCount = 0; if (int.TryParse(object1.ToString(), out iCount) && iCount > 0) throw new Exception("已存在此物料大类信息【" + ascmMaterialCategory_Model.categoryCode + "】"); AscmMaterialCategoryService.GetInstance().Update(ascmMaterialCategory); } else { AscmMaterialCategoryService.GetInstance().Save(ascmMaterialCategory); } jsonObjectResult.result = true; jsonObjectResult.message = ""; jsonObjectResult.id = ascmMaterialCategory.id.ToString(); jsonObjectResult.entity = ascmMaterialCategory; } catch (Exception ex) { jsonObjectResult.result = false; jsonObjectResult.message = ex.Message; } string sReturn = JsonConvert.SerializeObject(jsonObjectResult); return Content(sReturn); }
public ActionResult DataRepair(int? page, int? rows, string sort, string order, string queryWord) { string userName = string.Empty; if (User.Identity.IsAuthenticated) { userName = User.Identity.Name; } List<AscmMaterialItem> list = null; JsonDataGridResult jsonDataGridResult = new JsonDataGridResult(); string sql = string.Empty; try { object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialItem where isFlag = 0"); int nI = 0; int times = 0; if (int.TryParse(obj.ToString(), out nI) && nI > 0) { decimal temp = Convert.ToDecimal(nI) / 10000; times = Convert.ToInt16(Math.Ceiling(temp)); } if (times > 0) { for (int i = 0; i < times; i++) { #region 维护逻辑 sql = "from AscmMaterialItem where isFlag = 0 and rownum <= 10000 order by id"; IList<AscmMaterialItem> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialItem>(sql); if (ilist != null && ilist.Count > 0) { foreach (AscmMaterialItem ascmMaterialItem in ilist) { //添加物料大类 string categoryStr = ascmMaterialItem.docNumber.Substring(0, 4); object objcategory = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialCategory where categoryCode = '" + categoryStr + "'"); int categoryNI = 0; if (int.TryParse(objcategory.ToString(), out categoryNI) && categoryNI == 0) { AscmMaterialCategory ascmMaterialCategory = new AscmMaterialCategory(); int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialCategory"); ascmMaterialCategory.id = ++maxId; ascmMaterialCategory.createUser = userName; ascmMaterialCategory.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialCategory.modifyUser = userName; ascmMaterialCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialCategory.categoryCode = categoryStr; AscmMaterialCategoryService.GetInstance().Save(ascmMaterialCategory); } //添加物料小类 string subcategoryStr = ascmMaterialItem.docNumber.Substring(4, 3); AscmMaterialCategory category = AscmMaterialCategoryService.GetInstance().GetId(categoryStr); string combinationCode = categoryStr + "." + subcategoryStr; object objsubcategory = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmMaterialSubCategory where subCategoryCode = '" + subcategoryStr + "' and categoryId = " + category.id); int subcategoryNI = 0; if (int.TryParse(objsubcategory.ToString(), out subcategoryNI) && subcategoryNI == 0) { AscmMaterialSubCategory ascmMaterialSubCategory = new AscmMaterialSubCategory(); int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmMaterialSubCategory"); ascmMaterialSubCategory.id = ++maxId; ascmMaterialSubCategory.createUser = userName; ascmMaterialSubCategory.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialSubCategory.modifyUser = userName; ascmMaterialSubCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); ascmMaterialSubCategory.subCategoryCode = subcategoryStr; ascmMaterialSubCategory.categoryId = category.id; ascmMaterialSubCategory.combinationCode = categoryStr + "." + subcategoryStr; AscmMaterialSubCategoryService.GetInstance().Save(ascmMaterialSubCategory); } else if (int.TryParse(objsubcategory.ToString(), out subcategoryNI) && subcategoryNI > 0) { sql = "from AscmMaterialSubCategory where combinationCode = '" + combinationCode + "'"; IList<AscmMaterialSubCategory> ilistSubCategory = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialSubCategory>(sql); if (ilistSubCategory != null && ilistSubCategory.Count > 0) { foreach (AscmMaterialSubCategory ascmMaterialSubCategory in ilistSubCategory) { if (!string.IsNullOrEmpty(ascmMaterialSubCategory.zMtlCategoryStatus)) { ascmMaterialItem.zMtlCategoryStatus = ascmMaterialSubCategory.zMtlCategoryStatus; } if (!string.IsNullOrEmpty(ascmMaterialSubCategory.dMtlCategoryStatus)) { ascmMaterialItem.dMtlCategoryStatus = ascmMaterialSubCategory.dMtlCategoryStatus; } if (!string.IsNullOrEmpty(ascmMaterialSubCategory.wMtlCategoryStatus)) { ascmMaterialItem.wMtlCategoryStatus = ascmMaterialSubCategory.wMtlCategoryStatus; } } } } AscmMaterialSubCategory subCategory = AscmMaterialSubCategoryService.GetInstance().GetId(combinationCode); if (subCategory != null) { ascmMaterialItem.subCategoryId = subCategory.id; ascmMaterialItem.isFlag = 1; AscmMaterialItemService.GetInstance().Update(ascmMaterialItem); } } } #endregion } } sql = "from AscmMaterialItem where isFlag = 0 order by docNumber"; YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage(); ynPage.SetPageSize(rows.HasValue ? rows.Value : YnBaseDal.YnPage.DEFAULT_PAGE_SIZE);//pageRows ynPage.SetCurrentPage(page.HasValue ? page.Value : 1);//pageNumber IList<AscmMaterialItem> newilist = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmMaterialItem>(sql,sql,ynPage); if (newilist != null && newilist.Count > 0) { list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmMaterialItem>(newilist); foreach (AscmMaterialItem ascmMaterialItem in list) { jsonDataGridResult.rows.Add(ascmMaterialItem); } } jsonDataGridResult.result = true; if (newilist.Count == 0) { jsonDataGridResult.message = "已完成物料大类、小类及物料信息维护!"; } jsonDataGridResult.total = ynPage.GetRecordCount(); } catch (Exception ex) { jsonDataGridResult.message = ex.Message; } return Json(jsonDataGridResult, JsonRequestBehavior.AllowGet); }
public void Update(AscmMaterialCategory ascmMaterialCategory) { try { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmMaterialCategory>(ascmMaterialCategory); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialCategory)", ex); throw ex; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmMaterialCategory)", ex); throw ex; } }