public static tb_articleEntity Populate_tb_articleEntity_FromDr(IDataReader dr)
{
tb_articleEntity Obj = new tb_articleEntity();
Obj.Id = ((dr["id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["id"]);
Obj.Title = dr["title"].ToString();
Obj.Author = dr["author"].ToString();
Obj.Content = dr["content"].ToString();
Obj.Status = ((dr["status"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["status"]);
Obj.AddTime = ((dr["addtime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["addtime"]);
Obj.UpdateTiem = ((dr["updatetime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["updatetime"]);
return(Obj);
}
public static tb_articleEntity GetarticleEntityByTitle(string title)
{
tb_articleEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@Title", SqlDbType.VarChar)
};
_param[0].Value = title;
string sqlStr = "SELECT * FROM [sharecms].[dbo].[tb_article] with(nolock) where [Title] = @Title ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_articleEntity_FromDr(dr);
}
}
return(_obj);
}
public static int Updatearticle(tb_articleEntity _tb_article)
{
string sqlStr = "update tb_article set [Title] = @Title,[Author] = @Author,[Content] = @Content,[Status] = @Status,[Addtime] = @Addtime,[Updatetime] = @Addtime where id = @Id";
SqlParameter[] _param =
{
new SqlParameter("@Title", SqlDbType.VarChar),
new SqlParameter("@Author", SqlDbType.VarChar),
new SqlParameter("@Content", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime),
new SqlParameter("@Updatetime", SqlDbType.DateTime),
new SqlParameter("@id", SqlDbType.Int)
};
_param[0].Value = _tb_article.Title;
_param[1].Value = _tb_article.Author;
_param[2].Value = _tb_article.Content;
_param[3].Value = _tb_article.Status;
_param[4].Value = _tb_article.AddTime;
_param[5].Value = _tb_article.UpdateTiem;
_param[6].Value = _tb_article.Id;
return(SqlHelper.ExecuteNonQuery(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
}
public static int Insertarticle(tb_articleEntity _tb_article)
{
string sqlStr = " insert into tb_article([Title],[Author],[Content],[Status],[Addtime],[Updatetime]) values(@Title,@Author,@Content,@Status,@Addtime,@Updatetime) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@Title", SqlDbType.VarChar),
new SqlParameter("@Author", SqlDbType.VarChar),
new SqlParameter("@Content", SqlDbType.VarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime),
new SqlParameter("@Updatetime", SqlDbType.DateTime)
};
_param[0].Value = _tb_article.Title;
_param[1].Value = _tb_article.Author;
_param[2].Value = _tb_article.Content;
_param[3].Value = _tb_article.Status;
_param[4].Value = _tb_article.AddTime;
_param[5].Value = _tb_article.UpdateTiem;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
return(res);
}