private void addPInfo_Click(object sender, EventArgs e) { try { if (this.lvMInfo.SelectedItems.Count == 0) return; frmSelectPInfo fspi = new frmSelectPInfo(); PurveyInfoData pid = (PurveyInfoData)fspi.ShowSelect(); foreach (ListViewItem lvi in this.lvPurvey.Items) { if ((PurveyInfoData)lvi.Tag == pid) { lvi.Selected = true; return; } } frmInput fi = new frmInput("请输入供应价格"); string str = fi.ShowInput(); double price = Convert.ToDouble(str); PurveyData pd = new PurveyData(); pd.PInfoID = pid.ID; pd.MInfoID = ((MerchandiseInfoData)this.lvMInfo.SelectedItems[0].Tag).ID; pd.Price = price; int i = PurveyCortrol.addPurevey(pd); pd.ID = i; addPurevey(pid, pd); } catch (MessageException ex) { if (ex.Message != "") MessageBox.Show(ex.Message); } }
/// <summary> /// 向PListView里插入一条记录 /// </summary> /// <param name="pid"></param> /// <param name="id">对应记录ID存储在第三列Tag</param> private void addPurevey(PurveyInfoData pid, PurveyData pd) { try { //供应商名 ListViewItem lvi = new ListViewItem(pid.Name); lvi.Tag = pid; //添加商品单价 ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem(); lvs.Text = pd.Price.ToString(); lvs.Tag = pd; lvi.SubItems.Add(lvs); //添加送货天数 lvi.SubItems.Add(pid.Days.ToString()); //添加供应商类型 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.Address); this.lvPurvey.Items.Add(lvi); } catch (MessageException ex) { MessageBox.Show(ex.Message); } }
public static int addPurevey(PurveyData pd) { int i = p.insertPurvey(pd); pd.ID = i; ls.Add(pd); return(i); }
public static void delPurevey(PurveyData pd) { p.delPurvey(pd); for (int i = 0; i < ls.Count; i++) { if (pd.ID == ls[i].ID) { ls.RemoveAt(i); break; } } }
private void delPInfo_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("您确定要删除这些选中的项目吗?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) foreach (ListViewItem lvi in this.lvPurvey.SelectedItems) { PurveyData pd = (PurveyData)lvi.SubItems[1].Tag; //pd.ID = ; PurveyCortrol.delPurevey(pd); lvi.Remove(); } }
/// <summary> /// 删除供应商品 /// </summary> /// <param name="purvey">供应商品类</param> /// <returns></returns> public int delPurvey(PurveyData purvey) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("delete from Purvey where ID = @id", conn); cmd.Parameters.AddWithValue("@id", purvey.ID); int i = cmd.ExecuteNonQuery(); conn.Close(); return(i); }
/// <summary> /// 修改供应商品 /// </summary> /// <param name="purvey">供应商品类</param> /// <returns></returns> public int updatePurvey(PurveyData purvey) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("update purvey set PInfoID = @PinfoID,MInfoID = @MInfoID,Price = @Price where ID = @id", conn); cmd.Parameters.AddWithValue("@id", purvey.ID); cmd.Parameters.AddWithValue("@PInfoID", purvey.PInfoID); cmd.Parameters.AddWithValue("@MInfoID", purvey.MInfoID); cmd.Parameters.AddWithValue("@Price", purvey.Price); int i = cmd.ExecuteNonQuery(); conn.Close(); return(i); }
/// <summary> /// 插入供应商品 /// </summary> /// <param name="purvey">供应商品类</param> /// <returns></returns> public int insertPurvey(PurveyData purvey) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("insert into Purvey values(@PInfoID,@MInfoID,@Price)", conn); cmd.Parameters.AddWithValue("@PInfoID", purvey.PInfoID); cmd.Parameters.AddWithValue("@MInfoID", purvey.MInfoID); cmd.Parameters.AddWithValue("@Price", purvey.Price); cmd.ExecuteNonQuery(); cmd.CommandText = "select @@IDENTITY"; int i = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(i); }
/// <summary> /// 查询供应商品 /// </summary> /// <param name="purvey">供应商品类</param> /// <returns>返回供应商品集合</returns> public List <PurveyData> selPurvey() { List <PurveyData> list = new List <PurveyData>(); SqlConnection conn = new SqlConnection(connStr); SqlDataAdapter sda = new SqlDataAdapter("select * from purvey", conn); DataSet ds = new DataSet(); sda.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) { PurveyData pd = new PurveyData(); pd.ID = (int)dr[0]; pd.PInfoID = (int)dr[1]; pd.MInfoID = (int)dr[2]; pd.Price = Convert.ToDouble(dr[3]); list.Add(pd); } return(list); }
private void lvHint_DoubleClick(object sender, EventArgs e) { if (this.lvHint.SelectedItems.Count == 0) { return; } ListViewItem lvi = this.lvHint.SelectedItems[0]; PurveyData pd = (PurveyData)lvi.Tag; MerchandiseInfoData mid = MInfoCortrol.getMInfoOfID(pd.MInfoID); foreach (TreeNode tn in this.mTypeTreeView.tvMType.Nodes) { selectNotes(tn, mid.TypeID); } foreach (ListViewItem lv in this.lvMInfo.Items) { if (lv.Tag == mid) { lv.Selected = true; } } }