private void btnOk_Click(object sender, EventArgs e)
{
//新增或者修改
if (CheckEmpty())
{
ProductInfoBll proBll = new ProductInfoBll();
ProductInfo pro = new ProductInfo();
pro.CId = Convert.ToInt32(cmbCategory.SelectedValue);//获取选择的类别
pro.ProCost = Convert.ToDouble(txtCost.Text);//价格
pro.ProName = txtName.Text;//名字
pro.ProNum = txtNum.Text;//编号
pro.ProPrice = Convert.ToDouble(txtPrice.Text);//实际的价格
pro.ProSpell = txtSpell.Text;//拼音
pro.ProStock = Convert.ToInt32(txtStock.Text);
pro.ProUnit = txtUnit.Text;//单位
pro.Remark = txtRemark.Text; ;//备注
if (Temp == 1)//新增
{
pro.DelFlag = 0;
pro.SubBy = 1;
pro.SubTime = System.DateTime.Now;//当前时间
}
else if (Temp == 2)//修改
{
pro.ProId = Convert.ToInt32(labId.Text);
}
md.MsgDivShow(proBll.AddOrUpdateProductInfo(pro, Temp) ? "操作成功" : "操作失败", 1, Bind);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (CheckBox3())
{
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.ProStock = Convert.ToDecimal(txtStock.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();
string msg3 = bll.SaveProductInfo(pro, this.TP) ? "操作成功" : "操作失败";
MessageBox.Show(msg3);
this.Close();
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
//int temp = 0;
//if (string.IsNullOrEmpty(txtSearch.Text))//空
//{
//}
//else
//{
////搜索
//if (char.IsLetter(txtSearch.Text[0]))//字母
//{
// temp = 1;
//}
//else
//{
// temp = 2;
//}
//}
int temp = string.IsNullOrEmpty(txtSearch.Text) ? 0 : char.IsLetter(txtSearch.Text[0]) ? 1 : 2;
ProductInfoBll proBll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false;//禁止自动生成列
dgvProduct.DataSource = proBll.GetProductByProSpellOrProNum(temp, txtSearch.Text);
dgvProduct.ClearSelection();
}
private void benDeleteCategory_Click(object sender, EventArgs e)
{
if (dgvCategoryInfo.SelectedRows.Count <= 0)
{
MessageBox.Show("请选定后再删除");
return;
}
if (DialogResult.OK == MessageBox.Show("你舍得删除么", "删除类别", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
int r = -1;
int id = Convert.ToInt32(dgvCategoryInfo.SelectedRows[0].Cells[0].Value.ToString());
ProductInfoBll bll = new ProductInfoBll();
List <ProductInfo> list = bll.GetProductInfoByCatid(id);
r = list.Count;
if (r > 0)
{
MessageBox.Show("该类别下有产品，不能删除，如想强制删除，请联系售后");
}
else
{
CategoryInfoBll bll_c = new CategoryInfoBll();
string msg4 = bll_c.SoftDeleteCategoryInfoByCatId(id) ? "删除好了" : "删除出错了";
MessageBox.Show(msg4);
LoadCategoryInfoByDelFlag(0);
}
}
}
//注销商品类别
private void btnDeleteCategory_Click(object sender, EventArgs e)
{
if (dgvCategory.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选择要注销的商品类别");
return;
}
if (MessageBox.Show("确定删除该类别吗", "删除商品类别", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
//获取类别ID
int cId = ((CategoryInfo)dgvCategory.SelectedRows[0].DataBoundItem).CId;
ProductInfoBll proBll = new ProductInfoBll();
if (proBll.GetProductInfoCountByCId(cId) > 0)
{
md.MsgDivShow("抱歉，该类别下有产品，不能删除");
return;
}
CategoryInfoBll cBll = new CategoryInfoBll();
md.MsgDivShow(cBll.SoftDeleteCategoryByCId(cId) ? "操作成功" : "操作失败", 1);
LoadAllCategoryInfoByDelFlag(0);
return;
}
md.MsgDivShow("取消了", 1);
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
int n = 0;
if (string.IsNullOrEmpty(txtSearch.Text))
{
LoadProductInfoByDelFlag(0);
return;
}
if (char.IsLetter(txtSearch.Text[0]))
{
n = 1;
}
else
{
n = 2;
}
ProductInfoBll pbll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false;
dgvProduct.DataSource = pbll.GetProductInfoBySpellOrNum(txtSearch.Text, n);
if (dgvProduct.SelectedRows.Count > 0)
{
dgvProduct.SelectedRows[0].Selected = false;
}
}
private void btnOk_Click(object sender, EventArgs e)
{
//新增或者修改
if (CheckEmpty())
{
ProductInfoBll proBll = new ProductInfoBll();
ProductInfo pro = new ProductInfo();
pro.CId = Convert.ToInt32(cmbCategory.SelectedValue); //获取选择的类别
pro.ProCost = Convert.ToDouble(txtCost.Text); //价格
pro.ProName = txtName.Text; //名字
pro.ProNum = txtNum.Text; //编号
pro.ProPrice = Convert.ToDouble(txtPrice.Text); //实际的价格
pro.ProSpell = txtSpell.Text; //拼音
pro.ProStock = Convert.ToInt32(txtStock.Text);
pro.ProUnit = txtUnit.Text; //单位
pro.Remark = txtRemark.Text;; //备注
if (Temp == 1) //新增
{
pro.DelFlag = 0;
pro.SubBy = 1;
pro.SubTime = System.DateTime.Now; //当前时间
}
else if (Temp == 2) //修改
{
pro.ProId = Convert.ToInt32(labId.Text);
}
md.MsgDivShow(proBll.AddOrUpdateProductInfo(pro, Temp) ? "操作成功" : "操作失败", 1, Bind);
}
}
public ActionResult Info(int sellerId, int productId)
{
string msg;
ProductInfo productInfo = null;
BuyerInfo user = Session["User"] as BuyerInfo;
if (user == null)
{
return(View(productInfo));
}
productInfo = ProductInfoBll.GetModel(sellerId, productId, out msg);
var list = BuyerInfoBll.GetBuyerProductView(user.BuyerId, sellerId);
BuyerProductView productInfo1 = list.FirstOrDefault(p => p.ProductId == productId);
if (productInfo == null)
{
productInfo = new ProductInfo()
{
ProductFullName = "商品信息有误"
}
}
;
return(View(productInfo));
}
//加载主菜单
private void LoadProductInfoByDelFlag(int p)
{
ProductInfoBll bll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false;
dgvProduct.DataSource = bll.GetAllProductInfoByDelFlag(p);
dgvProduct.SelectedRows[0].Selected = false;
}
//显示所有产品
private void LoadProductInfoByDelFlag(int p)
{
ProductInfoBll proBll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false; //禁止自动生成列
dgvProduct.DataSource = proBll.GetAllProductInfoByDelFlag(p);
dgvProduct.ClearSelection(); //清除默认第一行选中
}
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 + "元");
}
}
//根据商品类别id查找该类别下的所有产品
private void LoadProductInfoByCId(TreeNodeCollection tnc, int p)
{
ProductInfoBll proBll = new ProductInfoBll();
List <ProductInfo> listProduct = proBll.GetProductInfoByCId(p);
for (int i = 0; i < listProduct.Count; i++)
{
tnc.Add(listProduct[i].ProName + "==" + listProduct[i].ProPrice + "元");
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
string txt = txtSearch.Text;
ProductInfoBll bll = new ProductInfoBll();
dgvProductInfo.DataSource = bll.GetProductInfoByProNum(txt);
dgvProductInfo.AutoGenerateColumns = false;
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.DataSource = bll.GetProductInfoByCatid(id);
dgvProductInfo.AutoGenerateColumns = false;
if (dgvProductInfo.SelectedRows.Count > 0)
{
dgvProductInfo.SelectedRows[0].Selected = false;
}
}
else
{
LoadProductInfoByDelFlag(0);
}
}
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 = new ProductInfo();
pro = bll.GetProductInfoById(id);
if (pro != null)
{
mep.Obj = pro;
LoadChangeProductInfo(4);
}
}
else
{
MessageBox.Show("请选中要修改的行，谢谢哦");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
//注销产品
if (dgvProduct.SelectedRows.Count <= 0)
{
md1.MsgDivShow("请选中要删除的产品", 1);
return;
}
if (MessageBox.Show("确实要删除该产品?", "删除产品", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
//获取选中产品的ID
int proId = ((ProductInfo)dgvProduct.SelectedRows[0].DataBoundItem).ProId;
ProductInfoBll proBll = new ProductInfoBll();
md1.MsgDivShow(proBll.SoftDeleteByProId(proId) ? "操作成功" : "操作失败", 1);
LoadAllProductInfoByDelFlag(0);//刷新！！！！！！！！
return;
}
md1.MsgDivShow("你已经取消了注销该产品", 1);
return;
}
/// <summary>
/// 删除产品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDeletePro_Click(object sender, EventArgs e)
{
if (dgvProductInfo.SelectedRows.Count > 0)
{
if (DialogResult.OK == MessageBox.Show("真的要删除么", "删除", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))
{
string msg3 = "";
for (int i = 0; i < dgvProductInfo.SelectedRows.Count; i++)
{
int id = Convert.ToInt32(dgvProductInfo.SelectedRows[i].Cells[0].Value.ToString());
ProductInfoBll bll = new ProductInfoBll();
msg3 = bll.SoftDeleteProductInfoByProId(id)?"删除成功":"删除失败";
}
MessageBox.Show(msg3);
LoadProductInfoByDelFlag(0);
}
}
else
{
MessageBox.Show("请选中要删除的行");
}
}
//注销商品类别
private void btnDeleteCategory_Click(object sender, EventArgs e)
{
if (dgvCategory.SelectedRows.Count <= 0)
{
md.MsgDivShow("请选择要注销的商品类别");
return;
}
if (MessageBox.Show("确定删除该类别吗", "删除商品类别", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
//获取类别ID
int cId = ((CategoryInfo)dgvCategory.SelectedRows[0].DataBoundItem).CId;
ProductInfoBll proBll = new ProductInfoBll();
if (proBll.GetProductInfoCountByCId(cId) > 0)
{
md.MsgDivShow("抱歉，该类别下有产品，不能删除");
return;
}
CategoryInfoBll cBll = new CategoryInfoBll();
md.MsgDivShow(cBll.SoftDeleteCategoryByCId(cId) ? "操作成功" : "操作失败", 1);
LoadAllCategoryInfoByDelFlag(0);
return;
}
md.MsgDivShow("取消了", 1);
}
private void btnDelete_Click(object sender, EventArgs e)
{
//注销产品
if (dgvProduct.SelectedRows.Count <= 0)
{
md1.MsgDivShow("请选中要删除的产品", 1);
return;
}
if (MessageBox.Show("确实要删除该产品?", "删除产品", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
//获取选中产品的ID
int proId = ((ProductInfo)dgvProduct.SelectedRows[0].DataBoundItem).ProId;
ProductInfoBll proBll = new ProductInfoBll();
md1.MsgDivShow(proBll.SoftDeleteByProId(proId) ? "操作成功" : "操作失败", 1);
LoadAllProductInfoByDelFlag(0);//刷新！！！！！！！！
return;
}
md1.MsgDivShow("你已经取消了注销该产品", 1);
return;
}
//显示产品信息的方法
private void LoadAllProductInfoByDelFlag(int p)
{
ProductInfoBll proBll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false;
dgvProduct.DataSource = proBll.GetAllProductInfoByDelFlag(p);
dgvProduct.ClearSelection();
}
//根据商品类别id查找该类别下的所有产品
private void LoadProductInfoByCId(TreeNodeCollection tnc, int p)
{
ProductInfoBll proBll = new ProductInfoBll();
List<ProductInfo> listProduct = proBll.GetProductInfoByCId(p);
for (int i = 0; i < listProduct.Count; i++)
{
tnc.Add(listProduct[i].ProName + "==" + listProduct[i].ProPrice + "元");
}
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{
//int temp = 0;
//if (string.IsNullOrEmpty(txtSearch.Text))//空
//{
//}
//else
//{
////搜索
//if (char.IsLetter(txtSearch.Text[0]))//字母
//{
// temp = 1;
//}
//else
//{
// temp = 2;
//}
//}
int temp = string.IsNullOrEmpty(txtSearch.Text) ? 0 : char.IsLetter(txtSearch.Text[0]) ? 1 : 2;
ProductInfoBll proBll = new ProductInfoBll();
dgvProduct.AutoGenerateColumns = false;//禁止自动生成列
dgvProduct.DataSource = proBll.GetProductByProSpellOrProNum(temp, txtSearch.Text);
dgvProduct.ClearSelection();
}
public void GetProductListTest()
{
var psg = ProductInfoBll.GetProductList(1, 10, "", "", 1, 1, out _errMsg);
Assert.Fail();
}
