/// <summary>
/// 收據匯入
/// </summary>
protected void SetReceiptTrans(DataSet dsReceipt)
{
BReceipt bReceipt = new BReceipt();
//刪除所有Receipt
lbState.Invoke((Action <string>)SetStatus, "刪除FoodOrg收據資料");
bReceipt.DelAll();
lbState.Invoke((Action <string>)SetStatus, "從access取收據資料移到FoodOrg");
lbl_ReceiptAll.Invoke((Action <string>)SetReceiptAll, dsReceipt.Tables[0].Rows.Count.ToString());
int intReceiptCount = 0;
foreach (DataRow dr in dsReceipt.Tables[0].Rows)
{
MReceipt mod = new MReceipt();
//民國和屆相差 59
mod.TWYear = SetTWYear(dr["Period"].ToString());
mod.MemberType = dr["MemberType"].ToString();
mod.MemberID = SetMemberGed(dr["MemberID"].ToString());
mod.ReceiptType = dr["ReceiptType"].ToString();
mod.Fee = Convert.ToInt32(dr["Fee"].ToString());
mod.ReceivedFromAppend = dr["ReceivedFromAppend"].ToString();
mod.Remark = dr["Remark"].ToString();
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
string strCancelUser = dr["CancelUser"].ToString();
string strCancelDate = dr["CancelDate"].ToString();
if (strCancelUser.Length > 0)
{
mod.CancelUser = strCancelUser;
}
if (strCancelDate.Length > 0)
{
mod.CancelDate = Convert.ToDateTime(strCancelDate);
}
mod.Enable = Convert.ToBoolean(dr["Enable"].ToString());
new BReceipt().Add(mod);
intReceiptCount++;
lbReceiptCount.Invoke((Action <int>)SetReceipt, intReceiptCount);
}
}
private void OperateInit()
{
BllPurchaseTable purchase = bPurchase.GetPurchaseModel(slipnumber);
if (purchase != null)
{
txtSupplierCode.Text = purchase.SUPPLIER_CODE;
if (!string.IsNullOrEmpty(purchase.SUPPLIER_CODE) && bCommon.GetBaseMaster("SUPPLIER", purchase.SUPPLIER_CODE) != null)
{
txtSupplierName.Text = bCommon.GetBaseMaster("SUPPLIER", purchase.SUPPLIER_CODE).Name;
}
txtInvoiceNo.Text = purchase.INVOICE_NUMBER;
txtInvoiceAmount.Text = CConvert.ToString(purchase.INVOICE_AMOUNT);
txtInvoiceNoLocal.Text = purchase.INVOICE_NUMBER_LOCAL;
txtInvoiceAmountLocal.Text = CConvert.ToString(purchase.INVOICE_AMOUNT_LOCAL);
txtPurchaseDate.Value = purchase.SLIP_DATE;
txtPaymentDate.Value = purchase.PAYMENT_DATE;
//txtPackAmount.Text = CConvert.ToString(purchase.PACKING_AMOUNT);
#region dgvData明细确认初始化
int i = 1;
dgvData.Rows.Clear();
string currentSupplier = "";
dgvData.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
dgvData.ReadOnly = true;
foreach (BllPurchaseLineTable line in purchase.Items)
{
int currentRowIndex = dgvData.Rows.Add(1);
DataGridViewRow row = dgvData.Rows[currentRowIndex];
row.Cells["No"].Value = i++;
string SupplierCode = CConvert.ToString(row.Cells["SUPPLIER_CODE"].Value);
if (currentSupplier == "" || currentSupplier != SupplierCode)
{
currentSupplier = SupplierCode;
if (!string.IsNullOrEmpty(purchase.SUPPLIER_CODE))
{
row.Cells["SUPPLIER_NAME"].Value = bCommon.GetBaseMaster("SUPPLIER", purchase.SUPPLIER_CODE).Name;
}
}
row.Cells["PO_SLIP_NUMBER"].Value = line.PURCHASE_ORDER_NUMBER;
row.Cells["SLIP_NUMBER"].Value = line.RECEIPT_SLIP_NUMBER;
row.Cells["AMOUNT"].Value = line.INVOICE_AMOUNT;
if (!string.IsNullOrEmpty(line.CURRENCY_CODE))
{
row.Cells["CURRENCY_NAME"].Value = bCommon.GetBaseMaster("CURRENCY", line.CURRENCY_CODE).Name;
}
row.Cells["TAX_AMOUNT"].Value = line.TAX_AMOUNT;
row.Cells["PACKAGE_AMOUNT"].Value = line.PACKING_AMOUNT;
BllReceiptLineTable receiptLine = new BReceipt().GetLineModel(line.RECEIPT_SLIP_NUMBER, line.RECEIPT_LINE_NUMBER);
if (receiptLine != null)
{
if (!string.IsNullOrEmpty(receiptLine.PRODUCT_CODE))
{
row.Cells["PRODUCT_NAME"].Value = bCommon.GetBaseMaster("PRODUCT", receiptLine.PRODUCT_CODE).Name;
}
row.Cells["AMOUNT_INCLUDED_TAX"].Value = receiptLine.AMOUNT_INCLUDED_TAX;
decimal InAmount = bPurchase.GetGetInvoiceAmount(line.RECEIPT_SLIP_NUMBER);
if (receiptLine.AMOUNT_INCLUDED_TAX > 0 && InAmount > 0 && receiptLine.AMOUNT_INCLUDED_TAX >= InAmount)
{
row.Cells["UN_INVOICE_AMOUNT"].Value = receiptLine.AMOUNT_INCLUDED_TAX - InAmount;
}
else
{
row.Cells["UN_INVOICE_AMOUNT"].Value = 0;
}
}
}
#endregion
}
}
