private OutboundRcvd LoadOutbounds(string outboundId) { OutboundRcvd item = new OutboundRcvd(); string sql = string.Format("select OutboundID,Sales , OrderNo, (PriceAmount + Freight) as InvAmt, RcvdAmount from V_OutboundCash " + " where PriceAmount > 0 and ShipDate <>'' and OutboundID = '{0}'", outboundId); DataTable dt = Database.Select(sql); if (dt == null || dt.Rows.Count == 0) { return(item); } string temp = ""; int i = 0, col = 0; item.OutboundId = dt.Rows[i][col++].ToString(); item.Sales = dt.Rows[i][col++].ToString(); item.OutboundNo = dt.Rows[i][col++].ToString(); temp = dt.Rows[i][col++].ToString(); if (string.IsNullOrEmpty(temp) == false) { item.InvoiceAmount = Convert.ToDouble(temp); } temp = dt.Rows[i][col++].ToString(); if (string.IsNullOrEmpty(temp) == false) { item.RcvdAmount = Convert.ToDouble(temp); } item.BalanceAmount = item.InvoiceAmount - item.RcvdAmount; return(item); }
private List <OutboundRcvd> LoadOutbounds() { List <OutboundRcvd> list = new List <OutboundRcvd>(); string sql = "select OutboundID,Sales , OrderNo, (PriceAmount + Freight) as InvAmt, RcvdAmount from V_OutboundCash "; sql += " where PriceAmount > 0 and Sales <> 'NO' and ShipDate <>'' Order By OrderNo "; DataTable dt = Database.Select(sql); if (dt == null || dt.Rows.Count == 0) { return(list); } OutboundRcvd item = null; string temp = ""; for (int i = 0, col = 0; i < dt.Rows.Count; i++) { col = 0; temp = dt.Rows[i][1].ToString(); if (string.IsNullOrEmpty(temp.Trim())) { continue; } item = new OutboundRcvd(); item.OutboundId = dt.Rows[i][col++].ToString(); item.Sales = dt.Rows[i][col++].ToString(); item.OutboundNo = dt.Rows[i][col++].ToString(); temp = dt.Rows[i][col++].ToString(); if (string.IsNullOrEmpty(temp) == false) { item.InvoiceAmount = Convert.ToDouble(temp); } temp = dt.Rows[i][col++].ToString(); if (string.IsNullOrEmpty(temp) == false) { item.RcvdAmount = Convert.ToDouble(temp); } item.BalanceAmount = item.InvoiceAmount - item.RcvdAmount; //靠PayOff = “yes” if (item.BalanceAmount <= 0.0) { continue; } list.Add(item); } return(list); }
private void OnCellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { int nFind = -1; if (e.Column == colSales) { SelectSales(e.Value.ToString()); return; } if (e.Column == colOutboundNo) { nFind = FindOutbound(e.Value.ToString()); if (nFind < 0) { return; } OutboundRcvd item = OutboundList[nFind]; gridView.SetRowCellValue(e.RowHandle, colBalance, item.BalanceAmount.ToString("f2")); return; } if (e.Column == colRcvdAmount) { string poNo = gridView.GetRowCellValue(e.RowHandle, colOutboundNo).ToString(); nFind = FindOutbound(poNo); if (nFind < 0) { return; } OutboundRcvd item = OutboundList[nFind]; double val = 0.0; double.TryParse(e.Value.ToString(), out val); gridView.SetRowCellValue(e.RowHandle, colBalance, (item.BalanceAmount - val).ToString("f2")); return; } }
private void FrmRcvdEdit_Load(object sender, EventArgs e) { if (RcvdGridView == null) { return; } GridView rcvdView = RcvdGridView; int sel = rcvdView.FocusedRowHandle; boundId = rcvdView.GetRowCellValue(sel, "OutboundID").ToString(); recId = rcvdView.GetRowCellValue(sel, "RecordID").ToString(); amount = rcvdView.GetRowCellValue(sel, "RcvdAmount").ToString(); txtPoNo.Text = rcvdView.GetRowCellValue(sel, "OutboundNo").ToString(); txtSales.Text = rcvdView.GetRowCellValue(sel, "Sales").ToString(); cboPayOff.Text = rcvdView.GetRowCellValue(sel, "PayOff").ToString(); txtRcvdAmt.Text = rcvdView.GetRowCellValue(sel, "RcvdAmount").ToString(); txtRemark.Text = rcvdView.GetRowCellValue(sel, "Remark").ToString(); item = LoadOutbounds(boundId); txtInvAmt.Text = item.InvoiceAmount.ToString("f2"); }