/// <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 } }