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