问题1:
URLrewriter重写规则,要想将
项目名/News/2009/01/08/9393.html 这种目录模式发送到:项目名/News/details.aspx?year=&month=&day=&id=
该页面解析,如何解决'/'转义的问题,注(我试过这个规则:<rewrite url="~/News/(\d{4})/(\d{2})/(\d{2})/(\d{4})\.html$" to="~/News/details.aspx?Year=$1&Month=$2&Day=$3&ID=$4" processing="stop"/>)
可以转到,但是css 及图片所有用的相对路径均失效,并且我尝试用~/news/images/**.gif这种路径也不行,请指教。顺便再问个问题:
问题2:
CREATE PROCEDURE UP_house_ADD
@id int output,
@kind int,
@fyleixing nvarchar(50),
@qy int,
@qyname nvarchar(50),
@adress nvarchar(300),
@pay real,
@jyprice real,
@zhuangxiu int,
@zxname nvarchar(50),
@chaoxiang nvarchar(50),
@huxing int,
@hxname nvarchar(50),
@quanshu nvarchar(50),
@age nvarchar(50),
@tax nvarchar(50),
@area int,
@floor nvarchar(50),
@pass int,
@other ntext,
@ring int,
@luduan nvarchar(50),
@star nvarchar(50),
@linkman nvarchar(50),
@linktel nvarchar(50),
@kehuname nvarchar(50),
@kehutel nvarchar(50),
@data datetime,
@xingzhi int,
@wyleixing nvarchar(50),
@zhongjie int,
@huiyuanid int,
@counts int,
@Email nvarchar(50),
@qq nvarchar(50),
@zhifu nvarchar(50),
@zhuangtai nvarchar(50),
@shangwang nvarchar(50),
@lastdate datetime,
@xiaoqu_name nvarchar(50),
@wuye_address nvarchar(250),
@jichu nvarchar(500),
@peitao nvarchar(50),
@zhoubian nvarchar(500),
@jiaotong nvarchar(500),
@shanchupwd nvarchar(200),
@xiaomin int,
@tuijian int,
@sign int AS
INSERT INTO [house](
[kind],[fyleixing],[qy],[qyname],[adress],[pay],[jyprice],[zhuangxiu],[zxname],[chaoxiang],[huxing],[hxname],[quanshu],[age],[tax],[area],[floor],[pass],[other],[ring],[luduan],[star],[linkman],[linktel],[kehuname],[kehutel],[data],[xingzhi],[wyleixing],[zhongjie],[huiyuanid],[counts],[Email],[qq],[zhifu],[zhuangtai],[shangwang],[lastdate],[xiaoqu_name],[wuye_address],[jichu],[peitao],[zhoubian],[jiaotong],[shanchupwd],[xiaomin],[tuijian],[sign]
)VALUES(
@kind,@fyleixing,@qy,@qyname,@adress,@pay,@jyprice,@zhuangxiu,@zxname,@chaoxiang,@huxing,@hxname,@quanshu,@age,@tax,@area,@floor,@pass,@other,@ring,@luduan,@star,@linkman,@linktel,@kehuname,@kehutel,@data,@xingzhi,@wyleixing,@zhongjie,@huiyuanid,@counts,@Email,@qq,@zhifu,@zhuangtai,@shangwang,@lastdate,@xiaoqu_name,@wuye_address,@jichu,@peitao,@zhoubian,@jiaotong,@shanchupwd,@xiaomin,@tuijian,@sign
)
SET @id=SCOPE_IDENTITY()GO
我一个存储过程中output IDENTITY,总为0;
我是这样用的(三层开发),数据层执行完这个存储:
public int Add(Hyfcw.Model.Houseinfor model)
{
int rowsAffected;
。。
。
SQLHelper.RunProcedure("UP_house_ADD", parameters, out rowsAffected);
return (int)parameters[0].Value;
}然后在aspx.cs页面调用了bll层的add()后,再用model.Id为什么还是为空?为什么?????请高人指点。
URLrewriter重写规则,要想将
项目名/News/2009/01/08/9393.html 这种目录模式发送到:项目名/News/details.aspx?year=&month=&day=&id=
该页面解析,如何解决'/'转义的问题,注(我试过这个规则:<rewrite url="~/News/(\d{4})/(\d{2})/(\d{2})/(\d{4})\.html$" to="~/News/details.aspx?Year=$1&Month=$2&Day=$3&ID=$4" processing="stop"/>)
可以转到,但是css 及图片所有用的相对路径均失效,并且我尝试用~/news/images/**.gif这种路径也不行,请指教。顺便再问个问题:
问题2:
CREATE PROCEDURE UP_house_ADD
@id int output,
@kind int,
@fyleixing nvarchar(50),
@qy int,
@qyname nvarchar(50),
@adress nvarchar(300),
@pay real,
@jyprice real,
@zhuangxiu int,
@zxname nvarchar(50),
@chaoxiang nvarchar(50),
@huxing int,
@hxname nvarchar(50),
@quanshu nvarchar(50),
@age nvarchar(50),
@tax nvarchar(50),
@area int,
@floor nvarchar(50),
@pass int,
@other ntext,
@ring int,
@luduan nvarchar(50),
@star nvarchar(50),
@linkman nvarchar(50),
@linktel nvarchar(50),
@kehuname nvarchar(50),
@kehutel nvarchar(50),
@data datetime,
@xingzhi int,
@wyleixing nvarchar(50),
@zhongjie int,
@huiyuanid int,
@counts int,
@Email nvarchar(50),
@qq nvarchar(50),
@zhifu nvarchar(50),
@zhuangtai nvarchar(50),
@shangwang nvarchar(50),
@lastdate datetime,
@xiaoqu_name nvarchar(50),
@wuye_address nvarchar(250),
@jichu nvarchar(500),
@peitao nvarchar(50),
@zhoubian nvarchar(500),
@jiaotong nvarchar(500),
@shanchupwd nvarchar(200),
@xiaomin int,
@tuijian int,
@sign int AS
INSERT INTO [house](
[kind],[fyleixing],[qy],[qyname],[adress],[pay],[jyprice],[zhuangxiu],[zxname],[chaoxiang],[huxing],[hxname],[quanshu],[age],[tax],[area],[floor],[pass],[other],[ring],[luduan],[star],[linkman],[linktel],[kehuname],[kehutel],[data],[xingzhi],[wyleixing],[zhongjie],[huiyuanid],[counts],[Email],[qq],[zhifu],[zhuangtai],[shangwang],[lastdate],[xiaoqu_name],[wuye_address],[jichu],[peitao],[zhoubian],[jiaotong],[shanchupwd],[xiaomin],[tuijian],[sign]
)VALUES(
@kind,@fyleixing,@qy,@qyname,@adress,@pay,@jyprice,@zhuangxiu,@zxname,@chaoxiang,@huxing,@hxname,@quanshu,@age,@tax,@area,@floor,@pass,@other,@ring,@luduan,@star,@linkman,@linktel,@kehuname,@kehutel,@data,@xingzhi,@wyleixing,@zhongjie,@huiyuanid,@counts,@Email,@qq,@zhifu,@zhuangtai,@shangwang,@lastdate,@xiaoqu_name,@wuye_address,@jichu,@peitao,@zhoubian,@jiaotong,@shanchupwd,@xiaomin,@tuijian,@sign
)
SET @id=SCOPE_IDENTITY()GO
我一个存储过程中output IDENTITY,总为0;
我是这样用的(三层开发),数据层执行完这个存储:
public int Add(Hyfcw.Model.Houseinfor model)
{
int rowsAffected;
。。
。
SQLHelper.RunProcedure("UP_house_ADD", parameters, out rowsAffected);
return (int)parameters[0].Value;
}然后在aspx.cs页面调用了bll层的add()后,再用model.Id为什么还是为空?为什么?????请高人指点。
解决方案 »
- 有什么好用的工具可将数据库的表自动生成C#的实体类吗?
- 请问生成安装项目,如何跨过选定安装目录,直接按我指定的目录进行安装,谢谢!
- 碰到了新问题,求高人解答
- 求教,添加程序可以运行但是无法添加成功???
- 如何用正则表达式取得<div class='a'></div>内的值?
- ~HELP~!自定义combox控件问题,如何让Combox有:items,等属性
- CDHtmlDialog在C#中怎么实现?
- 十万火急求教:在C#程序中如何以一个windows2000的帐户和密码连接该电脑
- 请问怎么在C#的应用程序里面调用一个url地址
- 有没有高手懂delphi帮我解释这一小段代码。。急在线等待
- 我想知道这个让页面悬挂的效果是怎么实现的
- 下载了一个Microsoft.Visual.Studio.Team.System.2008.Team.Suite-ZWTiSO,有3.73G,但是没有看到setup。exe,怎么办?
Hyfcw.Web/News/2009/01/08/~/Images/form_title_icon1.gif这个下面,怎么解决????????
放到虚拟目录中????????????????????????????
看清我的问题意思Hyfcw.Web/News/2009/01/08/ 这个中的/ 需要转义掉,就是不能让他解析成目录
{
if (HttpContext.Current.Request.ApplicationPath == "/")
{
return @"http://" + HttpContext.Current.Request.Url.Host;
}
else
{
return @"http://" + HttpContext.Current.Request.Url.Host + HttpContext.Current.Request.ApplicationPath;
}
}<img src="<%=GetBaseURL()%>/Images/form_title_icon1.gif" />