private void ShowInfo(int newsId)
{
rr2.BLL.newsInfo bll = new rr2.BLL.newsInfo();
rr2.Model.newsInfo model = bll.GetModel(newsId);
this.lblnewsId.Text = model.newsId.ToString();
this.lbluserId.Text = model.userId.ToString();
this.lblTypeId.Text = model.typeId.ToString();
this.lblnewsTitle.Text = model.newsTitle;
this.lblnewsContent.Text = model.newsContent;
this.lblnewsCount.Text = model.newsCount.ToString();
this.lblnewsReleaseTime.Text = model.newsReleaseTime.ToString();
this.lblext1.Text = model.ext1;
this.lblext2.Text = model.ext2;
this.lblext3.Text = model.ext3;
}
protected void Page_Load(object sender, EventArgs e)
{
string newsid = Request.QueryString["newsId"]; //从地址栏获取传过来的值
if (!IsPostBack) //回传提交，如果不是第一次执行，则不走这段代码
{
mdlnews = bllnews.GetModel(int.Parse(newsid));
UserId.Value = newsid;
TBnewsContent.Text = mdlnews.newsContent;
TBnewType.Text = mdlnews.typeId.ToString();
TBnewsTitle.Text = mdlnews.newsTitle;
TBnewsUser.Text = mdlnews.userId.ToString();
TBnewsReleaseTime.Text = mdlnews.newsReleaseTime.ToString();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public rr2.Model.newsInfo DataRowToModel(DataRow row)
{
rr2.Model.newsInfo model = new rr2.Model.newsInfo();
if (row != null)
{
if (row["newsId"] != null && row["newsId"].ToString() != "")
{
model.newsId = int.Parse(row["newsId"].ToString());
}
if (row["userId"] != null && row["userId"].ToString() != "")
{
model.userId = int.Parse(row["userId"].ToString());
}
if (row["typeId"] != null && row["typeId"].ToString() != "")
{
model.typeId = int.Parse(row["typeId"].ToString());
}
if (row["newsTitle"] != null)
{
model.newsTitle = row["newsTitle"].ToString();
}
if (row["newsContent"] != null)
{
model.newsContent = row["newsContent"].ToString();
}
if (row["newsCount"] != null && row["newsCount"].ToString() != "")
{
model.newsCount = int.Parse(row["newsCount"].ToString());
}
if (row["newsReleaseTime"] != null && row["newsReleaseTime"].ToString() != "")
{
model.newsReleaseTime = DateTime.Parse(row["newsReleaseTime"].ToString());
}
if (row["ext1"] != null)
{
model.ext1 = row["ext1"].ToString();
}
if (row["ext2"] != null)
{
model.ext2 = row["ext2"].ToString();
}
if (row["ext3"] != null)
{
model.ext3 = row["ext3"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(rr2.Model.newsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into newsInfo(");
strSql.Append("userId,typeId,newsTitle,newsContent,newsCount,newsReleaseTime,ext1,ext2,ext3)");
strSql.Append(" values (");
strSql.Append("@userId,@typeId,@newsTitle,@newsContent,@newsCount,@newsReleaseTime,@ext1,@ext2,@ext3)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@userId", SqlDbType.Int, 4),
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@newsTitle", SqlDbType.VarChar, 100),
new SqlParameter("@newsContent", SqlDbType.VarChar, 4000),
new SqlParameter("@newsCount", SqlDbType.Int, 4),
new SqlParameter("@newsReleaseTime", SqlDbType.DateTime),
new SqlParameter("@ext1", SqlDbType.VarChar, 200),
new SqlParameter("@ext2", SqlDbType.VarChar, 200),
new SqlParameter("@ext3", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.userId;
parameters[1].Value = model.typeId;
parameters[2].Value = model.newsTitle;
parameters[3].Value = model.newsContent;
parameters[4].Value = model.newsCount;
parameters[5].Value = model.newsReleaseTime;
parameters[6].Value = model.ext1;
parameters[7].Value = model.ext2;
parameters[8].Value = model.ext3;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(rr2.Model.newsInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update newsInfo set ");
strSql.Append("typeId=@typeId,");
strSql.Append("newsTitle=@newsTitle,");
strSql.Append("newsContent=@newsContent,");
strSql.Append("newsCount=@newsCount,");
strSql.Append("newsReleaseTime=@newsReleaseTime");
strSql.Append(" where newsId=@newsId");
SqlParameter[] parameters =
{
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@newsTitle", SqlDbType.VarChar, 100),
new SqlParameter("@newsContent", SqlDbType.VarChar, 4000),
new SqlParameter("@newsCount", SqlDbType.Int, 4),
new SqlParameter("@newsReleaseTime", SqlDbType.DateTime),
new SqlParameter("@newsId", SqlDbType.Int, 4)
};
parameters[0].Value = model.typeId;
parameters[1].Value = model.newsTitle;
parameters[2].Value = model.newsContent;
parameters[3].Value = model.newsCount;
parameters[4].Value = model.newsReleaseTime;
parameters[5].Value = model.newsId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public rr2.Model.newsInfo GetModel(int newsId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 newsId,userId,typeId,newsTitle,newsContent,newsCount,newsReleaseTime,ext1,ext2,ext3 from newsInfo ");
strSql.Append(" where newsId=@newsId");
SqlParameter[] parameters =
{
new SqlParameter("@newsId", SqlDbType.Int, 4)
};
parameters[0].Value = newsId;
rr2.Model.newsInfo model = new rr2.Model.newsInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtuserId.Text))
{
strErr += "userId格式错误！\\n";
}
if (!PageValidate.IsNumber(txtTypeId.Text))
{
strErr += "typeId格式错误！\\n";
}
if (this.txtnewsTitle.Text.Trim().Length == 0)
{
strErr += "newsTitle不能为空！\\n";
}
if (this.txtnewsContent.Text.Trim().Length == 0)
{
strErr += "newsContent不能为空！\\n";
}
if (!PageValidate.IsNumber(txtnewsCount.Text))
{
strErr += "newsCount格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtnewsReleaseTime.Text))
{
strErr += "newsReleaseTime格式错误！\\n";
}
if (this.txtext1.Text.Trim().Length == 0)
{
strErr += "ext1不能为空！\\n";
}
if (this.txtext2.Text.Trim().Length == 0)
{
strErr += "ext2不能为空！\\n";
}
if (this.txtext3.Text.Trim().Length == 0)
{
strErr += "ext3不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int newsId = int.Parse(this.lblnewsId.Text);
int userId = int.Parse(this.txtuserId.Text);
int typeId = int.Parse(this.txtTypeId.Text);
string newsTitle = this.txtnewsTitle.Text;
string newsContent = this.txtnewsContent.Text;
int newsCount = int.Parse(this.txtnewsCount.Text);
DateTime newsReleaseTime = DateTime.Parse(this.txtnewsReleaseTime.Text);
string ext1 = this.txtext1.Text;
string ext2 = this.txtext2.Text;
string ext3 = this.txtext3.Text;
rr2.Model.newsInfo model = new rr2.Model.newsInfo();
model.newsId = newsId;
model.userId = userId;
model.typeId = typeId;
model.newsTitle = newsTitle;
model.newsContent = newsContent;
model.newsCount = newsCount;
model.newsReleaseTime = newsReleaseTime;
model.ext1 = ext1;
model.ext2 = ext2;
model.ext3 = ext3;
rr2.BLL.newsInfo bll = new rr2.BLL.newsInfo();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
