private void LoadCategoryInfoByDelFlag(int p)
{
CategoryInfoBLL bll = new CategoryInfoBLL();
List<CategoryInfo> list = new List<CategoryInfo>();
list = bll.GetCategoryInfoByDelFlag(p);
list.Insert(0, new CategoryInfo() { CatName = "请选择", CatId = -1 });
cmbCategory.DataSource = list;
cmbCategory.DisplayMember = "CatName";
cmbCategory.ValueMember = "CatId";
}
private void LoadCategoryInfoByDelFlag(int p)
{
CategoryInfoBLL bll = new CategoryInfoBLL();
List<CategoryInfo> list = bll.GetCategoryInfoByDelFlag(p);
for(int i=0; i < list.Count; i++)
{
TreeNode tn = tvCategory.Nodes.Add(list[i].CatName);
LoadProductInfoByCatId(list[i].CatId, tn.Nodes);
}
}
private void LoadCategoryInfoByDelFlag(int p)
{
CategoryInfoBLL bal = new CategoryInfoBLL();
dgvCategoryInfo.AutoGenerateColumns = false;
dgvCategoryInfo.DataSource = bal.GetCategoryInfoByDelFlag(p);
dgvCategoryInfo.SelectedRows[0].Selected = false;
}
private void LoadCategoryInfoByDelFlagToCmb(int p)
{
CategoryInfoBLL bal = new CategoryInfoBLL();
dgvCategoryInfo.AutoGenerateColumns = false;
List<CategoryInfo> list = bal.GetCategoryInfoByDelFlag(p);
list.Insert(0, new CategoryInfo() { CatId = -1, CatName = "请选择" });
cmbCategory.DataSource = list;
cmbCategory.DisplayMember = "CatName";
cmbCategory.ValueMember = "CatId";
}
private void benDeleteCategory_Click(object sender, EventArgs e)
{
if(dgvCategoryInfo.SelectedRows.Count<=0)
{
MessageBox.Show("请选择要删除的行");
return;
}
if(DialogResult.OK == MessageBox.Show("删除类别","Are you sure?",MessageBoxButtons.OKCancel,MessageBoxIcon.Question))
{
int id = Convert.ToInt32(dgvCategoryInfo.SelectedRows[0].Cells[0].Value.ToString());
ProductInfoBLL bll = new ProductInfoBLL();
int r = bll.GetProductInfoCountByCatId(id);
if(r > 0)
{
MessageBox.Show("该类别有产品，不能删除");
return;
}
CategoryInfoBLL cbll = new CategoryInfoBLL();
string msg = cbll.SoftDeleteCategoryInfoByCatId(id) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
LoadCategoryInfoByDelFlag(0);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if(CheckEmpty())
{
CategoryInfo ct = new CategoryInfo();
ct.CatName = txtCName.Text;
ct.CatNum = Convert.ToInt32(txtCNum.Text);
ct.Remark = txtCRemark.Text;
if(this.Tp == 1)
{
ct.DelFlag = 0;
ct.SubBy = 1;
ct.SubTime = DateTime.Now;
}
else if(this.Tp == 2)
{
ct.CatId = Convert.ToInt32(labId.Text);
}
CategoryInfoBLL bll = new CategoryInfoBLL();
string msg = bll.SaveCategoryInfo(ct, this.Tp) ? "操作成功" : "操作失败";
MessageBox.Show(msg);
this.Close();
}
}
//UpdateProductCategory
private void btnUpdateCategory_Click(object sender, EventArgs e)
{
if(dgvCategoryInfo.SelectedRows.Count>0)
{
//选中行后获取id
//根据id获取该对象
int id = Convert.ToInt32(dgvCategoryInfo.SelectedRows[0].Cells[0].Value.ToString());
//根据id去数据库查询
CategoryInfoBLL bll = new CategoryInfoBLL();
CategoryInfo ct = bll.GetCategoryInfoById(id);
if(ct !=null)
{
mea.Obj = ct;
LoadFrmChangeCategoryInfo(2);
}
}
else
{
MessageBox.Show("please select!!");
}
}
