// public static string remote = "Server=.;Trusted_Connection=yes;"; public static void CreateTonHienTai(clsDB db, string @ma_dvcs, string @ma_kho, string @ma_vi_tri, string @masp) { string @ma_vi_triCondition = @ma_vi_tri; string query = ""; if (@ma_vi_triCondition.Equals("00")) { @ma_vi_triCondition = ""; } string sql = "\n IF OBJECT_ID('tempdb.dbo.#TonHienTai') IS NOT NULL DROP TABLE #TonHienTai " + "\n CREATE TABLE #TonHienTai ( ma_dvcs nvarchar(500),ma_kho nvarchar(500),ma_vi_tri nvarchar(500),ma_vt nvarchar(500), ton float ) " + "\n if isnull((select dongboERP from nhaphanphoi where mafast ='" + ma_dvcs + "'),0) = 1 " + "\n insert #TonHienTai (ma_dvcs,ma_kho,ma_vi_tri,ma_vt,ton) " + "\n select distinct ma_dvcs,ma_kho, case ma_vi_tri when '' then '00' else ma_vi_tri end ma_vi_tri ,ma_vt,ton from OPENROWSET('SQLNCLI', '" + remote + "','SET FMTONLY OFF; " + "\n exec [FAST].[HTP_FBOR2_A].dbo.Fast$DMSGESO$CurrentStock ''" + ma_dvcs + "'',''" + ma_kho + "'',''" + ma_vi_triCondition + "'',''" + masp + "'' ') where 1=1 "; int sodo = db.updateQueryReturnInt(sql); query = "\n if isnull((select dongboERP from nhaphanphoi where mafast ='" + ma_dvcs + "'),0) = 0 " + "\n insert #TonHienTai (ma_dvcs,ma_kho,ma_vi_tri,ma_vt,ton) " + "\n select distinct ma_dvcs,ma_kho, ma_vi_tri ,ma_vt,ton from Kho_Test_HTP x " + "\n where 1= 1 and not exists (select 1 from #TonHienTai y where y.ma_dvcs = x.ma_dvcs and y.ma_kho = x.ma_kho and y.ma_vi_tri = x.ma_vi_tri and y.ma_vt = x.ma_vt ) "; if (@ma_dvcs.Trim().Length > 0) { query += " and ma_dvcs = '" + @ma_dvcs + "'"; } if (@ma_kho.Trim().Length > 0) { query += " and ma_kho ='" + @ma_kho + "' "; } if (@ma_vi_tri.Trim().Length > 0) { query += " and ma_vi_tri = '" + @ma_vi_tri + "' "; } if (@masp.Trim().Length > 0) { query += " and masp = '" + @masp + "'"; } int sodo2 = db.updateQueryReturnInt(query); }
public static void CreateTonDau(clsDB db, string @ma_dvcs, string @ma_kho, string @ma_vi_tri, string @masp) { string @ma_vi_triCondition = @ma_vi_tri; string query = ""; if (@ma_vi_triCondition.Equals("00")) { @ma_vi_triCondition = ""; } string sql = "\n IF OBJECT_ID('tempdb.dbo.#TonDau') IS NOT NULL DROP TABLE #TonDau " + "\n CREATE TABLE #TonDau ( ma_dvcs nvarchar(500),ma_kho nvarchar(500),ma_vi_tri nvarchar(500),ma_vt nvarchar(500), ton float ) " + "\n if isnull((select dongboERP from nhaphanphoi where mafast ='" + ma_dvcs + "'),0) = 1 " + "\n insert #TonHienTai (ma_dvcs,ma_kho,ma_vi_tri,ma_vt,ton) " + "\n select distinct ma_dvcs,ma_kho, case ma_vi_tri when '' then '00' else ma_vi_tri end ma_vi_tri ,ma_vt,ton from OPENROWSET('SQLNCLI', '" + remote + "','SET FMTONLY OFF; " + "\n exec [FAST].[HTP_FBOR2_A].dbo.Fast$DMSGESO$Stock ''" + ma_dvcs + "'',''" + ma_kho + "'',''" + ma_vi_triCondition + "'',''" + masp + "'' ') where 1=1 "; int sodo = db.updateQueryReturnInt(sql); }