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