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