private void LoadProductInfoByDelFlag(int p)
{
ProductInfoBLL bll = new ProductInfoBLL();
dgvProduct.AutoGenerateColumns = false;
dgvProduct.DataSource = bll.GetProductInfoByDelFlag(p);
dgvProduct.SelectedRows[0].Selected = false;
}
private void LoadProductInfoByCatId(int p, TreeNodeCollection tnc)
{
ProductInfoBLL bll = new ProductInfoBLL();
List<ProductInfo> list = bll.GetProductInfoByCatId(p);
for(int i=0; i<list.Count; i++)
{
tnc.Add(list[i].ProName + "====="+list[i].ProPrice+"元");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if(CheckEmpty())
{
ProductInfo pro = new ProductInfo();
pro.CatId = Convert.ToInt32(cmbCategory.SelectedValue);
pro.ProCost = Convert.ToDecimal(txtCost.Text);
pro.ProName = txtName.Text;
pro.ProNum = txtNum.Text;
pro.ProPrice = Convert.ToDecimal(txtPrice.Text);
pro.ProSpell = txtSpell.Text;
pro.ProUnit = txtUnit.Text;
pro.Remark = txtRemark.Text;
if(this.Tp == 3)
{
pro.DelFlag = 0;
pro.SubBy = 1;
pro.SubTime = System.DateTime.Now;
}
else if(this.Tp == 4)
{
pro.ProId = Convert.ToInt32(labId.Text);
}
ProductInfoBLL bll = new ProductInfoBLL();
if(bll.SaverProduct(pro,this.Tp))
{
MessageBox.Show("操作失败");
}
else
{
MessageBox.Show("操作成功");
}
this.Close();
}
}
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);
}
}
//search for id and alphaet
private void txtSearch_TextChanged(object sender, EventArgs e)
{
if(string.IsNullOrEmpty(txtSearch.Text))
{
LoadProductInfoByDelFlag(0);
return;
}
int n = 0;
if(char.IsLetter(txtSearch.Text[0]))
{
//the first text is alphaet
n = 1;
}
else
{
//the first is number
n = 2;
}
ProductInfoBLL bll = new ProductInfoBLL();
dgvProduct.AutoGenerateColumns = false;
dgvProduct.DataSource = bll.GetProductInfoBySpellOrNum(txtSearch.Text, n);
if(dgvProduct.SelectedRows.Count > 0)
{
dgvProduct.SelectedRows[0].Selected = false;
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
//获取文本框的内容
string txt = txtSearch.Text;
//传到bll层
ProductInfoBLL bll = new ProductInfoBLL();
List<ProductInfo> list = bll.GetProductInfoByProNum(txt);
//集合绑定到dgv上
dgvProductInfo.AutoGenerateColumns = false;
dgvProductInfo.DataSource = list;
if(dgvProductInfo.SelectedRows.Count>0)
{
dgvProductInfo.SelectedRows[0].Selected = false;
}
}
private void cmbCategory_SelectedIndexChanged(object sender, EventArgs e)
{
if(cmbCategory.SelectedIndex !=0)
{
int id = Convert.ToInt32(cmbCategory.SelectedValue);
ProductInfoBLL bll = new ProductInfoBLL();
dgvProductInfo.AutoGenerateColumns = false;
dgvProductInfo.DataSource = bll.GetProductInfoByCatId(id);
if(dgvProductInfo.SelectedRows.Count>0)
{
dgvProductInfo.SelectedRows[0].Selected = false;
}
}
else
{
LoadProductInfoByDelFlag(0);
}
}
//Update Product
private void btnUpdatePro_Click(object sender, EventArgs e)
{
if(dgvProductInfo.SelectedRows.Count>0)
{
int id = Convert.ToInt32(dgvProductInfo.SelectedRows[0].Cells[0].Value.ToString());
ProductInfoBLL bll = new ProductInfoBLL();
ProductInfo pro = bll.GetProductInfoById(id);
if(pro!=null)
{
meaFcp.Obj = pro;
InsertOrUpdate(4);
}
}
else
{
MessageBox.Show("请选中Product");
}
}
private void btnDeletePro_Click(object sender, EventArgs e)
{
if(dgvProductInfo.SelectedRows.Count>0)
{
//提示
if(DialogResult.OK == MessageBox.Show("真的要删除吗","删除",MessageBoxButtons.OKCancel,MessageBoxIcon.Question))
{
int id = Convert.ToInt32(dgvProductInfo.SelectedRows[0].Cells[0].Value.ToString());
ProductInfoBLL bll = new ProductInfoBLL();
if(bll.DeleteProductInfoByProId(id))
{
MessageBox.Show("操作成功");
}
else
{
MessageBox.Show("操作失败");
}
LoadProductInfoByDelFlag(0);
}
}
else
{
MessageBox.Show("请选择要删除的行");
}
}