/// <summary>
/// 更新关系表
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
EPRelationBll eprBll = new EPRelationBll();
List <EPRelation> eprList = new List <EPRelation>();
eprList.Clear();
int count = listBoxEmp.Items.Count;
if (count != 0)
{
for (int i = 0; i < count; i++)
{
EPRelation epr = new EPRelation();
epr.ProjectName = listBoxPro.SelectedItem.ToString();
epr.EmployeeId = listBoxEmp.Items[i].ToString().Split(' ')[0];
epr.CreateDate = DateTime.Now.ToString();
eprList.Add(epr);
}
bool b = eprBll.AddAfterDeleteInfo(eprList);
if (b)
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败");
}
}
}
/// <summary>
/// 根据项目名查询关系表
/// </summary>
/// <param name="name">项目名</param>
/// <returns>项目相同的,工号不同的关系类集合</returns>
public List <EPRelation> QueryByProName(string name)
{
string sql = "select * from EPRelation where ProjectName=@name";
SQLiteParameter paras = new SQLiteParameter("@name", name);
List <EPRelation> eprList = new List <EPRelation>();
eprList.Clear();
var reader = SQLiteHelper.ExecuteReader(sql, paras);
if (reader.HasRows)
{
while (reader.Read())
{
EPRelation epr = new EPRelation();
epr.EmployeeId = reader[2].ToString();
epr.ProjectName = reader[1].ToString();
eprList.Add(epr);
}
}
reader.Close();
return(eprList);
}
//根据员工编号查询关系表
public List <EPRelation> QueryLikeThis(string num)
{
List <EPRelation> list = new List <EPRelation>();
list.Clear();
string sql = " select * from EPRelation where EmployeeId like '%" + num + "%'";
var reader = SQLiteHelper.ExecuteReader(sql);
if (reader.HasRows)
{
while (reader.Read())
{
EPRelation epr = new EPRelation();
epr.Id = Convert.ToInt32(reader[0]);
epr.ProjectName = reader[1].ToString();
epr.EmployeeId = reader[2].ToString();
epr.CreateDate = reader[3].ToString();
list.Add(epr);
}
}
return(list);
reader.Close();
}
