sf_dfsLv.28休闲值: 1264
相关回复帖子154条
感谢楼主
[原贴][原创]抚顺望花锦州路清水湾足疗验证
2016/7/27 21:13:00 123金雅洗浴
[原贴]沈阳 TY KH DH 有几家 都看看
2016/7/22 7:06:00 7197D饭锅当Guan的发给
[原贴][原创]丝足会所最新体验
2016/7/13 10:37:00 407不锈钢连胶条喉箍 卡箍
[原贴][原创]体验铁西区足疗小店
2016/7/11 9:08:00 359感谢!!!
[原贴]野狼验证铁西新人LF
2016/7/9 15:58:00 39十三D饭锅地方
[原贴]野狼验证铁西新人LF(已锁定)
2016/7/6 11:34:00谢谢楼主!
[原贴][原创]本人亲自验证的楼凤一一一白雪
2016/6/14 8:57:00 9西地那非溶于水吗
[原贴][原创]沈北附近洗浴分享
2016/6/14 8:50:00 673楼主辛苦!
[原贴][原创]本人亲自验证的楼凤一一一抚顺熟女毛毛
2016/6/13 11:12:00 27fgfgfgfgfgfg
[原贴][原创]本人亲自验证的楼凤一一一抚顺熟女毛毛(已锁定)
2016/6/8 7:17:00个名字个都不说 咋找
[原贴][原创]抚顺 sF
2016/5/25 21:32:00 1071ggggggggggggggggg
[原贴][原创]登清泉两个月试水情况详解
2016/5/23 15:27:00 596gfddfgdfgdfgdfgdgdg
[原贴][原创]登清泉两个月试水情况详解(已锁定)
2016/5/18 12:31:00gfddfgdfgdfgdfgdgdg
[原贴][原创]登清泉两个月试水情况详解(已锁定)
2016/5/18 12:29:00RzButtonEdit14
[原贴][原创]抚顺兴沅(有哥们误读成兴抚)自驾攻略!
2016/5/16 7:42:00 3289D饭锅D呱呱
[原贴]抚顺验证圣浪洗浴经济实惠
2016/5/15 9:04:00 2344sdfsdfsdfsfdsfs
[原贴]抚顺验证圣浪洗浴经济实惠(已锁定)
2016/4/26 7:38:00fgdgdgdfg
[原贴]大东区的洗浴超值!!!
2016/4/6 6:49:00 3578dfgdgdgfd
[原贴][原创]大东鑫鑫洗浴6.25已验证
2016/4/6 6:49:00 2463fgdgdfgdgfdgdf
[原贴]大东区的洗浴超值!!!
2016/4/6 6:48:00 3578dfsfsdfsfdsdfsdfsdf
[原贴]大东区的洗浴超值!!!(已锁定)
2016/4/5 13:28:00c:\zzzzzz
[原贴]方形广场附近足疗店,大惊喜
2016/3/19 20:22:00 5126看看什么情况
[原贴][原创]有个好地方 地方比较小 不起眼
2016/2/6 12:40:00 44哥们,Wo上月去过,真不错!!!可能是你点子不好吧,!!!
[原贴]交作业,抚顺高湾兴沅归来
2016/1/27 16:21:00 27ffsdfsfdsfsdf
[原贴][原创]刚刚验证的一家足疗店,(功能齐全)
2016/1/21 20:51:00 5584fgsdfgsdgsdgd
[原贴][原创]抚顺金色假日
2016/1/21 20:38:00 2704sdfadfafafd
[原贴][原创]抚顺金色假日(已锁定)
2016/1/19 10:40:00fgdgfdsgsdgfsdgfs
[原贴][原创]抚顺金色假日(已锁定)
2016/1/19 10:36:00tgyegdfgdgdfg
[原贴][原创]抚顺金色假日(已锁定)
2016/1/17 12:30:00gggffttyuiigfrrtghhh
[原贴][原创]抚顺金色假日(已锁定)
2016/1/17 8:16:00fdsafasgadfg
[原贴][原创]抚顺金色假日(已锁定)
2016/1/3 9:47:00[SF_GetOpPass]
[原贴]dh真实验证(重点是非常安全)
2015/12/29 9:50:00 7678[SF_GetOpPass]
[原贴][原创]本周末验证浴王,棒棒糖,附午夜惊魂,沈阳的狼友必看
2015/12/29 9:42:00 5909UserName.SetFocus;
[原贴][原创5.31]抚顺-真实体验版-最实际的去处
2015/12/28 20:50:00 4765回复了看看
[原贴]大北关街碧泉宫,有惊喜!
2015/12/23 8:01:00 3108鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴
[原贴]抚顺金凯撒扫盲贴
2015/10/30 11:24:00 3477鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴
[原贴]沈阳怕是不行了,抚顺离沈阳就不远
2015/10/30 11:21:00 2551鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴鑫浪洗浴
[原贴][原创]7月17日下午验证
2015/10/30 11:19:00 4213dfgfdgdgddddd
[原贴]抚顺道街最新验证
2015/9/28 8:48:00 2263dfgdfgdddddddd
[原贴]抚顺道街最新验证(已锁定)
2015/9/28 8:48:00空气滤芯
[原贴]抚顺道街最新验证(已锁定)
2014/11/14 10:37:00关于洗浴论坛帖子不能回复的解决办法
[原贴]抚顺道街最新验证(已锁定)
2014/10/27 12:52:00关于洗浴论坛帖子不能回复的解决办法
[原贴]我也说说金帝吧,多年金帝的老顾客了
2014/10/27 12:51:00 3816sdfsfsdfsfds
[原贴]我也说说金帝吧,多年金帝的老顾客了(已锁定)
2014/1/20 16:57:00fgdfgddddd
[原贴]我也说说金帝吧,多年金帝的老顾客了(已锁定)
2014/1/20 16:56:00CREATE PROCEDURE [KS_JBA] @i_OperType int, @i_BillID int, @i_BL_Dt varchar(10), @i_BL_BT int, @i_BT_TBLX smallint, @i_WLDW_ID int, @i_YSYF_Money numeric(28, 10), @i_YSYF_Remain numeric(28, 10), @i_VIP_ID int, @o_CardMoney numeric(28, 10) output, @o_ProdID int output AS set nocount on Declare @Result int, @DateB varchar(10) if @i_BL_BT in (60, 62, 63, 65) begin if exists(select XT_FD from KsdAdvSystem where upper(XT_NR)='INIORSTART' and upper(XT_SZ)='START') begin set @Result=-7 --系统已进行了开账C作! goto Error end end else begin if exists(select XT_FD from KsdAdvSystem where upper(XT_NR)='INIORSTART' and upper(XT_SZ)='INI') begin set @Result=-4 --系统尚未进行开账C作! goto Error end select @DateB = XT_SZ from KsdAdvSystem where upper(XT_NR)='STARTDATE' if @i_BL_Dt<@DateB begin set @Result=-8 --单据日期在开账日期前! goto Error end end select @DateB=DateB from KsdMP where MonthName='本期' if @i_BL_Dt<@DateB begin if @i_OperType = -1 set @Result=-60 --已结存单据不允许红冲! else set @Result=-32 --单据日期应大于本期开始日期! goto Error end if (@i_OperType=0) and exists(select Mst_ID from KsdMainBill where Mst_ID = @i_BillID and BL_State = 2) begin set @Result=-9 --该单据已被过账审核! goto Error end if exists(select XT_FD from KsdAdvSystem where XT_FD='00000' and XT_OU='1') begin set @Result=-47 --系统正在进行抄账,请稍后再试。 goto Error end --if @i_BL_BT<>59 请zuo完总量盘点C作后,再继续进行此C作。 if (@i_BL_BT<100 or="or" @i_BL_BT>200) and @i_BL_BT not in (5,6,53,54,57,58,68,71,74,244,245) begin exec @Result= dbo.KS_CheckSerial @i_BillID,@o_ProdID output if @Error<>0 or @Result<0 goto="goto" Error end if @i_OperType =-1 begin if exists(select Mst_ID="Mst_ID" from="from" KsdMainBill="KsdMainBill" where="where" Mst_ID="Mst_ID" = @i_BillID and="and" XT_Flg="XT_Flg" < 0) begin set @Result=-33 --单据已被红冲! goto Error end if exists(select Mst_ID="Mst_ID" from="from" KsdMainBill="KsdMainBill" where="where" Mst_ID="Mst_ID" = @i_BillID and="and" BL_State="BL_State" <>2) begin set @Result=-78 --未审核单据不能被红冲! goto Error end --if exists(select Mst_ID from KsdMainBill where Mst_ID = @i_BillID and (MakePZ='1')) 单据已S成凭证不能红冲 --if (@i_VIP_ID<>-1) and (@i_BL_BT in (1, 4, 15, 16)) end else begin if @i_BL_BT in (0, 1) begin if ((@i_BL_BT = 0) and exists(SELECT b.BL_State from KsdDetailBill a,KsdMainBill b where b.Mst_ID=a.BL_ID and b.Mst_ID=@i_BillID and a.Prod_DDID in ( select detail_ID from KsdDetailBill where BL_ID in (select Mst_ID from KsdMainBill where BL_BT=5 and BL_State <> 2)) ) ) or ((@i_BL_BT = 1) and exists(SELECT b.BL_State from KsdDetailBill a,KsdMainBill b where b.Mst_ID=a.BL_ID and b.Mst_ID=@i_BillID and a.Prod_DDID in ( select detail_ID from KsdDetailBill where BL_ID in (select Mst_ID from KsdMainBill where BL_BT=6 and BL_State <> 2)) ) ) begin set @Result=-52 --相关订单未经审核! goto Error end if ((@i_BL_BT = 0) and exists(SELECT b.BL_State from KsdDetailBill a,KsdMainBill b where b.Mst_ID=a.BL_ID and b.Mst_ID=@i_BillID and a.Prod_DDID in ( select detail_ID from KsdDetailBill where BL_ID in (select Mst_ID from KsdMainBill where BL_BT=5 and DDBL_ZT = 3 )) ) ) or ((@i_BL_BT = 1) and exists(SELECT b.BL_State from KsdDetailBill a,KsdMainBill b where b.Mst_ID=a.BL_ID and b.Mst_ID=@i_BillID and a.Prod_DDID in ( select detail_ID from KsdDetailBill where BL_ID in (select Mst_ID from KsdMainBill where BL_BT=6 and DDBL_ZT = 3 )) ) ) begin set @Result=-53 --相关订单已被强制完成! goto Error end end if @i_BL_BT in (1, 3, 14, 15, 61 ) if exists(select * from KsdBIU where XT_ID=@i_WLDW_ID and IsNull(BIU_XY_Limit,0)<>0) and exists(select * from KsdBIU where XT_ID=@i_WLDW_ID and IsNull(BIU_XY_Limit,0)<(IsNull(BIU_YSK,0)-IsNull(BIU_YFK,0)+@i_YSYF_Remain)) begin if exists(select * from ksdSysTemInfo where XT_FD='0000400022' and Can_flg='√') begin if exists(select * from ksdSysTemInfo where XT_FD='0000400015' and Can_flg='√') begin set @Result=5 --goto Error 超出单位信用额度!但允许过帐 end end else begin set @Result=-6 -- 超出单位信用额度!不允许过帐 goto Error end end end /*if @i_OperType <>-1 begin if (@i_BL_BT=59) begin declare @CK_ID int, @FL_ID int, @ZL_ID int select @CK_ID = Change, @ZL_ID = PayMoney from MasterBillDft where XT_ID = @i_DftID if not exists(select XT_ID from MasterBillDft where XT_ID = @CK_ID and XT_Flg = -3 and BL_State <> -1) begin set @Result = -65 goto Error end if exists(select XT_ID from MasterBillDft where Change = @CK_ID and BL_State <> -1 and BL_BT = 66 and isNull(PayMoney,0) = 0) begin set @Result = -66 goto Error end if exists(select a.XT_ID from MasterBillDft a , MasterBillDft b where b.PayMoney = @i_DftID and a.BIS_I_ID = b.BIS_I_ID and a.XT_Flg = -3 and a.BL_State <> -1 and a.BL_BT = 66) begin set @Result=-46 goto Error end if exists(select XT_ID from MasterBillDft where XT_ID = @i_DftID and XT_Flg = -5) begin set @Result=-56 goto Error end end end*/ if IsNull(@Result, 0)>0 return @Result else return 0 Error: if IsNull(@Result, 0)>=0 set @Result=-1 return @Result GO
[原贴]沈阳好浴宫
2013/9/25 15:48:00 2671看看什么情况
[原贴]沈阳好浴宫(已锁定)
2013/8/18 10:08:00看看什么情况
[原贴]沈阳好浴宫(已锁定)
2013/8/18 10:07:00看看什么情况
[原贴][分享]大东洗浴KH,DH,TY全都有!!!
2013/8/18 10:05:00 4376看看什么情况
[原贴]6月 5日验证了大东鑫鑫洗浴
2013/8/18 10:04:00 2285