private void GetOrderIdToIncomeForm(DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1 || e.RowIndex == grvReceivableFromCustomer.Rows.Count - 1)
{
return;
}
DataGridViewRow row = grvReceivableFromCustomer.Rows[e.RowIndex];
string amount = row.Cells["Amount"].Value.ToString();
string incomeAmount = row.Cells["IncomeAmount"].Value.ToString();
int purchaseOrderId = int.Parse(row.Cells["PurchaseReceiptOrderId"].Value.ToString());
if (decimal.Parse(amount) - decimal.Parse(incomeAmount) == 0)
{
MessageBox.Show("Công nợ này đã thanh toán hết!");
return;
}
FormCollection activeForms = Application.OpenForms;
Form incomeForm = new Form();
foreach (Form f in activeForms)
{
if (f.Name == "IncomeForm")
{
incomeForm = f;
}
}
Label lbCostId = incomeForm.Controls.Find("lbCostId", true)[0] as Label;
lbCostId.Text = "0";
Label lbOrderId = incomeForm.Controls.Find("lbOrderId", true)[0] as Label;
JSManagementDataSet.ReceivableFromCustomersDataTable receivableFromCustDataTable = receivableCustomerAdapter.GetReceivableFromCustomersByPurchaseOrderId(purchaseOrderId);
decimal totalAmount = 0;
decimal totalIncome = 0;
int custId = 0;
foreach (DataRow r in receivableFromCustDataTable.Rows)
{
totalAmount += decimal.Parse(r.ItemArray[3].ToString());
totalIncome += decimal.Parse(r.ItemArray[4].ToString());
custId = int.Parse(r.ItemArray[6].ToString());
}
lbOrderId.Text = purchaseOrderId.ToString();
TextBox txtreason = incomeForm.Controls.Find("txtReason", true)[0] as TextBox;
Label incomeHeader = incomeForm.Controls.Find(Constant.Income.LABEL_INCOME_HEADER_CONTROL_NAME, true)[0] as Label;
txtreason.Text = string.Format("Lập {0} tiền ... ngày {1} / Mã số bưu gửi: {2} / Đơn hàng: {3}", incomeHeader.Text, DateTime.Parse(row.Cells["OrderDate"].Value.ToString()).ToShortDateString(), row.Cells["BillNumber"].Value.ToString(), row.Cells["PurchaseReceiptOrderId"].Value.ToString());
UCTextBoxCurrency txtAmount = incomeForm.Controls.Find("ucTextBoxCurrency1", true)[0] as UCTextBoxCurrency;
txtAmount.Value = totalAmount - totalIncome;
CustomerSelectUserControl customerSelectUserControl = incomeForm.Controls.Find("customerSelectUserControl1", true)[0] as CustomerSelectUserControl;
customerSelectUserControl.Enabled = false;
customerSelectUserControl.CustId = custId;
this.Close();
}
private bool InsertIncome(int purchaseOrderId)
{
JSManagementDataSet.PurchaseReceiptOrderDataTable purchaseData = purchaseReceipOrderAdapter.GetById(purchaseOrderId);
JSManagementDataSet.ReceivableFromCustomersDataTable receivableData = receivableCustomerAdapter.GetReceivableFromCustomersByPurchaseOrderId(purchaseOrderId);
if (purchaseData.Rows.Count == 0 || receivableData.Rows.Count == 0)
{
return(false);
}
string incomeNumber = purchaseData[0].BillNumber;
DateTime incomeDate = DateTime.Now;
string payerName = purchaseData[0].BillNumber;
string reason = string.Empty;
decimal amount = receivableData[0].Amount - receivableData[0].IncomeAmount;
if (amount > 0)
{
reason = string.Format("Thu nợ tiền hàng ngày {0} / Mã số bưu gửi: {1} / Đơn hàng: {2}", DateTime.Parse(purchaseData[0].OrderDate.ToString()).ToShortDateString(), purchaseData[0].BillNumber, purchaseData[0].PurchaseReceiptOrderId.ToString());
}
else
{
reason = string.Format("Chi tiền chênh lệch ngày {0} / Mã số bưu gửi: {1} / Đơn hàng: {2}", DateTime.Parse(purchaseData[0].OrderDate.ToString()).ToShortDateString(), purchaseData[0].BillNumber, purchaseData[0].PurchaseReceiptOrderId.ToString());
}
string createdBy = LoginInfor.UserName;
DateTime createdDate = DateTime.Now;
int toBankAccountId = purchaseData[0].BankAccountId;
string bankAccountName;
if (toBankAccountId == 0)
{
bankAccountName = "Tiền mặt";
}
else
{
bankAccountName = bankAccountTableAdapter.GetDataById(toBankAccountId)[0].BankAccountName;
}
int custId = purchaseData[0].CustId;
object income = new object();
//StringBuilder sb = new StringBuilder();
//sb.AppendLine("Bạn có chắc chắn tạo phiếu thu? ");
//sb.AppendLine("Mã số bưu gửi: " + incomeNumber == string.Empty? purchaseData[0].CustId.ToString() : incomeNumber);
//sb.AppendLine("Số tiền: " + amount);
//sb.AppendLine("Bằng chữ: " + VNCurrency.ToString(amount));
//sb.AppendLine("Tới tài khoản: " + bankAccountName);
//DialogResult reviewConfirmMessage = MessageBox.Show(sb.ToString(), "Bạn có chắc chắn?", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
//if (reviewConfirmMessage == System.Windows.Forms.DialogResult.Cancel)
//{
// return false;
//}
income = incomeTableAdapter.InsertIncomeReturnId(
incomeDate,
incomeNumber,
payerName,
reason,
amount,
createdBy,
createdDate,
createdBy,
createdDate,
null,
null,
purchaseOrderId,
null,
toBankAccountId, custId);
return(true);
}
