/// <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("");
}
