/// <summary> /// 数据查询,绑定 /// </summary> private void BindData(int currentPage) { string strWhere = GetCondition(); DataSet ds = bSales.GetSalesList(strWhere, "", (currentPage - 1) * PageSize + 1, currentPage * PageSize); _currentDt = ds.Tables[0]; //reSetCurrentDt(); //this.dgvData.DataSource = _currentDt; string currentInvoiceNumber = ""; dgvData.Rows.Clear(); foreach (DataRow dr in _currentDt.Rows) { int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow row = dgvData.Rows[currentRowIndex]; row.Cells["Row"].Value = dr["Row"]; string invoiceNumber = CConvert.ToString(dr["INVOICE_NUMBER"]); if (currentInvoiceNumber == "" || currentInvoiceNumber != invoiceNumber) { currentInvoiceNumber = invoiceNumber; row.Cells["INVOICE_NUMBER"].Value = invoiceNumber; row.Cells["CUSTOMER_CLAIM_NAME"].Value = dr["CUSTOMER_CLAIM_NAME"]; row.Cells["INVOICE_AMOUNT"].Value = dr["INVOICE_AMOUNT"]; row.Cells["SLIP_DATE"].Value = CConvert.DateTimeToString(dr["SLIP_DATE"], "yyyy-MM-dd"); } row.Cells["CURRENCY_NAME"].Value = dr["CURRENCY_NAME"]; row.Cells["UN_RECEIPT_AMOUNT"].Value = dr["UN_RECEIPT_AMOUNT"]; row.Cells["CUSTOMER_CLAIM_DATE"].Value = CConvert.DateTimeToString(dr["CUSTOMER_CLAIM_DATE"], "yyyy-MM-dd"); row.Cells["PAYMENT_STATUS_NAME_C"].Value = dr["PAYMENT_STATUS_NAME"]; row.Cells["ORDER_SLIP_NUMBER"].Value = dr["ORDER_SLIP_NUMBER"]; row.Cells["ORDER_AMOUNT"].Value = dr["ORDER_AMOUNT"]; row.Cells["LINE_INVOICE_AMOUNT"].Value = dr["LINE_INVOICE_AMOUNT"]; row.Cells["SHIPMENT_SLIP_NUMBER"].Value = dr["SHIPMENT_SLIP_NUMBER"]; row.Cells["SHIPMENT_AMOUNT"].Value = dr["SHIPMENT_AMOUNT"]; row.Cells["SLIP_NUMBER"].Value = dr["SLIP_NUMBER"]; row.Cells["PAYMENT_STATUS_C"].Value = dr["PAYMENT_STATUS"]; } if (_currentDt.Rows.Count < PageSize) { dgvData.Rows.Add(PageSize - _currentDt.Rows.Count); } }
private void FrmAlloation_Load(object sender, EventArgs e) { BllOrderHeaderTable headerTable = bOrderHeader.GetModel(_slipNumber); this.txtSlipNumber.Text = headerTable.SLIP_NUMBER; this.txtCustomerCode.Text = headerTable.CUSTOMER_CODE; this.txtCustomerName.Text = headerTable.CUSTOMER_NAME; this.txtEndCustomerCode.Text = headerTable.ENDER_CUSTOMER_CODE; this.txtEndCustomerName.Text = headerTable.ENDER_CUSTOMER_NAME; this.txtDeliveryPointCode.Text = headerTable.DELIVERY_POINT_CODE; this.txtDeliveryPointName.Text = headerTable.DELIVERY_POINT_NAME; this.txtOwnerPoNumber.Text = headerTable.CUSTOMER_PO_NUMBER; this.txtSlipDate.Text = CConvert.DateTimeToString(headerTable.SLIP_DATE, "yyyy-MM-dd"); this.txtDepartualDate.Text = CConvert.DateTimeToString(headerTable.DEPARTUAL_DATE, "yyyy-MM-dd"); DataGridViewComboBoxColumn co = this.dgvData.Columns["DEPARTUAL_WAREHOUSE"] as DataGridViewComboBoxColumn; co.DataSource = CCacheData.WAREHOUSE.Copy(); co.DisplayMember = "NAME"; co.ValueMember = "CODE"; foreach (BllOrderLineTable lineModel in headerTable.Items) { decimal quantity = CConvert.ToDecimal(lineModel.QUANTITY) - CConvert.ToDecimal(lineModel.SHIPMENT_QUANTITY); int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow dgvr = dgvData.Rows[currentRowIndex]; dgvr.Cells["NO"].Value = lineModel.LINE_NUMBER; dgvr.Cells["PRODUCT_CODE"].Value = lineModel.PRODUCT_CODE; dgvr.Cells["PRODUCT_NAME"].Value = lineModel.PRODUCT_NAME; dgvr.Cells["PRODUCT_SPEC"].Value = lineModel.PRODUCT_SPEC; dgvr.Cells["QUANTITY"].Value = quantity; dgvr.Cells["UNIT_CODE"].Value = lineModel.UNIT_NAME; dgvr.Cells["UNIT_NAME"].Value = lineModel.UNIT_NAME; dgvr.Cells["REF_STOCK"].Value = "参照"; //当前己引当的仓库的取得 BaseWarehouseTable warehouseTable = bAlloation.GetAlloationWarehouse(headerTable.SLIP_NUMBER, lineModel.LINE_NUMBER); string warehouseCode = warehouseTable.CODE; if (warehouseCode != null && warehouseCode != "") { ((DataGridViewComboBoxCell)dgvr.Cells["DEPARTUAL_WAREHOUSE"]).Style.NullValue = warehouseTable.NAME + " "; } else { warehouseCode = headerTable.DEPARTUAL_WAREHOUSE_CODE; ((DataGridViewComboBoxCell)dgvr.Cells["DEPARTUAL_WAREHOUSE"]).Style.NullValue = headerTable.DEPARTUAL_WAREHOUSE_NAME + " "; } dgvr.Cells["DEFAULT_WAREHOUSE_CODE"].Value = warehouseCode; //当前仓库实际库存的取得 BaseStockTable stockTable = bStock.GetModel(warehouseCode, lineModel.PRODUCT_CODE); decimal stock = 0; if (stockTable != null) { stock = CConvert.ToDecimal(stockTable.QUANTITY); } //己使用的引当数量,当前订单除外,己出库数量除外 stock -= bAlloation.GetAlloationQuantity(headerTable.SLIP_NUMBER, warehouseCode, lineModel.PRODUCT_CODE); dgvr.Cells["STOCK"].Value = stock; dgvr.Cells["ALLOATION_QUANTITY"].Value = quantity; BaseProductTable pTable = null; if (lineModel.PRODUCT_CODE.Length >= 4 && lineModel.PRODUCT_CODE.Substring(0, 4) == "9999") { pTable = bProduct.GetModel(lineModel.PRODUCT_CODE.Substring(0, 4)); } else { pTable = bProduct.GetModel(lineModel.PRODUCT_CODE); } if (pTable.STOCK_FLAG == 2) { dgvr.Cells["IS_ALLOATION"].Value = "OK"; } else if (quantity > stock) { dgvr.Cells["IS_ALLOATION"].Value = "NG"; } else { dgvr.Cells["IS_ALLOATION"].Value = "OK"; } } }
/// <summary> /// BindData /// </summary> /// <param name="isShowMessage"></param> public void BindData(bool isShowMessage) { DataTable dt = bShipment.GetShipmentPlanList(GetConduction()).Tables[0]; if (dt.Rows.Count > 0) { dgvData.Rows.Clear(); this.dgvData.Columns["SHIPMENT_CHK"].Visible = true; this.dgvData.AlternatingRowsDefaultCellStyle.BackColor = Color.White; dgvData.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; int i = 1; string currentSlipNumber = ""; foreach (DataRow dr in dt.Rows) { int currentRowIndex = dgvData.Rows.Add(1); DataGridViewRow dgvr = dgvData.Rows[currentRowIndex]; dgvr.Cells["NO"].Value = i++; string slipNumber = CConvert.ToString(dr["SLIP_NUMBER"]); if (currentSlipNumber == "" || currentSlipNumber != slipNumber) { currentSlipNumber = slipNumber; dgvr.Cells["SLIP_NUMBER"].Value = slipNumber; dgvr.Cells["END_CUSTOMER_NAME"].Value = dr["ENDER_CUSTOMER_NAME"]; dgvr.Cells["SERIAL_NUMBER"].Value = dr["SERIAL_NUMBER"]; dgvr.Cells["DEPARTUAL_DATE"].Value = CConvert.DateTimeToString(dr["DEPARTUAL_DATE"], "yyyy-MM-dd"); dgvr.Cells["ARRIVAL_DATE"].Value = CConvert.DateTimeToString(dr["DUE_DATE"], "yyyy-MM-dd"); dgvr.Cells["CHECK_NUMBER"].Value = dr["CHECK_NUMBER"]; dgvr.Cells["CUSTOMER_PO_NUMBER"].Value = dr["CUSTOMER_PO_NUMBER"]; dgvr.Cells["WAREHOUSE_NAME"].Value = dr["DEPARTUAL_WAREHOUSE_NAME"]; } dgvr.Cells["PRODUCT_CODE"].Value = dr["PRODUCT_CODE"]; dgvr.Cells["PRODUCT_NAME"].Value = dr["PRODUCT_NAME"]; dgvr.Cells["ORDER_QUANTITY"].Value = dr["QUANTITY"]; dgvr.Cells["ALLOATION_QUANTITY"].Value = dr["ALLOATION_QUANTITY"]; dgvr.Cells["QUANTITY"].Value = CConvert.ToDecimal(dr["QUANTITY"]) - CConvert.ToDecimal(dr["SHIPMENT_QUANTITY"]); dgvr.Cells["SHIPMENT_QUANTITY"].Value = CConvert.ToDecimal(dr["SHIPMENT_QUANTITY"]); dgvr.Cells["UNIT_CODE"].Value = dr["UNIT_CODE"]; dgvr.Cells["UNIT_NAME"].Value = dr["UNIT_NAME"]; dgvr.Cells["WAREHOUSE_CODE"].Value = dr["DEPARTUAL_WAREHOUSE_CODE"]; dgvr.Cells["TRUE_SLIP_NUMBER"].Value = slipNumber; dgvr.Cells["LINE_NUMBER"].Value = dr["LINE_NUMBER"]; dgvr.Cells["CURRENCY_CODE"].Value = dr["CURRENCY_CODE"]; dgvr.Cells["LINE_MEMO"].Value = dr["LINE_MEMO"]; dgvr.Cells["TAX_RATE"].Value = dr["TAX_RATE"]; dgvr.Cells["PRICE"].Value = dr["PRICE"]; dgvr.Cells["SHIPMENT_DEPOSIT"].Value = dr["SHIPMENT_DEPOSIT"]; dgvr.Cells["AMOUNT_INCLUDED_TAX"].Value = dr["AMOUNT_INCLUDED_TAX"]; } } else { if (isShowMessage) { MessageBox.Show("查询的信息不存在!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } this.dgvData.AlternatingRowsDefaultCellStyle.BackColor = COLOR_DIFF_ROW; initDgvData(); } ReSetDataGridView(""); }