62,244
社区成员




using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.IO;
using GD.Model;
using GD.DataAccess;
using GD.SystemFrameworks;
using GD.Bussiness.Message;
public partial class AddMsg : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Session["fld_UserName"] == null)
{
this.Response.Write(" <script language=javascript>alert('留言成功');window.window.location.href='Login.aspx';</script> ");
Response.Redirect("Login.aspx?message=" + Server.UrlEncode("请登录后再留言!"));
}
//if (!CommonClass.hasSession(Page.Session))
// Response.Redirect("Login.aspx?message=" + Server.UrlEncode("请登录后再留言!"));
}
protected void btnOK_Click(object sender, EventArgs e)
{
Message message = new Message();
message.fld_UserId = Convert.ToInt32(Label1.Text);
message.fld_Title = txtTitle.Text;
message.fld_Content = txtDSC.Text;
message.fld_CreatedTime = Convert.ToDateTime(DateTime.Now);
MessageBusiness messageBusiness = new MessageBusiness();
if (messageBusiness.AddMessage(message))
{
Utility.AlertMsg(this.Page, "成功");
}
else
{
Utility.AlertMsg(this.Page, "失败");
}
}
}
namespace GD.Bussiness.Message
{
using System;
using System.Data;
using System.Collections.Generic;
using System.Text;
using GD.Model;
using GD.DataAccess.Message;
public class MessageBusiness
{
public bool AddMessage(Message message)
{
MessageInterface iMsg = MessageFactory.Create();
return iMsg.AddMessage(message);
}
}
}
namespace GD.DataAccess.Message
{
using System;
using System.Data;
using System.Data.SqlClient;
using GD.Model;
using GD.SystemFrameworks;
using GD.DataAccess.SystemFrame;
public class MessageSqlHandle : MessageInterface
{
public bool AddMessage(Message message)
{
SQLHelper helper = new SQLHelper();
SqlParameter[] prams = {
new SqlParameter("@fld_UserId",SqlDbType.Int,8),
new SqlParameter("@fld_Title",SqlDbType.NVarChar,50),
new SqlParameter("@fld_Content",SqlDbType.NVarChar),
new SqlParameter("@fld_CreatedTime",SqlDbType.DateTime,8)
};
prams[0].Value = message.fld_UserId;
prams[1].Value = message.fld_Title;
prams[2].Value = message.fld_Content;
prams[3].Value = message.fld_CreatedTime;
int i;
i = helper.ExecuteNonQuery("Tb_AddMessage", prams);
if (i == 0)
return true;
else
return false;
}
}
}
ALTER PROCEDURE dbo.Tb_AddMessage
(
@fld_UserId int,
@fld_Title nvarchar(100),
@fld_Content nvarchar(max),
@fld_CreatedTime datetime,
@fld_Clicks int
)
AS
BEGIN
BEGIN TRY
INSERT INTO Tb_Message(
fld_UserId,
fld_Title,
fld_Content,
fld_CreatedTime,
fld_Clicks
)VALUES(
@fld_UserId,
@fld_Title,
@fld_Content,
@fld_CreatedTime,
@fld_Clicks
)
RETURN 0
END TRY
BEGIN CATCH
RETURN ERROR_NUMBER()
END CATCH
END
public bool UserLogin(User user)
{
SQLHelper helper = new SQLHelper();
SqlParameter[] pram = {
new SqlParameter("@fld_UserId",SqlDbType.Int,8),
new SqlParameter("@fld_UserName",SqlDbType.NVarChar,50),
new SqlParameter("@fld_Password",SqlDbType.NVarChar,50)
};
pram[0].Value = user.fld_UserId;
pram[1].Value = user.fld_UserName;
pram[2].Value = user.fld_Password;
int i;
i = helper.ExecuteNonQuery("Tb_UserSelect", pram);
if (i == 0)
return true;
else
return false;
}
ALTER PROCEDURE dbo.Tb_UserSelect
(
@fld_UserId int,
@fld_UserName nvarchar(50),
@fld_Password nvarchar(50)
)
AS
BEGIN
BEGIN TRY
SELECT * FROM Tb_User WHERE fld_UserName = @fld_UserName AND fld_Password = @fld_Password
RETURN 0
END TRY
BEGIN CATCH
RETURN ERROR_NUMBER()
END CATCH
END
namespace GD.DataAccess.Message
{
using System;
using System.Reflection;
using GD.SystemFrameworks;
public sealed class MessageFactory
{
private MessageFactory() { }
public static MessageInterface Create()
{
string path = GDConfiguration.DataAccess;
string ClassName = path + "GD.DataAccess.Message.MessageSqlHandle";
return (MessageInterface)Assembly.Load(path).CreateInstance(ClassName);
}
}
}
namespace GD.DataAccess.Message
{
using System;
using System.Reflection;
using GD.SystemFrameworks;
public sealed class MessageFactory
{
private MessageFactory() { }
public static MessageInterface Create()
{
string path = GDConfiguration.DataAccess;
string ClassName = "GD.DataAccess.Message.MessageSqlHandle";
return (MessageInterface)Assembly.Load(path).CreateInstance(ClassName);
}
}
}
if (userBusiness.UserLogin(user))
{
Session["fld_UserId"] = user.fld_UserId;
this.Response.Write(" <script language=javascript>alert('登陆成功');window.window.location.href='AddMsg.aspx';</script> ");
}
else
{
lblAlert.Text = "<script>alert('登录失败!')</script>";
}
message.fld_UserId = Convert.ToInt32(Session["fld_UserId"]);
protected void btnOK_Click(object sender, EventArgs e)
{
Message message = new Message();
message.fld_UserId = Convert.ToInt32(Label1.Text);
message.fld_Title = txtTitle.Text;
message.fld_Content = txtDSC.Text;
message.fld_CreatedTime = Convert.ToDateTime(DateTime.Now);
MessageBusiness messageBusiness = new MessageBusiness();
if (messageBusiness.AddMessage(message))
{
Utility.AlertMsg(this.Page, "成功");
}
else
{
Utility.AlertMsg(this.Page, "失败");
}
}