public int Update(ProjectSupplier pp)
{
var bd = db.ProjectSuppliers.Where(a => a.ID == pp.ID).SingleOrDefault();
bd.SupplierID = pp.SupplierID;
bd.ProjectID = bd.ProjectID;
return(db.SaveChanges());
}
//指定的ProjectSupplier需要添加吗？
private static bool CanAddProjectSupplier(ProjectSupplier tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
int i_rtn = 0;
//查询，在ProjectSupplier表中是否有
i_rtn = Convert.ToInt32(SQLiteHelper.ExecuteScalar("SELECT Count(*) FROM ProjectSupplier WHERE SupplierID = @SuppierID AND ProjectID=@ProjectID", tNew.Ps.SupplierID, tNew.Ps.ProjectID));
if (i_rtn > 0)
{
MessageBox.Show("要添加的供货商在项目供应商表中存在，不需要添加！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
session.Close();
return(false);
}
session.Close();
return(true);
}
//移除项目供应商
public static void RemoveProjectSupplier(ProjectSupplier tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
ProjectSupplier toDelete = session.Get <ProjectSupplier>(tNew.Ps);
try
{
session.Delete(toDelete);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//加入项目供应商
public static void AddProjectSupplier(ProjectSupplier tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
if (!CanAddProjectSupplier(tNew))
{
session.Close();
return;
}
session.Save(tNew);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
public long Insert(ProjectSupplier buider)
{
db.ProjectSuppliers.Add(buider);
db.SaveChanges();
return(buider.ID);
}
