public void Delete(AscmMaterialSubCategory ascmMaterialSubCategory)
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Delete<AscmMaterialSubCategory>(ascmMaterialSubCategory);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmMaterialSubCategory)", ex);
throw ex;
}
}
public ContentResult MaterialSubCategorySave(AscmMaterialSubCategory ascmMaterialSubCategory_Model, int? id)
{
JsonObjectResult jsonObjectResult = new JsonObjectResult();
try
{
string userName = string.Empty;
if (User.Identity.IsAuthenticated)
{
userName = User.Identity.Name;
}
AscmMaterialSubCategory ascmMaterialSubCategory = null;
if (id.HasValue)
{
ascmMaterialSubCategory = AscmMaterialSubCategoryService.GetInstance().Get(id.Value);
ascmMaterialSubCategory.modifyUser = userName;
ascmMaterialSubCategory.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
else
{
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");
}
if (ascmMaterialSubCategory == null)
throw new Exception("保存物料子类信息失败 ！");
if (ascmMaterialSubCategory_Model.subCategoryCode == null || ascmMaterialSubCategory_Model.subCategoryCode == "")
throw new Exception("物料子类不能为空！");
ascmMaterialSubCategory.zMtlCategoryStatus = ascmMaterialSubCategory_Model.zMtlCategoryStatus;
ascmMaterialSubCategory.dMtlCategoryStatus = ascmMaterialSubCategory_Model.dMtlCategoryStatus;
ascmMaterialSubCategory.wMtlCategoryStatus = ascmMaterialSubCategory_Model.wMtlCategoryStatus;
ascmMaterialSubCategory.description = ascmMaterialSubCategory_Model.description;
ascmMaterialSubCategory.tip = ascmMaterialSubCategory_Model.tip;
if (id.HasValue)
AscmMaterialSubCategoryService.GetInstance().Update(ascmMaterialSubCategory);
else
AscmMaterialSubCategoryService.GetInstance().Save(ascmMaterialSubCategory);
jsonObjectResult.result = true;
jsonObjectResult.message = "";
//jsonObjectResult.id = ascmMaterialSubCategory.id.ToString();
//jsonObjectResult.entity = ascmMaterialSubCategory;
}
catch (Exception ex)
{
jsonObjectResult.result = false;
jsonObjectResult.message = ex.Message;
}
string sReturn = JsonConvert.SerializeObject(jsonObjectResult);
return Content(sReturn);
}
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 void Update(AscmMaterialSubCategory ascmMaterialSubCategory)
{
try
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmMaterialSubCategory>(ascmMaterialSubCategory);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmMaterialSubCategory)", ex);
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Get AscmMaterialSubCategory)", ex);
throw ex;
}
}
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);
}
