public void TestProjectAdd1()
{
// TODO: Add your test.
CProjectInfo tp = new CProjectInfo();
tp.ProjectName = "测试添加，不包含projectID";
CProjectInfoBLL.AddProjectInfo(tp);
}
void ListBox1SelectedIndexChanged(object sender, EventArgs e)
{
if (((ListBox)sender).SelectedItem == null)
{
return;
}
Debug.WriteLine("当前选择：" + ((ListItem)((ListBox)sender).SelectedItem).Value);
CProjectInfo tp = CProjectInfoBLL.GetProjectInfo(Convert.ToInt32(((ListItem)((ListBox)sender).SelectedItem).Value));
textBoxProjectID.Text = tp.ProjectID.ToString();
textBoxProjectName.Text = tp.ProjectName;
textBoxBuildArea.Text = tp.BuildArea.ToString();
textBoxContractor.Text = tp.Contractor;
textBoxMomo.Text = tp.Memo;
}
//删除
void ButtonDelClick(object sender, EventArgs e)
{
if (listBox1.SelectedItem == null)
{
return;
}
DialogResult result;
int iProjectID = Convert.ToInt32(((ListItem)listBox1.SelectedItem).Value);
string sProjectName = ((ListItem)listBox1.SelectedItem).Text;
result = MessageBox.Show("您确认删除当前选中的【" + sProjectName + "】项目吗？", "删除确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == System.Windows.Forms.DialogResult.Yes)
{
CProjectInfoBLL.DelProjectInfo(iProjectID);
}
//刷新listbox
FillListBox1();
}
//填充ListBox
void FillListBox1()
{
listBox1.Items.Clear();
DataSet tds = new DataSet();
tds = CProjectInfoBLL.GetProjectInfos();
// listBox1.DataSource = tds.Tables[0];
// listBox1.DisplayMember = "ProjectName";
foreach (DataRow dr in tds.Tables[0].Rows)
{
Debug.WriteLine(dr[1].ToString());
//string ts = dr[0].ToString() + "," + dr[1].ToString();
ListItem tlt = new ListItem(dr[1].ToString(), dr[0].ToString());
listBox1.Items.Add(tlt);
}
//要求listBox重绘
}
//添加新项目
void ButtonAddClick(object sender, EventArgs e)
{
int i_LastProjectID;
i_LastProjectID = CProjectInfoBLL.GetMaxProjectID();
Debug.WriteLine("最大ProjectID=" + i_LastProjectID.ToString());
//检测输入合理性
if (CheckFillOK())
{
CProjectInfo tp = new CProjectInfo();
tp.ProjectID = i_LastProjectID + 1;
tp.ProjectName = textBoxProjectName.Text.Trim();
if (textBoxBuildArea.Text != "")
{
tp.BuildArea = Convert.ToInt32(textBoxBuildArea.Text);
}
else
{
tp.BuildArea = 0;
}
tp.Contractor = textBoxContractor.Text.Trim();
if (textBoxProjectDays.Text != "")
{
tp.ProjectDays = Convert.ToInt32(textBoxProjectDays.Text);
}
else
{
tp.ProjectDays = 0;
}
tp.Memo = textBoxMomo.Text.Trim();
//添加到数据库中
CProjectInfoBLL.AddProjectInfo(tp);
//刷新listbox
FillListBox1();
listBox1.Refresh();
// listBox1.Invalidate();
// listBox1.Update();
}
}
//修改
void ButtonModifyClick(object sender, EventArgs e)
{
if (listBox1.SelectedItem == null)
{
return;
}
if (CheckFillOK())
{
CProjectInfo tp = new CProjectInfo();
tp.ProjectID = Convert.ToInt32(((ListItem)listBox1.SelectedItem).Value);
tp.ProjectName = textBoxProjectName.Text;
if (textBoxBuildArea.Text == "")
{
tp.BuildArea = 0;
}
else
{
tp.BuildArea = Convert.ToInt32(textBoxBuildArea.Text);
}
tp.Contractor = textBoxContractor.Text;
if (textBoxProjectDays.Text == "")
{
tp.ProjectDays = 0;
}
else
{
tp.ProjectDays = Convert.ToInt32(textBoxProjectDays.Text);
}
tp.Memo = textBoxMomo.Text;
CProjectInfoBLL.UpdateProjectInfo(tp);
//刷新listbox
FillListBox1();
}
}
