public static tb_MenuEntity Populate_tb_MenuEntity_FromDr(IDataReader dr)
{
tb_MenuEntity Obj = new tb_MenuEntity();
Obj.Id = ((dr["id"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["id"]);
Obj.ParentId = ((dr["parentid"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["parentid"]);
Obj.Menuname = dr["menuname"].ToString();
Obj.Url = dr["url"].ToString();
Obj.Type = ((dr["type"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["type"]);
return(Obj);
}
public static int UpdateMenu(tb_MenuEntity _tb_Menu)
{
string sqlStr = "update tb_Menu set [parentid] = @ParentId,[menuname] = @MenuName,[url] = @Url,[type] = @Type where id = @Id";
SqlParameter[] _param =
{
new SqlParameter("@ParentId", SqlDbType.Int),
new SqlParameter("@MenuName", SqlDbType.VarChar),
new SqlParameter("@Url", SqlDbType.VarChar),
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@Id", SqlDbType.Int)
};
_param[0].Value = _tb_Menu.ParentId;
_param[1].Value = _tb_Menu.Menuname;
_param[2].Value = _tb_Menu.Url;
_param[3].Value = _tb_Menu.Type;
_param[4].Value = _tb_Menu.Id;
return(SqlHelper.ExecuteNonQuery(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
}
public static int InsertMenu(tb_MenuEntity _tb_MenuEntity)
{
string sqlStr = "insert into tb_Menu([parentid],[menuname],[url],[type]) values(@ParentId,@MenuName,@Url,@Type) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@ParentId", SqlDbType.Int),
new SqlParameter("@MenuName", SqlDbType.VarChar),
new SqlParameter("@Url", SqlDbType.VarChar),
new SqlParameter("@Type", SqlDbType.Int)
};
_param[0].Value = _tb_MenuEntity.ParentId;
_param[1].Value = _tb_MenuEntity.Menuname;
_param[2].Value = _tb_MenuEntity.Url;
_param[3].Value = _tb_MenuEntity.Type;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(WebConfig.ExamRW, CommandType.Text, sqlStr, _param));
return(res);
}
public static tb_MenuEntity Get_tb_MenuEntity(int id)
{
tb_MenuEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@Id", SqlDbType.Int)
};
_param[0].Value = id;
string sqlStr = "SELECT * FROM tb_Menu with(nolock) where id = @Id ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.ExamRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_tb_MenuEntity_FromDr(dr);
}
}
return(_obj);
}
