public override void VerifyRenderingInServerForm(Control control)
{
//required to avoid the runtime error "
//Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server."
}
- Feb 02 Fri 2024 11:26
-
ASP.net C# Export GridView into Excel
- Feb 01 Thu 2024 14:19
-
(SQL) 動態SQL + PIVOT(欄位轉置) + 欄位資料組成字串
DECLARE @columns NVARCHAR(MAX);
DECLARE @sql NVARCHAR(MAX);
-- 動態生成要顯示的題目欄位
SELECT @columns = COALESCE(@columns + ', ', '') + QUOTENAME(QUESTION) FROM (
- Apr 20 Thu 2023 09:07
-
(Oracle) ERP 客戶聯絡人資料
SELECT hcasa.org_id,
role_acct.account_number,
AR.CUSTOMER_NAME,
hcsua.tax_reference,
party.person_first_name || party.person_middle_name || party.person_last_name contact_first_name,
- Feb 24 Fri 2023 13:53
-
(Oracle) ERP 修改OM & AR Invoice
create table select * from bkp_ra_cust_trx_184210
as select * from ra_customer_trx_all where customer_trx_id=184210
and org_id=202;
- Feb 21 Tue 2023 11:31
-
(Oracle) ERP 查詢Concurrent LOG & Output FILE位置
查詢Conncurrent LOG FILE位置
SELECT FCPP.CONCURRENT_REQUEST_ID REQ_ID,
FCP.NODE_NAME,
FCP.LOGFILE_NAME
FROM FND_CONC_PP_ACTIONS FCPP,
- Dec 09 Fri 2022 10:27
-
ASP.net C# 執行外部程式
var process = new Process
{
StartInfo = new ProcessStartInfo
{
FileName = "C:\\Debug\\ConsoleTest.exe", // 執行檔路徑
- Dec 06 Tue 2022 14:35
-
(Oracle) PL SQL 一年內日期列表
SELECT TO_CHAR(add_months(add_months(sysdate, -12), ROWNUM - 1), 'MON-yy') AS yearmonth
FROM DUAL
CONNECT BY ROWNUM <=
(SELECT months_between(sysdate, add_months(sysdate, -12))
FROM dual);
- Oct 18 Tue 2022 21:07
-
(Oracle) 外包工單 Release 後未自動產生PR
今天遇到一個問題,
外包工單在release 後未產生PR,
經查詢PR interface是有資料的,
但發生了錯誤,所以並未建立PR成功,
錯誤訊息為 Please enter a valid Deliver to Location
- Oct 08 Fri 2021 09:59
-
(Oracle) ERP 未開立PO的PR List
select prh.segment1 "PR NUM",
trunc(prh.creation_date) "PO Creation Date",
trunc(prl.creation_date) "Line Creation Date",
prl.line_num "Seq #",
msi.segment1 "Item Num",
- Oct 08 Fri 2021 09:43
-
(Oracle) ERP PR & PO 關聯資料
select mp.organization_code "ORG",
pha.segment1 "PO NO",
asp.vendor_name "Supply",
assa.vendor_site_code "Site",
pla.line_num "Line",
- Oct 08 Fri 2021 09:39
-
(Oracle) ERP 未有銷售訂單的內部採購單資料
Select RQH.SEGMENT1 REQ_NUM,
RQL.LINE_NUM,
RQL.REQUISITION_HEADER_ID,
RQL.REQUISITION_LINE_ID,
RQL.ITEM_ID,
- Jul 28 Wed 2021 13:45
-
(Oracle) ERP AR Payment Term 更新
declare
v_invoice_no varchar2(25):='invoice';
v_term varchar2(30):='payment term';
v_trx_id number;
v_term_id number;
