Пример #1
0
 //导入结算单据
 void ImportDocument()
 {
     if (windowStatus == WindowStatus.View)
     {
         return;
     }
     if (txtcCustName.Tag == null)//客户
     {
         MessageBoxEx.Show(string.Format("请选择{0}!", lblCustName.Text.Replace(":", "")));
         txtcCustName.Focus();
         return;
     }
     string paymentType = CommonCtrl.IsNullToString(cboOrderType.SelectedValue);//收付款类型
     if (paymentType.Length == 0)
     {
         return;
     }
     if (orderType == DataSources.EnumOrderType.RECEIVABLE)
     {
         #region 应收
         DataSources.EnumReceivableType enumType = (DataSources.EnumReceivableType)int.Parse(paymentType);
         if (enumType == DataSources.EnumReceivableType.RECEIVABLE)
         {
             cmsImport.Show(base.btnImport, 0, base.btnImport.Height);
             return;
         }
         else
         {
             //预收
             frmReceivableByAdvances frm = new frmReceivableByAdvances(txtcCustName.Tag.ToString());
             if (frm.ShowDialog() == DialogResult.OK)
             {
                 BindDocument(frm.listRows, true);
             }
         }
         #endregion
     }
     else
     {
         #region 应付
         StringBuilder sbWhere = new StringBuilder();
         DataSources.EnumPaymentType enumType = (DataSources.EnumPaymentType)int.Parse(paymentType);
         if (enumType == DataSources.EnumPaymentType.PAYMENT)
         {
             frmPayment frm = new frmPayment(txtcCustName.Tag.ToString());
             if (frm.ShowDialog() == DialogResult.OK)
             {
                 BindDocument(frm.listRows, false);
             }
         }
         else
         {
             frmPaymentByAdvances frm = new frmPaymentByAdvances(txtcCustName.Tag.ToString());
             if (frm.ShowDialog() == DialogResult.OK)
             {
                 BindDocument(frm.listRows, true);
             }
         }
         #endregion
     }
 }
 /// <summary>
 /// 导入预收
 /// </summary>
 void ImportYuShou(TextChooser txtcCust, Label lblCust)
 {
     if (txtcCust.Tag == null)
     {
         MessageBoxEx.Show(string.Format("请选择{0}!", lblCust.Text.TrimEnd(':')));
         txtcCust.Focus();
         return;
     }
     //frmBalanceDocuments frmDocumentsYu = new frmBalanceDocuments(DataSources.EnumOrderType.RECEIVABLE, txtcCust.Tag.ToString(), ((int)DataSources.EnumReceivableType.ADVANCES).ToString());
     frmReceivableByAdvances frmDocumentsYu = new frmReceivableByAdvances(txtcCust.Tag.ToString());
     if (frmDocumentsYu.ShowDialog() == DialogResult.OK)
     {
         StringBuilder sbWhere = new StringBuilder();
         sbWhere.AppendFormat("sale_order_id in ({0})", frmDocumentsYu.ids);
         sbWhere.AppendFormat(" and wait_money>0");
         DataTable dt = DBHelper.GetTable("", "v_parts_sale_order_receivable", "*", 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["advance_money"];//开单金额
             dgvr.Cells[colSettledMoney.Name].Value = dr["money"];//已结算金额
             dgvr.Cells[colWaitMoney.Name].Value = dr["wait_money"];//未结算金额
         }
     }
 }
Пример #3
0
 /// <summary>
 /// 导入预收
 /// </summary>
 void ImportReceivableByAdvances()
 {
     frmReceivableByAdvances frm = new frmReceivableByAdvances(txtcCustName.Tag.ToString());
     if (frm.ShowDialog() == DialogResult.OK)
     {
         BindDocument(frm.listRows, true);
     }
 }