vb進(jìn)銷存管理系統(tǒng)畢業(yè)論文(編輯修改稿)
2024-10-13 18:29 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 部收貨數(shù)量加月初存貨數(shù)量作為權(quán)數(shù)，去除本月全部收貨成本加上月初存貨成本，計(jì)算出存貨的加權(quán)平均單位成本，從而確定存貨的發(fā)出和庫(kù)存成本。 計(jì)算公式如下： 移動(dòng)平均法 移動(dòng)平均法亦稱移動(dòng)加權(quán)平均法，指本次收貨的成本加原有庫(kù)存的成本，除以本次收貨數(shù)量加原有收貨數(shù)量，據(jù)以計(jì)算加權(quán)單價(jià)，并對(duì)發(fā)出存貨進(jìn)行計(jì)價(jià)的 移動(dòng)加權(quán)平均法的優(yōu)點(diǎn)：能使管理當(dāng)局及時(shí)了解存貨的結(jié)存情況，而且計(jì)算的平均單位成本以及發(fā)出和結(jié)存的存貨成本比較客觀。缺點(diǎn)：每次收貨都要計(jì)算一次平均單價(jià)，計(jì)算工作量較大。 五、編碼實(shí)現(xiàn)與測(cè)試 編碼摘要 材料收發(fā)存分類匯總的部分代碼： sql 語(yǔ)句： SELECT [K_llll_D].[CLBH] AS CLBH, [K_llll_M].[KDRQ] AS KDRQ, [K_llll_M].[CBXM] AS CBXM, [K_llll_M].[DHDH], [K_llll_D].[SLSL] AS SLSL, [k_LLLL_D].[JEJE] AS JEJE FROM K_llll_M INNER JOIN K_llll_D ON [K_llll_M].[DHDH]=[K_llll_D].[DHDH] WHERE [K_llll_M].[status]=1。 SELECT [K_clrk_D].[CLBH] AS CLBH, [K_clrk_M].[KDRQ] AS KDRQ, [K_clrk_M].[DHDH] AS DHDH, [K_clrk_D].[SLSL] AS SLSL, [SLSL]*[K_clrk_D].[DJDJ] AS JEJE FROM K_clrk_M INNER JOIN K_clrk_D ON [K_clrk_M].[DHDH]=[K_clrk_D].[DHDH] WHERE [K_clrk_m].[STATUS]=1。 SELECT , Sum() AS ZSL, Sum() AS ZJE, year([KDRQ]) amp。 amp。 Month([KDRQ]) amp。 amp。 1 AS MON FROM SFC_rk AS A GROUP BY , year([KDRQ]) amp。 amp。 Month([KDRQ]) amp。 amp。 1。 SELECT , Sum(IIf(ISNULL(),0,)) AS ZSL, Sum(IIf(ISNULL(),0,)) AS ZJE, year([KDRQ]) amp。 amp。 Month([KDRQ]) amp。 amp。 1 AS MON FROM SFC_ck AS A GROUP BY , year([KDRQ]) amp。 amp。 Month([KDRQ]) amp。 amp。 1。 SELECT AS BHBH, AS YFYF, IIf(ISNULL(),0,) AS QCSL, IIf(ISNULL(),0,) AS SRSL, [QCSL]+SRSL AS MISL, IIf(ISNULL(),0,) AS QCJE, IIf(ISNULL(),0,) AS SRJE, [QCJE]+SRJE AS MIJE FROM T_SFC_QC AS A LEFT JOIN SFC_RK_GP AS B ON (=CDATE()) AND (=) ORDER BY [bhbh]。 SELECT , , , , (ISNULL(),0,) AS QMSL, , , (ISNULL(),0,) AS QMJE, IIF(ISNULL(),0,) AS FCSL, IIF(ISNULL(),0,) AS FCJE FROM SFC_AAA AS A LEFT JOIN SFC_CK_GP AS B ON (=CDATE()) AND (=) ORDER BY [bhbh]。 SELECT , AS PMPM, AS GGGG, , , , , , , , , , , , FROM SFC_BBB AS A LEFT JOIN J_clcl AS B ON = ORDER BY 。 SELECT SFC_CCC.*, IIf(ISNULL([O_Dzfy].[ZWZW]),空 ,[O_Dzfy].[ZWZW]) AS ZWBB FROM SFC_CCC LEFT JOIN O_Dzfy ON [O_Dzfy].[FHFH]=[SFC_CCC].[FLBB]。 SELECT SFC_ZW_B.*, IIf(isnull([O_Dzfy].[ZWZW]),空 ,[O_Dzfy].[ZWZW]) AS ZWCC FROM SFC_ZW_B LEFT JOIN O_Dzfy ON [SFC_ZW_B].[FLCC]=[O_Dzfy].[FHFH]。 SELECT AS FLBB, AS ZWBB, AS ZWCC, AS YFYF, Sum() AS QCZSL, Sum() AS SRZSL, Sum() AS FCZSL, Sum() AS QMZSL, Sum() AS QCZJE, Sum() AS SRZJE, Sum() AS FCZJE, Sum() AS QMZJE FROM SFC_ZW_C AS A GROUP BY , , , 。 全月一次加權(quán)平均計(jì)算單價(jià)的部分代碼： sql 語(yǔ)句： SELECT , SUM() AS RKSL, SUM() AS RKJE FROM AVER_MTH_RK1 AS A WHERE NOT (ISNULL()) GROUP BY [CLBH]。 SELECT , [SLSL], [JEJE], [YFYF] FROM AVER_MTH_RK AS A LEFT JOIN T_SFC_QC AS B ON (=) AND (=)。 SELECT , , , , * AS JEJE FROM K_clrk_M AS A INNER JOIN K_clrk_D AS B ON = WHERE STATUS=1。 VB 進(jìn)銷存管理系統(tǒng)畢業(yè)論文 SELECT , , IIf(=0,IIf(ISNULL([QCSL]),0,[QCJE]/[QCSL]),(+)/(CSL+)) AS DJDJ FROM AVER_MTH_RK2 AS A LEFT JOIN T_SFC_QC AS B ON =。 功能函數(shù) Public Sub Do_Aver_DJ() Dim da_Rec As Dim da_SQL As String Set da_Rec = (select * from AVER_DJ) Do While Not da_SQL = update J_clcl set DJDJ = amp。 (DJDJ) amp。 where BHBH= 39。 amp。 (CLBH) amp。 39。 (da_SQL) da_SQL = update K_LLLL_D set JEJE = amp。 (DJDJ) amp。 * where =39。 amp。 _ (CLBH) amp。 39。 and IN (SELECT DHDH FROM AVER_mth_LL2) (da_SQL) Loop End Sub 收發(fā)存明細(xì) ,追蹤某中材
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1