protected void btnAdd_Click(object sender, EventArgs e)
{
NewsListEntity _NewsListEntity = new NewsListEntity();
_NewsListEntity.CreateDate = DateTime.Now;
_NewsListEntity.Creator = userEntity.UserName;
if (txtExpDate.Text == "")
_NewsListEntity.ExpireDate = DateTime.Parse("2038-01-01");
else
_NewsListEntity.ExpireDate = DateTime.Parse(txtExpDate.Text);
_NewsListEntity.IsPublish = chkIsPublish.Checked==true ? '1':'0';
_NewsListEntity.LastModifier = userEntity.UserName;
_NewsListEntity.LastModifyDate = DateTime.Now;
_NewsListEntity.NewsBody = FreeTextBox1.Text;
_NewsListEntity.NewsTitle = txtTitle.Text;
_NewsListEntity.NewsTypeID = Int32.Parse(dpType.SelectedValue);
_NewsListEntity.PublishDate = DateTime.Parse("2012-01-01");
string szResult = DbHelper.GetInstance().AddNewsListInfor(_NewsListEntity);
NewsUser _NewsUser = new NewsUser();
_NewsUser.NewsID =Convert.ToInt32(szResult);
_NewsUser.NewsTypeDetailName = ddlOperatorTypeDetail.SelectedItem.Text;
_NewsUser.NewsTypeuserName = txtObjectValueN.Text;
DbHelper.GetInstance().AddNewsUser(_NewsUser);
Context.Response.Redirect("NewMaintain.aspx");
}
public string AddNewsUser(NewsUser _NewsUser)
{
DbParameter[] pramsInsert = {
MakeInParam("@NewsID",(DbType)SqlDbType.Int,4,_NewsUser.NewsID),
MakeInParam("@NewsTypeDetailName",(DbType)SqlDbType.VarChar,50,_NewsUser.NewsTypeDetailName),
MakeInParam("@NewsTypeUserName",(DbType)SqlDbType.VarChar,50,_NewsUser.NewsTypeuserName),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[News_NewsUser]");
sb.Append("([NewsID]");
sb.Append(",[NewsTypeDetailName]");
sb.Append(",[NewsTypeUserName]");
sb.Append(")");
sb.Append("VALUES");
sb.Append("(@NewsID");
sb.Append(",@NewsTypeDetailName");
sb.Append(",@NewsTypeUserName");
sb.Append(")");
sb.Append(" select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
