private void btnAmend_Click(object sender, EventArgs e)
{
try
{
if (this.lvPureves.SelectedItems.Count == 0)
{
throw new MessageException("请选择要修改的项目！");
}
checkText();
PurveyInfoData pid = getPInfo();
pid.ID = ((PurveyInfoData)this.lvPureves.SelectedItems[0].Tag).ID;
PInfoCortrol.updPurveyInfo(pid);
ListViewItem lvi = new ListViewItem(pid.Name);
lvi.Tag = pid;
ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem();
PurveyTypeData ptd = PTypeCortrol.getPTypeOfID(pid.PTypeID);
lvs.Text = ptd.TypeName;
lvs.Tag = ptd;
lvi.SubItems.Add(lvs);
lvi.SubItems.Add(pid.LinkMan);
lvi.SubItems.Add(pid.Tel);
lvi.SubItems.Add(pid.Fox);
lvi.SubItems.Add(pid.Email);
lvi.SubItems.Add(pid.Days.ToString());
lvi.SubItems.Add(pid.Address);
this.lvPureves.Items[this.lvPureves.SelectedIndices[0]] = lvi;
clear();
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 向ListView里插入一条记录
/// </summary>
/// <param name="pid"></param>
private void addPurevey(PurveyInfoData pid)
{
try
{
ListViewItem lvi = new ListViewItem(pid.Name);
lvi.Tag = pid;
ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem();
PurveyTypeData ptd = PTypeCortrol.getPTypeOfID(pid.PTypeID);
lvs.Text = ptd.TypeName;
lvs.Tag = ptd;
lvi.SubItems.Add(lvs);
lvi.SubItems.Add(pid.Days.ToString());
lvi.SubItems.Add(pid.LinkMan);
lvi.SubItems.Add(pid.Tel);
lvi.SubItems.Add(pid.Fox);
lvi.SubItems.Add(pid.Email);
lvi.SubItems.Add(pid.Address);
this.lvPureves.Items.Add(lvi);
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 增加类型名并返回新ID
/// </summary>
/// <param name="ptd">增加的类</param>
/// <returns>新ID</returns>
public static int addTypeName(PurveyTypeData ptd)
{
int i = pt.insertPurveyType(ptd);
ptd.ID = i;
ls.Add(ptd);
return(i);
}
/// <summary>
/// 删除供应商类型
/// </summary>
/// <param name="purveyType">返回供应商类型类</param>
/// <returns></returns>
public int delPurveyType(PurveyTypeData purveyType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("delete from purveyType where id = @id", conn);
cmd.Parameters.AddWithValue("@id", purveyType.ID);
int i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
/// <summary>
/// 更新供应商类型
/// </summary>
/// <param name="purveyType">返回供应商类型类</param>
/// <returns></returns>
public int updatePurveyType(PurveyTypeData purveyType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("update purveyType set TypeName = @TypeName where id = @id", conn);
cmd.Parameters.AddWithValue("@id", purveyType.ID);
cmd.Parameters.AddWithValue("TypeName", purveyType.TypeName);
int i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
/// <summary>
/// 删除类型名并返回所处集合的下标
/// </summary>
/// <param name="ptd"><增加的类/param>
/// <returns>所处集合的下标</returns>
public static int delTypeName(PurveyTypeData ptd)
{
pt.delPurveyType(ptd);
int i;
for (i = 0; i < ls.Count; i++)
{
if (ptd.ID == ls[i].ID)
{
ls.RemoveAt(i);
break;
}
}
return(i);
}
/// <summary>
/// 修改类型名并返回所处集合的下标
/// </summary>
/// <param name="ptd"><增加的类/param>
/// <returns>所处集合的下标</returns>
public static int updTypeName(PurveyTypeData ptd)
{
pt.updatePurveyType(ptd);
int i;
for (i = 0; i < ls.Count; i++)
{
if (ptd.ID == ls[i].ID)
{
ls[i] = ptd;
break;
}
}
return(i);
}
/// <summary>
/// 插入供应商类型
/// </summary>
/// <param name="purveyType">返回供应商类型类</param>
/// <returns></returns>
public int insertPurveyType(PurveyTypeData purveyType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("insert into purveyType values(@TypeName)", conn);
cmd.Parameters.AddWithValue("@TypeName", purveyType.TypeName);
cmd.ExecuteNonQuery();
cmd.CommandText = "select @@IDENTITY";
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(i);
}
/// <summary>
/// 查询供应商类型
/// </summary>
/// <param name="purveyType">返回供应商类型类</param>
/// <returns>返回供应商类型的集合</returns>
public List <PurveyTypeData> selPurveyType()
{
List <PurveyTypeData> list = new List <PurveyTypeData>();
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter sda = new SqlDataAdapter("select * from purveyType", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PurveyTypeData purType = new PurveyTypeData();
purType.ID = (int)dr[0];
purType.TypeName = dr[1].ToString();
list.Add(purType);
}
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
frmSelectPType frm = new frmSelectPType();
PurveyTypeData pd = (PurveyTypeData)frm.ShowSelect();
this.txtGenre.Text = pd.TypeName;
this.txtGenre.Tag = pd;
}
catch (MessageException ex)
{
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
}
private void btnAccession_Click(object sender, EventArgs e)
{
frmInput ipt = new frmInput("请输入类型名！");
try
{
string str = ipt.ShowInput();
int i = PTypeCortrol.addTypeName(new PurveyTypeData(0, str));
PurveyTypeData ptd = new PurveyTypeData(i, str);
this.pTypeListBox.lbPType.Items.Add(ptd);
}
catch (Exception ex)
{
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
}
private void btnAmend_Click(object sender, EventArgs e)
{
frmInput ipt = new frmInput("请输入类型名！", this.pTypeListBox.lbPType.SelectedItem.ToString());
try
{
string str = ipt.ShowInput();
PurveyTypeData ptd = new PurveyTypeData(((PurveyTypeData)this.pTypeListBox.lbPType.SelectedItem).ID, str);
int i = PTypeCortrol.updTypeName(ptd);
this.pTypeListBox.lbPType.Items[i] = ptd;
}
catch (MessageException ex) {
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
PurveyTypeData ptd = new PurveyTypeData(((PurveyTypeData)this.pTypeListBox.lbPType.SelectedItem).ID, "");
int i = PTypeCortrol.delTypeName(ptd);
this.pTypeListBox.lbPType.Items.RemoveAt(i);
if (this.pTypeListBox.lbPType.Items.Count >= i + 1)
{
this.pTypeListBox.lbPType.SelectedIndex = i;
}
else
if (this.pTypeListBox.lbPType.Items.Count >= i)
{
this.pTypeListBox.lbPType.SelectedIndex = i - 1;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
