void BtnAddToProjectClick(object sender, EventArgs e)
{
//加入到项目相关单位
ProjectCompanies newPc = new ProjectCompanies();
ProjectCompany tPc = new ProjectCompany();
if (comboBox1.SelectedValue != null && comboBox1.SelectedValue.GetType() != typeof(DataRowView))
{
tPc.ProjectID = Convert.ToInt32(comboBox1.SelectedValue);
}
else
{
return;
}
if (dataGridViewCompanies.CurrentRow != null)
{
tPc.CompanyID = Convert.ToInt32(dataGridViewCompanies.CurrentRow.Cells["CompanyID"].Value);
newPc.CompanyType = Convert.ToInt32(dataGridViewCompanies.CurrentRow.Cells["CompanyType"].Value);
}
newPc.Ps = tPc;
BLL.CompanyBLL.AddProjectCompany(newPc);
//刷新项目供应商
RefreshProjectCompnies(newPc.Ps.ProjectID);
}
private static ProjectCompany ConvertIdsProjectToCompany(ProjectCompanies projComp)
{
return(new ProjectCompany
{
idCompany = projComp.idCompany,
idProject = projComp.idProject
});
}
public void InsertProjectToCompany(int idCompany, int idProject, string priceType, string discriptions, DateTime?DateStartProject, DateTime?DateFinishProject,
string paid, string destination)
{
var projectToCompany = new ProjectCompanies(idCompany, idProject, priceType, discriptions, paid, destination);
var dateProjectCompany = new DateProjectCompanies(idCompany, idProject, DateStartProject, DateFinishProject);
//ProjectToCompanyDataServices.Instance.InsertProjectToCompany(ConvertProjectToCompany(projectToCompany), ConvertDateProjectCompany(dateProjectCompany));
ProjectToCompanyDataServices.Instance.InsertProjectToCompany(projectToCompany.MapTo(new ProjectCompany()), dateProjectCompany.MapTo(new DateProjectCompany()));
}
private static ProjectCompany ConvertProjectToCompany(ProjectCompanies projComp)
{
return(new ProjectCompany
{
idCompany = projComp.idCompany,
idProject = projComp.idProject,
priceType = projComp.priceType,
discriptions = projComp.discriptions,
paid = projComp.paid,
destination = projComp.destination
});
}
public IEnumerable <ProjectCompanies> GetOldDestination(int idProject, int idCompany)
{
var proCom = new ProjectCompanies(idCompany, idProject);
var query = ProjectToCompanyDataServices.Instance.ViewingOldDestination(proCom.MapTo(new ProjectCompany()));
var list = new List <ProjectCompanies>();
foreach (var pc in query)
{
list.Add(new ProjectCompanies
{
destination = pc.destination
});
}
return(list);
}
//移除项目供应商
public static void RemoveProjectCompany(ProjectCompanies tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
ProjectCompanies toDelete = session.Get <ProjectCompanies>(tNew.Ps);
try
{
session.Delete(toDelete);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//指定的ProjectCompany需要添加吗？
private static bool CanAddProjectCompany(ProjectCompanies tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
int i_rtn = 0;
//查询，在ProjectCompany表中是否有
i_rtn = Convert.ToInt32(SQLiteHelper.ExecuteScalar("SELECT Count(*) FROM ProjectCompanies WHERE CompanyID = @CompanyID AND ProjectID=@ProjectID", tNew.Ps.CompanyID, tNew.Ps.ProjectID));
if (i_rtn > 0)
{
MessageBox.Show("要添加的单位在项目单位中存在，不需要添加！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
session.Close();
return(false);
}
session.Close();
return(true);
}
//加入项目供应商
public static void AddProjectCompany(ProjectCompanies tNew)
{
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
if (!CanAddProjectCompany(tNew))
{
session.Close();
return;
}
session.Save(tNew);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
public bool CheckProjectToCompany(ProjectCompanies projectCompany)
{
return(Services.ProjectCompaniesServices.Instance.ChackProjectToCompany(projectCompany.IdCompany, projectCompany.IdProject));
}
public void Delete(ProjectCompanies projectCompany)
{
Services.ProjectCompaniesServices.Instance.DeleteProjectToCompany(projectCompany.IdProject, projectCompany.IdCompany);
}
public string GetOldDestination(ProjectCompanies projectCompany)
{
return(Services.ProjectCompaniesServices.Instance.GetOldDestination(projectCompany.IdProject, projectCompany.IdCompany));
}
public void Update(ProjectCompanies projectCompany)
{
Services.ProjectCompaniesServices.Instance.UpdateProjectToCompany(projectCompany.IdCompany, projectCompany.IdProject, projectCompany.PriceType, projectCompany.Discriptions, projectCompany.DateStartProject, projectCompany.DateFinishProject, projectCompany.Paid, projectCompany.Destination);
}
public void DeleteProjectToCompany(int idCompany, int idProject)
{
var proCom = new ProjectCompanies(idCompany, idProject);
ProjectToCompanyDataServices.Instance.DeleteProjectToCompany(proCom.MapTo(new ProjectCompany()));
}
