public static tb_Menu_articleEntity Populate_tb_Menu_articleEntity_FromDr(IDataReader dr)
{
tb_Menu_articleEntity Obj = new tb_Menu_articleEntity();
Obj.Id = ((dr["id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["id"]);
Obj.MenuId = ((dr["menuid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["menuid"]);
Obj.articleId = ((dr["articleid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["articleid"]);
Obj.AddTime = ((dr["addtime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["addtime"]);
return(Obj);
}
public static int UpdateMenu_article(tb_Menu_articleEntity _tb_Menu_article)
{
string sqlStr = "update tb_Menu_article set [menuid] = @MenuId,[articleid] = @articleId,[addtime] = @AddTime where id = @Id";
SqlParameter[] _param =
{
new SqlParameter("@MenuId", SqlDbType.Int),
new SqlParameter("@articleId", SqlDbType.Int),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int)
};
_param[0].Value = _tb_Menu_article.MenuId;
_param[1].Value = _tb_Menu_article.articleId;
_param[2].Value = _tb_Menu_article.AddTime;
_param[3].Value = _tb_Menu_article.Id;
return(SqlHelper.ExecuteNonQuery(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
}
public static int InsertMenu_articleEntity(tb_Menu_articleEntity _tb_Menu_articleEntity)
{
string sqlStr = "insert into tb_Menu_article([menuid],[articleid],[addtime]) values(@MenuId,@articleId,@Addtime) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@MenuId", SqlDbType.Int),
new SqlParameter("@articleId", SqlDbType.Int),
new SqlParameter("@Addtime", SqlDbType.DateTime)
};
_param[0].Value = _tb_Menu_articleEntity.MenuId;
_param[1].Value = _tb_Menu_articleEntity.articleId;
_param[2].Value = _tb_Menu_articleEntity.AddTime;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
return(res);
}
public static tb_Menu_articleEntity Get_tb_Menu_articleEntity(int id)
{
tb_Menu_articleEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@Id", SqlDbType.Int)
};
_param[0].Value = id;
string sqlStr = "SELECT * FROM tb_Menu_article with(nolock) where id = @Id ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_Menu_articleEntity_FromDr(dr);
}
}
return(_obj);
}
