public AscmMaterialCategory GetId(string categoryCode) { AscmMaterialCategory MaterialCategory = null; try { string sql = " from AscmMaterialCategory"; string where = "", whereQueryWord = ""; if (!string.IsNullOrEmpty(categoryCode)) { whereQueryWord = "categorycode = '" + categoryCode + "'"; } where = YnBaseClass2.Helper.StringHelper.SqlWhereAndAdd(where, whereQueryWord); if (!string.IsNullOrEmpty(where)) { sql += " where " + where; } IList <AscmMaterialCategory> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmMaterialCategory>(sql); if (ilist != null && ilist.Count > 0) { foreach (AscmMaterialCategory ascmMaterialCategory in ilist) { MaterialCategory = ascmMaterialCategory; break; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmMaterialItem)", ex); throw ex; } return(MaterialCategory); }
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; } }
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 void Delete(int id) { try { AscmMaterialCategory ascmMaterialCategory = Get(id); Delete(ascmMaterialCategory); } catch (Exception ex) { throw ex; } }
public AscmMaterialCategory Get(int id) { AscmMaterialCategory ascmMaterialCategory = null; try { ascmMaterialCategory = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmMaterialCategory>(id); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmMaterialCategory)"); throw ex; } return(ascmMaterialCategory); }