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