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