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