private static Tab_Y_Article ToModel(DataRow row) { Tab_Y_Article model = new Tab_Y_Article(); model.Idx = row.IsNull("Idx") ? null : (System.Int32?)row["Idx"]; model.Title = row.IsNull("Title") ? null : (System.String)row["Title"]; model.Content = row.IsNull("Content") ? null : (System.String)row["Content"]; model.UserId = row.IsNull("UserId") ? null : (System.Int32?)row["UserId"]; model.CreateDate = row.IsNull("CreateDate") ? null : (System.DateTime?)row["CreateDate"]; model.Aduit = row.IsNull("Aduit") ? null : (System.Boolean?)row["Aduit"]; model.BoardIdx = row.IsNull("BoardIdx") ? null : (System.Int32?)row["BoardIdx"]; model.ProductIdx = row.IsNull("ProductIdx") ? null : (System.Int32?)row["ProductIdx"]; model.ProductTypeIdx = row.IsNull("ProductTypeIdx") ? null : (System.Int32?)row["ProductTypeIdx"]; return(model); }
public int AddNew(Tab_Y_Article model) { string sql = "insert into Tab_Y_Article(Title,Content,UserId,CreateDate,Aduit,BoardIdx,ProductIdx,ProductTypeIdx) values(@Title,@Content,@UserId,@CreateDate,@Aduit,@BoardIdx,@ProductIdx,@ProductTypeIdx); select @@identity ;"; int Idx = Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sql , new SqlParameter("@Title", model.Title) , new SqlParameter("@Content", model.Content) , new SqlParameter("@UserId", model.UserId) , new SqlParameter("@CreateDate", model.CreateDate) , new SqlParameter("@Aduit", model.Aduit) , new SqlParameter("@BoardIdx", model.BoardIdx) , new SqlParameter("@ProductIdx", model.ProductIdx) , new SqlParameter("@ProductTypeIdx", model.ProductTypeIdx) )); return(Idx); }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { if (string.IsNullOrEmpty(Request["Idx"])) { Response.Redirect("KOL-share.aspx"); } DBEntity.Tab_Y_Article ent = new DBEntity.Tab_Y_Article(); ent = ent.Get(Request["Idx"]); this.ltlTitle.Text = ent.Title; this.ltlContent.Text = ent.Content; //写入阅读的日志表 DBEntity.Tab_Y_Article_ViewLog.Add_Y_Article_ViewLog(Request["Idx"], Request.UserHostAddress, Request.Url + "_" + ent.Title); } }
public bool Update(Tab_Y_Article model) { string sql = "update Tab_Y_Article set Title=@Title,Content=@Content,UserId=@UserId,CreateDate=@CreateDate,Aduit=@Aduit,BoardIdx=@BoardIdx,ProductIdx=@ProductIdx,ProductTypeIdx=@ProductTypeIdx where Idx=@Idx"; int rows = SqlHelper.ExecuteNonQuery(CommandType.Text, sql , new SqlParameter("@Title", model.Title) , new SqlParameter("@Content", model.Content) , new SqlParameter("@UserId", model.UserId) , new SqlParameter("@CreateDate", model.CreateDate) , new SqlParameter("@Aduit", model.Aduit) , new SqlParameter("@BoardIdx", model.BoardIdx) , new SqlParameter("@ProductIdx", model.ProductIdx) , new SqlParameter("@ProductTypeIdx", model.ProductTypeIdx) , new SqlParameter("Idx", model.Idx) ); return(rows > 0); }
public Tab_Y_Article Get(string Idx) { DataTable dt = SqlHelper.ExecuteDataset(CommandType.Text, "select * from Tab_Y_Article where Idx=@Idx", new SqlParameter("Idx", Idx)).Tables[0]; if (dt.Rows.Count > 1) { throw new Exception("more than 1 row was found"); } if (dt.Rows.Count <= 0) { return(null); } DataRow row = dt.Rows[0]; Tab_Y_Article model = ToModel(row); return(model); }