private void btnAmend_Click(object sender, EventArgs e)
{
try
{
if (this.lvMType.SelectedItems.Count == 0)
{
throw new MessageException("请选择要修改的项目！");
}
checkText();
MerchandiseInfoData mid = getMInfo();
mid.ID = ((MerchandiseInfoData)this.lvMType.SelectedItems[0].Tag).ID;
MInfoCortrol.updMInfo(mid);
ListViewItem lvi = new ListViewItem(mid.Name);
lvi.Tag = mid;
ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem();
MerchandiseTypeData ptd = MTypeCortrol.getMTypeOfID(mid.TypeID);
lvs.Text = ptd.Name;
lvs.Tag = ptd;
lvi.SubItems.Add(lvs);
lvi.SubItems.Add(mid.Quantity.ToString());
this.lvMType.Items[this.lvMType.SelectedIndices[0]] = lvi;
clear();
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
TreeNode tn = this.mTypeTreeView1.tvMType.SelectedNode;
if (tn == null)
{
throw new MessageException("请选择要删除的项目！");
}
else if (Convert.ToInt32(tn.Tag) == 1)
{
throw new MessageException("该项目不能删除！");
}
else if (MTypeCortrol.checkChild(Convert.ToInt32(tn.Tag)))
{
throw new MessageException("该项目下有子项目不能删除！");
}
MerchandiseTypeData mtd = new MerchandiseTypeData();
mtd.ID = Convert.ToInt32(tn.Tag);
mtd.Name = tn.Text;
mtd.ParentID = Convert.ToInt32(tn.Parent.Tag);
MTypeCortrol.delTypeName(mtd);
this.mTypeTreeView1.tvMType.Nodes.Remove(tn);
}
catch (SqlException)
{
MessageBox.Show("该类型正在被使用，不能删除！");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAmend_Click(object sender, EventArgs e)
{
try
{
TreeNode tn = this.mTypeTreeView1.tvMType.SelectedNode;
if (tn == null)
{
throw new MessageException("请选择要修改的项目！");
}
else if (Convert.ToInt32(tn.Tag) == 1)
{
throw new MessageException("该项目不能修改！");
}
frmInput ipt = new frmInput("请输入新类型名：", tn.Text);
string str = ipt.ShowInput();
MerchandiseTypeData mtd = new MerchandiseTypeData();
mtd.ID = Convert.ToInt32(tn.Tag);
mtd.Name = str;
mtd.ParentID = Convert.ToInt32(tn.Parent.Tag);
MTypeCortrol.updTypeName(mtd);
tn.Text = str;
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnAccession_Click(object sender, EventArgs e)
{
try
{
if (this.mTypeTreeView1.tvMType.SelectedNode == null)
{
throw new MessageException("请选择父项目！");
}
frmInput ipt = new frmInput("请输入商品类型：");
string str = ipt.ShowInput();
MerchandiseTypeData mtd = new MerchandiseTypeData();
mtd.Name = str;
mtd.ParentID = Convert.ToInt32(this.mTypeTreeView1.tvMType.SelectedNode.Tag);
int i = MTypeCortrol.addTypeName(mtd);
TreeNode tn = new TreeNode(str);
tn.Tag = i;
this.mTypeTreeView1.tvMType.SelectedNode.Nodes.Add(tn);
}
catch (MessageException ex)
{
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 增加类型
/// </summary>
/// <param name="mtd"></param>
/// <returns>新增加记录的id</returns>
public static int addTypeName(MerchandiseTypeData mtd)
{
int i = mt.insertMerchandiseType(mtd);
mtd.ID = i;
ls.Add(mtd);
return(i);
}
/// <summary>
/// 删除商品类别
/// </summary>
/// <param name="merType">商品类别类</param>
/// <returns></returns>
public int delMerchandiseType(MerchandiseTypeData merType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("delete from MerchandiseType where id = @id", conn);
cmd.Parameters.AddWithValue("@id", merType.ID);
int i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
/// <summary>
/// 删除类型名
/// </summary>
/// <param name="ptd">欲删除的类</param>
public static void delTypeName(MerchandiseTypeData mtd)
{
mt.delMerchandiseType(mtd);
int i;
for (i = 0; i < ls.Count; i++)
{
if (mtd.ID == ls[i].ID)
{
ls.RemoveAt(i);
break;
}
}
}
/// <summary>
/// 修改类型名
/// </summary>
/// <param name="ptd"></param>
public static void updTypeName(MerchandiseTypeData mtd)
{
mt.updateMerchandiseType(mtd);
int i;
for (i = 0; i < ls.Count; i++)
{
if (mtd.ID == ls[i].ID)
{
ls[i] = mtd;
break;
}
}
}
/// <summary>
/// 显示类型选择窗口，如果选择空抛出MessageException异常
/// </summary>
/// <returns>返回商品类型类</returns>
public Object ShowSelect()
{
this.ShowDialog();
if (ok == false)
{
throw new MessageException("");
}
MerchandiseTypeData mtd = new MerchandiseTypeData();
mtd.ID = Convert.ToInt32(this.mTypeTreeView.tvMType.SelectedNode.Tag);
mtd.Name = this.mTypeTreeView.tvMType.SelectedNode.Text;
mtd.ParentID = Convert.ToInt32(this.mTypeTreeView.tvMType.SelectedNode.Parent.Tag);
return(mtd);
}
/// <summary>
/// 修改商品类别
/// </summary>
/// <param name="merType">商品类别类</param>
/// <returns></returns>
public int updateMerchandiseType(MerchandiseTypeData merType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("update MerchandiseType set name = @name,parentID = @parentID where id = @id", conn);
cmd.Parameters.AddWithValue("@id", merType.ID);
cmd.Parameters.AddWithValue("@name", merType.Name);
cmd.Parameters.AddWithValue("@parentID", merType.ParentID);
int i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
//private int _iD;
//private string _name;
//private int _parentID;
/// <summary>
/// 插入商品类别
/// </summary>
/// <param name="merType">商品类别类</param>
/// <returns>返回新增加记录的自动编号</returns>
public int insertMerchandiseType(MerchandiseTypeData merType)
{
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
SqlCommand cmd = new SqlCommand("insert into MerchandiseType values(@name,@parentID)", conn);
cmd.Parameters.AddWithValue("@name", merType.Name);
cmd.Parameters.AddWithValue("@parentID", merType.ParentID);
cmd.ExecuteNonQuery();
cmd.CommandText = "select @@IDENTITY";
int i = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(i);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
frmSelectMType frmSM = new frmSelectMType();
MerchandiseTypeData mtd = (MerchandiseTypeData)frmSM.ShowSelect();
this.txtGenre.Tag = mtd;
this.txtGenre.Text = mtd.Name;
}
catch (MessageException ex)
{
if (ex.Message != "")
{
MessageBox.Show(ex.Message);
}
}
}
/// <summary>
/// 查询商品类别
/// </summary>
/// <param name="merType">商品类别类</param>
/// <returns>返回商品类别的集合</returns>
public List <MerchandiseTypeData> selMerchandiseType()
{
List <MerchandiseTypeData> list = new List <MerchandiseTypeData>();
SqlConnection conn = new SqlConnection(connStr);
SqlDataAdapter sda = new SqlDataAdapter("select * from MerchandiseType", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
MerchandiseTypeData mer = new MerchandiseTypeData();
mer.ID = (int)dr[0];
mer.Name = dr[1].ToString();
mer.ParentID = (int)dr[2];
list.Add(mer);
}
return(list);
}
private void addMIinfo(MerchandiseInfoData mid)
{
try
{
ListViewItem lvi = new ListViewItem(mid.Name);
lvi.Tag = mid;
ListViewItem.ListViewSubItem lvs = new ListViewItem.ListViewSubItem();
MerchandiseTypeData mtd = MTypeCortrol.getMTypeOfID(mid.TypeID);
lvs.Text = mtd.Name;
lvs.Tag = mtd;
lvi.SubItems.Add(lvs);
lvi.SubItems.Add(mid.Quantity.ToString());
this.lvMType.Items.Add(lvi);
}
catch (MessageException ex)
{
MessageBox.Show(ex.Message);
}
}
