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);
}
