public void SelectRow(DataRow row, string condition = "") { frmSelect frm = new frmSelect(); frm.dgv.AddColumn("选择", "选择", "", 40, 2, "{0:,1:√}"); frm.dgv.AddColumn("item_subno", "货号", "", 110, 1, ""); frm.dgv.AddColumn("barcode", "条码", "", 110, 1, ""); frm.dgv.AddColumn("item_name", "商品名称", "", 160, 1, ""); frm.dgv.AddColumn("item_subname", "拼音码", "", 90, 1, ""); frm.dgv.AddColumn("unit_no", "单位", "", 60, 1, ""); frm.dgv.AddColumn("item_size", "规格", "", 60, 1, ""); frm.dgv.AddColumn("price", "价格", "", 100, 3, "0.00"); frm.dgv.AddColumn("product_area", "产地", "", 150, 1, ""); frm.Text = "选择商品"; frm.condition = condition; IBLL.IPriceBLL pricebll = new BLL.PriceBLL(); var sup_id = this.txt_cust.Text.Trim().Split('/')[0]; List <DataRow> lis = frm.SelectDataRow("货号:", "item_subno"); int index = 0; for (int i = 0; i < this.editGrid1.DataSource.Rows.Count; i++) { if (this.editGrid1.DataSource.Rows[i] == row) { index = i; } } if (lis.Count > 1) { for (int i = 0; i < lis.Count - 1; i++) { this.editGrid1.DataSource.Rows.InsertAt(this.editGrid1.DataSource.NewRow(), index); } } foreach (DataRow dr in lis) { var dgv_tb = this.editGrid1.DataSource.Copy(); dgv_tb.ImportRow(dr); var dgv_dr = dgv_tb.Rows[dgv_tb.Rows.Count - 1]; dgv_dr["valid_price"] = pricebll.GetCustItemPrice(sup_id, dr["item_no"].ToString(), "0"); dgv_dr["sub_amount"] = Helper.Conv.ToDecimal(dgv_dr["in_qty"]) * Helper.Conv.ToDecimal(dgv_dr["valid_price"]); Conv.CopyDataRow(this.editGrid1.DataSource, index, dgv_dr); index++; } if (!string.IsNullOrEmpty(this.editGrid1.DataSource.Rows[this.editGrid1.DataSource.Rows.Count - 1]["item_subno"].ToString())) { this.editGrid1.DataSource.Rows.Add(); } this.editGrid1.Editing = false; this.editGrid1.Refresh(); }
private void btnSelect_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txt_sup.Text)) { MsgForm.ShowFrom("请先选择供应商"); return; } IBLL.IInOutBLL bll = new BLL.InOutBLL(); var dt = new DataTable(); var supcust_no = txt_sup.Text.Trim().Split('/')[0]; dt = bll.GetSimpleInOutList(DateTime.Now.AddMonths(-2), DateTime.Now, supcust_no, "A"); frmSelect frm = new frmSelect(); frm.dgv.AddColumn("oper_date", "日期", "", 100, 1, "yyyy-MM-dd"); frm.dgv.AddColumn("sheet_no", "单据号", "", 150, 1, ""); frm.dgv.AddColumn("仓库", "仓库", "", 200, 1, ""); frm.dgv.AddColumn("货商", "货商", "", 200, 1, ""); frm.dgv.AddColumn("total_amount", "金额", "", 100, 3, "0.00"); frm.Text = "选择入库单"; frm.tb = dt; frm.is_show_left = false; this.txt_voucher_no.Text = frm.SelectData("单号:", "sheet_no"); }
public void SelectRow(DataRow row, string condition = "") { frmSelect frm = new frmSelect(); frm.dgv.AddColumn("选择", "选择", "", 40, 2, "{0:,1:√}"); frm.dgv.AddColumn("item_subno", "货号", "", 110, 1, ""); frm.dgv.AddColumn("barcode", "条码", "", 110, 1, ""); frm.dgv.AddColumn("item_name", "商品名称", "", 160, 1, ""); frm.dgv.AddColumn("item_subname", "拼音码", "", 90, 1, ""); frm.dgv.AddColumn("unit_no", "单位", "", 60, 1, ""); frm.dgv.AddColumn("item_size", "规格", "", 60, 1, ""); frm.dgv.AddColumn("price", "价格", "", 100, 3, "0.00"); frm.dgv.AddColumn("product_area", "产地", "", 150, 1, ""); frm.Text = "选择商品"; frm.condition = condition; List <DataRow> lis = frm.SelectDataRow("货号:", "item_subno"); int index = 0; for (int i = 0; i < this.editGrid1.DataSource.Rows.Count; i++) { if (this.editGrid1.DataSource.Rows[i] == row) { index = i; } } if (lis.Count > 1) { for (int i = 0; i < lis.Count - 1; i++) { this.editGrid1.DataSource.Rows.InsertAt(this.editGrid1.DataSource.NewRow(), index); } } foreach (DataRow dr in lis) { var dgv_tb = this.editGrid1.DataSource.Copy(); dgv_tb.ImportRow(dr); var dgv_dr = dgv_tb.Rows[dgv_tb.Rows.Count - 1]; dgv_dr["old_price"] = dr["base_price"]; dgv_dr["old_price2"] = dr["base_price2"]; dgv_dr["old_price3"] = dr["base_price3"]; Conv.CopyDataRow(this.editGrid1.DataSource, index, dgv_dr); index++; } if (!string.IsNullOrEmpty(this.editGrid1.DataSource.Rows[this.editGrid1.DataSource.Rows.Count - 1]["item_subno"].ToString())) { this.editGrid1.DataSource.Rows.Add(); } this.editGrid1.Editing = false; this.editGrid1.Refresh(); }
private void btnSelect_Click(object sender, EventArgs e) { IBLL.IInOutBLL bll = new BLL.InOutBLL(); var dt = new DataTable(); var supcust_no = txt_cust.Text.Trim().Split('/')[0]; if (supcust_no != "") { dt = bll.GetSimpleSaleSheetList(DateTime.Now.AddMonths(-2), DateTime.Now, supcust_no); } frmSelect frm = new frmSelect(); frm.dgv.AddColumn("oper_date", "操作时间", "", 100, 1, "yyyy-MM-dd"); frm.dgv.AddColumn("sheet_no", "单号", "", 150, 1, ""); frm.dgv.AddColumn("仓库", "仓库", "", 200, 1, ""); frm.dgv.AddColumn("客户", "客户", "", 200, 1, ""); frm.dgv.AddColumn("total_amount", "金额", "", 100, 3, "0.00"); frm.Text = "选择销售单"; frm.tb = dt; frm.is_show_left = false; this.txt_voucher_no.Text = frm.SelectData("单号:", "sheet_no"); }
private void editGrid1_DoubleClickCell(object sender, string column_name, DataRow row, MouseEventArgs e) { if (column_name.Equals("item_subno")) { if (string.IsNullOrEmpty(this.txt_check_no.Text)) { this.txtsheet_no.Focus(); MsgForm.ShowFrom("请选择批次单"); return; } if (string.IsNullOrEmpty(this.txtbranch.Text)) { this.txtbranch.Focus(); MsgForm.ShowFrom("请选择仓库"); return; } IBLL.ICheckBLL bll = new BLL.CheckBLL(); var tbgoods = bll.GetCheckItemBak(new ic_t_check_bak() { sheet_no = this.txt_check_no.Text, branch_no = this.txtbranch.Text.Split('/')[0] }); frmSelect frm = new frmSelect(); frm.dgv.AddColumn("选择", "选择", "", 40, 2, "{0:,1:√}"); frm.dgv.AddColumn("item_no", "商品编号", "", 110, 1, ""); frm.dgv.AddColumn("item_subno", "货号", "", 110, 1, ""); frm.dgv.AddColumn("barcode", "条码", "", 110, 1, ""); frm.dgv.AddColumn("item_name", "商品名称", "", 160, 1, ""); frm.dgv.AddColumn("item_subname", "拼音码", "", 90, 1, ""); frm.dgv.AddColumn("unit_no", "单位", "", 60, 1, ""); frm.dgv.AddColumn("item_size", "规格", "", 60, 1, ""); frm.dgv.AddColumn("price", "价格", "", 100, 3, "0.00"); frm.dgv.AddColumn("product_area", "产地", "", 150, 1, ""); frm.Text = "选择商品"; frm.tb = tbgoods; List <DataRow> lis = frm.SelectDataRow("货号:", "item_subno"); int index = 0; for (int i = 0; i < this.editGrid1.DataSource.Rows.Count; i++) { if (this.editGrid1.DataSource.Rows[i] == row) { index = i; } } if (lis.Count > 1) { for (int i = 0; i < lis.Count - 1; i++) { this.editGrid1.DataSource.Rows.InsertAt(this.editGrid1.DataSource.NewRow(), index); } } foreach (DataRow dr in lis) { var dgv_tb = this.editGrid1.DataSource.Copy(); dgv_tb.ImportRow(dr); var dgv_dr = dgv_tb.Rows[dgv_tb.Rows.Count - 1]; dgv_dr["real_qty"] = dgv_dr["stock_qty"]; dgv_dr["item_pack"] = "0.00"; dgv_dr["packqty"] = dgv_dr["real_qty"]; dgv_dr["sgqty"] = "0.00"; dgv_dr["sgqty"] = "0.00"; dgv_dr["balance_qty"] = "0.00"; dgv_dr["real_amount"] = "0.00"; dgv_dr["in_price"] = dr["price"]; Conv.CopyDataRow(this.editGrid1.DataSource, index, dgv_dr); index++; } this.editGrid1.Editing = false; this.editGrid1.Refresh(); } }