/// <summary>
/// 导入预付
/// </summary>
/// <param name="txtcCust"></param>
/// <param name="lblCust"></param>
void ImportYuFu(TextChooser txtcCust, Label lblCust)
{
if (txtcCust.Tag == null)
{
MessageBoxEx.Show(string.Format("请选择{0}！", lblCust.Text.TrimEnd('：')));
txtcCust.Focus();
return;
}
//frmBalanceDocuments frmDocuments = new frmBalanceDocuments(DataSources.EnumOrderType.PAYMENT, txtcCust.Tag.ToString(), ((int)DataSources.EnumPaymentType.ADVANCES).ToString());
frmPaymentByAdvances frmDocuments = new frmPaymentByAdvances(txtcCust.Tag.ToString());
if (frmDocuments.ShowDialog() == DialogResult.OK)
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.AppendFormat("order_id in ({0})", frmDocuments.ids);
sbWhere.AppendFormat(" and wait_money>0");
DataTable dt = DBHelper.GetTable("", "v_parts_purchase_order_payment", "*", sbWhere.ToString(), "", "");
foreach (DataRow dr in dt.Rows)
{
DataGridViewRow dgvr = dgvDocuments.Rows[dgvDocuments.Rows.Add()];
dgvr.Cells[colOrderName.Name].Value = "采购订单";//单据名称
dgvr.Cells[colOrderNum.Name].Value = dr["order_num"];//单据编号
dgvr.Cells[colOrderID.Name].Value = dr["sale_billing_id"];//单据ID
//dgvr.Cells[colOrderDate.Name].Value = Common.UtcLongToLocalDateTime(dr["receivables_date"]);//单据日期
dgvr.Cells[colMoney.Name].Value = dr["prepaid_money"];//开单金额
dgvr.Cells[colSettledMoney.Name].Value = dr["money"];//已结算金额
dgvr.Cells[colWaitMoney.Name].Value = dr["wait_money"];//未结算金额
}
}
}
/// <summary>
/// 导入应付
/// </summary>
/// <param name="txtcCust"></param>
/// <param name="lblCust"></param>
void ImportYingFu2(TextChooser txtcCust, Label lblCust)
{
if (txtcCust.Tag == null)
{
MessageBoxEx.Show(string.Format("请选择{0}！", lblCust.Text.TrimEnd('：')));
txtcCust.Focus();
return;
}
//frmBalanceDocuments frmDocuments = new frmBalanceDocuments(DataSources.EnumOrderType.PAYMENT, txtcCust.Tag.ToString(), ((int)DataSources.EnumPaymentType.PAYMENT).ToString());
frmPayment frmDocuments = new frmPayment(txtcCust.Tag.ToString());
if (frmDocuments.ShowDialog() == DialogResult.OK)
{
BindDocuments2(frmDocuments.listRows);
}
}
/// <summary>
/// 导入应收
/// </summary>
/// <param name="txtcCust"></param>
/// <param name="lblCust"></param>
void ImportYingShou2(TextChooser txtcCust, Label lblCust)
{
if (txtcCust.Tag == null)
{
MessageBoxEx.Show(string.Format("请选择{0}！", lblCust.Text.TrimEnd('：')));
txtcCust.Focus();
return;
}
//frmReceivable frmDocuments = new frmReceivable(txtcCust.Tag.ToString());
frmReceivableByVerification frmDocuments = new frmReceivableByVerification(txtcCust.Tag.ToString());
if (frmDocuments.ShowDialog() == DialogResult.OK)
{
BindDocuments2(frmDocuments.listRows);
}
}