sitefactory 留言入库存储过程版

smj328 · 发表于 2009-4-6 12:08:05

本帖最后由 smj328 于 2009-4-6 12:21 编辑

在查询分析器上已经测试成功了，分别插入两个表中，两表关联，用存储过程实现自增id。理论上可以实现三表关联，实现回复一起采集发布，没做！
但是可惜的是火车头入库不支持存储过程，只能做个web接口了，还没做，有爱好sitefactory的一起研究

存储过程

CREATE PROCEDURE [dbo].[a_liuyan_zuhe_1]
(
@GeneralID int,
@ItemID int,
@TableName nvarchar(255),
@NodeID int,
@ModelID int,
@Title nvarchar(255),
@Inputer nvarchar(255),
@Status int,
@UpdateTime datetime,
@CreateTime datetime,
@EliteLevel int,
@Priority int,
@ID int,
@GuestName nvarchar(255),
@GuestContent nvarchar(4000),
@GuestFace nvarchar(255),
@GuestImages nvarchar(255)
)
AS
DEClARE @postid111 int
set @postid111=(select max(GeneralID) from PE_CommonModel)+1
INSERT INTO
[PE_CommonModel]
(
GeneralID,
ItemID,
TableName,
NodeID,
ModelID,
Title,
Inputer,
Status,
UpdateTime,
CreateTime,
EliteLevel,
Priority
)
Values
(
@postid111,
@postid111,
@TableName,
@NodeID,
@ModelID,
@Title,
@Inputer,
@Status,
@UpdateTime,
@CreateTime,
@EliteLevel,
@Priority
)
INSERT INTO
[PE_U_GuestBook]
(
ID,
GuestName,
GuestContent,
GuestFace,
GuestImages
)
Values
(
@postid111,
@GuestName,
@GuestContent,
@GuestFace,
@GuestImages
)
RETURN
GO

复制代码

下面是调用代码
exec a_liuyan_zuhe_1 0,0,PE_U_GuestBook,7,21,标题标题标题,Anonymous,99,'2009-4-5 9:13:56','2009-4-6 9:13:56',0,0,0,用户名,内容内容,1,'01'

做了个web接口，发布一直是乱码，不知道怎么回事，懂得给我指导一下

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection Conn = new SqlConnection("server=203.171.230.133;database=helenhome2008cn;uid=helenhome2008cn;pwd=e*******");
Conn.Open();
SqlCommand cmd = new SqlCommand("a_liuyan_zuhe_1", Conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GeneralID", SqlDbType.Int);
cmd.Parameters["@GeneralID"].Value = "0";
cmd.Parameters.Add("@ItemID", SqlDbType.Int);
cmd.Parameters["@ItemID"].Value = "0";
cmd.Parameters.Add("@TableName", SqlDbType.NVarChar, 255);
cmd.Parameters["@TableName"].Value = "PE_U_GuestBook";
cmd.Parameters.Add("@NodeID", SqlDbType.Int);
cmd.Parameters["@NodeID"].Value = "7";
cmd.Parameters.Add("@ModelID", SqlDbType.Int);
cmd.Parameters["@ModelID"].Value = "21";
cmd.Parameters.Add("@Title", SqlDbType.NVarChar, 255);
cmd.Parameters["@Title"].Value = "标题标题标题11111111";
cmd.Parameters.Add("@Inputer", SqlDbType.NVarChar, 255);
cmd.Parameters["@Inputer"].Value = "Anonymous";
cmd.Parameters.Add("@Status", SqlDbType.Int);
cmd.Parameters["@Status"].Value = "99";
cmd.Parameters.Add("@UpdateTime", SqlDbType.DateTime);
cmd.Parameters["@UpdateTime"].Value = "2009-4-6 9:13:56";
cmd.Parameters.Add("@CreateTime", SqlDbType.DateTime);
cmd.Parameters["@CreateTime"].Value = "2009-4-6 9:13:56";
cmd.Parameters.Add("@EliteLevel", SqlDbType.Int);
cmd.Parameters["@EliteLevel"].Value = "0";
cmd.Parameters.Add("@Priority", SqlDbType.Int);
cmd.Parameters["@Priority"].Value = "0";
cmd.Parameters.Add("@ID", SqlDbType.Int);
cmd.Parameters["@ID"].Value = "0";
cmd.Parameters.Add("@GuestName", SqlDbType.NVarChar, 255);
cmd.Parameters["@GuestName"].Value = "用户名";
cmd.Parameters.Add("@GuestContent", SqlDbType.NVarChar, 4000);
cmd.Parameters["@GuestContent"].Value = "内容内容";
cmd.Parameters.Add("@GuestFace", SqlDbType.NVarChar, 255);
cmd.Parameters["@GuestFace"].Value = "1";
cmd.Parameters.Add("@GuestImages", SqlDbType.NVarChar, 255);
cmd.Parameters["@GuestImages"].Value = "01";
//cmd.ExecuteNonQuery();//执行存储过程
//SqlDataReader dr = cmd.ExecuteReader();
// @GuestName nvarchar(255),
// @GuestContent nvarchar(4000),
// @GuestFace nvarchar(255),
// @GuestImages nvarchar(255)
//SqlConnection conn = new SqlConnection("server=203.171.230.133;database=helenhome2008cn;uid=helenhome2008cn;pwd=ehelenhome2008cn");
//SqlCommand cmd = new SqlCommand();
//conn.Open();
//cmd.Connection = conn;
//cmd.CommandText = "exec a_liuyan_zuhe_1 0,0,PE_U_GuestBook,7,21,标题标题标题,Anonymous,99,'2009-4-6 9:13:56','2009-4-6 9:13:56',0,0,0,用户名,内容内容,1,'01'";
//cmd.ExecuteNonQuery();
//cmd = null;
//conn.Close();
//conn = null;
Response.Write("<script>alert('提交成功')</script>");
//string sql = "exec a_liuyan_zuhe_1 0,0,PE_U_GuestBook,7,21,标题标题标题,Anonymous,99,'2009-4-6 9:13:56','2009-4-6 9:13:56',0,0,0,用户名,内容内容,1,'01'";
//cmd = new SqlCommand(sql, conn);
//conn.Open();
//Response.Write("发布成功！" + sqlyuju.Text);
//return;
}

复制代码

会.net的欢迎一起研究，我的qq：506483574

xyz5200 · 发表于 2009-4-6 12:47:27

现在懂NET的少之又少．

懷念過去↑文 · 发表于 2009-4-6 15:53:31

徘徊了1个多月终于想好了继续学习NET

smj328 · 发表于 2009-4-7 22:13:55

哈哈弄好了，在做web发布模块了，支持同时回复

帐号		自动登录	找回密码
密码			加入会员

sitefactory 留言入库 存储过程版

浏览过的版块

sitefactory 留言入库存储过程版