private void insertTo退貨記錄(string p_str請購單號, string p_str產品編號, int p_int退貨數量) { CKGPartOrderFactory l_factory請購主檔 = _context.CFactoryManager.CKGPartOrderFactory; CKGPartOrder l_code請購主檔 = l_factory請購主檔.getKGPartOrderBy請購單號(p_str請購單號); CKGPartOrderDetailFactory l_factory請購明細 = _context.CFactoryManager.CKGPartOrderDetailFactory; CKGPartOrderDetail l_code請購明細 = l_factory請購明細.get請購單內的單一產品明細(p_str請購單號, p_str產品編號); CKGPartOrderDetailOutFactory l_factroy退貨記錄 = _context.CFactoryManager.CKGPartOrderDetailOutFactory; CKGPartOrderDetailOut l_code退貨記錄 = l_factroy退貨記錄.createCKGPartOrderDetailOut(); CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser; l_code退貨記錄.f_ExchangeID請購單號 = p_str請購單號; l_code退貨記錄.f_SalesSmid業代員編 = l_code請購主檔.f_SalesSmid業代員編; l_code退貨記錄.f_SalesBranch業代單位 = l_user.f_branchid所別; l_code退貨記錄.f_AssistantSmid退貨助理員編 = l_user.f_userid帳號; //"F9446";// l_code退貨記錄.f_ProductID產品編號 = l_code請購明細.f_ProductID產品編號; l_code退貨記錄.f_ProductName產品名稱 = l_code請購明細.f_ProductName產品名稱; l_code退貨記錄.f_OutAmount退貨數量 = p_int退貨數量; l_code退貨記錄.f_OutDate退貨日期 = DateTime.Today.ToString("yyyy/MM/dd"); l_code退貨記錄.f_Qty產品單位 = l_code請購明細.f_Qty產品單位; l_code退貨記錄.f_Cost產品成本 = l_code請購明細.f_Cost產品成本價; l_code退貨記錄.f_UnitPrice產品單價 = l_code請購明細.f_UnitPrice產品單價; l_code退貨記錄.f_ListPrice建議售價 = l_code請購明細.f_ListPrice建議售價; l_code退貨記錄.f_OutTotal總計退貨價格 = l_code請購明細.f_UnitPrice產品單價 * p_int退貨數量; l_code退貨記錄.f_OutReasons退貨原因 = iv_txt退貨原因.Text.Replace("'", ""); l_code退貨記錄.f_Check管理者確認退貨 = "False"; l_code退貨記錄.f_EditDate編輯日期 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); l_factroy退貨記錄.insertCKGPartOrderDetailOut(l_code退貨記錄); }
private void 確認退貨記錄(string p_strId) { CKGPartOrderDetailOutFactory l_factory退貨記錄 = _context.CFactoryManager.CKGPartOrderDetailOutFactory; CKGPartOrderDetailOut l_code退貨記錄 = l_factory退貨記錄.get退貨資料ById(p_strId); CKGPointFactory l_factory點數資料 = _context.CFactoryManager.CKGPointFactory; CKGPoint l_code點數資料 = l_factory點數資料.get業代點數資料(l_code退貨記錄.f_SalesSmid業代員編); CUser l_user業代 = _context.CFactoryManager.CUserFactory.get高都員工檔(l_code退貨記錄.f_SalesSmid業代員編); if (l_code點數資料 == null) { l_code點數資料 = l_factory點數資料.createCKGPoint(); l_code點數資料.f_Smid業代員編 = l_code退貨記錄.f_SalesSmid業代員編; l_code點數資料.f_Name業代姓名 = l_user業代.f_username姓名; l_code點數資料.f_Point現有點數 = 0; l_factory點數資料.insertCKGPoint(l_code點數資料); } string l_str現在時間 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); // l_factory退貨記錄.update確認退貨By管理者(p_strId, l_str現在時間); //把錢存回業代的點數 l_factory點數資料.update沖帳取消或退貨成功後點數歸回(l_code退貨記錄.f_SalesSmid業代員編, l_code退貨記錄.f_OutTotal總計退貨價格); CKGPointDetailFactory l_factory點數紀錄 = _context.CFactoryManager.CKGPointDetailFactory; CKGPointDetail l_code點數紀錄 = l_factory點數紀錄.createCKGPointDetail(); CUser l_user = Session[SealedGlobalPage.SESSIONKEY_LOGIN_USER_DATA] as CUser; l_code點數紀錄.f_ImportSmid匯入人員員編 = l_user.f_userid帳號; //"F9446";// l_code點數紀錄.f_ImportName匯入人員姓名 = l_user.f_username姓名; //"黃敏惠";// l_code點數紀錄.f_Smid業代員編 = l_code退貨記錄.f_SalesSmid業代員編; l_code點數紀錄.f_Name業代姓名 = l_user業代.f_username姓名; l_code點數紀錄.f_ImportPoint匯入點數 = l_code退貨記錄.f_OutTotal總計退貨價格; l_code點數紀錄.f_ImportDate匯入日期 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); l_code點數紀錄.f_ImportType匯入方式 = "退貨加回"; l_factory點數紀錄.insertCKGPointDetail(l_code點數紀錄); }