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(); }