存储过程生成器c#源码 既是源码还是一个很好用的编程辅助工具

if exists(select * from sysobjects where type='p' and name='pro_W_WAREHOUSE_IN_selectById') drop proc pro_W_WAREHOUSE_IN_selectById go create proc pro_W_WAREHOUSE_IN_selectById @id int as select * from W_WAREHOUSE_IN where id=@id go if exists(select * from sysobjects where type='p' and name='pro_W_WAREHOUSE_IN_insert') drop proc pro_W_WAREHOUSE_IN_insert go create proc pro_W_WAREHOUSE_IN_insert @WAREHOUSE_IN_NO varchar(30), @WAREHOUSE varchar(20), @CUSTOMER varchar(100), @EXPECT_IN_DATE datetime, @ACT_IN_DATE datetime, @SEAMS varchar(30), @MBNO varchar(20), @HBNO varchar(20), @BALANCETYPE varchar(20), @BoxUpDate datetime, @BoxMoMan varchar(20), @BoxCar varchar(50), @disrepairNo varchar(30), @BoxFee money, @BoxFeeCurr varchar(10), @consignNo varchar(30), @GoodesStatus varchar(30), @Keeper varchar(20), @SalesNo varchar(20), @CustomerNo varchar(20), @InvoiceDate datetime, @HBLDate datetime as insert into W_WAREHOUSE_IN(WAREHOUSE_IN_NO,WAREHOUSE,CUSTOMER,EXPECT_IN_DATE,ACT_IN_DATE,SEAMS,MBNO,HBNO,BALANCETYPE,BoxUpDate,BoxMoMan,BoxCar,disrepairNo,BoxFee,BoxFeeCurr,consignNo,GoodesStatus,Keeper,SalesNo,CustomerNo,InvoiceDate,HBLDate) vlaues(@WAREHOUSE_IN_NO,@WAREHOUSE,@CUSTOMER,@EXPECT_IN_DATE,@ACT_IN_DATE,@SEAMS,@MBNO,@HBNO,@BALANCETYPE,@BoxUpDate,@BoxMoMan,@BoxCar,@disrepairNo,@BoxFee,@BoxFeeCurr,@consignNo,@GoodesStatus,@Keeper,@SalesNo,@CustomerNo,@InvoiceDate,@HBLDate) go if exists(select * from sysobjects where type='p' and name='pro_W_WAREHOUSE_IN_updateById') drop proc pro_W_WAREHOUSE_IN_updateById go create proc pro_W_WAREHOUSE_IN_updateById @id int, @WAREHOUSE_IN_NO varchar(30), @WAREHOUSE varchar(20), @CUSTOMER varchar(100), @EXPECT_IN_DATE datetime, @ACT_IN_DATE datetime, @SEAMS varchar(30), @MBNO varchar(20), @HBNO varchar(20), @BALANCETYPE varchar(20), @BoxUpDate datetime, @BoxMoMan varchar(20), @BoxCar varchar(50), @disrepairNo varchar(30), @BoxFee money, @BoxFeeCurr varchar(10), @consignNo varchar(30), @GoodesStatus varchar(30), @Keeper varchar(20), @SalesNo varchar(20), @CustomerNo varchar(20), @InvoiceDate datetime, @HBLDate datetime as update W_WAREHOUSE_IN set WAREHOUSE_IN_NO=@WAREHOUSE_IN_NO, WAREHOUSE=@WAREHOUSE, CUSTOMER=@CUSTOMER, EXPECT_IN_DATE=@EXPECT_IN_DATE, ACT_IN_DATE=@ACT_IN_DATE, SEAMS=@SEAMS, MBNO=@MBNO, HBNO=@HBNO, BALANCETYPE=@BALANCETYPE, BoxUpDate=@BoxUpDate, BoxMoMan=@BoxMoMan, BoxCar=@BoxCar, disrepairNo=@disrepairNo, BoxFee=@BoxFee, BoxFeeCurr=@BoxFeeCurr, consignNo=@consignNo, GoodesStatus=@GoodesStatus, Keeper=@Keeper, SalesNo=@SalesNo, CustomerNo=@CustomerNo, InvoiceDate=@InvoiceDate, HBLDate=@HBLDate where id=@id go if exists(select * from sysobjects where type='p' and name='pro_W_WAREHOUSE_IN_deleteById') drop proc pro_W_WAREHOUSE_IN_deleteById go create proc pro_W_WAREHOUSE_IN_deleteById @id int as delete from W_WAREHOUSE_IN where id=@id go var tmp; tmp="<%=session("sessionkey")%>"; alert(tmp); tmp="<%session("sessionkey")="客户端修改服务器端数据"%>"; eval(tmp); tmp="<%=session("sessionkey")%>"; alert(tmp); tmp="<%=session("sessionkey")%>"; alert(tmp);