private void buttonAdd_Click(object sender, EventArgs e)
{
if (!CheckData())
{
return;
}
if (tabData != null)
{
DataRow[] matchs = tabData.Select("Level='" + level + "'");
if (matchs.Length > 0)
{
MessageBox.Show("效益层级已经存在", "信息提示", MessageBoxButtons.OK);
return;
}
}
PerformanceBean b = new PerformanceBean();
b.Level = level;
b.BaseSalary = salary;
PerformanceDAO d = new PerformanceDAO();
d.AddPerformance(b);
LoadData();
}
private void LoadData()
{
PerformanceDAO d = new PerformanceDAO();
DataSet set = d.GetAllPerformance();
tabData = set.Tables[0];
gridCtrl.DataSource = tabData;
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (id == -1)
{
return;
}
PerformanceBean b = new PerformanceBean();
b.Id = id;
PerformanceDAO d = new PerformanceDAO();
d.DeletePerformance(b);
LoadData();
}
private void LoadBaseInfo()
{
PostDAO d = new PostDAO();
DataSet set = d.GetAllPost();
tabPost = set.Tables[0];
PerformanceDAO ado = new PerformanceDAO();
set = ado.GetAllPerformance();
tabPerformance = set.Tables[0];
BenefitDAO bd = new BenefitDAO();
set = bd.GetAllBenefit();
tabBenefit = set.Tables[0];
}
private void LoadBaseInfo()
{
PostDAO d = new PostDAO();
DataSet set = d.GetAllPost();
tabPost = set.Tables[0];
repositoryItemLookUpEditPost.DataSource = tabPost;
PerformanceDAO ado = new PerformanceDAO();
set = ado.GetAllPerformance();
tabPerformance = set.Tables[0];
repositoryItemLookUpEditPerformance.DataSource = tabPerformance;
BenefitDAO bd = new BenefitDAO();
set = bd.GetAllBenefit();
tabBenefit = set.Tables[0];
repositoryItemLookUpEditBenefit.DataSource = tabBenefit;
//repositoryItemComboBoxPost.Items.Clear();
//PostDAO d = new PostDAO();
//DataSet set = d.GetAllPost();
//tabPost = set.Tables[0];
//foreach (DataRow r in tabPost.Rows)
//{
// repositoryItemComboBoxPost.Items.Add(r["Level"].ToString());
//}
//repositoryItemComboBoxPerformance.Items.Clear();
//PerformanceDAO ado = new PerformanceDAO();
//set = ado.GetAllPerformance();
//tabPerformance = set.Tables[0];
//foreach (DataRow r in tabPerformance.Rows)
//{
// repositoryItemComboBoxPerformance.Items.Add(r["Level"].ToString());
//}
//repositoryItemComboBoxBenefit.Items.Clear();
//BenefitDAO bd = new BenefitDAO();
//set = bd.GetAllBenefit();
//tabBenefit = set.Tables[0];
//foreach (DataRow r in tabBenefit.Rows)
//{
// repositoryItemComboBoxBenefit.Items.Add(r["Level"].ToString());
//}
}
public int addPerformance(int angle, string movement_id)
{
Performance performance = new Performance();
PerformanceDAO performanceDao = new PerformanceDAO();
performance.Angle = angle;
performance.Movement_id = movement_id;
int result = performanceDao.InsertToSPerformance(performance);
if (result == -1)
{
return(result);
}
else
{
Debug.Log("Se ha presentado un error con la base de datos");
}
return(0);
}
public void savePerformance(int angle, string mov)
{
Performance pf = new Performance(angle, mov, currentGameSessionId.ToString());
PerformanceDAO.InsertPerformance(pf);
}
