/// <summary> /// 将分类绑定到树上 /// </summary> private void BindClass() { gsClass = new VipSoft.BLL.GoodsClass(); dtClass = gsClass.GetList("ShopID="+PublicState.Master.ShopID).Tables[0]; this.treeView_Class.Nodes.Clear(); Function.BindGoodsClass(this.treeView_Class, dtClass); }
private void button_Add_Click(object sender, EventArgs e) { VipSoft.BLL.GoodsClass gc = new VipSoft.BLL.GoodsClass(); if (this.textBox_ClassName.Text == "新类别" || this.textBox_ClassName.Text == "") { MessageBox.Show("请输入分类名称。"); return; } if (this.label_ID.Text == "label_ID" && this.label_ParentID.Text == "label_ParentID") { MessageBox.Show("请先在左侧列表中选择对应操作!"); return; } if (this.button_Add.Text == "增加分类") { if (this.label_ParentID.Text == "") { MessageBox.Show("请先在左侧列表中选择对应操作!"); return; } VipSoft.Model.GoodsClass model = new Model.GoodsClass(); model.ClassName = this.textBox_ClassName.Text; model.ParentID = int.Parse(this.label_ParentID.Text); model.ShopID = PublicState.Master.ShopID; model.ShopName = PublicState.Master.ShopName; gc.Add(model); // 写入日志 VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog(); log.Add(new VipSoft.Model.SysLog(PublicState.Master, "商品分类管理", string.Format("增加分类成功,名称:{0}父类:{1}", this.textBox_ClassName.Text, this.textBox_Parent.Text), DateTime.Now)); // 文本框清空 this.label_ID.Text = ""; this.label_ParentID.Text = ""; this.textBox_Parent.Text = ""; this.textBox_ClassName.Text = ""; } else { VipSoft.Model.GoodsClass gci = new VipSoft.Model.GoodsClass(); gci.ClassName = this.textBox_ClassName.Text.Trim(); gci.ID = int.Parse(this.label_ID.Text); gc.Update(gci); // 写入日志 VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog(); log.Add(new VipSoft.Model.SysLog(PublicState.Master, "商品分类管理", string.Format("修改分类成功,名称:{0}父类:{1}", this.textBox_ClassName.Text, this.textBox_Parent.Text), DateTime.Now)); } // 重新绑定 BindClass(); }
private void OrderReport_Load(object sender, EventArgs e) { this.comboBox_PayType.Items.Add(new DictionaryEntry("所有类型", "")); this.comboBox_PayType.Items.Add(new DictionaryEntry("储值卡余额消费", "1")); this.comboBox_PayType.Items.Add(new DictionaryEntry("现金消费", "2")); this.comboBox_PayType.Items.Add(new DictionaryEntry("信用卡支付", "3")); this.comboBox_PayType.Items.Add(new DictionaryEntry("代金券支付", "4")); this.comboBox_PayType.Items.Add(new DictionaryEntry("联合支付", "5")); this.comboBox_PayType.DisplayMember = "Key"; this.comboBox_PayType.ValueMember = "Value"; this.comboBox_G_PayType.Items.Add(new DictionaryEntry("所有类型", "")); this.comboBox_G_PayType.Items.Add(new DictionaryEntry("储值卡余额消费", "1")); this.comboBox_G_PayType.Items.Add(new DictionaryEntry("现金消费", "2")); this.comboBox_G_PayType.Items.Add(new DictionaryEntry("联合消费", "3")); this.comboBox_G_PayType.DisplayMember = "Key"; this.comboBox_G_PayType.ValueMember = "Value"; // 会员等级 DataTable dtLevel = new VipSoft.BLL.CardLevel().GetAllList().Tables[0]; this.comboBox_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0")); foreach (DataRow dr in dtLevel.Rows) this.comboBox_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString())); this.comboBox_CardLevel.DisplayMember = "Key"; this.comboBox_CardLevel.ValueMember = "Value"; this.comboBox_B_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0")); foreach (DataRow dr in dtLevel.Rows) this.comboBox_B_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString())); this.comboBox_B_CardLevel.DisplayMember = "Key"; this.comboBox_B_CardLevel.ValueMember = "Value"; this.comboBox_P_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0")); foreach (DataRow dr in dtLevel.Rows) this.comboBox_P_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString())); this.comboBox_P_CardLevel.DisplayMember = "Key"; this.comboBox_P_CardLevel.ValueMember = "Value"; DataTable dtClass; // 产品分类 dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID="+PublicState.Master.ShopID).Tables[0]; Function.BindGoodsClass(this.comboBox_G_Class, dtClass); Function.BindGoodsClass(this.comboBox_M_Class, dtClass); DataTable dt = (DataTable)this.comboBox_G_Class.DataSource; this.comboBox_G_Class.DataSource = dt; this.comboBox_M_Class.DataSource = dt; this.comboBox_Sign.SelectedIndex = 0; this.comboBox_B_Sign.SelectedIndex = 0; this.comboBox_OrderType.SelectedIndex = 0; this.comboBox_PayType.SelectedIndex = 0; this.comboBox_G_Sign.SelectedIndex = 0; this.comboBox_G_OrderType.SelectedIndex = 0; this.comboBox_G_PayType.SelectedIndex = 0; this.comboBox_G_Class.SelectedIndex = 0; this.comboBox_M_Sign.SelectedIndex = 0; this.comboBox_M_OrderType.SelectedIndex = 0; this.comboBox_M_Class.SelectedIndex = 0; this.comboBox_P_Sign.SelectedIndex = 0; this.dateTimePicker_Start.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_End.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_G_Start.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_G_End.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_M_Start.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_M_End.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_B_Start.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_P_Start.Text = DateTime.Now.ToShortDateString(); this.dateTimePicker_P_End.Text = DateTime.Now.ToShortDateString(); this.maskedTextBox_B_Start.Text = "00:00:00"; this.maskedTextBox_P_Start.Text = "00:00:00"; this.maskedTextBox_P_End.Text = "00:00:00"; this.maskedTextBox_B_End.Text = "23:59:59"; this.maskedTextBox_End.Text = "23:59:59"; this.maskedTextBox_G_Start.Text = "00:00:00"; this.maskedTextBox_G_End.Text = "23:59:59"; this.maskedTextBox_M_Start.Text = "00:00:00"; this.maskedTextBox_M_End.Text = "23:59:59"; this.maskedTextBox5.Text = "00:00:00"; }
private void dgvMCollect_CellClick(object sender, DataGridViewCellEventArgs e) { this.dgvMWater.Rows.Clear(); if (this.dgvMCollect.SelectedRows.Count == 0) return; StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_M_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_M_Start.Value.ToShortDateString() + " " + this.maskedTextBox_M_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_M_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_M_End.Value.ToShortDateString() + " " + this.maskedTextBox_M_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append("CreateDateTime <= '" + time2.ToString() + "'"); } if (this.comboBox_M_OrderType.SelectedIndex == 1) sb.Append(" and OrderType=0");// 余额消费 else if (this.comboBox_M_OrderType.SelectedIndex == 2) sb.Append(" and OrderType=1");// 记次 if (this.comboBox_M_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_M_Class.SelectedItem)["Value"].ToString(); DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" and GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" and GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.textBox_M_Price.Text != "¥0.00" && this.textBox_M_Price.Text != "") sb.Append(" and Price" + this.comboBox_M_Sign.Text + this.textBox_M_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append(" and MemID=" + this.searchMember4.MemID); } string cardID = this.dgvMCollect.SelectedRows[0].Cells[0].Value.ToString(); DataSet dst = null; //单据表 if (sb.ToString() != "") { dst = new VipSoft.BLL.OrderLog().GetListCollect("SELECT CardID,GoodsCode,GoodsName,sum(Number) as Numbers,Price, sum(DiscountPrice) as sumMoneys from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode where " + sb.ToString() + " and CardID='" + cardID + "' and orderType not in (2,3,8) group by GoodsCode,GoodsName,Price,DiscountPrice,cardID"); } else { dst = new VipSoft.BLL.OrderLog().GetListCollect("SELECT CardID,GoodsCode,GoodsName,sum(Number) as Numbers,Price, sum(DiscountPrice) as sumMoneys from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode where " + sb.ToString() + " CardID='" + cardID + "' and orderType not in (2,3,8) group by GoodsCode,GoodsName,Price,DiscountPrice,cardID"); } foreach (DataRow drst in dst.Tables[0].Rows) { this.dgvMWater.Rows.Add(drst["GoodsCode"], drst["GoodsName"], drst["Price"], drst["sumMoneys"], drst["Numbers"], drst["sumMoneys"]); } }
private void dgvGCollect_CellClick(object sender, DataGridViewCellEventArgs e) { this.dgvGWater.Rows.Clear(); if (this.dgvGCollect.SelectedRows.Count == 0) return; string goodsCode = this.dgvGCollect.SelectedRows[0].Cells[0].Value.ToString(); DataSet dt = null; StringBuilder sb = new StringBuilder(); if (this.dateTimePicker_G_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + this.maskedTextBox_G_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" a.CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_G_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + this.maskedTextBox_G_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append(" a.CreateDateTime <= '" + time2.ToString() + "'"); } string type; if (this.comboBox_G_OrderType.SelectedIndex == 1) { sb.Append(" and a.OrderType=0");// 余额消费 if (this.comboBox_G_PayType.SelectedIndex != -1 && this.comboBox_G_PayType.SelectedIndex != 0) { type = ((DictionaryEntry)this.comboBox_G_PayType.SelectedItem).Value.ToString(); sb.Append(" and a.PayType=" + type); } } else if (this.comboBox_G_OrderType.SelectedIndex == 2) sb.Append(" and a.OrderType=1");// 记次 else if (this.comboBox_G_OrderType.SelectedIndex == 3) sb.Append(" and a.OrderType=2");// 退货 DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; if (this.comboBox_G_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_G_Class.SelectedItem)["Value"].ToString(); string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" b.GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" b.GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.TextBox_G_Key.Text != "") sb.Append(" b.GoodsCode='" + this.TextBox_G_Key.Text + "' or b.GoodsName like '%" + this.TextBox_G_Key.Text + "%'"); if (this.textBox_G_Price.Text != "¥0.00" && this.textBox_G_Price.Text != "") sb.Append(" b.Price" + this.comboBox_G_Sign.Text + this.textBox_G_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append("MemID=" + this.searchMember4.MemID); } if (sb.ToString() != "") { dt = new VipSoft.BLL.OrderLog().GetListCollect("SELECT a.OrderCode,a.CardID,a.MemName,b.Number,b.DiscountPrice,a.DiscountMoney,a.OrderType,a.CreateTime,b.GoodsCode ,b.GoodsName,b.GoodsID,b.OrderCode from OrderLog as a left join OrderDetail as b on a.OrderCode=b.OrderCode where " + sb.ToString() + " and b.GoodsCode='" + goodsCode + "' and a.OrderType not in (2,3,8)"); } else { dt = new VipSoft.BLL.OrderLog().GetListCollect("SELECT a.OrderCode,a.CardID,a.MemName,b.Number,b.DiscountPrice,a.DiscountMoney,a.OrderType,a.CreateTime ,a.GoodsCode,a.GoodsName,b.GoodsCode,b.OrderCode from OrderLog as a left join OrderDetail as b on a.GoodsCode=b.GoodsCode where " + sb.ToString() + " b.GoodsCode='" + goodsCode + "' and a.OrderType not in (2,3,8)"); } // todo ddddddsssssss foreach (DataRow dr in dt.Tables[0].Rows) { this.dgvGWater.Rows.Add(dr["a.OrderCode"], dr["CardID"], dr["MemName"], dr["Number"], dr["DiscountPrice"], dr["DiscountMoney"], dr["OrderType"].ToString() == "0" ? "储值消费" : (dr["OrderType"].ToString() == "1" ? "记次消费" : (dr["OrderType"].ToString() == "2" ? "退货" : "累计积分")), dr["CreateTime"]); } }
private void Button_M_Query_Click(object sender, EventArgs e) { this.dgvMWater.Rows.Clear(); this.dgvMCollect.Rows.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_M_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_M_Start.Value.ToShortDateString() + " " + this.maskedTextBox_M_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); return; } sb.Append(" and CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_M_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_M_End.Value.ToShortDateString() + " " + this.maskedTextBox_M_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); return; } sb.Append("CreateDateTime <= '" + time2.ToString() + "'"); } if (this.comboBox_M_OrderType.SelectedIndex == 1) sb.Append(" and OrderType=0");// 余额消费 else if (this.comboBox_M_OrderType.SelectedIndex == 2) sb.Append(" and OrderType=1");// 记次 if (this.comboBox_M_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_M_Class.SelectedItem)["Value"].ToString(); DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" and GoodsID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" and GoodsID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.textBox_M_Price.Text != "¥0.00" && this.textBox_M_Price.Text != "") sb.Append(" and Price" + this.comboBox_M_Sign.Text + this.textBox_M_Price.Text.Replace("¥", "")); if (this.searchMember4.CardID != "") { searchMember4.GetSearchMember(); sb.Append(" and MemID=" + this.searchMember4.MemID); } //汇总表 int Mnum = 0; decimal Money = 0; DataSet ds = null; if (sb.ToString() == "") { ds = new VipSoft.BLL.OrderLog().GetListCollect("SELECT MemID,CardID,MemName,sum(Number) as TotalNumbers,sum(DiscountPrice) as DiscountMoneys from OrderLog left join OrderDetail on OrderLog.OrderCode=OrderDetail.OrderCode where " + sb.ToString() + " OrderType not int (2,3,8) group by MemID,CardID,MemName"); } else { ds = new VipSoft.BLL.OrderLog().GetListCollect("SELECT MemID,CardID,MemName,sum(Number) as TotalNumbers,sum(DiscountPrice) as DiscountMoneys from OrderLog left join OrderDetail on OrderLog.OrderCode=OrderDetail.OrderCode where " + sb.ToString() + " and OrderType not in (2,3,8) group by MemID,CardID,MemName"); } if (ds.Tables[0].Rows.Count > 0) { this.lblM_Ing.Visible = false; } else { this.lblM_Ing.Visible = true; } foreach (DataRow dr in ds.Tables[0].Rows) { Mnum += int.Parse(dr["TotalNumbers"].ToString()); Money += Math.Round(decimal.Parse(dr["DiscountMoneys"].ToString()), 2); this.dgvMCollect.Rows.Add(dr["CardID"], dr["MemName"], dr["TotalNumbers"], dr["DiscountMoneys"]); } this.lbl_num.Text = Mnum.ToString(); this.lmoney.Text = Money.ToString("#0.00"); }
private void Button_G_Query_Click(object sender, EventArgs e) { this.dgvGCollect.Rows.Clear(); this.dgvGWater.Rows.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("1=1"); if (this.dateTimePicker_G_Start.Checked) { DateTime time1; string t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + this.maskedTextBox_G_Start.Text; if (!DateTime.TryParse(t1, out time1)) { MessageBox.Show("开始时间输入错误!"); this.maskedTextBox_G_Start.Text = "00:00:00"; t1 = this.dateTimePicker_G_Start.Value.ToShortDateString() + " " + "00:00:00"; DateTime.TryParse(t1, out time1); } sb.Append(" a.CreateDateTime >= '" + time1.ToString() + "'"); } if (this.dateTimePicker_G_End.Checked) { DateTime time2; string t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + this.maskedTextBox_G_End.Text; if (!DateTime.TryParse(t2, out time2)) { MessageBox.Show("结束时间输入错误!"); this.maskedTextBox_G_End.Text = "23:59:59"; t2 = this.dateTimePicker_G_End.Value.ToShortDateString() + " " + "23:59:59"; DateTime.TryParse(t2, out time2); } sb.Append(" a.CreateDateTime <= '" + time2.ToString() + "'"); } string type; if (this.comboBox_G_OrderType.SelectedIndex == 1) { sb.Append(" and a.OrderType=0");// 余额消费 if (this.comboBox_G_PayType.SelectedIndex != -1 && this.comboBox_G_PayType.SelectedIndex != 0) { type = ((DictionaryEntry)this.comboBox_G_PayType.SelectedItem).Value.ToString(); sb.Append(" and a.PayType=" + type); } } else if (this.comboBox_G_OrderType.SelectedIndex == 2) sb.Append(" and a.OrderType=1");// 记次 if (this.comboBox_G_Class.SelectedIndex != 0) { string classID = ((DataRowView)this.comboBox_G_Class.SelectedItem)["Value"].ToString(); DataTable dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID=" + PublicState.Master.ShopID).Tables[0]; string ids = Function.GetChildClassListStr(dtClass, classID); if (ids != "") sb.Append(" b.ID in (select ID from Goods where ClassID in (" + ids + "))"); else sb.Append(" b.ID in (select ID from Goods where ClassID = " + classID + ")"); } if (this.TextBox_G_Key.Text != "") sb.Append(" a.GoodsCode='" + this.TextBox_G_Key.Text + "' or a.GoodsName like '%" + this.TextBox_G_Key.Text + "%'"); if (this.textBox_G_Price.Text != "¥0.00" && this.textBox_G_Price.Text != "") sb.Append(" a.Price" + this.comboBox_G_Sign.Text + this.textBox_G_Price.Text.Replace("¥", "")); if (this.searchMember3.CardID != "") { searchMember3.GetSearchMember(); sb.Append("MemID=" + this.searchMember3.MemID); } decimal gmoney = 0M; decimal danprice = 0M; decimal jinhuoprice = 0M; int xinums = 0; decimal lirun = 0M; decimal Zprice = 0M; decimal Cprice = 0M; int SumN = 0; //汇总表 DataSet ds = new VipSoft.BLL.OrderDetail().GetListCollect("SELECT a.GoodsCode,a.GoodsName,a.price,sum(a.Number) as numbers,sum(DiscountPrice) as sumMoneys,b.buyprice,(sum(b.price*a.Number)-sum(b.buyprice*a.Number)) as buyprices from (select orderDetail.GoodsCode,orderDetail.GoodsName,orderDetail.price,orderDetail.Number,OrderLog.PayType,OrderLog.MemID,OrderLog.CreateDateTime,OrderLog.OrderType,orderDetail.DiscountPrice from orderLog left join orderDetail on orderLog.orderCode=orderDetail.orderCode ) as a left join goods as b on b.goodscode=a.goodscode where " + sb.ToString() + " and a.OrderType not in (2,3,8) group by a.goodsCode,a.goodsName,a.price,b.buyprice"); if (ds.Tables[0].Rows.Count > 0) { this.lbl_G_Loading.Visible = false; } else { this.lbl_G_Loading.Visible = true; } foreach (DataRow drt in ds.Tables[0].Rows) { gmoney += Math.Round(decimal.Parse(drt["sumMoneys"].ToString()), 2); danprice = Math.Round(decimal.Parse(drt["price"].ToString()), 2); jinhuoprice = Math.Round(decimal.Parse(drt["buyprice"].ToString()), 2); xinums = int.Parse(drt["Numbers"].ToString()); SumN += int.Parse(drt["Numbers"].ToString()); Zprice += xinums * danprice; Cprice += xinums * jinhuoprice; lirun += Math.Round(decimal.Parse(drt["buyprices"].ToString()), 2); try { decimal sumMoney = Convert.ToDecimal(drt["price"].ToString()) * int.Parse(drt["numbers"].ToString()); if (sumMoney != 0) this.dgvGCollect.Rows.Add(drt["GoodsCode"], drt["GoodsName"], drt["price"], drt["buyprice"], drt["numbers"], drt["sumMoneys"], Convert.ToDecimal(drt["buyprices"].ToString()), (Convert.ToDecimal(drt["buyprices"].ToString()) / sumMoney * 100).ToString("0.00") + "%"); else this.dgvGCollect.Rows.Add(drt["GoodsCode"], drt["GoodsName"], drt["price"], drt["buyprice"], drt["numbers"], drt["sumMoneys"], Convert.ToDecimal(drt["buyprices"].ToString()), "0"); } catch { } } lirun = (Zprice - Cprice); this.lbl_g.Text = gmoney.ToString("¥0.00"); this.lbl_danprice.Text = Zprice.ToString("¥0.00"); this.lbl_jinprice.Text = Cprice.ToString("¥0.00"); this.lbl_lirun.Text = lirun.ToString("¥0.00"); this.lbl_xnum.Text = SumN.ToString(); }
private void toolStripMenuItem_Item_Click(object sender, EventArgs e) { ToolStripMenuItem item = (ToolStripMenuItem)sender; TreeNode node = this.treeView_Class.SelectedNode; int id = int.Parse(node.Name.Replace("class_", "")); switch (item.Name) { case "toolStripMenuItem_Edit": this.label_ID.Text = node.Name.Replace("class_", ""); this.textBox_Parent.Text = node.Parent != null ? node.Parent.Text : "根类别"; this.textBox_ClassName.Text = node.Text; this.button_Add.Text = "修改类别"; this.groupBox_manage.Text = "修改类别"; break; case "toolStripMenuItem_Delete": if (this.treeView_Class.SelectedNode.Text == "根类别") return; DialogResult res = MessageBox.Show("您确定要删除这个分类么?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (res == DialogResult.Yes) { VipSoft.BLL.GoodsClass gc = new VipSoft.BLL.GoodsClass(); DataTable listClass = gc.GetList("[ShopID]="+PublicState.Master.ShopID).Tables[0]; CheckHasGoods hasGoods = new CheckHasGoods(); if (hasGoods.Exist(listClass, id.ToString()) != 0) { MessageBox.Show("当前分类下面还有商品,要删除分类,请首先删除该分类下面的全部商品。"); return; } if (gc.Delete(id)) { MessageBox.Show("分类删除成功。"); // 移除节点 node.Remove(); // 写入日志 VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog(); log.Add(new VipSoft.Model.SysLog(PublicState.Master, "商品分类管理", string.Format("删除分类成功,名称:{0}父类:{1}", this.textBox_ClassName.Text, this.textBox_Parent.Text), DateTime.Now)); } else MessageBox.Show("删除失败,请重试。"); } break; case "toolStripMenuItem_Add": this.label_ParentID.Text = id.ToString(); //查询该类别下是否有产品,如果有则不能再增加子类别 DataSet ds = new VipSoft.BLL.Goods().GetList("ClassId=" + id + ""); if (ds.Tables[0].Rows.Count > 0) { MessageBox.Show("该类别下已有产品!不能再添加子类别"); return; } this.textBox_Parent.Text = node.Text; this.textBox_ClassName.Text = "新类别"; this.button_Add.Text = "增加分类"; this.groupBox_manage.Text = "增加下级分类"; break; } }
/// <summary> /// 绑定产品分类树形菜单 /// </summary> private void BindTree() { VipSoft.BLL.GoodsClass gc = new VipSoft.BLL.GoodsClass(); listClass = gc.GetList("ShopID="+PublicState.Master.ShopID).Tables[0]; Function.BindGoodsClass(this.treeView_Class, listClass); }
/// <summary> /// 绑定商品分类 /// </summary> private void LoadGoodsClass() { DataSet ds = new VipSoft.BLL.GoodsClass().GetList("[ShopID]="+PublicState.Master.ShopID); Function.BindGoodsClass(this.comboBox_Class, ds.Tables[0]); }
/// <summary> /// 绑定商品树 /// </summary> private void BindGoodsTreeThread() { Thread.Sleep(50); //延时100毫秒 VipSoft.BLL.GoodsClass goodsC = new VipSoft.BLL.GoodsClass(); VipSoft.BLL.Goods goods = new VipSoft.BLL.Goods(); string where = "ShopID="+PublicState.Master.ID; DataTable dtClass = goodsC.GetList(where).Tables[0]; DataTable dtGoods = goods.GetList(where).Tables[0]; ExpenseGoodsTreeShowHandler goodsTreeHandler = new ExpenseGoodsTreeShowHandler(BindGoodsTreeInvoke); this.BeginInvoke(goodsTreeHandler, dtClass, dtGoods); }